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.

Shopping

PMax

Display

YouTube

reporting

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.

Ready to Use This Script?

Variable	Default	Description
`EMAIL_ADDRESS`	""	Recipient for the daily summary email. Blank = log + sheet only.
`SPREADSHEET_URL`	""	KPI log sheet URL. Leave blank to auto-create one (URL logged).

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.