Marketing Budget and Campaign Tracking Spreadsheet: Compare Spend, Leads, and Return by Channel
marketing analyticscampaign trackingbudget planningROIKPI reportingExcelGoogle Sheets

Marketing Budget and Campaign Tracking Spreadsheet: Compare Spend, Leads, and Return by Channel

SSpreadsheet Strategy Editorial Team
2026-11-20
6 min read

Build an Excel or Google Sheets marketing tracker to compare spend, leads, customers, acquisition cost, and return by campaign.

A well-structured marketing budget spreadsheet helps you connect planned spend with actual costs, leads, customers, and revenue. This guide shows how to build an Excel or Google Sheets campaign tracker, define reliable inputs, calculate cost per lead and customer acquisition cost, compare channels, and decide when budget changes are justified.

Overview

A marketing budget spreadsheet is most useful when it does more than list invoices. It should show how money moves through the campaign funnel and make comparisons possible across channels, campaigns, and reporting periods.

A practical workbook can contain five connected areas:

  • Campaign setup: campaign name, channel, objective, audience, owner, start date, and end date.
  • Budget plan: planned spend by month, channel, or campaign.
  • Performance inputs: actual spend, impressions or clicks where relevant, leads, qualified leads, opportunities, customers, and attributed revenue.
  • Calculated metrics: budget variance, pacing, cost per lead, conversion rates, customer acquisition cost, return on ad spend, and marketing return.
  • Dashboard view: summary tables and charts for recurring weekly or monthly reviews.

Keep raw inputs separate from formulas. A simple structure might use tabs named Campaigns, Monthly Spend, Results, Assumptions, and Dashboard. This makes it easier to replace a platform export without overwriting calculations.

For cleaner reporting, standardize imported campaign names, dates, and channel labels before summarizing them. The Google Sheets and Excel data cleaning checklist can help with that preparation. If your workbook also includes pipeline estimates, connect it to a sales forecast spreadsheet rather than maintaining two conflicting revenue assumptions.

How to estimate

Start with one row per campaign and one reporting period per row. For example, a monthly tracking table might include:

Month | Channel | Campaign | Planned Spend | Actual Spend | Leads | Qualified Leads | Customers | Revenue

Use formulas for the metrics that depend on these inputs:

  • Budget variance: Actual Spend − Planned Spend.
  • Budget variance percentage: (Actual Spend − Planned Spend) ÷ Planned Spend.
  • Cost per lead: Actual Spend ÷ Leads.
  • Lead-to-customer conversion rate: Customers ÷ Leads.
  • Customer acquisition cost: Actual Spend ÷ Customers.
  • Return on ad spend: Attributed Revenue ÷ Actual Spend.
  • Marketing return: (Attributed Revenue − Actual Spend) ÷ Actual Spend.

Protect the sheet from divide-by-zero errors. In Excel or Google Sheets, a formula such as =IFERROR(E2/F2,"") returns a blank when the denominator is empty or zero. You can also use IF(F2=0,"",E2/F2) when you want the condition to be explicit.

For monthly pacing, compare actual spend to the portion of the budget that should have been used by the reporting date. A basic pacing percentage is Actual Spend ÷ Planned Spend to Date. Do not compare a full-quarter budget with one month of spend unless the campaign was deliberately front-loaded.

Use pivot tables, SUMIFS, or a Google Sheets QUERY to summarize results by channel and campaign. A pivot table is often the easiest choice for a small business dashboard because it allows the reporting period, channel, and campaign to be changed without rewriting formulas.

Choose one primary comparison metric before making a decision. Cost per lead may be appropriate for an early lead-generation campaign, while customer acquisition cost or attributed revenue may be more useful when sales-cycle data is available. Comparing channels using different stages of the funnel can produce a misleading ranking.

Inputs and assumptions

