Using AdWords Scripts to Find Trends

By Ricky Solanki, September 26th 2015 in Scripts
1 Comment

Are AdWords scripts actually useful?

The answer to the above question is: yes! There is no end to the list of possibilities that you can use AdWords scripts for. You can write the scripts or you can use the ones freely available on the internet. You can use scripts for a one-time usage or for repeated usage. You can manually run them when you need them or you can schedule them for running at pre-determined time and frequency. You can manage almost any aspect of your campaign with the help of AdWords scripts.

This report is not available in Adwords unless you did it manually

Screen Shot 2015-09-30 at 11.06.13

We call this the trend overview so can be seen across a year. Often month on month changess are small but overtme can be significant e.g. in the example above the CTR has been dropping overtime.

Here’s how to set this up:

The highlighted elements of the script need to be edited before adding this script. TrendOverviewScript

  1. When added the script will send a url of the report on google drive via e-mail or you can specify a url.
  2. To receive the url of the spreadsheet add your email
  3. Set the number of months you want the report for. use at least 12 months

Screen Shot 2015-09-30 at 11.13.20

Go to Bulk Operations to Upload

Under bulk operation there is a tab called scripts and you can name your script and copy the code with the changes and authorise and approve the script and run it.

It should look like:

Screen Shot 2015-09-30 at 11.18.00

 You can download the script here.


Welcome to using scripts!

Ricky Solanki

Growth Director - Push

Ricky Solanki has worked on over 500+ adwords campaigns. He started working in paid search all the way back in in 2004 and has used that knowledge to build the Push Analyser. Push Analyser is a unique software tool used by his agency Push to deliver exceptional results for small to medium size businesses across the Globe.

More blog posts by Ricky Solanki



January 24th 2017

Why is it so difficult to get these scripts to work. They all seem to have one line of errors - is this down to Adwords being updated too many times over the past year and a bit?