Ad Performance Report
Generates a Google Spreadsheet with ad performance stats segmented by headline and final URL, including distribution charts. Covers all ad types and optionally emails the report link weekly.
by Google (original), chiliad (adaptation)·developers.google.com/google-ads/scripts/docs/solutions/ad-performance
Overview
Ad Performance Report copies a template spreadsheet, queries the last 7 days of ad performance data across all ad types (text, expanded text, responsive search, display, video, shopping, and more), aggregates metrics by headline and final URL, and writes the results into two sheets with distribution charts. The report link is emailed to the configured recipients.
Setup
- 1Make a copy of the official template spreadsheet linked in the Google Ads Scripts documentation.
- 2Paste the spreadsheet URL into CONFIG.spreadsheet_url.
- 3Set CONFIG.recipient_emails to the email addresses that should receive the report link.
- 4Schedule weekly (Monday morning recommended) to capture the prior week's data.
- 5Run once in preview to confirm the new spreadsheet is created and data populates.
Configuration Variables
| Variable | Default |
|---|---|
CONFIG.recipient_emails | ['YOUR_EMAIL_HERE'] |
CONFIG.spreadsheet_url | 'YOUR_SPREADSHEET_URL' |
Expected Output
Generated new reporting spreadsheet https://docs.google.com/spreadsheets/d/... Ad performance report available at https://docs.google.com/spreadsheets/d/... (Email sent to recipients with the spreadsheet link)
Notes
Each run creates a new copy of the spreadsheet, timestamped with the current date. Old report spreadsheets are not deleted automatically — clean them up periodically from Google Drive.