{"id":627,"date":"2019-04-16T21:40:36","date_gmt":"2019-04-16T21:40:36","guid":{"rendered":"https:\/\/searchadspro.com\/?p=627"},"modified":"2019-04-16T21:49:28","modified_gmt":"2019-04-16T21:49:28","slug":"google-ads-script-to-get-search-terms-to-a-spreadsheet","status":"publish","type":"post","link":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/","title":{"rendered":"Google Ads Script to Get Search Terms to a Spreadsheet"},"content":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243;][et_pb_row][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.21.1&#8243; z_index_tablet=&#8221;500&#8243;]<\/p>\n<h2>Google Ads Script to Get Search Terms to a Spreadsheet Given a Date Range<\/h2>\n<p>I was writing this Google Ads script to extract Search Terms from my campaigns for a client. And I happen stumble upon a comment on the Google Ads Strategy Facebook group asking for a similar script, so I decided to polish it a little bit and post this script on my website and link it from the facebook group.<\/p>\n<p>You can use this script to extract search terms from your account, so you can add new keywords into your Google Ads account or add negative keywords into the account, whatever the purpose this should help speed up your search terms analysis. You can schedule this script to run weekly so you can do your search terms analysis weekly or however often you&#8217;d like.<\/p>\n<p>The script requires a few configuration so you can get the most out of it.<\/p>\n<p><strong>First<\/strong>, copy and paste the script below to your Google Ads account.<\/p>\n<p><strong>Second<\/strong>, copy the spreadsheet template and enter the url into the script by replacing the spreadsheetUrl variable(line 4) in the script.<\/p>\n<p><a style=\"color: blue; text-decoration: underline;\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1x5ADciCWOBgBlkyrdPhgB1EEECjTdIIpTRXS9WAlI3I\/edit#gid=0\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Copy this Spreadsheet Template<\/a><\/p>\n<p><strong>Third<\/strong>, create a label and attach it to all the campaigns you want to extract your search terms from and enter the label into the spreadsheet by replacing the YourLabelHere.<\/p>\n<p><strong>Fourth<\/strong>, pick the date range you want the script to use to extract from your Google Ads account.<\/p>\n<p><strong>Fifth<\/strong>, optional, you can schedule this script to run weekly or monthly.<\/p>\n<p>Enjoy! Please let me know what you think! My email is in the spreadsheet.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-highlight=\"4\">function main() {\r\n  \/\/mcc();\r\n\r\n  var spreadsheetUrl = 'https:\/\/docs.google.com\/spreadsheets\/d\/1x5ADciCWOBgBlkyrdPhgB1EEECjTdIIpTRXS9WAlI3I\/edit?usp=sharing';\r\n\r\n  var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);\r\n  var sheet = spreadsheet.getSheetByName(\"Config\");\r\n  var range = sheet.getDataRange();\r\n  var data = range.getValues();\r\n\r\n  var dateRange = 'Today';\r\n  var extractLabel = 'ValidLabel';\r\n  for(i=0;i&lt;data.length;i++){\r\n    if(data[i][0] == 'EXIT'){\r\n      break;\r\n    }else if(data[i][0] == 'DateRange'){\r\n      dateRange = data[i][1];\r\n    }else if(data[i][0] == 'CampaignLabel'){\r\n      extractLabel = data[i][1];\r\n    }\r\n  }\r\n\r\n  var campaignIds = [];\r\n\r\n  var campaignSelector = AdsApp\r\n  .campaigns()\r\n  .withCondition(\"LabelNames CONTAINS_ANY ['\" + extractLabel + \"']\");\r\n\r\n  var campaignIterator = campaignSelector.get();\r\n  while (campaignIterator.hasNext()) {\r\n    var campaign = campaignIterator.next();\r\n    campaignIds.push(campaign.getId());\r\n  }  \r\n\r\n  var awql = \"SELECT CampaignName, AdGroupName, Query, Ctr, Cost, Impressions, Conversions \" +\r\n      \"FROM   SEARCH_QUERY_PERFORMANCE_REPORT \" +\r\n      \"WHERE  Impressions &lt; 10 \" +\r\n      \" AND CampaignId in [\" + campaignIds.join(',') + \"] \" +\r\n      \"DURING \" + dateRange;\r\n  Logger.log(awql);\r\n  var report = AdsApp.report(awql);\r\n\r\n  report.exportToSheet(spreadsheet.insertSheet());\r\n  Logger.log(\"Report available at \" + spreadsheet.getUrl());\r\n}<\/pre>\n<p>\u00a0<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p><div class=\"et_pb_row et_pb_row_0 et_pb_row_empty\">\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div> Google Ads Script to Get Search Terms to a Spreadsheet Given a Date RangeI was writing this Google Ads script to extract Search Terms from my campaigns for a client. And I happen stumble upon a comment on the Google Ads Strategy Facebook group asking for a similar script, so I decided to polish [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":578,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[8],"tags":[20,19],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Ads Script to Get Search Terms to a Spreadsheet - SearchAdsPro.com<\/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:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Ads Script to Get Search Terms to a Spreadsheet - SearchAdsPro.com\" \/>\n<meta property=\"og:description\" content=\"Google Ads Script to Get Search Terms to a Spreadsheet Given a Date RangeI was writing this Google Ads script to extract Search Terms from my campaigns for a client. And I happen stumble upon a comment on the Google Ads Strategy Facebook group asking for a similar script, so I decided to polish [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"SearchAdsPro.com\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-16T21:40:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-16T21:49:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"harris\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"harris\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/\",\"url\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/\",\"name\":\"Google Ads Script to Get Search Terms to a Spreadsheet - SearchAdsPro.com\",\"isPartOf\":{\"@id\":\"https:\/\/searchadspro.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg\",\"datePublished\":\"2019-04-16T21:40:36+00:00\",\"dateModified\":\"2019-04-16T21:49:28+00:00\",\"author\":{\"@id\":\"https:\/\/searchadspro.com\/#\/schema\/person\/31110261336bfda861babde5f5627d71\"},\"breadcrumb\":{\"@id\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#primaryimage\",\"url\":\"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg\",\"contentUrl\":\"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg\",\"width\":200,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/searchadspro.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Ads Script to Get Search Terms to a Spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/searchadspro.com\/#website\",\"url\":\"https:\/\/searchadspro.com\/\",\"name\":\"SearchAdsPro.com\",\"description\":\"Google Ads Scripts For You!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/searchadspro.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/searchadspro.com\/#\/schema\/person\/31110261336bfda861babde5f5627d71\",\"name\":\"harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/searchadspro.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eaa09eb6b56be120316e01eec6ac8113?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eaa09eb6b56be120316e01eec6ac8113?s=96&d=mm&r=g\",\"caption\":\"harris\"},\"description\":\"Harris Lim is a Google Ads Manager since 2005 and have manage hundreds of local business Google Ads account. He currently focuses on Google Ads automation through Google Ads scripts. Find me on facebook https:\/\/www.facebook.com\/harrisyulim\",\"sameAs\":[\"https:\/\/searchadspro.com\"],\"url\":\"https:\/\/searchadspro.com\/author\/harris\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Ads Script to Get Search Terms to a Spreadsheet - SearchAdsPro.com","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:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"Google Ads Script to Get Search Terms to a Spreadsheet - SearchAdsPro.com","og_description":"Google Ads Script to Get Search Terms to a Spreadsheet Given a Date RangeI was writing this Google Ads script to extract Search Terms from my campaigns for a client. And I happen stumble upon a comment on the Google Ads Strategy Facebook group asking for a similar script, so I decided to polish [&hellip;]","og_url":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/","og_site_name":"SearchAdsPro.com","article_published_time":"2019-04-16T21:40:36+00:00","article_modified_time":"2019-04-16T21:49:28+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg","type":"image\/jpeg"}],"author":"harris","twitter_card":"summary_large_image","twitter_misc":{"Written by":"harris","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/","url":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/","name":"Google Ads Script to Get Search Terms to a Spreadsheet - SearchAdsPro.com","isPartOf":{"@id":"https:\/\/searchadspro.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg","datePublished":"2019-04-16T21:40:36+00:00","dateModified":"2019-04-16T21:49:28+00:00","author":{"@id":"https:\/\/searchadspro.com\/#\/schema\/person\/31110261336bfda861babde5f5627d71"},"breadcrumb":{"@id":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#primaryimage","url":"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg","contentUrl":"https:\/\/searchadspro.com\/wp-content\/uploads\/2019\/03\/code3.jpg","width":200,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/searchadspro.com\/google-ads-script-to-get-search-terms-to-a-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/searchadspro.com\/"},{"@type":"ListItem","position":2,"name":"Google Ads Script to Get Search Terms to a Spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/searchadspro.com\/#website","url":"https:\/\/searchadspro.com\/","name":"SearchAdsPro.com","description":"Google Ads Scripts For You!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/searchadspro.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/searchadspro.com\/#\/schema\/person\/31110261336bfda861babde5f5627d71","name":"harris","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/searchadspro.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eaa09eb6b56be120316e01eec6ac8113?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eaa09eb6b56be120316e01eec6ac8113?s=96&d=mm&r=g","caption":"harris"},"description":"Harris Lim is a Google Ads Manager since 2005 and have manage hundreds of local business Google Ads account. He currently focuses on Google Ads automation through Google Ads scripts. Find me on facebook https:\/\/www.facebook.com\/harrisyulim","sameAs":["https:\/\/searchadspro.com"],"url":"https:\/\/searchadspro.com\/author\/harris\/"}]}},"_links":{"self":[{"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/posts\/627"}],"collection":[{"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/comments?post=627"}],"version-history":[{"count":6,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/posts\/627\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/posts\/627\/revisions\/633"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/media\/578"}],"wp:attachment":[{"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/media?parent=627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/categories?post=627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/searchadspro.com\/wp-json\/wp\/v2\/tags?post=627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}