MCC Neglected Accounts
Finds client accounts spending money with zero human or scripted changes in the lookback window — making neglect visible before the client makes it visible for you.
by Dmytro Tonkikh·chiliad.io
Overview
Money moving with nobody at the wheel is how churn emails start. MCC Neglected Accounts runs inside the manager account and cross-references two signals per client account: spend in the lookback window, and entries in the account's change history over the same period. Accounts above the spend threshold with ZERO changes are flagged. Coasting can be legitimate for a stable account — but it should be a decision with an owner, not an accident this report is the first to notice.
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 MIN_SPEND to what 'meaningful money' is for your portfolio.
- 4Set EMAIL_ADDRESS and schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
LOOKBACK_DAYS | 14 |
MIN_SPEND | 100 |
MAX_ACCOUNTS | 50 |
LABEL_FILTER | (empty) |
EMAIL_ADDRESS | (empty) |
Expected Output
[OK] Client A (123-456-7890) - spend 3120.40, changes: 96 [SKIP] Client D (456-789-0123) - spend 42.10 below threshold === MCC Neglected Accounts (last 14 days, 23 accounts) === Spending with zero changes: 1 [NEGLECTED] Client C (345-678-9012) spend: 1240.20 changes: 0 in 14 days Email sent to you@example.com
Notes
Changes include scripts and API activity, so an account managed purely by automation counts as 'touched' — this finds accounts with NOTHING happening. Google's change history covers 30 days, capping LOOKBACK_DAYS at 29.