Marketing Channel ROI Comparison: How to Compare Fairly

Why "Which Channel Is Winning" Is the Wrong First Question

Someone in the board review asks it eventually: "Which channel is actually working?" You have three numbers ready — one from the ad platform's own dashboard, one from a spreadsheet a former hire built, one you calculated last night trying to reconcile the two. They don't agree, because they were never measuring the same thing. The paid social number counts media spend only. The content number, if it exists at all, ignores the hours your team put into it. The event number lands somewhere in a different fiscal quarter than the leads it produced.

None of that means the channels are performing badly. It means the comparison is broken before the first number gets written down. A fair marketing channel ROI comparison isn't about finding a smarter formula — it's about making sure every channel is measured on the same window, the same cost basis, and the same definition of a result, so that when one channel looks better than another, it actually is. This piece walks through how to build that comparison using your own figures, without borrowing a benchmark that describes someone else's business.

The Three Numbers a Fair Comparison Needs

Every channel-level marketing channel ROI comparison collapses down to three related numbers, computed the same way for every channel in the table:

• Cost per lead (CPL) — total cost attributed to the channel over the period, divided by leads generated in that period.
• Customer acquisition cost (CAC) — total cost attributed to the channel, divided by customers (not leads) acquired in that period.
• Return on investment (ROI) — the value generated by the channel, minus its cost, divided by its cost, expressed as a percentage.

The formula matters less than the consistency of what goes into it. If paid search costs include the media buy only, and content costs include a fully loaded share of a writer's salary, the comparison is comparing two different kinds of number that happen to share a label. For a deeper walkthrough of how to define "cost" and "result" for each channel before you calculate anything, see how to measure marketing channel ROI.

Building a Comparison Table on One Consistent Basis

Before any numbers go in a table, three decisions need to be made once, in writing, and applied to every channel without exception:

1. The time window. Pick a period — a month, a quarter — and pull every channel's cost and result from that same window. A channel with a long sales cycle will look artificially weak if its window is too short; note that as a caveat rather than adjusting the window for one channel and not the others.
2. The cost basis. Decide whether "cost" means media spend only, or media spend plus a share of headcount, tools, and agency fees. Either is defensible. What isn't defensible is mixing the two across channels in the same table.
3. The attribution rule. Decide what counts as a channel's result — first touch, last touch, or a split. Whatever you pick, apply it uniformly. A cost-per-lead comparison across channels is only useful once you've settled on a consistent way to size up each channel's raw cost; if that's the piece you're missing, cost per lead by channel benchmark walks through how to set that baseline for your own numbers rather than borrowing someone else's.

Once those three rules are fixed, build one table with a row per channel and a column for cost, leads, customers, CPL, CAC, and ROI. Nothing goes in until it's been through the same rule.

A Worked Example: Three Channels, One Method

The numbers below are a worked example only — plug in your own figures in place of these. They exist to show the mechanics of the comparison, not to describe what any channel should cost or return.

Say your three channels are paid search, paid social, and content/organic, all measured over the same fiscal quarter, using a fully loaded cost basis and last-touch attribution:

Channel	Cost (assumed)	Leads (assumed)	Customers (assumed)	CPL	CAC
Paid search	$30,000	300	15	$100	$2,000
Paid social	$18,000	240	8	$75	$2,250
Content/organic	$12,000	90	9	$133	$1,333

On raw cost-per-lead alone, paid social looks cheapest. On cost per customer, content is the strongest performer in this worked example — a reminder that CPL and CAC can point in different directions, and a marketing channel roi comparison built on only one of them can steer a reallocation decision the wrong way.

To get to ROI, you'd add an assumed value per customer (say, average deal value or lifetime value) and run: (value − cost) ÷ cost. That final step depends entirely on a number only your finance team or your own historical close data can supply — don't substitute an industry average for it. The comparison is doing its job once it forces you to look at CPL, CAC, and ROI side by side for the same channels over the same window, rather than trusting whichever number happened to be highlighted in a dashboard.

From Comparison to Reallocation

A comparison table is diagnostic, not a decision. The decision is what you do with the gap once you see it — and that's a separate, deliberate step, not an automatic one. A channel with a worse CPL but a better CAC might still deserve more budget if it's converting the customers you actually want. A channel that looks strong on paper might be running against a ceiling — there may not be more inventory to buy at that price, no matter how good its numbers look this quarter.

Before shifting money, work through how much can move, how fast, and what happens to the channel losing budget mid-flight. How to allocate marketing budget by channel covers the mechanics of splitting a total budget across channels in the first place; reallocating marketing budget between channels covers the harder case — moving money between channels that are already live, including what to do about campaigns that were already funded under the old split.

Keeping the Comparison Honest as the Quarter Moves

A comparison built once, in a slide deck, at the start of the quarter goes stale the moment actuals start coming in. Costs shift as invoices land later than expected. Lead counts move as campaigns ramp or stall. Customer counts lag behind both, because deals take time to close. A comparison that isn't rebuilt on a schedule quietly turns into an assumption everyone keeps repeating even after it stops being true.

The fix isn't a more sophisticated formula — it's a fixed cadence for rerunning the same table with fresh actuals, and a habit of checking whether last quarter's "winning" channel still looks that way once the lagging customer numbers catch up. Treat the comparison as a living check-in, not a one-time exercise you file away after the board meeting.

Where This Comparison Fits Into Your Budget Process

Building this table by hand, in a spreadsheet, works — it just has to be rebuilt every time actuals change, across every channel, on the same three rules, without anyone quietly relaxing the cost basis for the channel they'd rather see win. The Marketing Channel ROI Comparison Worksheet sets up that table with the CPL, CAC, and ROI formulas pre-built, so you're only ever filling in your own cost, lead, and customer figures for each channel — the same structure walked through above, ready to reuse every period.

If you're maintaining a full plan and budget across more channels than three, and want the comparison to recompute itself as actuals get logged rather than as a periodic export, that's what the MarketPlans workspace is built for — one plan, a channel-level budget, and the variance between planned and actual updating as you go, rather than at quarter-end. You can see how it fits alongside the rest of your budget process on the marketing budget tools hub, browse the full set of standalone worksheets in the store, or join the waitlist to try the workspace itself.