MCC Conversion Health
Sweeps every client account for the classic silent disaster: campaigns spending while conversion tracking stopped recording — flagged portfolio-wide in one daily run.
by Jordan Lagan (concept), chiliad (rewrite)·chiliad.io
Overview
The client's developer 'cleaned up' GTM on Tuesday; you find out at the month-end report. MCC Conversion Health runs inside the manager account and checks every client account: recent-window conversions vs a baseline window. Accounts that spent money recently with ZERO conversions despite a converting baseline are flagged — the signature of a broken tag, deleted trigger, or halted import. The email fires only when at least one account flatlined.
Setup
- 1Open your MANAGER (MCC) account and go to Tools → Bulk Actions → Scripts.
- 2Click the + button to create a new script and paste the code below.
- 3Adjust RECENT_DAYS for low-volume portfolios (longer window = fewer false alarms).
- 4Set EMAIL_ADDRESS and schedule daily.
Configuration Variables
| Variable | Default |
|---|---|
RECENT_DAYS | 7 |
BASELINE_DAYS | 30 |
MIN_BASELINE_CONV | 5 |
MAX_ACCOUNTS | 50 |
LABEL_FILTER | (empty) |
Expected Output
[OK] Client A (123-456-7890) - recent conversions: 84.0, spend: 3120.40 [OK] Client B (234-567-8901) - recent conversions: 22.5, spend: 890.20 === MCC Conversion Health (23 accounts) === Flatlined: 1 [ALERT] Client C (345-678-9012) spent 1204.10 in 7 days with 0 conversions (baseline: 118.0) Email sent to you@example.com
Notes
Account-level totals only — for per-conversion-action flatline detection, run the single-account Conversion Tracking Health Check inside the flagged account. Offline-import-heavy clients can lag more than 7 days; raise RECENT_DAYS for those portfolios.