Paid media

Monthly ad budget tracker: the columns to track and when a spreadsheet stops being enough

The short answer

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.

ColumnWhat it holdsFormula or source
Planned budgetThe approved monthly budget for the campaignFrom the plan; change it only when the approval changes
Spend to dateCost so far this monthPlatform export or connector, with the time it was pulled
Expected spend to dateWhat should be spent by nowPlanned budget x time elapsed / active time in the month
PaceSpend against expectationSpend to date / expected spend to date
Forecast month-endWhere the month lands at the current rateRun rate x remaining active days + spend to date
Gap to planForecast minus planned budgetPositive is over, negative is under
Daily budget to hitThe daily spend that lands the month(Planned budget - spend to date) / active days left
OwnerWho changes the budgetName, so alerts have a destination
NoteWhy it is off or was changedFree 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

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.

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.

Keep reading

Related insights

Every resource on this topic

Free 30-minute pipeline plan

Want this applied to your own numbers?

No pitch and no commitment. We would genuinely love to hear what you are working on, what needs to change, and share what we would bring to the table. Two short steps, and a senior strategist replies within one business day.

  • Senior-led first call, no junior handoff
  • Your top three fixes, whether or not we work together
  • NDA on request, transparent paid media fees
PlanConversion Strategy TeamSenior strategists in ABM, paid media, search, RevOps and AI. Every request is read by a person.

Trusted by enterprise and growth B2B teams

  • ABB logo
  • KNIME logo
  • Nakisa logo

Founder’s in-house leadership. Before PlanConversion, the founder led enterprise marketing in-house at these companies as Director of Revenue Growth. They are not clients.

  • Coveo logo
  • Assent logo
You are requesting: Free 30-minute pipeline plan
Where should we send the plan?

We reply within one business day with a practical scope and next step.

We reply within one business day. No sharing.

Reply in one business dayNDA on requestSenior team on every call

We use your details to reply to this request, and send marketing only if you opt in. No sharing. Privacy policy

$120M+pipeline influenced
18,000+qualified leads
92%clients expand scope
Pipeline planPricing