One email with every client account's spend — yesterday, month-to-date, and yesterday vs the account's own 7-day average — so a client suddenly burning or flatlining is visible before the client notices.
by Dmytro Tonkikh·chiliad.io
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.
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.
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.
MCC Spend Digest runs inside your manager account, iterates every client account (optionally filtered by an MCC label), and compiles one table: yesterday's spend, the account's own 7-day daily average with the deviation percentage, and month-to-date. Accounts deviating beyond your threshold are flagged [!] at the top of the inbox — the two failure modes it catches daily are 'client suddenly burning budget' and 'client silently stopped spending'.
| Variable | Default |
|---|---|
DEVIATION_FLAG_PCT | 50 |
MAX_ACCOUNTS | 50 |
LABEL_FILTER | (empty) |
EMAIL_ADDRESS | (empty) |
=== MCC Spend Digest (23 accounts) ===
[!] Client A (123-456-7890) yesterday: 812.40 7d avg: 402.10 (+102%) MTD: 6240.20
Client B (234-567-8901) yesterday: 420.15 7d avg: 398.55 (+5%) MTD: 5804.90
[!] Client C (345-678-9012) yesterday: 0.00 7d avg: 184.20 (-100%) MTD: 2210.40
Email sent to you@example.comEach account's spend is in its own currency — the digest doesn't convert. Accounts are processed sequentially; around 50 accounts fits comfortably in the script time limit, beyond that split by LABEL_FILTER into multiple scheduled copies.