MCC Spend Digest
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
Overview
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'.
Setup
- 1Open your MANAGER (MCC) account and go to Tools → Bulk Actions → Scripts — this script does not run in client accounts.
- 2Click the + button to create a new script and paste the code below.
- 3Optionally set LABEL_FILTER to an MCC account label to scope the digest.
- 4Set EMAIL_ADDRESS and schedule daily (early morning).
Configuration Variables
| Variable | Default |
|---|---|
DEVIATION_FLAG_PCT | 50 |
MAX_ACCOUNTS | 50 |
LABEL_FILTER | (empty) |
EMAIL_ADDRESS | (empty) |
Expected Output
=== 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.comNotes
Each 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.