Compares this week vs last week across all enabled campaigns. Highlights significant changes in spend, conversions, CPA, and CTR. Optionally emails the report.
reporting
email
performance
Overview
Weekly Performance Report compares this week's account-level metrics against the previous week and flags metrics that have changed by more than your CHANGE_THRESHOLD. It covers impressions, clicks, CTR, cost, conversions, CPA, and ROAS. The formatted summary can optionally be emailed to a recipient of your choice by providing an email address and enabling SEND_EMAIL.
Setup
Ready to Use This Script?
Sign up to install this script with one click and manage it across all your Google Ads accounts.
1Create a new script and paste the code.
2Set CHANGE_THRESHOLD to the fractional change that should be flagged (default 0.20 = 20%).
3To receive the report by email, set SEND_EMAIL = true and provide a valid EMAIL_ADDRESS.
4Schedule weekly (Sunday night or Monday morning recommended) so each run compares a full week.
5Preview the script once to confirm the numbers look correct against your Google Ads dashboard.
Configuration Variables
Variable
Default
Description
SEND_EMAIL
false
Set to true to email the report after each run.
EMAIL_ADDRESS
""
The email address to send the report to. Required when SEND_EMAIL = true.
CHANGE_THRESHOLD
0.20
Metrics that change by more than this fraction are flagged with ◄ (0.20 = 20%).
THIS_WEEK_SUN_TODAY includes the current partial day, so running the script mid-week will compare an incomplete week against a full prior week. For a like-for-like comparison, run only on the last day of the week or adjust the date range constants.