Projects month-end account spend from month-to-date plus a recency-weighted run rate, compares it to your monthly target, and alerts when the projection drifts beyond tolerance.
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.
Monthly Spend Forecast answers the question every client asks mid-month: where will spend land? It takes month-to-date spend, blends the last-7-days run rate (weighted 2:1) with the month's average so budget changes show up quickly, and projects month-end spend for the account and per campaign. With a MONTHLY_TARGET set, it alerts when the projection misses the target by more than your tolerance — including the exact daily spend needed for the rest of the month to land on target.
| Variable | Default |
|---|---|
MONTHLY_TARGET | 0 |
VARIANCE_ALERT_PCT | 10 |
TOP_CAMPAIGNS | 15 |
EMAIL_ADDRESS | (empty) |
=== Monthly Spend Forecast === Month progress: day 15 of 31 Month-to-date spend: 6240.10 (avg 445.72/day) Last 7 days run rate: 512.40/day PROJECTED MONTH-END SPEND: 14180.55 Target: 12000.00 -> projection is +18.2% vs target. [ALERT] Overpacing beyond 10%. --- Top campaigns by projected month-end spend --- Generic — Broad MTD: 2411.02 projected: 5480.20 Brand — Exact MTD: 1820.44 projected: 4100.80 Email sent to you@example.com
Complete days only — today's partial data is excluded, so the projection is stable regardless of run time. Pairs with a Monthly Budget Cap script: the forecast tells you the drift early; the cap is the hard stop. Paused campaigns' month-to-date spend is included (money already spent counts).