What does it do

This script allows you to easily compare the performance of an account across two date ranges. It downloads reports including account data, campaign data, ad group data, keyword data and ad text data for the specified time period. The script combines all this data on a single Google Spreadsheet and shows the percentage of change for each metric.

Why should you use it

This script allows to report on weekly or monthly basis, in order to compare performance of an account across two date ranges. Some of the use cases are listed below:

  • A weekly report that shows last week's account performance compared to the week before last.
  • A monthly report which shows last month's account performance compared to the month before last.
  • A report that compares the same number of days (and same days of the week) before and after an optimization was made.

Settings

Setting Name

Enter the name you want to give the setting. You can have multiple settings for the same script, and you can choose to pause and enable these settings as you wish. 

Account Name

Enter the name of the account for which you wish to report the performance comparison.

Spreadsheet URL

The script pastes the results in a Google Spreadsheet. If you want to paste the results in an existing spreadsheet, put in the address of the spreadsheet. If you leave 'NEW' in the spreadsheet setting, the script will create a new spreadsheet in the Google Drive folder associated with your Google Ads account email. A new spreadsheet will be created each time the script runs.

Time

Choose the date range type amongst the three options for which you want the script to aggregate data. You can choose to select previous days, around opts (to see the impact of optimizations on account performance) or if you want to view the comparison for a custom date range.

Days in Report

Enter the duration of the date range for which you want to compare account performance. It is set at 7 days by default, but you can edit it as per your requirement.

Campaign Name Selector

If you want to run the script for specific campaigns, you can mention the name of the campaign in this field. Leaving it blank will run the script for all campaigns. This can be helpful if you have a very large account or well-segregated campaigns based on product category. 

For example, if you put 'Brand' in this field, the script will run for all campaigns that have 'Brand' in their name.

Segment

Use segments to split your data into rows based on the options that matter the most to you. This can be a different period of time, click type, or device.  

Specifying the Dates

Optimization Date:
In case you select "around opts" option in "Time", you would be required to fill in the date on which the change was applied in the account. If you haven't selected the option, you can just leave it as it is. 

For example, if the account was optimized on 1st July, 2018 then this date can be set here.

Pre Start Date:
Enter the first day of the date range for the Pre Optimization period. If you wish to compare previous one month data from the date of Optimization, then 1st June, 2018 should be entered here.

Pre End Date:
Enter the last day of the date range for the Pre Optimization period. If you wish to compare previous one month data from the date of Optimization, then 30th June, 2018 should be entered here.

Post Start Date:
Enter the first day of the date range for the Post Optimization period. If you wish to compare the performance of the month after from the date of Optimization, then 2nd July, 2018 should be entered here.

Post End Date:
Enter the last day of the date range for the Post Optimization period. If you wish to compare the performance of the month after from the date of Optimization, then 31st July, 2018 should be entered here.

Did this answer your question?