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 for successful keywords (for example, all searches that led to a sale) and then searching for this campaign for campaign and inserting them into the appropriate ad groups. Of course, you always catch keywords that are already booked in. Depending how granular you Gopogle Ads Account is already set up, the harder it is to find searches that are not yet added as a keyword. This can be very time consuming.

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?

  1. The script analyzes the specified Google Adwords accounts for searches 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.


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 zu laden.

Inhalt laden

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 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.
  3. Set the viewing period in the script
  4. In the script, set the ID of a Google Spreadsheet in which the data is to be created.
  5. Save and authorize the script
  6. Run the script. After a few minutes, the results should be available