The quality of a marketing ROI spreadsheet depends on consistent definitions. Document these assumptions in a visible Assumptions tab:

  • Spend: Decide whether actual spend includes media only or also creative, software, contractor, event, and internal production costs. Use the same definition across campaigns.
  • Reporting date: State whether costs are recorded by invoice date, platform delivery date, payment date, or another convention. Mixing these approaches can shift spend between months.
  • Lead definition: Specify what counts as a lead and whether duplicates, spam submissions, existing customers, or incomplete records are excluded.
  • Customer definition: Record whether a customer means a closed deal, a paid order, or another completed action.
  • Revenue: Identify whether revenue is gross, net of discounts, or limited to collected revenue. If a sale is still pending, do not treat an estimate as settled revenue without labeling it.
  • Attribution: Record the attribution rule used for the report, such as first touch, last touch, or a manually assigned source. No single view necessarily explains the full customer journey.
  • Currency and tax treatment: Keep currency consistent and note whether taxes or fees are included.

Unattributed conversions deserve their own row or status rather than being silently assigned to a channel. Track them separately, investigate whether the source can be recovered, and show both channel-attributed and total results. This prevents the dashboard from overstating the performance of channels with stronger tracking coverage.

Use data validation lists for channel names, campaign stages, and reporting months. Consistent labels prevent errors such as treating “Paid Search,” “paid search,” and “Search Ads” as three separate channels. Conditional formatting can highlight overspend, missing campaign owners, negative variance, or unusually high acquisition cost, but it should support review rather than replace it.

Worked examples

Assume the following illustrative monthly results for two campaigns. The figures are examples for demonstrating the calculations, not performance benchmarks.

CampaignPlanned spendActual spendLeadsCustomersRevenue
Search campaign2,0002,2004055,500
Email campaign8006003043,200

For the search campaign, cost per lead is 2,200 ÷ 40, or 55. Customer acquisition cost is 2,200 ÷ 5, or 440. Return on ad spend is 5,500 ÷ 2,200, or 2.5. Budget variance is 200 over plan, which is a 10% increase relative to the planned spend.

For the email campaign, cost per lead is 600 ÷ 30, or 20. Customer acquisition cost is 600 ÷ 4, or 150. Return on ad spend is 3,200 ÷ 600, or approximately 5.33. The campaign used 200 less than planned.

These figures suggest that the email campaign was more efficient on the selected metrics, but they do not automatically justify moving all available budget there. Check audience size, revenue quality, reporting lag, attribution coverage, campaign objective, and whether additional spend would produce the same result. A campaign can have a low cost per lead and still create little sales value if lead quality is weak.

For a recurring decision meeting, add columns for decision, owner, and next review date. A useful decision may be “hold,” “increase gradually,” “reduce,” or “investigate tracking.” Link the workbook to a small business KPI dashboard if the marketing metrics need to sit alongside sales, cash flow, or operational measures.

When to recalculate

Enter new results weekly when campaigns are active, but make budget reallocation decisions on a cadence that matches the buying cycle. Fast-moving campaigns may need a weekly review; campaigns with delayed lead qualification or sales conversion may need a monthly review. Avoid treating incomplete early results as final.

Recalculate the workbook whenever pricing inputs change, including media costs, platform fees, software subscriptions, production costs, or campaign budgets. Update assumptions when conversion stages, revenue definitions, or attribution rules change. Refresh the model when a campaign launches, pauses, changes audience, or shifts from lead generation to sales conversion.

Before each review:

  1. Reconcile platform exports, invoices, and internal sales records.
  2. Check that every spend entry has the correct month, channel, and campaign name.
  3. Separate attributed, unattributed, duplicate, and pending conversions.
  4. Review formulas for broken references and confirm that pivot tables or dashboard ranges include new rows.
  5. Compare planned versus actual spend and investigate material differences.
  6. Record the decision, owner, and date for the next check.

Run a formula and link review after major edits. The spreadsheet audit checklist is useful for checking formula errors, broken links, and reporting inconsistencies. If you are comparing budget choices under uncertain conversion assumptions, create best-case, base-case, and downside scenarios with a scenario analysis spreadsheet.

Finally, preserve prior reporting periods instead of overwriting them. A dated monthly snapshot creates an audit trail and lets you distinguish a real performance change from a change in measurement. With consistent inputs and clearly labeled assumptions, your marketing budget spreadsheet becomes a repeatable decision tool rather than a one-time campaign log.

Related Topics

#marketing analytics#campaign tracking#budget planning#ROI#KPI reporting#Excel#Google Sheets
S

Spreadsheet Strategy Editorial Team

Senior SEO Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.