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
Monitors your account for unexpected performance deviations by comparing today's stats against historical averages for the same weekday. Sends an alert email when impressions, clicks, conversions, or cost deviate beyond configurable thresholds.
One 0-100 score for the whole account, built from seven objective checks — tracking flatlines, disapprovals, serving status, budget losses, negative coverage and query hygiene — with the deduction breakdown as your fix list.
Finds the structural gaps that stop ad groups from serving: ad groups without active ads, without an RSA, without keywords, keyword-stuffed themes, and multi-RSA ad groups.
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.
Maps every campaign's ad schedule and flags forgotten narrow serving windows, stale schedule bid modifiers that Smart Bidding ignores, and (optionally) campaigns running 24/7.
Aggregates call assets per campaign — received vs missed, average duration, and the share of quality calls — and alerts when you're paying for calls nobody answers.
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.
| Variable | Default |
|---|---|
CONFIG.recipient_emails | ['YOUR_EMAIL_HERE'] |
CONFIG.spreadsheet_url | 'YOUR_SPREADSHEET_URL' |
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)
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.