{"id":894,"date":"2021-09-13T10:16:00","date_gmt":"2021-09-13T08:16:00","guid":{"rendered":"https:\/\/nilsrooijmans.com\/daily\/?p=894"},"modified":"2024-06-19T08:30:27","modified_gmt":"2024-06-19T06:30:27","slug":"eta-to-rsa-migration-toolkit-script-1","status":"publish","type":"post","link":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1","title":{"rendered":"ETA-to-RSA migration toolkit: Script #1"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Google recently announced that they will be sunsetting Expanded Text Ads (ETAs). Beginning in July 2022, you will no longer be able to create new ETAs or edit existing ETAs in Google Ads.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Although existing ETAs will continue to be shown after the change, we all need to prepare for a world where Responsive Search Ads (RSAs) are the only option for your new ads.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To help you prepare for this change,&nbsp;<strong>I will be creating a small library of new scripts that will help you make the most of this transition.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are still 10 months of runway, so let&#8217;s do this: <strong>let&#8217;s make those RSAs outperform your ETAs!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The\u00a0<strong>first script\u00a0<\/strong>in this series solves a simple problem: knowing what ad groups do not have an\u00a0RSA yet and where to best allocate your time in the creation of new RSAs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The script will check all enabled ad groups in all enabled search campaigns, and:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>for each ad group, it will check if you have at least the minimum number of RSAs enabled (threshold configurable),<\/li>\n\n\n\n<li>if the ad group does not have the minimum number of RSAs, it is logged in a Google Sheet, and the rows in the sheet will be sorted by the number of impressions of the ad group<\/li>\n\n\n\n<li>also, if the ad group does not have the minimum number of RSAs, AND if the ad group has had over X impressions during the last 7 days, an email alert will be sent (where X is also configurable).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Stay tuned,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8211; Nils<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google recently announced that they will be sunsetting Expanded Text Ads (ETAs). Beginning in July 2022, you will no longer be able to create new ETAs or edit existing ETAs in Google Ads. Although existing ETAs will continue to be shown after the change, we all need to prepare for a world where Responsive Search &hellip; <a href=\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;ETA-to-RSA migration toolkit: Script #1&#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-894","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>ETA-to-RSA migration toolkit: Script #1 - 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\/eta-to-rsa-migration-toolkit-script-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ETA-to-RSA migration toolkit: Script #1 - Nils Rooijmans\" \/>\n<meta property=\"og:description\" content=\"Google recently announced that they will be sunsetting Expanded Text Ads (ETAs). Beginning in July 2022, you will no longer be able to create new ETAs or edit existing ETAs in Google Ads. Although existing ETAs will continue to be shown after the change, we all need to prepare for a world where Responsive Search &hellip; Continue reading &quot;ETA-to-RSA migration toolkit: Script #1&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\" \/>\n<meta property=\"og:site_name\" content=\"Nils Rooijmans\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-13T08:16:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-19T06:30:27+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1#article\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\"},\"author\":{\"name\":\"Nils Rooijmans\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"headline\":\"ETA-to-RSA migration toolkit: Script #1\",\"datePublished\":\"2021-09-13T08:16:00+00:00\",\"dateModified\":\"2024-06-19T06:30:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\"},\"wordCount\":261,\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"articleSection\":[\"Google Ads\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\",\"name\":\"ETA-to-RSA migration toolkit: Script #1 - Nils Rooijmans\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\"},\"datePublished\":\"2021-09-13T08:16:00+00:00\",\"dateModified\":\"2024-06-19T06:30:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nilsrooijmans.com\/daily\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ETA-to-RSA migration toolkit: Script #1\"}]},{\"@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":"ETA-to-RSA migration toolkit: Script #1 - 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\/eta-to-rsa-migration-toolkit-script-1","og_locale":"en_US","og_type":"article","og_title":"ETA-to-RSA migration toolkit: Script #1 - Nils Rooijmans","og_description":"Google recently announced that they will be sunsetting Expanded Text Ads (ETAs). Beginning in July 2022, you will no longer be able to create new ETAs or edit existing ETAs in Google Ads. Although existing ETAs will continue to be shown after the change, we all need to prepare for a world where Responsive Search &hellip; Continue reading \"ETA-to-RSA migration toolkit: Script #1\"","og_url":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1","og_site_name":"Nils Rooijmans","article_published_time":"2021-09-13T08:16:00+00:00","article_modified_time":"2024-06-19T06:30:27+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":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1#article","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1"},"author":{"name":"Nils Rooijmans","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"headline":"ETA-to-RSA migration toolkit: Script #1","datePublished":"2021-09-13T08:16:00+00:00","dateModified":"2024-06-19T06:30:27+00:00","mainEntityOfPage":{"@id":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1"},"wordCount":261,"publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"articleSection":["Google Ads"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1","url":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1","name":"ETA-to-RSA migration toolkit: Script #1 - Nils Rooijmans","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#website"},"datePublished":"2021-09-13T08:16:00+00:00","dateModified":"2024-06-19T06:30:27+00:00","breadcrumb":{"@id":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nilsrooijmans.com\/daily\/eta-to-rsa-migration-toolkit-script-1#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nilsrooijmans.com\/daily"},{"@type":"ListItem","position":2,"name":"ETA-to-RSA migration toolkit: Script #1"}]},{"@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\/894","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=894"}],"version-history":[{"count":1,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"predecessor-version":[{"id":895,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/894\/revisions\/895"}],"wp:attachment":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}