On this page:
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 you should use it
This script allows reporting on a weekly or monthly basis, in order to compare the 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 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 into 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 the product category. You can also use this to exclude a certain campaign.
For example:
To run the script for all campaigns that have "Brand" in their name, you'll need to put CampaignName CONTAINS Brand. No underscore or quotations are required.
To run the script for all campaigns except the ones that have "Brand" in their name, you'll need to put CampaignName CONTAINS_IGNORE_CASE Brand. No underscore or quotations are required.
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 2021 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 the previous one-month data from the date of Optimization, then 1st June 2021 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 the previous one-month data from the date of Optimization, then 30th June 2021 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 the date of Optimization, then 2nd July 2021 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 the date of Optimization, then 31st July 2021 should be entered here.