{"id":435,"date":"2022-10-04T19:09:00","date_gmt":"2022-10-04T17:09:00","guid":{"rendered":"https:\/\/nilsrooijmans.com\/daily\/?p=435"},"modified":"2024-03-11T10:54:12","modified_gmt":"2024-03-11T09:54:12","slug":"query-migration-tool","status":"publish","type":"post","link":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool","title":{"rendered":"Query Migration Tool"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Last week, I was in Berlin to attend and present at the SMX Advanced event.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Several people joined my workshop on the Google Ads Query Language.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We discussed many aspects of this new way of getting reports from the new Google Ads script environment.\u00a0You know, this new environment\u00a0<strong>we all need to migrate to before the end of this month.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One of the more challenging parts of migrating your current scripts to the new environment is the migration of AWQL queries to GAQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is a tool that might be of help if you get stuck: <a href=\"https:\/\/developers.google.com\/google-ads\/scripts\/docs\/reference\/query-migration-tool\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/developers.google.com\/google-ads\/api\/docs\/migration\/query-migration-tool<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8211; Nils<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PS: Having trouble migrating your scripts? I&#8217;m currently offering 1-hour migration support sessions. Email me at nils@nilsrooijmans.com to get on the list for that.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last week, I was in Berlin to attend and present at the SMX Advanced event. Several people joined my workshop on the Google Ads Query Language. We discussed many aspects of this new way of getting reports from the new Google Ads script environment.\u00a0You know, this new environment\u00a0we all need to migrate to before the &hellip; <a href=\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Query Migration Tool&#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-435","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>Query Migration Tool - 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\/query-migration-tool\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query Migration Tool - Nils Rooijmans\" \/>\n<meta property=\"og:description\" content=\"Last week, I was in Berlin to attend and present at the SMX Advanced event. Several people joined my workshop on the Google Ads Query Language. We discussed many aspects of this new way of getting reports from the new Google Ads script environment.\u00a0You know, this new environment\u00a0we all need to migrate to before the &hellip; Continue reading &quot;Query Migration Tool&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\" \/>\n<meta property=\"og:site_name\" content=\"Nils Rooijmans\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-04T17:09:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-11T09:54:12+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\/query-migration-tool#article\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\"},\"author\":{\"name\":\"Nils Rooijmans\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"headline\":\"Query Migration Tool\",\"datePublished\":\"2022-10-04T17:09:00+00:00\",\"dateModified\":\"2024-03-11T09:54:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\"},\"wordCount\":138,\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"articleSection\":[\"Google Ads\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\",\"name\":\"Query Migration Tool - Nils Rooijmans\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\"},\"datePublished\":\"2022-10-04T17:09:00+00:00\",\"dateModified\":\"2024-03-11T09:54:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nilsrooijmans.com\/daily\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query Migration Tool\"}]},{\"@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":"Query Migration Tool - 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\/query-migration-tool","og_locale":"en_US","og_type":"article","og_title":"Query Migration Tool - Nils Rooijmans","og_description":"Last week, I was in Berlin to attend and present at the SMX Advanced event. Several people joined my workshop on the Google Ads Query Language. We discussed many aspects of this new way of getting reports from the new Google Ads script environment.\u00a0You know, this new environment\u00a0we all need to migrate to before the &hellip; Continue reading \"Query Migration Tool\"","og_url":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool","og_site_name":"Nils Rooijmans","article_published_time":"2022-10-04T17:09:00+00:00","article_modified_time":"2024-03-11T09:54:12+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\/query-migration-tool#article","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool"},"author":{"name":"Nils Rooijmans","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"headline":"Query Migration Tool","datePublished":"2022-10-04T17:09:00+00:00","dateModified":"2024-03-11T09:54:12+00:00","mainEntityOfPage":{"@id":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool"},"wordCount":138,"publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"articleSection":["Google Ads"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool","url":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool","name":"Query Migration Tool - Nils Rooijmans","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#website"},"datePublished":"2022-10-04T17:09:00+00:00","dateModified":"2024-03-11T09:54:12+00:00","breadcrumb":{"@id":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nilsrooijmans.com\/daily\/query-migration-tool"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nilsrooijmans.com\/daily\/query-migration-tool#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nilsrooijmans.com\/daily"},{"@type":"ListItem","position":2,"name":"Query Migration Tool"}]},{"@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\/435","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=435"}],"version-history":[{"count":1,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/435\/revisions"}],"predecessor-version":[{"id":436,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/435\/revisions\/436"}],"wp:attachment":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/media?parent=435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/categories?post=435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/tags?post=435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}