{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Scenario","Keyword Header","Placement Header","Read Me"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Scenario","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,11],[19,2,33,4]]}
[]
[null,"Scenario 1: Optimize GDN keywords"]
[null,null,"Google Display Network Keyword Optimization Tool"]
[null,null,"Automatically optimize your Google Display Network keyword campaigns"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scenario 2: Optimize placements (at campaign level)"]

{"sheet":"Keyword Header","index":1,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Englsih","Keyword","Campaign","Ad group","Status","Max. CPC","Clicks","Impressions","CTR","Avg. CPC","Avg. CPM","Cost","Conv. (1-per-click)","Cost / conv. (1-per-click)","Conv. rate (1-per-click)","Total conv. value","Value / conv. (1-per-click)"]
["Chinese (Simplified)","关键字","广告系列","广告组","状态","最高每次点击费用","点击次数","展示次数","点击率","平均每次点击费用","平均每千次展示费用","总费用","转化次数（每次点击仅算一次转化）","费用/转化次数（每次点击仅算一次转化）","转化率（每次点击仅算一次转化）","总转化价值","每次转化价值（每次点击一次转化）"]
["Chinese (Traditional)","關鍵字","廣告活動","廣告群組","狀態","最高單次點擊出價","點擊","曝光","點閱率","平均單次點擊出價","平均千次曝光出價","費用","轉換 (單次點擊單次轉換)","單次轉換費用 (單次點擊單次轉換)","轉換率 (單次點擊單次轉換)","總轉換價值","單次轉換價值 (單次點擊單次轉換)"]
["Danish","Søgeord","Kampagne","Annoncegruppe","Status","Maks. CPC","Klik","Visninger","CTR","Gns. CPC","Gns. CPM","Pris","Konv. (en pr. klik)","Pris/konv. (en pr. klik)","Konv.frekv. (en pr. klik)","Samlet konv.værdi","Værdi/konv. (en pr. klik)"]
["Dutch","Zoekwoord","Campagne","Advertentiegroep","Status","Max. CPC","Aantal klikken","Vertoningen","CTR","Gem. CPC","Gem. CPM","Kosten","Conv. (1-per-klik)","Kosten / conv. (1-per-klik)","Conv. perc. (1-per-klik)","Totale conv.waarde","Waarde/conv. (1-per-klik)"]
["French","Mot clé","Campagne","Groupe d'annonces","État","CPC max.","Clics","Impressions","CTR","CPC moy.","CPM moy.","Coût","Conv. (1 par clic)","Coût/Conv. (1 par clic)","Taux de conv. (1 par clic)","Valeur de conv. totale","Valeur/conv. (1 par clic)"]
["German","Keyword","Kampagne","Anzeigengruppe","Status","Max. CPC","Klicks","Impressionen","CTR","Durchschn. CPC","Durchschn. CPM","Kosten","Conv. (1-pro-Klick)","Kosten/Conv. (1-pro-Klick)","Conv.-Rate (1-pro-Klick)","Conv.-Wert gesamt","Wert/Conv. (1-pro-Klick)"]
["Italian","Parola chiave","Campagna","Gruppo di annunci",null,"CPC max","Clic","Impressioni","CTR","CPC medio","CPM medio","Costo","Conv. (1 per clic)","Costo/Conv. (1 per clic)","Tasso conv. (1 per clic)","Valore conv. totali","Valore/conv. (1 per clic)"]
["Japanese","キーワード","キャンペーン","広告グループ","ステータス","上限クリック単価","クリック数","表示回数","クリック率","平均クリック単価","平均 CPM","ご利用金額","クリックスルー コンバージョン","費用/クリックスルー コンバージョン","クリックスルー コンバージョン率","ビュースルー コンバージョン","値/クリックスルー コンバージョン"]
["Korean","키워드","캠페인","광고그룹","상태","최대 CPC","클릭수","노출수","클릭률(CTR)","평균 CPC","평균 CPM","비용","전환수(순 방문자 기준)","전환당비용(순 방문자 기준)","전환율(순 방문자 기준)","총 전환 가치","전환당 전환 가치(순 방문자 기준)"]
["Portuguese (Brazil)","Palavra-chave","Campanha","Grupo de anúncios","Status","CPC máx.","Cliques","Impressões","CTR","CPC médio","CPM méd.","Custo","Conv. (1 por clique)","Custo/conv. (uma por clique)","Taxa conv. (uma por clique)","Conv. de visualização","Valor/conv. (1 por clique)"]
["Portuguese (Portugal)","Palavra-chave","Campanha","Grupo de anúncios","Estado","CPC máx.","Cliques","Impressões","CTR","CPC Médio","CPM médio","Custo","Conv. (1 por clique)","Custo/conv. (1 por clique)","Taxa de conv. (1 por clique)","Conversões através da visualização","Valor/conv. (1 por clique)"]
["Spanish","Palabra clave","Campaña","Grupo de anuncios","Estado","CPC máx.","Clics","Impresiones","CTR","CPC medio","CPM medio","Coste","Conv. (1 por clic)","Coste/conv. (1 por clic)","Porcentaje de conversiones (1 por clic)","Valor conv. totales","Valor/conv. (1 por clic)"]
["Swedish","Sökord","Kampanj","Annonsgrupp","Status","Högsta CPC","Klick","Visningar","CTR","Gen. CPC","Gen. CPM","Kostnad","Omv. (1 per klick)","Kostn./omv. (1 per klick)","Omv.frekvens (1 per klick)","Summa omv.värde","Värde/omv. (1 per klick)"]

{"sheet":"Placement Header","index":2,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["English","Domain","Placement","Ad group","Campaign","Criteria Display Name","Status","Max. CPC","Clicks","Impressions","CTR","Avg. CPC","Cost","Conv. (1-per-click)","Cost / conv. (1-per-click)","Conv. rate (1-per-click)","View-through conv.","Targeting Mode"]
["Chinese (Simplified)","域名","展示位置","广告组","广告系列","标准显示名称","状态","最高每次点击费用","点击次数","展示次数","点击率","平均每次点击费用","总费用","转化次数（每次点击仅算一次转化）","费用/转化次数（每次点击仅算一次转化）","转化率（每次点击仅算一次转化）","浏览型转化","定位模式"]
["Chinese (Traditional)","網域","刊登位置","廣告群組","廣告活動","條件顯示名稱","狀態","最高單次點擊出價","點擊","曝光","點閱率","平均單次點擊出價","費用","轉換 (單次點擊單次轉換)","單次轉換費用 (單次點擊單次轉換)","轉換率 (單次點擊單次轉換)","查看轉換次數","指定方式"]
["Danish","Domæne","Placering","Annoncegruppe","Kampagne","Kriterievisningsnavn","Status","Maks. CPC","Klik","Visninger","CTR","Gns. CPC","Pris","Konv. (en pr. klik)","Pris/konv. (en pr. klik)","Konv.frekv. (en pr. klik)","Visningskonvertering","Målretningstilstand"]
["Dutch","Domein","Plaatsing","Advertentiegroep","Campagne","Weergavenaam voor criteria","Status","Max. CPC","Aantal klikken","Vertoningen","CTR","Gem. CPC","Kosten","Conv. (1-per-klik)","Kosten / conv. (1-per-klik)","Conv. perc. (1-per-klik)","Weergaveconversie","Targetingmodus"]
["French","Domaine","Emplacement","Groupe d'annonces","Campagne","Nom d'affichage des critères","État","CPC max.","Clics","Impressions","CTR","CPC moy.","Coût","Conv. (1 par clic)","Coût/Conv. (1 par clic)","Taux de conv. (1 par clic)","Conv. après affichage","Mode de ciblage"]
["German","Domain","Placement","Anzeigengruppe","Kampagne","Anzeigename für Kriterien","Status","Max. CPC","Klicks","Impressionen","CTR","Durchschn. CPC","Kosten","Conv. (1-pro-Klick)","Kosten/Conv. (1-pro-Klick)","Conv.-Rate (1-pro-Klick)","View-through-Conv.","Ausrichtungsmodus"]
["Italian","Dominio","Posizionamento","Gruppo di annunci","Campagna","Nome visualizzato dei criteri","Stato","CPC max","Clic","Impressioni","CTR","CPC medio","Costo","Conv. (1 per clic)","Costo/Conv. (1 per clic)","Tasso conv. (1 per clic)","Conv. view-through","Modalità di targeting"]
["Japanese","ドメイン","プレースメント","広告グループ","キャンペーン","クライテリア表示名","ステータス","上限クリック単価","クリック数","表示回数","クリック率","平均クリック単価","ご利用金額","クリックスルー コンバージョン","費用/クリックスルー コンバージョン","クリックスルー コンバージョン率","ビュースルー コンバージョン","ターゲット モード"]
["Korean","도메인","게재위치","광고그룹","캠페인","기준 표시 이름","상태","최대 CPC","클릭수","노출수","클릭률(CTR)","평균 CPC","비용","전환수(순 방문자 기준)","전환당비용(순 방문자 기준)","전환율(순 방문자 기준)","조회 후 전환","타겟팅 모드"]
["Portuguese (Brazil)","Domínio","Posicionamento","Grupo de anúncios","Campanha","Nome de exibição dos critérios","Status","CPC máx.","Cliques","Impressões","CTR","CPC médio","Custo","Conv. (1 por clique)","Custo/conv. (uma por clique)","Taxa conv. (uma por clique)","Conv. de visualização","Modo de segmentação"]
["Portuguese (Portugal)","Domínio","Posicionamento","Grupo de anúncios","Campanha","Nome de Apresentação dos Critérios","Estado","CPC máx.","Cliques","Impressões","CTR","CPC Médio","Custo","Conv. (1 por clique)","Custo/conv. (1 por clique)","Taxa de conv. (1 por clique)","Conversões através da visualização","Modo de segmentação"]
["Spanish","Dominio","Ubicación","Grupo de anuncios","Campaña","Nombre visible de criterio","Estado","CPC máx.","Clics","Impresiones","CTR","CPC medio","Coste","Conv. (1 por clic)","Coste/conv. (1 por clic)","Porcentaje de conversiones (1 por clic)","Conv. con vista","Modo de orientación"]
["Swedish","Domän","Placering","Annonsgrupp","Kampanj","Kriterier för visningsnamn","Status","Högsta CPC","Klick","Visningar","CTR","Gen. CPC","Kostnad","Omv. (1 per klick)","Kostn./omv. (1 per klick)","Omv.frekvens (1 per klick)","Visningsbaserade omv.","Inriktningsläge"]

{"sheet":"Read Me","index":3,"n_rows":243,"n_cols":5,"rows_kept":243,"cut":false,"hidden":false,"merged":[[11,2,12,7],[217,2,218,7],[15,2,15,7],[16,3,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[0,1,0,7],[2,1,2,7],[3,2,4,7],[5,2,7,7],[8,2,9,7],[28,2,28,7],[29,2,29,7],[30,3,31,7],[33,2,33,7],[34,2,34,7],[35,2,35,7],[22,2,22,7],[23,2,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[42,2,42,7],[43,2,43,7],[44,2,44,7],[45,2,45,7],[47,2,47,7],[48,2,48,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7],[40,2,40,7],[41,2,41,7],[55,2,55,7],[56,2,56,7],[57,2,57,7],[58,2,58,7],[59,2,59,7],[60,2,60,7],[49,2,49,7],[50,2,50,7],[51,2,51,7],[52,2,52,7],[53,2,53,7],[54,2,54,7],[68,2,68,7],[69,2,69,7],[70,2,70,7],[71,2,71,7],[72,2,72,7],[73,2,73,7],[61,2,61,7],[62,2,62,7],[63,2,63,7],[64,2,64,7],[65,3,66,7],[67,2,67,7],[80,2,80,7],[81,2,81,7],[82,2,82,7],[83,2,83,7],[84,2,84,7],[85,2,85,7],[74,2,74,7],[75,2,75,7],[76,2,76,7],[77,2,77,7],[78,2,78,7],[79,2,79,7],[92,2,92,7],[93,2,93,7],[94,2,94,7],[95,2,95,7],[96,2,96,7],[97,2,97,7],[86,2,86,7],[87,2,87,7],[88,2,88,7],[89,2,89,7],[90,2,90,7],[91,2,91,7],[137,2,137,7],[138,2,138,7],[139,2,139,7],[140,2,140,7],[141,2,141,7],[142,2,142,7],[98,2,98,7],[99,2,99,7],[100,2,100,7],[101,2,101,7],[102,2,102,7],[136,2,136,7],[103,2,103,7],[125,2,126,7],[150,2,150,7],[152,2,152,7],[153,2,153,7],[154,2,154,7],[155,2,155,7],[156,2,156,7],[143,2,143,7],[144,2,144,7],[145,2,145,7],[146,2,146,7],[147,2,147,7],[148,3,149,7],[163,2,163,7],[164,2,164,7],[165,2,165,7],[166,2,166,7],[167,2,167,7],[168,2,168,7],[157,2,157,7],[158,2,158,7],[159,2,159,7],[160,2,160,7],[161,2,161,7],[162,2,162,7],[176,2,176,7],[177,2,177,7],[178,2,178,7],[179,2,179,7],[180,2,180,7],[181,2,181,7],[170,2,170,7],[171,2,171,7],[172,2,172,7],[173,2,173,7],[174,2,174,7],[175,2,175,7],[187,2,187,7],[188,2,188,7],[189,2,189,7],[190,2,190,7],[191,2,191,7],[192,2,192,7],[182,2,182,7],[183,2,183,7],[184,2,184,7],[185,2,185,7],[186,2,186,7],[199,2,199,7],[200,2,200,7],[201,2,201,7],[202,2,202,7],[203,2,203,7],[204,2,204,7],[193,2,193,7],[194,2,194,7],[195,2,195,7],[196,2,196,7],[197,2,197,7],[198,2,198,7],[211,2,211,7],[212,2,212,7],[213,2,213,7],[214,2,214,7],[215,2,215,7],[216,2,216,7],[205,2,205,7],[206,2,206,7],[207,2,207,7],[208,2,208,7],[209,2,209,7],[210,2,210,7],[248,2,248,7],[249,2,249,7],[250,2,250,7],[251,2,251,7],[252,2,252,7],[253,2,253,7],[242,2,242,7],[243,2,243,7],[244,2,244,7],[245,2,245,7],[246,2,246,7],[247,2,247,7],[260,2,260,7],[261,2,261,7],[262,2,262,7],[263,2,263,7],[264,2,264,7],[254,2,254,7],[255,2,255,7],[256,2,256,7],[257,2,257,7],[258,2,258,7],[259,2,259,7]]}
[null,"Instructions"]
[]
[null,"Caveats"]
[null,1,"The Macro only works for conversion-tracking installed accounts, because the Macro optimizes based on your conversion or CPA data."]
[]
[null,2,"The Macro only works for Manual CPC bidding campaigns, not Conversion Optimizer enabled campaigns, auto bidding or CPM campaigns.  So, if you download all campaign reports, please make sure all campaigns use Manaul CPC bidding."]
[]
[]
[null,3,"Make sure to download the keyword report from the Display Network Tab - not the \"Keywords\" tab, because this Macro only works for Display Campaigns."]
[]
[]
[null,4,"The Macro supports headings in English, Chinese, Danish, Dutch, French, German, Italian, Japanese, Korean, Portuguese,Spanish and Swedish ."]
[]
[]
[null,"Steps"]
[null,1,"Download Report from AdWords Interface"]
[null,null,"a. ","If you would like to optimize keyword report, you can download account, campaign or ad group level report from display network tab."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"b.","If you would like to optimize \"automatic placement\" report, you must download BOTH campaign-level keyword and automatic placement reports from display network tab."]
[]
[null,null,null,"b1.","Download \"campaign-level\" keyword report"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"b2.","Download \"campaign-level\" automatic placement report"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"c.","If you would like to optimize \"managed placement\" report, you can download account, campaign or ad group level report from display network tab."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2,"Excute the Macro from clicking on one of buttons in \"Scenario\" Tab."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,3,"You will be prompted to read the disclaimer, if this is the first time using the Macro."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,4,"You will be prompted to provide your customer ID.  This is optional, but we encourage you to provide to help us improve the tool better."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,5,"Import the download csv"]
[null,null,"a. If you choose \"Keyword Optimization\", browse the keyword report that you just downloaded."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"b."," If you choose \"Placement Optimization\", you will be prompted to select either automatic or managed placements optimization."]
[]
[]
[null,null,null,"b1","Optimize Automatic Placements"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"b2","Optimize Managed Placements"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6,"Set up the criteria for optimzation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,7,"You will be redirected to see this page, because we would like to track your usage.  Please close the tab once it is loaded and go back to the Excel."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,8,"Review the result in the \"Upload Changes to Editor\" Tab.  Make necessary change and then upload via Editor."]