{"id":704,"date":"2017-01-20T12:54:11","date_gmt":"2017-01-20T08:54:11","guid":{"rendered":"https:\/\/optimizationup.com\/?p=704"},"modified":"2025-04-11T09:41:07","modified_gmt":"2025-04-11T05:41:07","slug":"search-query-report-adwords-script","status":"publish","type":"post","link":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/","title":{"rendered":"Run Search Query Report Like a Pro Using Google Ads Scripts"},"content":{"rendered":"\n

One of the most important reports of managing AdWords <\/a>campaigns is the search query report. You need to see the actual search queries that trigger your ads to identify new terms to add to your positive keywords and find undesired search terms and add them as negative keywords. Actually, the process can be time-consuming if you manage multiple accounts as you need to log in and manually generate the report each time.<\/p>\n\n\n\n

In order to get the most out of the search term report and make sure it runs consistently across all our accounts. We’ve written a new Google Ads script<\/a> that can automate and schedule the process for us. The script goes through all the campaigns\/accounts and returns search queries that meet certain criteria you set and store them in a spreadsheet.  And to ensure that the script doesn’t return the search queries that already added as positive\/negative keywords. The script iterates over all the keywords in all accounts and compares them to all the search queries. Then, the script returns 4 values of results in your Google spreadsheet:<\/p>\n\n\n\n

 <\/div>\n\n\n\n
# Added: the query is already added to your account as an exact match type.<\/div>\n\n\n\n
# Not Added: the query is not added and none of the criteria below applies to it.<\/div>\n\n\n\n
# Not added and has conversions: the query is not added and has a number of conversions higher than the conversion threshold.<\/div>\n\n\n\n
\n

# Not excluded and low performing: the query is not excluded as the CTR is lower than the threshold.<\/p>\n

\"\"<\/figure>

<\/p>\n

We’ve set 3 threshold elements that you can change easily depending on your goals:<\/p>\n<\/div>\n\n\n\n

 <\/div>\n\n\n\n
# Impressions: this is the minimum number of impressions of search queries to consider enough data.<\/div>\n\n\n\n
# CTR: If the CTR is below the threshold, the query will be labeled as “Not excluded and low performing”.<\/div>\n\n\n\n
\n

# Conversions: If the number of conversions is above the threshold and the query is not added anywhere in the account, the query will be labeled as “Not added and has conversions”.<\/p>\n

Once the script finishes, it sends an email to the specified email address. So, you can schedule the  Adwords script<\/a> to run at a specific time and once the report is ready, you will receive an email with your report.<\/p>\n<\/div>\n\n\n\n

 <\/h5>\n\n\n\n
Smart Search Query Report- Manager Account<\/h5>\n\n\n\n

Here\u2019s the source code for the MCC script. To ensure processing doesn\u2019t exceed limits, we recommend running the script on a maximum of 50 AdWords<\/a> accounts at a time.<\/p>\n\n\n\n

 <\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
\/***************************************************<\/span><\/span>\n*<\/span> Smart Search Query Report Script<\/span><\/span>\n*<\/span> Version <\/span>1.0<\/span><\/span>\n*<\/span> Created By<\/span>:<\/span> Ahmed Ali<\/span><\/span>\n*<\/span>https<\/span>:<\/span>\/\/<\/span>optimizationup<\/span>.<\/span>com<\/span>\/<\/span><\/span>\n****************************************************\/<\/span><\/span>\n<\/span>\n\/\/<\/span> Add your spreadsheet here<\/span><\/span>\nvar SPREADSHEET_URL <\/span>=<\/span> <\/span>'<\/span>https:\/\/docs.google.com\/spreadsheets\/d\/xxxxxxxxxx<\/span>'<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> This <\/span>is<\/span> the quereis minmum number of impressions<\/span>.<\/span><\/span>\nvar Impressions_Threshold <\/span>=<\/span> <\/span>50<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> If the CTR <\/span>is<\/span> below the threshold<\/span>,<\/span> it will be labeled <\/span>as<\/span> <\/span>"<\/span>Not excluded and low performing<\/span>"<\/span><\/span>\nvar CTR_Threshold <\/span>=<\/span> <\/span>1<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> If the number of converionis <\/span>is<\/span> above the threshold <\/span>and<\/span> the qury <\/span>is<\/span> <\/span>not<\/span> added<\/span>,<\/span> it will be labeld <\/span>as<\/span> <\/span>"<\/span>Not added and has conversions<\/span>"<\/span><\/span>\nvar Conversions_Threshold <\/span>=<\/span> <\/span>0<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> Add your email here<\/span><\/span>\nvar Notify_Me <\/span>=<\/span> <\/span>"<\/span>add your email here<\/span>"<\/span><\/span>\nvar sheet <\/span>=<\/span> SpreadsheetApp<\/span>.<\/span>openByUrl<\/span>(<\/span>SPREADSHEET_URL<\/span>).<\/span>getActiveSheet<\/span>()<\/span>;<\/span><\/span>\n<\/span>\nvar columns <\/span>=<\/span> <\/span>[<\/span><\/span>\n <\/span>'<\/span>CustomerDescriptiveName<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>ExternalCustomerId<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Query<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>CampaignName<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>AdGroupName<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Impressions<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Clicks<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Cost<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Ctr<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Conversions<\/span>'<\/span> <\/span><\/span>\n <\/span>]<\/span>;<\/span><\/span>\n<\/span>\n<\/span>\nfunction <\/span>main<\/span>()<\/span> <\/span>{<\/span> <\/span><\/span>\n sheet<\/span>.<\/span>clearContents<\/span>()<\/span>; <\/span><\/span>\n sheet<\/span>.<\/span>appendRow<\/span>(<\/span>columns<\/span>)<\/span>;<\/span><\/span>\n sheet<\/span>.<\/span>getRange<\/span>(<\/span>"<\/span>K1<\/span>"<\/span>).<\/span>setValue<\/span>(<\/span>"<\/span>Results<\/span>"<\/span>)<\/span>;<\/span><\/span>\n <\/span><\/span>\n var accountIterator = MccApp<\/span>.<\/span>accounts<\/span>().<\/span>executeInParallel<\/span>(<\/span>'<\/span>SQR<\/span>'<\/span>)<\/span>;<\/span><\/span>\n <\/span>send_email<\/span>()<\/span>; <\/span><\/span>\n}<\/span><\/span>\n<\/span>\n<\/span>\nfunction <\/span>SQR<\/span>()<\/span> <\/span>{<\/span><\/span>\n<\/span>\n\/\/<\/span> Get <\/span>all<\/span> the keywords <\/span>in<\/span> <\/span>all<\/span> the acccounts<\/span><\/span>\n<\/span>\n var allKeywords = <\/span>[]<\/span>;<\/span><\/span>\n var report = AdWordsApp<\/span>.<\/span>report<\/span>(<\/span><\/span>\n <\/span>"<\/span>SELECT AdGroupId, Criteria <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>FROM KEYWORDS_PERFORMANCE_REPORT <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>WHERE KeywordMatchType = EXACT <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>DURING TODAY<\/span>"<\/span>)<\/span>;<\/span><\/span>\n var rows = report<\/span>.<\/span>rows<\/span>()<\/span>;<\/span><\/span>\n <\/span>while<\/span> <\/span>(<\/span>rows<\/span>.<\/span>hasNext<\/span>())<\/span> <\/span>{<\/span><\/span>\n var row = rows<\/span>.<\/span>next<\/span>()<\/span>;<\/span><\/span>\n var KeywordsLower = row<\/span>[<\/span>'<\/span>Criteria<\/span>'<\/span>].<\/span>toLowerCase<\/span>()<\/span>;<\/span><\/span>\n allKeywords<\/span>.<\/span>push<\/span>(<\/span>KeywordsLower<\/span>)<\/span>;<\/span><\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n\/\/<\/span> Get <\/span>all<\/span> the search queries <\/span>in<\/span> <\/span>all<\/span> the accounts<\/span><\/span>\n var positiveKeywords = <\/span>[]<\/span>;<\/span><\/span>\n var columnsStr = columns<\/span>.<\/span>join<\/span>(<\/span>'<\/span>,<\/span>'<\/span>)<\/span> <\/span>+<\/span> <\/span>"<\/span> <\/span>"<\/span>;<\/span><\/span>\n var SQRreport = AdWordsApp<\/span>.<\/span>report<\/span>(<\/span><\/span>\n <\/span>'<\/span>SELECT <\/span>'<\/span> <\/span>+<\/span> columnsStr <\/span>+<\/span><\/span>\n <\/span>'<\/span>FROM SEARCH_QUERY_PERFORMANCE_REPORT <\/span>'<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span> WHERE Impressions > 50 <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>DURING LAST_30_DAYS<\/span>"<\/span><\/span>\n <\/span>)<\/span>;<\/span><\/span>\n <\/span><\/span>\n var rows = SQRreport<\/span>.<\/span>rows<\/span>()<\/span>; <\/span><\/span>\n <\/span>while<\/span> <\/span>(<\/span>rows<\/span>.<\/span>hasNext<\/span>())<\/span> <\/span>{<\/span><\/span>\n var row = rows<\/span>.<\/span>next<\/span>()<\/span>; <\/span><\/span>\n positiveKeywords<\/span>.<\/span>push<\/span>(<\/span>row<\/span>[<\/span>'<\/span>Query<\/span>'<\/span>])<\/span>; <\/span><\/span>\n<\/span>\n <\/span>for<\/span> <\/span>(<\/span>var i = <\/span>0<\/span>; i <\/span><<\/span> positiveKeywords<\/span>.<\/span>length; i<\/span>++<\/span>)<\/span> <\/span>{<\/span><\/span>\n<\/span>\n <\/span>if<\/span> <\/span>((<\/span>allKeywords<\/span>.<\/span>indexOf<\/span>(<\/span>positiveKeywords<\/span>[<\/span>i<\/span>])<\/span> <\/span>==<\/span>= <\/span>-<\/span>1<\/span>)<\/span> <\/span>&&<\/span> <\/span>(<\/span> row<\/span>[<\/span>'<\/span>Conversions<\/span>'<\/span>]<\/span> <\/span>><\/span> Conversions_Threshold<\/span>))<\/span> <\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot = <\/span>'<\/span>Not added and has conversions<\/span>'<\/span>;<\/span><\/span>\n<\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n <\/span>else<\/span> <\/span>if<\/span> <\/span>((<\/span>allKeywords<\/span>.<\/span>indexOf<\/span>(<\/span>positiveKeywords<\/span>[<\/span>i<\/span>])<\/span> <\/span>==<\/span>= <\/span>-<\/span>1<\/span>)<\/span> <\/span>&&<\/span> <\/span>(<\/span>parseFloat<\/span>(<\/span>row<\/span>[<\/span>'<\/span>Ctr<\/span>'<\/span>])<\/span> <\/span><<\/span> CTR_Threshold <\/span>))<\/span> <\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot = <\/span>'<\/span>Not excluded and low performing<\/span>'<\/span>;<\/span><\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n <\/span>else<\/span> <\/span>if<\/span> <\/span>(<\/span>allKeywords<\/span>.<\/span>indexOf<\/span>(<\/span>positiveKeywords<\/span>[<\/span>i<\/span>])<\/span> <\/span>==<\/span>= <\/span>-<\/span>1<\/span>)<\/span> <\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot = <\/span>'<\/span>Not added<\/span>'<\/span>;<\/span><\/span>\n<\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n <\/span>else<\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot =<\/span>'<\/span>Added<\/span>'<\/span><\/span>\n<\/span>\n <\/span>}<\/span> <\/span><\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n sheet<\/span>.<\/span>appendRow<\/span>([<\/span> row<\/span>[<\/span>'<\/span>CustomerDescriptiveName<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>ExternalCustomerId<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Query<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>CampaignName<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>AdGroupName<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Impressions<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Clicks<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Cost<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Ctr<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Conversions<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>addedOrNot<\/span>'<\/span>]])<\/span>;<\/span><\/span>\n<\/span>\n } <\/span><\/span>\n}<\/span><\/span>\n<\/span>\nfunction <\/span>send_email<\/span>()<\/span> <\/span>{<\/span><\/span>\nMailApp<\/span>.<\/span>sendEmail<\/span>(<\/span>Notify_Me<\/span>,<\/span><\/span>\n <\/span>'<\/span>SQR Report<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Your SQR report is ready, please visit <\/span>'<\/span>+<\/span>SPREADSHEET_URL<\/span>+<\/span>'<\/span> Thanks<\/span>'<\/span>)<\/span>; <\/span><\/span>\n<\/span>\n}<\/span><\/span>\n<\/span>\n<\/span>\n<\/span>\nSmart Search Query Report<\/span>-<\/span>Single Account<\/span><\/span>\n<\/span>\nHere\u2019s also the single account version<\/span>:<\/span><\/span>\n<\/span>\n\/***************************************************<\/span><\/span>\n*<\/span> SQR Report Script<\/span><\/span>\n*<\/span> Version <\/span>1.0<\/span><\/span>\n*<\/span> Created By<\/span>:<\/span> Ahmed Ali<\/span><\/span>\n*<\/span>https<\/span>:<\/span>\/\/<\/span>optimizationup<\/span>.<\/span>com<\/span>\/<\/span><\/span>\n****************************************************\/<\/span><\/span>\n<\/span>\n\/\/<\/span> Add your spreadsheet here<\/span><\/span>\nvar SPREADSHEET_URL = <\/span>'<\/span>https:\/\/docs.google.com\/spreadsheets\/d\/xxxxxxxxxxx<\/span>'<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> This <\/span>is<\/span> quereis minmum number of impressions<\/span>.<\/span><\/span>\nvar Impressions_Threshold = <\/span>50<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> If the CTR <\/span>is<\/span> below the threshold<\/span>,<\/span> it will be labeled <\/span>as<\/span> <\/span>"<\/span>Not excluded and low performing<\/span>"<\/span><\/span>\nvar CTR_Threshold = <\/span>1<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> If the number of conversions <\/span>is<\/span> above the threshold <\/span>and<\/span> the query <\/span>is<\/span> <\/span>not<\/span> added<\/span>,<\/span> it will be labeled <\/span>as<\/span> <\/span>"<\/span>Not added and has conversions<\/span>"<\/span><\/span>\nvar Conversions_Threshold = <\/span>0<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> Add your email here<\/span><\/span>\nvar Notify_Me = <\/span>"<\/span>add your email here<\/span>"<\/span><\/span>\n<\/span>\nfunction <\/span>main<\/span>()<\/span> <\/span>{<\/span> <\/span><\/span>\n<\/span>\n var sheet = SpreadsheetApp<\/span>.<\/span>openByUrl<\/span>(<\/span>SPREADSHEET_URL<\/span>).<\/span>getActiveSheet<\/span>()<\/span>;<\/span><\/span>\n var columns = <\/span>[<\/span><\/span>\n <\/span>'<\/span>CustomerDescriptiveName<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>ExternalCustomerId<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Query<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>CampaignName<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>AdGroupName<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Impressions<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Clicks<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Cost<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Ctr<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Conversions<\/span>'<\/span> <\/span><\/span>\n <\/span>]<\/span>;<\/span><\/span>\n <\/span><\/span>\n sheet<\/span>.<\/span>clearContents<\/span>()<\/span>; <\/span><\/span>\n sheet<\/span>.<\/span>appendRow<\/span>(<\/span>columns<\/span>)<\/span>;<\/span><\/span>\n sheet<\/span>.<\/span>getRange<\/span>(<\/span>"<\/span>K1<\/span>"<\/span>).<\/span>setValue<\/span>(<\/span>"<\/span>Added Or Not<\/span>"<\/span>)<\/span>;<\/span><\/span>\n<\/span>\n\/\/<\/span> Get <\/span>all<\/span> the keywords <\/span>in<\/span> <\/span>all<\/span> the acccounts<\/span><\/span>\nvar allKeywords = <\/span>[]<\/span>;<\/span><\/span>\n var report = AdWordsApp<\/span>.<\/span>report<\/span>(<\/span><\/span>\n <\/span>"<\/span>SELECT AdGroupId, Criteria <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>FROM KEYWORDS_PERFORMANCE_REPORT <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>WHERE KeywordMatchType = EXACT <\/span>"<\/span> <\/span>+<\/span><\/span>\n <\/span>"<\/span>DURING TODAY<\/span>"<\/span>)<\/span>;<\/span><\/span>\n var rows = report<\/span>.<\/span>rows<\/span>()<\/span>;<\/span><\/span>\n <\/span>while<\/span> <\/span>(<\/span>rows<\/span>.<\/span>hasNext<\/span>())<\/span> <\/span>{<\/span><\/span>\n var row = rows<\/span>.<\/span>next<\/span>()<\/span>;<\/span><\/span>\n var KeywordsLower = row<\/span>[<\/span>'<\/span>Criteria<\/span>'<\/span>].<\/span>toLowerCase<\/span>()<\/span>;<\/span><\/span>\n allKeywords<\/span>.<\/span>push<\/span>(<\/span>KeywordsLower<\/span>)<\/span>;<\/span><\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n<\/span>\n\/\/<\/span> Get <\/span>all<\/span> the search queries <\/span>in<\/span> <\/span>all<\/span> the accounts<\/span><\/span>\n var positiveKeywords = <\/span>[]<\/span>;<\/span><\/span>\n var columnsStr = columns<\/span>.<\/span>join<\/span>(<\/span>'<\/span>,<\/span>'<\/span>)<\/span> <\/span>+<\/span> <\/span>"<\/span> <\/span>"<\/span>;<\/span><\/span>\n<\/span>\n var SQRreport = AdWordsApp<\/span>.<\/span>report<\/span>(<\/span><\/span>\n <\/span>'<\/span>SELECT <\/span>'<\/span> <\/span>+<\/span> columnsStr <\/span>+<\/span><\/span>\n <\/span>'<\/span> FROM SEARCH_QUERY_PERFORMANCE_REPORT <\/span>'<\/span> <\/span>+<\/span><\/span>\n <\/span>'<\/span> WHERE <\/span>'<\/span> <\/span>+<\/span><\/span>\n <\/span>'<\/span> Impressions > <\/span>'<\/span> <\/span>+<\/span> Impressions_Threshold <\/span>+<\/span><\/span>\n <\/span>'<\/span> DURING LAST_30_DAYS<\/span>'<\/span><\/span>\n <\/span>)<\/span>;<\/span><\/span>\n <\/span><\/span>\n var rows = SQRreport<\/span>.<\/span>rows<\/span>()<\/span>; <\/span><\/span>\n <\/span>while<\/span> <\/span>(<\/span>rows<\/span>.<\/span>hasNext<\/span>())<\/span> <\/span>{<\/span><\/span>\n var row = rows<\/span>.<\/span>next<\/span>()<\/span>; <\/span><\/span>\n <\/span><\/span>\n positiveKeywords<\/span>.<\/span>push<\/span>(<\/span>row<\/span>[<\/span>'<\/span>Query<\/span>'<\/span>])<\/span>; <\/span><\/span>\n<\/span>\n <\/span><\/span>\n <\/span>for<\/span> <\/span>(<\/span>var i = <\/span>0<\/span>; i <\/span><<\/span> positiveKeywords<\/span>.<\/span>length; i<\/span>++<\/span>)<\/span> <\/span>{<\/span><\/span>\n<\/span>\n <\/span>if<\/span> <\/span>((<\/span>allKeywords<\/span>.<\/span>indexOf<\/span>(<\/span>positiveKeywords<\/span>[<\/span>i<\/span>])<\/span> <\/span>==<\/span>= <\/span>-<\/span>1<\/span>)<\/span> <\/span>&&<\/span> <\/span>(<\/span> row<\/span>[<\/span>'<\/span>Conversions<\/span>'<\/span>]<\/span> <\/span>><\/span> Conversions_Threshold<\/span>))<\/span> <\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot = <\/span>'<\/span>Not Added and has Conversions<\/span>'<\/span>;<\/span><\/span>\n<\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n <\/span>else<\/span> <\/span>if<\/span> <\/span>((<\/span>allKeywords<\/span>.<\/span>indexOf<\/span>(<\/span>positiveKeywords<\/span>[<\/span>i<\/span>])<\/span> <\/span>==<\/span>= <\/span>-<\/span>1<\/span>)<\/span> <\/span>&&<\/span> <\/span>(<\/span>parseFloat<\/span>(<\/span>row<\/span>[<\/span>'<\/span>Ctr<\/span>'<\/span>])<\/span> <\/span><<\/span> CTR_Threshold <\/span>))<\/span> <\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot = <\/span>'<\/span>Not excluded and low performing<\/span>'<\/span>;<\/span><\/span>\n<\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n <\/span>else<\/span> <\/span>if<\/span> <\/span>(<\/span>allKeywords<\/span>.<\/span>indexOf<\/span>(<\/span>positiveKeywords<\/span>[<\/span>i<\/span>])<\/span> <\/span>==<\/span>= <\/span>-<\/span>1<\/span>)<\/span> <\/span>{<\/span><\/span>\n row<\/span>.<\/span>addedOrNot = <\/span>'<\/span>Not Added<\/span>'<\/span>;<\/span><\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n <\/span>else<\/span>{<\/span><\/span>\n<\/span>\n row<\/span>.<\/span>addedOrNot =<\/span>'<\/span>Added<\/span>'<\/span><\/span>\n<\/span>\n <\/span>}<\/span> <\/span><\/span>\n <\/span>}<\/span><\/span>\n<\/span>\n sheet<\/span>.<\/span>appendRow<\/span>([<\/span> row<\/span>[<\/span>'<\/span>CustomerDescriptiveName<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>ExternalCustomerId<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Query<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>CampaignName<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>AdGroupName<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Impressions<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Clicks<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Cost<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Ctr<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>Conversions<\/span>'<\/span>],<\/span> row<\/span>[<\/span>'<\/span>addedOrNot<\/span>'<\/span>]])<\/span>;<\/span><\/span>\n<\/span>\n } <\/span><\/span>\n<\/span>\nMailApp<\/span>.<\/span>sendEmail<\/span>(<\/span>Notify_Me<\/span>,<\/span><\/span>\n <\/span>'<\/span>SQR Report<\/span>'<\/span>,<\/span><\/span>\n <\/span>'<\/span>Your SQR report for this month is ready, please visit <\/span>'<\/span>+<\/span>SPREADSHEET_URL<\/span>+<\/span>'<\/span> Thanks<\/span>'<\/span>)<\/span>; <\/span><\/span>\n<\/span>\n}<\/span><\/span><\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"
One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads to identify new terms to add to your positive keywords and find undesired search terms and add them as negative keywords. Actually, the process can be time-consuming if you manage…<\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":1282,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[33,44],"class_list":["post-704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-optimize","tag-google-ads","tag-google-ads-scripts"],"yoast_head":"\nRun Search Query Report Like a Pro Using Google Ads Scripts<\/title>\n<meta name=\"description\" content=\"One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/optimizationup.com\/search-query-report-adwords-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Run Search Query Report Like a Pro Using Google Ads Scripts\" \/>\n<meta property=\"og:description\" content=\"One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads\" \/>\n<meta property=\"og:url\" content=\"https:\/\/optimizationup.com\/search-query-report-adwords-script\/\" \/>\n<meta property=\"og:site_name\" content=\"Optimization Up\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/A7med.3lii\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-20T08:54:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-11T05:41:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/01\/Google-Ads-Script.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"466\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ahmed Ali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@A7med_3ly\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmed Ali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/\"},\"author\":{\"name\":\"Ahmed Ali\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"headline\":\"Run Search Query Report Like a Pro Using Google Ads Scripts\",\"datePublished\":\"2017-01-20T08:54:11+00:00\",\"dateModified\":\"2025-04-11T05:41:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/\"},\"wordCount\":430,\"commentCount\":19,\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/Google-Ads-Script.png\",\"keywords\":[\"Google Ads\",\"Google Ads Scripts\"],\"articleSection\":[\"Optimize\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/\",\"name\":\"Run Search Query Report Like a Pro Using Google Ads Scripts\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/Google-Ads-Script.png\",\"datePublished\":\"2017-01-20T08:54:11+00:00\",\"dateModified\":\"2025-04-11T05:41:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"description\":\"One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#primaryimage\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/Google-Ads-Script.png\",\"contentUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/Google-Ads-Script.png\",\"width\":1200,\"height\":466},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/search-query-report-adwords-script\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/optimizationup.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Run Search Query Report Like a Pro Using Google Ads Scripts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/\",\"name\":\"Optimization Up\",\"description\":\"Advanced Optimization & Analytics Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/optimizationup.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\",\"name\":\"Ahmed Ali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"caption\":\"Ahmed Ali\"},\"description\":\"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor & GA4 Auditor - discover all my products here.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/A7med.3lii\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/a7med-ali\\\/\",\"https:\\\/\\\/x.com\\\/A7med_3ly\"],\"url\":\"https:\\\/\\\/optimizationup.com\\\/author\\\/a7med\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Run Search Query Report Like a Pro Using Google Ads Scripts","description":"One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads","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:\/\/optimizationup.com\/search-query-report-adwords-script\/","og_locale":"en_US","og_type":"article","og_title":"Run Search Query Report Like a Pro Using Google Ads Scripts","og_description":"One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads","og_url":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/","og_site_name":"Optimization Up","article_author":"https:\/\/www.facebook.com\/A7med.3lii","article_published_time":"2017-01-20T08:54:11+00:00","article_modified_time":"2025-04-11T05:41:07+00:00","og_image":[{"width":1200,"height":466,"url":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/01\/Google-Ads-Script.png","type":"image\/png"}],"author":"Ahmed Ali","twitter_card":"summary_large_image","twitter_creator":"@A7med_3ly","twitter_misc":{"Written by":"Ahmed Ali","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#article","isPartOf":{"@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/"},"author":{"name":"Ahmed Ali","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"headline":"Run Search Query Report Like a Pro Using Google Ads Scripts","datePublished":"2017-01-20T08:54:11+00:00","dateModified":"2025-04-11T05:41:07+00:00","mainEntityOfPage":{"@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/"},"wordCount":430,"commentCount":19,"image":{"@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#primaryimage"},"thumbnailUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/01\/Google-Ads-Script.png","keywords":["Google Ads","Google Ads Scripts"],"articleSection":["Optimize"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/optimizationup.com\/search-query-report-adwords-script\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/","url":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/","name":"Run Search Query Report Like a Pro Using Google Ads Scripts","isPartOf":{"@id":"https:\/\/optimizationup.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#primaryimage"},"image":{"@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#primaryimage"},"thumbnailUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/01\/Google-Ads-Script.png","datePublished":"2017-01-20T08:54:11+00:00","dateModified":"2025-04-11T05:41:07+00:00","author":{"@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"description":"One of the most important reports of managing AdWords campaigns is the search query report. You need to see the actual search queries that trigger your ads","breadcrumb":{"@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/optimizationup.com\/search-query-report-adwords-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#primaryimage","url":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/01\/Google-Ads-Script.png","contentUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/01\/Google-Ads-Script.png","width":1200,"height":466},{"@type":"BreadcrumbList","@id":"https:\/\/optimizationup.com\/search-query-report-adwords-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/optimizationup.com\/"},{"@type":"ListItem","position":2,"name":"Run Search Query Report Like a Pro Using Google Ads Scripts"}]},{"@type":"WebSite","@id":"https:\/\/optimizationup.com\/#website","url":"https:\/\/optimizationup.com\/","name":"Optimization Up","description":"Advanced Optimization & Analytics Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/optimizationup.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768","name":"Ahmed Ali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","caption":"Ahmed Ali"},"description":"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor & GA4 Auditor - discover all my products here.","sameAs":["https:\/\/www.facebook.com\/A7med.3lii","https:\/\/www.linkedin.com\/in\/a7med-ali\/","https:\/\/x.com\/A7med_3ly"],"url":"https:\/\/optimizationup.com\/author\/a7med\/"}]}},"_links":{"self":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/comments?post=704"}],"version-history":[{"count":4,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/704\/revisions"}],"predecessor-version":[{"id":2176,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/704\/revisions\/2176"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media\/1282"}],"wp:attachment":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media?parent=704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/categories?post=704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/tags?post=704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}