Compare Date Range - User Guide
Easily compare the performance of an account across two date ranges using the compare data range script. 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 percent change on each metric.
Why should you use it?
This script allows to report on weekly or monthly basis 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
How does it work?
Choose the account you want to run the script in and go to the All Enhanced Scripts page. On this page select the Compare Date Range script.
You can either create a new setting 'Create new setting' or 'Copy setting from an existing account'. To create a new setting, follow the steps below:
- Setting Name:
Enter the name you want to give the setting so that you can check it later whenever you want. The same script can have multiple settings for the same account. You can choose to pause and enable settings as you wish.
- Mention the account name:
Enter the name of the account for which you wish to report the performance comparison.
- Spreadsheet URL:
The script generates a report in a Google spreadsheet. You can choose to copy the report in an existing spreadsheet in which case you can copy paste the URL in this field. Otherwise, you can leave it as NEW and this will generate a new spreadsheet for the report each time the script runs.
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. Set at 7 days by default, but you can edit it as per your requirement.
- Campaign Name Selector Statement:
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.
Use segments to split your data into rows based on the options that matter the most to you - it can be a different period of time, click type, or device.
- Optimization Date:
In case you select "around opts" option in "Time", you would require to feed in the date on which the change was applied in the account. Else you can leave it as it is. If the account was optimized on 1st July, 2016 then this date can be set here.
- Pre Start Date:
Enter here 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, 2016 should be entered here.
- Pre End Date:
Enter here 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, 2016 should be entered here.
- Post Start Date:
Enter here 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, 2016 should be entered here.
- Post End Date:
Enter here 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, 2016 should be entered here.
How to install and run the enhanced script?
After entering the details for the setting, click on 'Save settings'. This will give you an option to 'Download' the script which can then be installed in the AdWords account. For detailed steps on how to install a script in AdWords, read this article. This script can also be run at the MCC level. This article explains how to install and run enhanced scripts at the MCC level.