The Compare Date Range Enhanced 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 percent change on each metric.
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:
You can either create a new setting by selecting 'Create new setting' or 'Copy setting from an existing account'. To create a new setting, follow the steps below:
Enter the name you want to give the setting, so that you can check it later whenever you want. One script can have multiple settings for the same account. You can choose to pause and enable settings as you wish.
Enter the name of the account for which you wish to report the performance comparison.
This script generates a report in a Google spreadsheet, and you can choose to copy the report in an existing spreadsheet, for 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. 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.
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.
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, 2016 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, 2016 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, 2016 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, 2016 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, 2016 should be entered here.
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.
Our award-winning customer care team is here for you.