Account Summary Report
Generates a daily at-a-glance performance overview of your entire Google Ads account. Writes prior-day stats to a Google Sheet with running history and optionally emails a formatted comparison of yesterday vs. two days ago vs. one week ago.
by Google (original), chiliad (adaptation)·developers.google.com/google-ads/scripts/docs/solutions/account-summary
Overview
Account Summary Report pulls yesterday's account-level KPIs — cost, average CPC, CTR, impressions, and clicks — appends them to an auto-created daily log sheet, and emails an HTML comparison of yesterday vs two days ago vs the same day last week (with percentage changes). Self-contained: no template spreadsheet or named ranges required. Read-only.
Setup
- 1Create a new script and paste the code.
- 2Set EMAIL_ADDRESS to receive the daily summary email; leave blank to log + sheet only.
- 3Leave SPREADSHEET_URL blank on the first run to auto-create the KPI log sheet — its URL is logged; paste it back to keep appending.
- 4Schedule daily, after midnight in the account time zone, so each run captures the previous complete day.
Configuration Variables
| Variable | Default |
|---|---|
EMAIL_ADDRESS | "" |
SPREADSHEET_URL | "" |
Expected Output
=== Account Summary: 2026-06-14 === Cost: 482.10 Avg. CPC: 0.84 CTR: 3.21% Impressions: 17920 Clicks: 575 Emailed summary to you@example.com
Notes
Read-only — never changes the account. Schedule daily after midnight (account time zone) so each run captures the previous complete day; the log sheet de-duplicates by date. Search impression share was dropped because it is not a customer-level metric in GAQL.