Pre-sorting via Search Query Script
I’ve developed an AdWords script that takes away the tedious part of the work, the comparison between existing and non-existent keywords.
The original, by Derek Martin can be found here. I have expanded the existing AdWords Script according to our wishes and made it a variant that we use daily in my AdWords workflow.
What exactly does the search query analysis script do?
- The script analyzes the specified Google Adwords accounts for searches that match “Conversions > 0” and executes them with the selected accounts.
- If a keyword is not found, the keyword with the relevant performance data is added to the Adwords account.
Here is an example, the spreadsheet that the script outputs. Column 1 contains the Search Query. The Campaign and AdGroup columns contain the source that triggered the keyword. Other performance data is behind it.
This data can then be used to quickly and easily find new AdGroups or expand existing ones. If a keyword is not one of the ones you want to insert, a comment can be written that will be retained even after the next run of the script.
Klicken Sie auf den unteren Button, um den Inhalt von docs.google.com zu laden.
How do I install the script?
- Install the script. Here you can find the script on Github
- adwords-search-query-report.js at AdWords account level
- adwords-search-query-report-MCC.js at AdWords MCC level
- Only for the MCC script you have to set an account-level label with the name “Search Query Conversion Report”. This is no longer the case with the AdWords Account version of the script.
- Set the viewing period in the script
- In the script, set the ID of a Google Spreadsheet in which the data is to be created.
- Save and authorize the script
- Run the script. After a few minutes, the results should be available