Campaign budget pacing calculator: how to measure planned vs actual spend

A campaign budget pacing calculator tells you whether a live campaign has spent the amount it should have spent by today. It also shows how much needs to be spent each remaining day to finish on budget.

The basic calculation is simple. The difficult part is deciding what 'should have spent' means. A straight-line campaign can use elapsed time. A campaign shaped around launch, seasonality or promotional periods needs a weighted plan. Using the wrong baseline can create false alarms or hide genuine delivery problems.

The three calculations you need

Planned spend to date

A campaign with a £30,000 budget running for 30 days should have spent £10,000 after ten complete days. For a weighted campaign, use the approved daily or weekly flighting instead. If 40% of the budget was intentionally assigned to the first week, the straight-line formula would incorrectly label the campaign as overspending.

Pacing variance

If planned spend is £10,000 and actual spend is £11,500, the campaign is £1,500 or 15% ahead of pace.

Required daily spend

If the campaign has £18,500 left and 20 days remaining, it needs to spend an average of £925 per day to finish on budget. This figure becomes more useful when compared with recent delivery. If the account has averaged only £600 per day and no major change is planned, the under-delivery is unlikely to recover by itself.

Worked example

The calculator has not yet told you what action to take. It has identified the size of the gap. The next step is to understand why the campaign is behind and whether increasing delivery is likely to damage performance.

What counts as a pacing problem?

There is no universal threshold. A 10% gap in the first two days of a three-month campaign may be noise. The same gap with four days remaining may be unrecoverable.

A practical rule is to combine three tests: size, duration and consequence. Flag a line when the variance exceeds an agreed percentage, persists for several refreshes and is large enough to affect the campaign objective. A working example used in Medusa's pacing guidance is plus or minus 10% against weighted planned-to-date, sustained for three consecutive days. That is a sensible starting point for many campaigns, but teams should tighten or loosen the rule based on flight length, budget size and volatility.

Why a weighted pacing calculator is better

Media delivery is rarely perfectly even. Retail campaigns may peak around salary dates or promotional weekends. Video activity may front-load reach. Search may follow demand. New platform activity may begin cautiously while tracking and creative are validated.

A weighted calculator stores the expected share of budget by day or week. Planned-to-date is then the sum of those approved weights rather than a simple fraction of elapsed time. This prevents the pacing process from fighting the strategy. It also makes client conversations clearer because the team can explain whether a difference is against the actual plan, not an arbitrary straight line.

Calculate outcomes, not only spend

A campaign can be on budget and still be failing. Add at least one outcome metric to the pacing view: conversions, revenue, qualified leads, completed views or another measure tied to the objective.

When spend is ahead and efficiency is stable, the campaign may have an opportunity to scale. When spend is ahead and CPA is deteriorating, the acceleration may need to be controlled. When spend is behind but outcomes are already strong, the team should assess whether the original budget was larger than the efficient opportunity. The pacing calculator should trigger investigation, not automatic spending for the sake of hitting a total.

Common causes of under-pacing

Under-delivery may be caused by audiences that are too narrow, bids or budgets that restrict auctions, creative disapprovals, broken billing, low search demand, an incorrect schedule or campaign settings that do not match the plan.

The fix depends on the cause. Broadening an audience may recover delivery but weaken quality. Increasing bids may raise cost. Reallocating budget to another channel may protect the overall objective more effectively than forcing the original line to spend.

Common causes of over-pacing

Over-delivery often comes from platform budgets that do not match the approved flighting, shared budgets, duplicated campaigns, incorrect start dates, automation without appropriate guardrails or a sudden increase in available demand.

The response should consider both the budget and the outcome. Pausing a high-performing line simply because it is ahead can be as damaging as ignoring inefficient overspend.

From calculator to operating process

A standalone calculator is valuable for an immediate check. An agency managing several clients needs the calculation to run automatically against every live plan.

Medusa uses the budgets and flighting in the media plan as the baseline, refreshes actuals from connected platforms and flags lines that move ahead or behind. This removes the need to download data, paste it into client-specific trackers and rebuild the same formula repeatedly.

Calculate the gap, then automate the monitoring

Use the formulas above for a quick diagnosis. Use Medusa when every client and channel needs the same planned-versus-actual logic, refreshed daily and attached to the original media plan.