Marketing campaign tracker in Excel: the columns, the formulas and the four tabs

A marketing campaign tracker in Excel is a spreadsheet with one row per campaign activity, columns for the plan and the spend, and formulas that turn the raw numbers into cost per result. The version below uses four tabs: Plan, Tracker, Weekly and Summary. It needs no add ins or macros, it works the same in Google Sheets, and you can build it from the layouts on this page. No download is needed, which also means no file from an unknown source.

This page gives the exact columns, the formulas to type in, the naming rules that keep the data clean, and the habits that stop a tracker from going stale in the third week. It suits a small team running several campaigns across paid, email, social and content.

Tab 1: Plan

The Plan tab is one row per campaign, written before any money is spent. It exists so that nobody can change the goal after the numbers come in.

Column	What goes in it	Example
Campaign ID	A short unique code	SPRING26
Name	Plain description	Spring trial offer
Owner	One named person	Priya
Goal	One measurable result, with a number	200 (trial sign ups)
Budget	Total approved spend	Your own figure
Start and end dates	Real dates	1 April to 30 April
Channels	The list, in one cell	Search ads, email
Audience	Who it is for	Existing newsletter list

Tab 2: Tracker

One row per activity within a campaign: one ad group, one email, one social post series. This is the tab people update, so keep it narrow.

Column	Letter	Content
Campaign ID	A	Matches the Plan tab
Channel	B	Search, email, social, display, content
Activity	C	What was run
Date started	D	The day it went live
Spend	E	Actual spend to date
Impressions	F	Times it was shown
Clicks	G	Clicks or opens
Conversions	H	The action named in the goal
Revenue	I	Value attributed, if you sell online
Click through rate	J	Formula
Conversion rate	K	Formula
Cost per conversion	L	Formula
Return on spend	M	Formula
Status	N	Planned, live, paused, done

The formulas, assuming your data starts in row 2, go in columns J to M. Wrap each in a check for zero so empty rows stay blank and nothing shows an error.

J2: =IF(F2=0,"",G2/F2)
K2: =IF(G2=0,"",H2/G2)
L2: =IF(H2=0,"",E2/H2)
M2: =IF(E2=0,"",I2/E2)

Format J and K as percentages, L as currency and M as a number with one decimal. Return on spend is revenue divided by spend, so 3.0 means three units of revenue for each unit spent. Use the same currency throughout the file.

Tab 3: Weekly

The Weekly tab records one snapshot per campaign per week, so you can see a trend and not only a total. Columns: week starting date, Campaign ID, spend that week, conversions that week, and a one line note. A line chart of weekly cost per conversion shows within a few weeks whether a campaign is improving or tiring. The note column is the most valuable one: "changed subject line", "ad copy test started", "site down Tuesday". Without notes you will not remember why the line moved.

Tab 4: Summary

The Summary tab reads from the other tabs and shows one row per campaign. Use the SUMIFS function to total the Tracker by Campaign ID.

B2 (spend): =SUMIFS(Tracker!E:E, Tracker!A:A, A2)
C2 (conversions): =SUMIFS(Tracker!H:H, Tracker!A:A, A2)
D2 (revenue): =SUMIFS(Tracker!I:I, Tracker!A:A, A2)
E2 (cost per conv): =IF(C2=0,"",B2/C2)
F2 (budget used): =B2/Plan!E2
G2 (goal reached): =C2/Plan!D2

Column A holds the Campaign ID. Adjust the cell references to match your own layout, and store the Plan goal as a plain number in column D, such as 200, with the unit written in the campaign name. The last two columns, budget used and goal reached, are the ones a manager reads. If budget used is at 80 percent and goal reached is at 30 percent, the discussion starts that day.

Keep the data clean

• Use a fixed list for Channel and Status. In Excel, use Data Validation to restrict each cell to your list. This prevents "Email", "email" and "e mail" being counted as three channels.
• Tag every link. Give each activity its own campaign tag so analytics matches the row. A naming rule and a builder are in the Google UTM generator guide.
• Freeze the top row and turn on filters, so a sheet with two hundred rows stays readable.
• Keep one source for each number. Copy spend from the ad platform's own report, not from memory or an invoice.
• Lock the Plan tab once the campaign starts, with edits allowed only by the owner.

Habits that keep a tracker alive

1. Set a fixed update time, for example Monday at ten, and put it in the team calendar.
2. Give every row a single owner. Rows owned by "the team" are never updated.
3. Review the Summary tab in the weekly meeting and nowhere else.
4. At the end of a campaign write three lines in the Plan tab: what worked, what did not, what you will change. That is what a future campaign draws on.
5. Archive finished campaigns to a separate file each quarter so the live sheet stays fast.

For a planning view that sits above the tracker, a twelve week implementation schedule shows the tasks and owners, and marketing campaign examples shows what a finished campaign looks like. When the numbers need to go to a client, the five part client report shows what to include.

Questions about marketing campaign trackers

What should a marketing campaign tracker include?

A campaign ID, owner, goal, budget, dates, channel, spend, results and the cost per result. Add a notes column so changes are recorded.

Is Excel good enough for campaign tracking?

Yes for a team running a handful of campaigns. When you have dozens of channels and daily data feeds, a dashboard connected to your accounts saves time. The columns in this page carry over to one.

How do I track campaign ROI in a spreadsheet?

Divide the revenue attributed to the campaign by the spend. For profit, subtract cost of goods and other costs from revenue before dividing by spend.

Can I use this in Google Sheets?

Yes. The formulas, including SUMIFS, work the same way in Google Sheets.

How often should I update a campaign tracker?

Weekly for most campaigns, and daily for paid campaigns in their first week or when a budget is changing fast.

One column the tracker has no source for

Every column above comes from a platform you pay for or control: ad spend, clicks, sign ups. A growing share of the people your campaign reaches arrive after asking an assistant, and that route leaves no impression count, no click and no spend to enter. A buyer who asks ChatGPT or Perplexity for the best provider in your field and then types your name into a browser shows up in your tracker as direct traffic. AI Knows Us fills that gap by asking the assistants the questions your campaign targets and recording whether your brand is named, so you can add a column for it beside the paid numbers.