AdWords Search Query Analysis

One problem with growing AdWords accounts is keeping track of keywords that have already been added. With granular controls of the accounts, it can take a lot of time (which you as a Google Ads consultant does not have) to evaluate the booked keywords and create new keyword bookings from the search queries. Keyword research can thus become a real hard work. I’ll show you how to simplify this with this script.

Manual evaluation of search queries to create new keywords

Using search queries to create new keywords means searching through search queries for successful keywords (e.g., all search queries that led to a sale) and then finding these campaign by campaign and adding them to the appropriate ad groups. Of course, you always catch keywords that are already booked in. The more refined the AdWords account is already set up, the more difficult it becomes to find search queries that are not yet booked as keywords. This can be very time consuming.

Pre-sorting via Search Query Script

I have further 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?

1. The script analyzes the specified Google AdWords accounts for search queries that match “Conversions > 0” and executes them with the selected accounts.
2. If a keyword is not found, the keyword with the relevant performance data is added to the Adwords account.

Result

Here is an example of 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.

How do I install the script?

1. Install the script. Here you can find the script on Github
   1. adwords-search-query-report.js at AdWords account level
   2. adwords-search-query-report-MCC.js at AdWords MCC level
2. Only for the MCC script do labels named “Search Query Conversion Report” need to be set at the account level. This is no longer the case with the AdWords Account version of the script.
3. Set the viewing period in the script
4. In the script, set the ID of a Google Spreadsheet where the data should be stored.
5. Save and authorize the script
6. Run the script. The results should be available within a few minutes.