This report will give you all the user search queries for your broad match keywords. Normally, you have to log in and manually generate the report each day. But with AdWords scripts, you can start storing all of that data into a Google Spreadsheet so that it is easier to work with.
So today I have a simple script that will store the search query report and send you an email reminding you that it's ready. All you need to do is fill in the url from an existing Google Doc that you have access to with the same log in as your AdWords account, and set the email addresses you want to send a notice to, and you should be all set. There is also a flag to determine if you want to ignore exact and exact (close variant) matched keywords from the results, which I recommend.
Thanks,
Russ
/*************************************************** * Store Search Query Perf Report in Google Doc * Version 1.1 * CHangelog v1.1 - Removed apiVersion, Updated formatting * Created By: Russ Savage * FreeAdWordsScripts.com ****************************************************/ var DATE_RANGE = 'LAST_7_DAYS'; var IGNORE_EXACT = true; var TO = ["email_1@my_company.com","email_2@my_company.com"]; var SPREADSHEET_URL = "your spreadsheet url goes here"; function main() { var columns = ['AccountDescriptiveName', 'CampaignName', 'AdGroupName', 'KeywordTextMatchingQuery', 'MatchType', 'Query', 'Device', 'Impressions', 'Clicks', 'Cost', 'Conversions', 'AverageCpc', 'CostPerConversion', 'ConversionRate', 'Ctr']; var columnsStr = columns.join(',') + " "; var sheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getActiveSheet(); sheet.clear(); sheet.appendRow(columns); var reportIter = AdWordsApp.report( 'SELECT ' + columnsStr + 'FROM SEARCH_QUERY_PERFORMANCE_REPORT ' + 'DURING ' + DATE_RANGE, { includeZeroImpressions: false }).rows(); while(reportIter.hasNext()) { var row = reportIter.next(); if(IGNORE_EXACT && row['MatchType'].indexOf('exact') >= 0) { continue; } var rowArray = []; for(var i in columns) { rowArray.push(row[columns[i]]); } sheet.appendRow(rowArray); } for(var i in TO) { MailApp.sendEmail(TO[i], "Search Query Report Ready", SPREADSHEET_URL); } }
Brilliant!
ReplyDeleteWhat if I want to filter out brand keywords ?
Where do I put the condition ?
Thanks!
Hi Giu, It kind of depends on how you have identified your brand terms. If you put all your brand terms in their own set of campaigns, you could add a filter in the loop that starts on line 41 that flags things as brand or non-brand.
DeleteIf you configured things using labels, things get a bit more complicated. Currently, there is no way to get labels from the search query performance report. That means, depending on the size of our account, you would need to have a separate script that stores keyword text and the labels (possibly in the same spreadsheet on a different tab) and then link the two together.
Thanks,
Russ
Do you need a remote phone spy? I knew one guy that can bring you something!
ReplyDeleteprint test page is a way to test and service all your hardware devices. It is done by using troubleshooting all your system i.e. printer.
ReplyDeleteAnd, You cannot open BIN file directly. You can save data and information in a particular folder using file extension bin. BIN files are connected with compacted parallel files. It contains a paired code.
Download Microsoft office as it could be the best choice for your work if you want to manage your data with an efficient tool.
ReplyDeleteAfter installing the setup.office.com on your computer system, your existing MS account or create a new account and enter the product key.
ReplyDeleteWonder to see this information... thanks for sharing with us.
ReplyDeleteopen acsm file
I appreciate your efforts, keep writing.
ReplyDeleteopen apk file on pc
tanx foг tаking the time to explore tһis, It’s ѵery helpful for me
ReplyDeleteدانلود سریال قورباغه دانلود سریال قورباغه دانلود سریال قورباغه دانلود سریال قورباغه دانلود سریال قورباغه
Great article! We will be linking to this great article on our website. Keep up the good writing.
ReplyDeleteروش تحقیق در علوم رفتاری زهره سرمد روش تحقیق در علوم رفتاری زهره سرمد
روش تحقیق در علوم رفتاری زهره سرمد روش تحقیق در علوم رفتاری زهره سرمد
Great info root android mobile
ReplyDeletecanon 5b00 error
ReplyDeletecanon support code 5b00
canon error code 5b00
5b00 error restoring program for canon printers
5b00 error canon g2000
canon g2000 5b00 error
how to fix g2000 blinking 7 times the ink absorber full error 5b00
how to fix canon printer printing blank pages
ReplyDeletemicrosoft word keeps crashing
Thank you for the valuable post. It seems very informative!
ReplyDeleteReason for Yahoo Mail Crash error – Get The proper solutions
How to Cancel McAfee Renewal?
Solutions to Cancel Avast Cleanup & Cancel Avast Subscription for all Devices
Shielding Your Computer From Viruses and Internet Attacks
ReplyDelete