Ad Budget Pacing Template: Formulas, Example, Free Method
The core budget pacing formulas — spend vs. expected, run-rate projection, safe daily spend — with a worked Google, Meta, and LinkedIn example table.
Updated July 2026.
An ad budget pacing template tracks month-to-date spend against where it should be, using three formulas: pacing percentage (spend-to-date ÷ expected spend-to-date), a run-rate projection, and a safe-daily-spend number for the days remaining. This one is free — every formula and the worked example below can be rebuilt in Google Sheets in about 15 minutes, covering Google Ads, Meta, and LinkedIn in one tab.
The budget pacing formulas
Four numbers, all derivable from your monthly budget, spend-to-date, and the calendar:
- Expected spend to date = (monthly budget ÷ days in month) × days elapsed. This is your straight-line plan.
- Pacing % = actual spend to date ÷ expected spend to date. 100% means on plan. Above ~110% you're hot; below ~90% you're leaving budget (and pipeline) on the table.
- Run-rate projection = (actual spend to date ÷ days elapsed) × days in month. Where the month lands if nothing changes.
- Safe daily spend = (monthly budget − actual spend to date) ÷ days remaining. What each remaining day can afford.
That's the entire budget pacing method. Everything else is plumbing.
Worked example: Google + Meta + LinkedIn on day 10
Day 10 of a 31-day month. Expected pace is 10 ÷ 31 = 32.3% of budget spent.
| Platform | Monthly budget | Spend (day 10) | Expected | Pacing % | Projected month-end | Safe daily spend |
|---|---|---|---|---|---|---|
| Google Ads | $15,000 | $5,400 | $4,839 | 112% | $16,740 | $457 |
| Meta | $9,000 | $2,610 | $2,903 | 90% | $8,091 | $304 |
| $6,000 | $2,480 | $1,935 | 128% | $7,688 | $168 | |
| Blended | $30,000 | $10,490 | $9,677 | 108% | $32,519 | $929 |
Read it like an operator: the blended 108% looks mild, but it's hiding a LinkedIn campaign running 28% hot — on track to blow its budget by $1,688 — partially masked by Meta underspending. Google is spending $540/day but can only afford $457/day from here. This is why you pace per platform and blended: averages hide fires.
Build the budget pacing spreadsheet, column by column
- Create columns: Platform, Monthly budget (B), MTD spend (C), Days elapsed (D), Days in month (E), Expected spend (F), Pacing % (G), Projection (H), Safe daily (I).
- Days in month:
=DAY(EOMONTH(TODAY(),0)). Days elapsed:=DAY(TODAY())-1— use complete days, because today's spend is still accumulating and will make you look under-paced. - Expected spend:
=B2/E2*D2 - Pacing %:
=C2/F2, formatted as a percentage. - Projection:
=C2/D2*E2 - Safe daily spend:
=(B2-C2)/(E2-D2) - Add conditional formatting on Pacing %: red above 110%, yellow below 90%.
- Add a blended row that sums budgets and spend, with the same formulas on the totals.
- Each morning, pull yesterday's month-to-date spend from Google Ads, Meta Ads Manager, and LinkedIn Campaign Manager, and paste into column C.
Two gotchas worth respecting: always compare complete days to complete days (mixing a partial today into MTD spend skews pacing low), and re-check column E at every month rollover — a 31-day formula quietly applied to February has ended careers.
Handling uneven spend (weekends, flights, month-end pushes)
Straight-line pacing assumes every day is equal. If your account reliably spends less on weekends, upgrade Expected Spend from "days elapsed" to "weight elapsed": give each weekday a weight (say, 1.0) and weekends less (say, 0.6), then compute expected spend as budget × (weight elapsed ÷ total weight). For campaigns on fixed flights rather than calendar months, swap "days in month" for flight length and pace against the flight. The formulas don't change — only the denominator does.
Why budget pacing spreadsheets break
Honest section. Every team builds this sheet; almost every team abandons it within a quarter, for the same four reasons:
1. Manual exports are the single point of failure. The sheet is only as fresh as the last paste. Skip Friday, and Monday's number covers a three-day blind spot — precisely when nobody was watching.
2. No intraday data. Google Ads can spend up to 2× a campaign's daily budget in a single day, and LinkedIn daily budgets can overshoot too. A once-a-day snapshot can't catch a spike that starts and finishes between pastes.
3. Formula rot. New campaigns don't add themselves. Rows get sorted, references break, the month rolls over, and the sheet keeps rendering confident green numbers that are quietly wrong.
4. It tells you that, never why. The sheet says LinkedIn is at 128%. It cannot tell you that someone raised a bid on Tuesday at 4 p.m. — the thing you actually need before you can fix anything.
The automated version of this template
The Ad Spend runs this exact math continuously: budget pacing checks every ~6 hours across Google, Meta, LinkedIn, TikTok, and Reddit, with alerts posted to Slack when pacing drifts — no exports, no pastes. Beyond the template's math, it layers on 1,900+ detection algorithms with baselines learned from your account, a permanent record of who changed what and when, and causal inference that ties the 128% pace to the exact change that caused it. It started as a free tool for budget pacing alerts, and pacing alerts are still free — see how the alerts work.
Keep the spreadsheet if you like the ritual — but get the safety net free. The Ad Spend's free tier includes budget pacing and ad performance alerts on every connected platform. See plans.
FAQ
What is the budget pacing formula?
Pacing % = actual spend to date ÷ expected spend to date, where expected spend to date = (monthly budget ÷ days in month) × days elapsed. 100% is on plan; the useful companion numbers are the run-rate projection and safe daily spend for the days remaining.
What's a good pacing percentage?
Most teams treat 95–105% as healthy, investigate outside 90–110%, and act immediately beyond 120%. Tighter bands make sense late in the month, when fewer days remain to correct course.
Should I pace against calendar days or business days?
Calendar days if spend is roughly flat across the week; weighted days if weekends reliably dip. Check a past month's daily spend — if Saturday runs under 70% of a weekday, weighting is worth the extra column.
Does this template work for lifetime or flight budgets?
Yes — replace "days in month" with total flight days and "days elapsed" with flight days completed. The pacing, projection, and safe-daily formulas carry over unchanged.
How often should I update a pacing spreadsheet?
Daily, using complete-day data — and that cadence is exactly the weakness. Platforms can materially overspend within a single day, which is why automated checks every few hours beat any manual routine.