{"id":378,"date":"2024-02-06T20:51:00","date_gmt":"2024-02-06T19:51:00","guid":{"rendered":"https:\/\/nilsrooijmans.com\/daily\/?p=378"},"modified":"2024-02-28T09:45:38","modified_gmt":"2024-02-28T08:45:38","slug":"google-ads-script-tag-your-winning-search-ads","status":"publish","type":"post","link":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads","title":{"rendered":"[Google Ads Script] Tag your winning search ads"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Here&#8217;s my catch of the day: a script by fellow PPC friend&nbsp;Kian N\u2019jie.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SCRIPT: Winning Search Ad Tagger<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>URL: <\/strong><a href=\"https:\/\/docs.google.com\/document\/d\/1OTvluEAh9d8nt5B-sHcu5oyipu1jVqGd6bxuEyolWoI\/view\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.google.com\/document\/d\/1OTvluEAh9d8nt5B-sHcu5oyipu1jVqGd6bxuEyolWoI\/view<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What it does:<\/strong><br>This script reviews all the RSAs within each enabled ad group, then labels the ad with the highest &#8220;conversions per impression (CPI)&#8221;, where CPI = CTR*Conv.Rate.\u00a0It looks at data over the last 30 days and labels the winning ad \u2018Current Winner\u2019. This allows for easy filtering and organization via Google Ads Editor or any other tool. The script also updates these labels each time it runs when you schedule it to run regularly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Why you care:<\/strong><br>When you are A\/B testing your ad copy, CPI is a key metric that shows the ratio between impressions and conversions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;ll let\u00a0<a href=\"https:\/\/adalysis.com\/blog\/inside-ad-testing-metrics-conversion-per-impression-cpi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Brad Geddes explain<\/a>:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">&#8220;<em>When you consider ad testing, which combination is better?<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>A) A high CTR and a low conversion rate<br>\u00a0 \u00a0&#8211; Lots of people click on your ads, so your page gets a lot of visibility, but not many of those users convert<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>B) A low CTR and a high conversion rate<br>\u00a0 \u00a0&#8211; Not many people click on your ads, but of those that do, many of them convert<br><br>It\u2019s impossible to say which is better since that information relies on two different metrics: CTR and Conversion rate.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>What CPI does is combine these two different metrics to form one single metric that will show you which ad will receive the most conversions from the impression.<\/em>&#8220;<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">PRO TIP: Add CPI as a custom column in your Google Ads interface to easily see the different CPI values for your different ads.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8211; Nils<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PS: This script would be even better if it only looked at ads that had gained a significant amount of impressions before choosing a winner.\u00a0It currently looks at all enabled ads, irrespective of the number of impressions, which I think is a mistake. If you agree and want the version that does take a minimum number of impressions into account -> send me an email at nils@nilsrooijmans.com.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s my catch of the day: a script by fellow PPC friend&nbsp;Kian N\u2019jie. SCRIPT: Winning Search Ad Tagger URL: https:\/\/docs.google.com\/document\/d\/1OTvluEAh9d8nt5B-sHcu5oyipu1jVqGd6bxuEyolWoI\/view What it does:This script reviews all the RSAs within each enabled ad group, then labels the ad with the highest &#8220;conversions per impression (CPI)&#8221;, where CPI = CTR*Conv.Rate.\u00a0It looks at data over the last 30 &hellip; <a href=\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;[Google Ads Script] Tag your winning search ads&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-378","post","type-post","status-publish","format-standard","hentry","category-google-ads"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[Google Ads Script] Tag your winning search ads - Nils Rooijmans<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Google Ads Script] Tag your winning search ads - Nils Rooijmans\" \/>\n<meta property=\"og:description\" content=\"Here&#8217;s my catch of the day: a script by fellow PPC friend&nbsp;Kian N\u2019jie. SCRIPT: Winning Search Ad Tagger URL: https:\/\/docs.google.com\/document\/d\/1OTvluEAh9d8nt5B-sHcu5oyipu1jVqGd6bxuEyolWoI\/view What it does:This script reviews all the RSAs within each enabled ad group, then labels the ad with the highest &#8220;conversions per impression (CPI)&#8221;, where CPI = CTR*Conv.Rate.\u00a0It looks at data over the last 30 &hellip; Continue reading &quot;[Google Ads Script] Tag your winning search ads&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\" \/>\n<meta property=\"og:site_name\" content=\"Nils Rooijmans\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-06T19:51:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-28T08:45:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_GreenBG_SQUARE_200x186.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"186\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nils Rooijmans\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nils Rooijmans\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads#article\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\"},\"author\":{\"name\":\"Nils Rooijmans\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"headline\":\"[Google Ads Script] Tag your winning search ads\",\"datePublished\":\"2024-02-06T19:51:00+00:00\",\"dateModified\":\"2024-02-28T08:45:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\"},\"wordCount\":364,\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"articleSection\":[\"Google Ads\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\",\"name\":\"[Google Ads Script] Tag your winning search ads - Nils Rooijmans\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\"},\"datePublished\":\"2024-02-06T19:51:00+00:00\",\"dateModified\":\"2024-02-28T08:45:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nilsrooijmans.com\/daily\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Google Ads Script] Tag your winning search ads\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/\",\"name\":\"Nils Rooijmans Daily Newsletter - Google Ads\",\"description\":\"Daily emails to boost your Google Ads Performance\",\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nilsrooijmans.com\/daily\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\",\"name\":\"Nils Rooijmans\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg\",\"contentUrl\":\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg\",\"width\":300,\"height\":300,\"caption\":\"Nils Rooijmans\"},\"logo\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/\"},\"description\":\"Google Ads Performance Architect with a passion for PPC Automation &amp; AI, in particular via Google Ads Scripts.\",\"sameAs\":[\"https:\/\/nilsrooijmans.com\/\",\"https:\/\/www.linkedin.com\/in\/nilsrooijmans\/\"],\"url\":\"https:\/\/nilsrooijmans.com\/daily\/author\/nils\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Google Ads Script] Tag your winning search ads - Nils Rooijmans","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads","og_locale":"en_US","og_type":"article","og_title":"[Google Ads Script] Tag your winning search ads - Nils Rooijmans","og_description":"Here&#8217;s my catch of the day: a script by fellow PPC friend&nbsp;Kian N\u2019jie. SCRIPT: Winning Search Ad Tagger URL: https:\/\/docs.google.com\/document\/d\/1OTvluEAh9d8nt5B-sHcu5oyipu1jVqGd6bxuEyolWoI\/view What it does:This script reviews all the RSAs within each enabled ad group, then labels the ad with the highest &#8220;conversions per impression (CPI)&#8221;, where CPI = CTR*Conv.Rate.\u00a0It looks at data over the last 30 &hellip; Continue reading \"[Google Ads Script] Tag your winning search ads\"","og_url":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads","og_site_name":"Nils Rooijmans","article_published_time":"2024-02-06T19:51:00+00:00","article_modified_time":"2024-02-28T08:45:38+00:00","og_image":[{"width":200,"height":186,"url":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_GreenBG_SQUARE_200x186.jpg","type":"image\/jpeg"}],"author":"Nils Rooijmans","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nils Rooijmans","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads#article","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads"},"author":{"name":"Nils Rooijmans","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"headline":"[Google Ads Script] Tag your winning search ads","datePublished":"2024-02-06T19:51:00+00:00","dateModified":"2024-02-28T08:45:38+00:00","mainEntityOfPage":{"@id":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads"},"wordCount":364,"publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"articleSection":["Google Ads"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads","url":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads","name":"[Google Ads Script] Tag your winning search ads - Nils Rooijmans","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#website"},"datePublished":"2024-02-06T19:51:00+00:00","dateModified":"2024-02-28T08:45:38+00:00","breadcrumb":{"@id":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-tag-your-winning-search-ads#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nilsrooijmans.com\/daily"},{"@type":"ListItem","position":2,"name":"[Google Ads Script] Tag your winning search ads"}]},{"@type":"WebSite","@id":"https:\/\/nilsrooijmans.com\/daily\/#website","url":"https:\/\/nilsrooijmans.com\/daily\/","name":"Nils Rooijmans Daily Newsletter - Google Ads","description":"Daily emails to boost your Google Ads Performance","publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nilsrooijmans.com\/daily\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0","name":"Nils Rooijmans","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/","url":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg","contentUrl":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg","width":300,"height":300,"caption":"Nils Rooijmans"},"logo":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/"},"description":"Google Ads Performance Architect with a passion for PPC Automation &amp; AI, in particular via Google Ads Scripts.","sameAs":["https:\/\/nilsrooijmans.com\/","https:\/\/www.linkedin.com\/in\/nilsrooijmans\/"],"url":"https:\/\/nilsrooijmans.com\/daily\/author\/nils"}]}},"_links":{"self":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/comments?post=378"}],"version-history":[{"count":1,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/378\/revisions"}],"predecessor-version":[{"id":379,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/378\/revisions\/379"}],"wp:attachment":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/media?parent=378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/categories?post=378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/tags?post=378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}