- Excludes today so the periods are complete
- Compares two consecutive seven-day windows
- Adds the matching seven-day window from the previous month
- Emails account and campaign-level exceptions
Free Google Ads script · Reporting
Weekly comparison
Compare the latest seven completed days with the previous seven days and the matching prior-month window.
What it is for
A faster check.
Not automatic judgement.
Week-on-week reports become noisy when they flag every small change. This script compares complete seven-day windows, adds a previous-month reference and highlights material changes in conversions, CPA, conversion rate, spend and ROAS.
- 01Set the recipient email
- 02Review alert percentages and minimum-volume gates
- 03Confirm conversion value is reliable before using ROAS alerts
- 04Schedule after the final day in the weekly window
Seven days can still be a small sample. Use the alerts to investigate, not as an automatic instruction to change bids or budgets.
Use this script at your own risk. Google Ads interfaces and reporting fields change. Always run Preview in the intended account and read the logs before enabling or scheduling it.
Loading script…How to install a Google Ads script
Copy. Configure.
Preview. Schedule.
- Open the correct Google Ads account and go to Tools → Bulk actions → Scripts.
- Create a new script, remove the example code and paste this script.
- Edit the CONFIG block. Never leave placeholder emails, budgets or thresholds unchanged.
- Authorize the script, select Preview and inspect its logs or report.
- Only schedule it after the preview matches the intended account and scope.