Monitors remaining account budget (prepaid balance) across all accounts under an MCC label, calculates days until the budget runs out based on 7-day average spend, writes a summary to a Google Sheet, and sends Telegram alerts per account.
by Dmytro Tonkikh·chiliad.io
One table of every campaign's bidding strategy with the two flags that matter: Manual CPC campaigns with enough volume for Smart Bidding, and target-based campaigns too data-starved to learn.
Finds the reallocation hiding in plain sight: efficient campaigns losing volume to budget caps, idle budgets that could fund them, and full budgets funding poor CPAs.
Runs campaigns only inside their date windows — Black Friday starts at 00:00 without anyone staying up, sales end exactly on time, weekend campaigns run only on weekends.
Compares yesterday's average CPC per campaign against its 30-day baseline and alerts on spikes — the earliest visible symptom of a new competitor, broad-match drift, or a bid change gone wrong.
Compares actual spend against your daily budget settings over 1, 7 and 28 days and alerts by email + Google Sheet when Google overdelivers beyond your thresholds.
Compares actual daily spend against the expected pace based on time of day. Logs over- and under-pacing campaigns and can auto-pause overspenders to protect your budget.
Runs from your MCC account and processes every child account tagged with a specific account label. For each account it reads the active account budget via GAQL, computes the remaining balance, average daily cost, yesterday's and this month's spend, and the projected days until the budget hits zero. Results are written to a Google Sheet and pushed to Telegram so account managers know when a client balance needs topping up.
| Variable | Default |
|---|---|
SPREADSHEET_URL | YOUR_SPREADSHEET_URL |
SHEET_NAME | Balance |
ACCOUNT_LABEL | Balance |
TELEGRAM_BOT_TOKEN | (empty) |
ACCOUNT_NOTIFICATIONS | {} |
📌 Client A 💰 Remaining budget: 1 240 EUR 📅 Days to 0: 15 📊 Avg. 7-day spend: 85 🔍 Spent yesterday: 92 📈 Spent this month: 940 Report written: 8 account(s) → Balance
Requires an MCC (manager) account — executeInParallel processes up to 50 child accounts per run. Only accounts with an approved account-level budget that has a finite spending limit (prepaid or invoiced billing with a cap) report a balance; pay-as-you-go accounts and budgets with an unlimited spending limit are skipped. The Telegram alert links the account name to the Google Ads billing page using the account's OCID, which the script fetches automatically.