Weekly Performance Report
Compares this week vs last week across all enabled campaigns. Highlights significant changes in spend, conversions, CPA, and CTR. Optionally emails the report.
by Dmytro Tonkikh·chiliad.io
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
- 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 |
|---|---|
SEND_EMAIL | false |
EMAIL_ADDRESS | "" |
CHANGE_THRESHOLD | 0.20 |
Expected Output
=== Weekly Performance Report === Impressions 42,810 +8.2% Clicks 1,940 +5.1% CTR 4.53% -2.8% Cost $3,210.40 +12.4% ◄ Conversions 128.0 +18.0% ◄ CPA $25.08 -5.1% ROAS 4.20 +3.2%
Notes
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.