Ad Spend Budget Spreadsheet: Track Planned vs. Actual Spend and ROAS by Campaign

An ad spend budget spreadsheet is a structured tracker that records how much you’ve allocated to each advertising channel, how much you’re actually spending per campaign, and what return each campaign generates. It answers three questions every week: Are we on pace? What’s working? Where should we shift money?

Ad spend budget spreadsheet: A multi-tab document that maps advertising budgets by channel and time period, tracks actual spend against plan at the campaign level, calculates ROAS per campaign, and logs quarterly reallocation decisions with supporting rationale.

Supermetrics and Windsor.ai both offer Google Sheets budget pacing templates that pull data directly from ad platforms, but those require paid subscriptions and API integrations. This spreadsheet gives you the same structure as a standalone document your whole team can use from day one. No integrations required. The urgency is real. WordStream’s 2026 Google Ads benchmarks show the average CPC across all industries is $5.26, up from $4.22 two years prior. CPC has risen for 87% of industries year over year. If you’re not tracking spend at the campaign level and shifting budget away from underperformers weekly, rising costs will eat your margin quietly.

Tab	Purpose	Key Columns
1. Annual Budget by Channel	Top-level allocation plan	Channel, Annual Budget, % of Total, Q1-Q4 Split, Monthly Average, Notes
2. Monthly Planned vs. Actual	Budget pacing by month	Channel, Month, Planned Spend, Actual Spend, Variance ($), Variance (%), Pace Status
3. Campaign-Level Tracker	Granular spend by campaign	Channel, Campaign Name, Monthly Budget, MTD Spend, Daily Run Rate, Projected Month-End, Over/Under Flag
4. ROAS by Campaign	Return on ad spend calculation	Campaign, Spend, Revenue, ROAS, CPA, Conversions, Conv. Rate, Profit/Loss
5. Quarterly Reallocation	Budget shift decisions and rationale	Channel, Previous Quarter Budget, Previous Quarter ROAS, New Budget, Change ($), Change (%), Rationale

• Annual Budget by Channel: Start here. Enter your total annual ad budget and allocate across channels. The template includes a suggested split based on your business model (B2B, DTC, or Local). For a B2B company spending $120,000/year on ads, a common starting split is 50% Google Search, 20% LinkedIn, 15% Meta retargeting, and 15% experimental. The percentages auto-calculate from dollar amounts.
• Monthly Planned vs. Actual: Each row is one channel for one month. Enter planned spend at the start of the month and update actual spend weekly. The “Pace Status” column shows “On Track” (within 10% of plan), “Overpacing” (more than 10% over), or “Underpacing” (more than 10% under). Conditional formatting uses green, red, and yellow for instant visual scanning.
• Campaign-Level Tracker: This is where daily management happens. Each row is an individual campaign. The “Daily Run Rate” formula divides MTD spend by the number of days elapsed. “Projected Month-End” multiplies the run rate by days remaining. If a campaign is projected to exceed its monthly budget by more than 15%, the row turns red. Update this tab every 2-3 days.
• ROAS by Campaign: Enter campaign-level spend and attributed revenue (from Google Ads conversion tracking, Meta’s CAPI, or your CRM). The sheet calculates ROAS, CPA, conversion rate, and a simple profit/loss estimate. This tab answers the only question that matters: for every dollar we spent, how much did we get back?
• Quarterly Reallocation: Every 90 days, review ROAS by channel. This tab pulls last quarter’s budget and ROAS data and provides space to enter the new quarter’s allocation with a required “Rationale” column. Documenting why you shifted $5,000 from LinkedIn to Google Search protects you from second-guessing and gives stakeholders full visibility.

We’ve audited ad accounts spending $10,000 to $400,000 per month at ScaleGrowth.Digital. The same patterns show up at every spend level:

1. Setting monthly budgets and never checking pacing. A $30,000/month Google Ads budget that runs at $1,200/day will exhaust by the 25th. The last 5 days of the month get zero impressions. The campaign-level tracker catches this on day 3, not day 25.
2. Averaging ROAS across all campaigns instead of measuring each one. An account with 4:1 blended ROAS might have two campaigns at 8:1 and three at 1.5:1. The bad campaigns are hiding behind the good ones. Tab 4 surfaces this by requiring campaign-level ROAS entry.
3. Never reallocating. Smartsheet’s 2025 advertising budget research found that teams who reallocate quarterly outperform those who set annual budgets by 20-35% in cost efficiency. The quarterly reallocation tab makes this a standard practice, not an exception.

“The number one reason ad budgets get cut isn’t poor performance. It’s the inability to prove good performance. If you can show your CFO exactly which campaigns generated which revenue at what cost, your budget grows. If you can’t, you’re first in line for cuts.”

Hardik Shah, Founder of ScaleGrowth.Digital