Monthly ad budget tracker: the columns to track and when a spreadsheet stops being enough
A monthly ad budget tracker needs one row per campaign and nine columns: planned budget, spend to date, expected spend to date, pace, forecast month-end spend, gap to plan, daily budget to hit, owner and a note. Update spend every day, not once a week, and keep a second sheet with a 12-month view of plan, forecast and actual per platform. A spreadsheet is enough for up to about 20 campaigns on one or two platforms; beyond that the manual copying costs more than it saves.
What a monthly ad budget tracker is for
A budget tracker answers three questions every day: how much have we spent, are we on plan, and what do we change. Most trackers answer only the first. They list spend and budget side by side, and the reader has to do the arithmetic that matters.
The version below adds the columns that turn a list into a control tool. It works for Google Ads, Microsoft Ads and LinkedIn Ads, and you can start it today in Excel or Google Sheets. We also publish a free pacing sheet template that has the formulas built in.
The nine columns that matter
Keep the sheet to one row per campaign. Group rows by platform and client or program, and put the account total at the top.
| Column | What it holds | Formula or source |
|---|---|---|
| Planned budget | The approved monthly budget for the campaign | From the plan; change it only when the approval changes |
| Spend to date | Cost so far this month | Platform export or connector, with the time it was pulled |
| Expected spend to date | What should be spent by now | Planned budget x time elapsed / active time in the month |
| Pace | Spend against expectation | Spend to date / expected spend to date |
| Forecast month-end | Where the month lands at the current rate | Run rate x remaining active days + spend to date |
| Gap to plan | Forecast minus planned budget | Positive is over, negative is under |
| Daily budget to hit | The daily spend that lands the month | (Planned budget - spend to date) / active days left |
| Owner | Who changes the budget | Name, so alerts have a destination |
| Note | Why it is off or was changed | Free text, dated |
Use active days, not calendar days, for campaigns with an ad schedule. A weekday-only campaign has about 21 active days in a typical month, and a tracker that divides by 30 will show it as underpacing all month.
Update it daily and note the hour
Stale data is the main way trackers fail. A sheet updated on Mondays reports Friday’s problem on the following Monday, after the budget has already overshot. Pull spend every morning at the same hour and record the hour. Expected spend should count today’s hours up to the pull, so a morning check is not compared with a full day of budget and every campaign does not look behind.
Platforms report on different clocks. Google Ads and Microsoft Ads use the account or campaign time zone, and LinkedIn’s daily budget resets at midnight UTC. Totals reconcile over the month. Days do not, so do not read a single day across platforms.
The 12-month sheet for finance
Keep a second sheet with months across and platforms down. Three rows per platform: plan, forecast (actual for past months) and variance. Update the current month’s forecast weekly and lock past months when they close. This is the view finance and leadership read, and it is where year-to-date underspend becomes visible before December.
Add one line for committed spend: insertion orders, purchase orders and fixed-flight campaigns. It prevents the sheet from showing available budget that is already spoken for. Our article on tracking spend against purchase orders explains the pattern.
Naming and tagging that keeps it clean
A tracker lives or dies on consistent names. If the campaign names in the sheet do not match the platform, every refresh breaks a lookup. Use one naming convention for campaigns across platforms, and use the same UTM values on every landing URL so that spend lines up with the pipeline it created. Our UTM link builder enforces naming rules before a link goes live, which keeps the tracker and the CRM describing the same campaigns.
When a spreadsheet stops being enough
- You manage more than about 20 campaigns, or three or more platforms, and the daily export takes more than 10 minutes.
- Budgets change mid-month and nobody recalculates the expected spend column.
- Several people edit the sheet and formulas break.
- Finance wants a forecast every week with a range, not a single number.
- You need alerts: someone has to open the sheet to learn that a campaign is off.
None of these is a reason to start with software. They are the reasons to move when the sheet costs more attention than the problems it finds.
What a pacing tool adds
Pacing Console is the tracker above, run for you. It pulls spend hourly with a script in your own Google Ads or Microsoft Ads account, or daily by sign-in, syncs LinkedIn Ads daily, calculates every column per campaign, and emails only the campaigns that are off pace. Forecasts, the daily budget to hit and a month-end accrual by client and platform are included.
The first month is free with no credit card. Solo is $19 and Pro is $49 USD per workspace a month after that. If you want to see the arithmetic first, the free PPC budget pacing calculator and the budget pacing sheet template do the same job for one campaign or a small account.
Key takeaways
Keep going
Frequently asked questions
What should a monthly ad budget tracker include?
Per campaign: planned budget, spend to date, expected spend to date, pace, forecast month-end, gap to plan, the daily budget to hit, an owner and a note. Add a 12-month sheet of plan, forecast and actual per platform for finance.
How do I track ad spend across Google Ads, Microsoft Ads and LinkedIn Ads in one sheet?
Use one row per campaign with a platform column, pull spend each morning at the same hour, and compare each campaign with expected spend to that hour. Total by platform and by client or program.
How often should I update an ad budget tracker?
Daily. A weekly update reports an overspend after it has happened. Record the hour of each pull so that pace is measured fairly.
Is there a free ad budget tracker template?
Yes. Our free Google Ads budget pacing sheet template for Excel and Google Sheets has the pace, daily budget and forecast formulas built in, and the PPC budget pacing calculator handles one campaign.
When should I replace a spreadsheet tracker with software?
When you manage more than about 20 campaigns across several platforms, budgets change mid-month, several people edit the sheet or finance wants weekly forecasts. Software pays back when the manual refresh costs more than it finds.
Sources
Related service: Paid media. See also pricing and client results.
We run enterprise B2B demand generation for teams in Montreal, Toronto, Ottawa and the United States.