Guide
How to forecast end-of-month ad spend
To forecast end-of-month ad spend, take spend-to-date, divide by the days elapsed to get a daily run-rate, then multiply by the total days in the month: spend ÷ days elapsed × days in month. That projection — not today's spend-to-date — tells you where you'll actually land, and it should be adjusted for channels that don't spend evenly across the week and for known holidays before you act on it.
Spend-to-date answers "how much have we spent" — a backward-looking number. The question that actually matters mid-month is forward-looking: "if nothing changes, where will we land on the last day?" That's a forecast, and it's simple enough to run by hand.
The method below is the same one that underlies daily pacing: a run-rate projection, adjusted for how each channel actually spends, re-run as new spend lands.
The steps
- 1
Get today's spend-to-date, per channel
Pull actual spend from the start of the month through today, for each channel separately. Forecasting an aggregate hides which channel is actually driving the risk.
- 2
Calculate the run-rate
Divide spend-to-date by the number of days elapsed. That's your average daily spend so far — the speed you're currently burning at.
- 3
Project to month-end
Multiply the run-rate by the total days in the month: spend ÷ days elapsed × days in month. That's your projected end-of-month total — the number to act on, not today's spend.
- 4
Compare the projection to budget
Subtract budget from the projection to get the variance in dollars, and as a percentage. A projection running more than roughly 10% over budget is worth a correction while there's still runway to make it.
- 5
Adjust for cadence
A flat daily average misreads channels that don't spend evenly — some bill on a 5-day cadence, others 7. Weight the run-rate for the days that channel actually spends on, rather than every calendar day equally, or the projection will be systematically off.
- 6
Adjust for holidays
A predictable spend spike or lull around a holiday isn't drift — it's the calendar. Factor known holidays into the projection so you don't chase a correction that fights a one-day blip instead of a real trend.
- 7
Re-run it daily, not once
A forecast from the 5th is stale by the 15th. Recalculate as new spend lands so the projection always reflects the most current trend — a forecast is a living number, not a one-time exercise.
Frequently asked questions
How do you forecast end-of-month ad spend?
Take spend-to-date, divide by days elapsed to get a daily run-rate, then multiply by the total days in the month. That projection tells you where you'll land if the current pace holds — adjust it for cadence and holidays before acting on it.
What's the formula for projecting ad spend?
Spend ÷ days elapsed × days in the month. It's a straight-line extrapolation of your current run-rate to the end of the period.
How accurate is a simple run-rate projection?
Accurate enough to catch real drift early, as long as you adjust for channels that spend unevenly across the week (cadence) and for known holidays — without those adjustments, an uneven channel will look like it's trending over or under when it's actually just running its normal weekly rhythm.
How often should I recalculate the forecast?
Daily, or at minimum every few days. The projection is only as good as the spend data behind it — a forecast from a week ago misses whatever has happened since, including any correction you already made.
What do I do if the forecast shows I'll go over budget?
Ease the daily spend for the channel's remaining active days rather than waiting for month-end. A small, early adjustment corrects the projection with far less disruption than a hard stop later — the earlier you catch it, the gentler the fix.
Keep reading
Do this automatically with Caeros.
Holiday- and cadence-aware pacing, an append-only ledger, one-click reconciliation that recovers surplus, and an honest scorecard of what it saved you — for every channel. $49/month, flat, budget and spend only.
Get startedTry the live demo