ROI and Marketing Efficiency Model: Measuring What Your Spend Actually Returns

At the end of every quarter, someone in the marketing team will present a slide showing that the quarter’s campaigns generated a 12× return on investment. The number sounds impressive. The finance team nods politely and immediately starts working out what it actually means.

The problem is not that marketing teams are being dishonest. It is that “ROI” is a loosely defined concept, and the version most commonly used — revenue generated divided by marketing spend — is almost entirely useless as a decision-making tool. A business with a 5% gross margin can report a 20× revenue ROI and still be destroying value with every pound it spends on customer acquisition. Finance teams know this. Marketing teams often do not. The analyst who can bridge that gap — who can take the marketing team’s channel data and turn it into a rigorous efficiency model — is genuinely valuable in any growth-stage business.

This post builds a marketing ROI model for GrowthCo, a D2C subscription business, and introduces the metrics that actually matter: Customer Acquisition Cost, CAC payback period, and channel-level efficiency.

---

Defining ROI — What Are We Actually Measuring?

There are three progressively useful ways to define marketing ROI, and understanding the difference between them is the foundation of the whole discipline.

Level 1 — Revenue ROI: Revenue generated / Marketing spend

This is the version that appears in most marketing dashboards. It is simple, intuitive, and misleading. Revenue tells you nothing about whether you made money. A retailer with 20% gross margins who spends £100k acquiring customers that generate £800k of revenue is not running a 8× ROI — it is running a significant loss once you account for the cost of goods sold.

Level 2 — Gross Profit ROI: Gross profit from acquired customers / Marketing spend

This is a material improvement. Gross profit tells you what revenue is worth after accounting for the direct cost of delivering it. For GrowthCo, which sells subscription boxes at £30/month with a 70% gross margin, the monthly gross profit per customer is £21. A campaign that acquires 1,000 customers at a cost of £50k generates £21,000 of gross profit in month one — a gross profit ROI of 0.42×. That looks terrible, but it should: the customers are valuable over their lifetime, not just in month one.

Level 3 — Contribution ROI: (Gross profit − retention costs − customer support − refunds) / Marketing spend

This is the most accurate version for subscription businesses. Some customers will churn in month one. Others will require disproportionate customer support. Refund rates vary by channel. Contribution ROI strips out these costs to give the cleanest view of what each pound of spend actually returned.

In practice, most businesses build Level 2 into their core ROI model and track Level 3 for specific decisions. The key principle is consistent: ROI should measure whether the lifetime value of acquired customers exceeds the cost to acquire them. That means the ROI model must be linked to an LTV calculation — which is the subject of the next post in this series.

---

Customer Acquisition Cost

Customer Acquisition Cost (CAC) is the single most important metric in a growth-stage company’s financial model. It measures the total cost required to acquire one new paying customer.

The basic formula is:

CAC = Total Marketing & Sales Spend / Number of New Customers Acquired

But the devil is in the definition of “total spend.” There are two common approaches:

Campaign-only CAC includes only the direct media spend: paid search budgets, social advertising, influencer fees, and agency costs. It ignores salaries, tooling, creative production, and overhead.

Fully-loaded CAC includes everything: direct media spend plus the prorated salaries of marketing and sales team members, marketing technology subscriptions, photo and video production, and a share of relevant overheads. This is the number finance teams use for planning because it reflects the true cost of maintaining the acquisition function.

The gap between these two can be substantial. If GrowthCo’s marketing team of four people costs £280k in annual salaries and employer costs, that is £70k per quarter before a single pound of media is spent. Leaving that out makes CAC look much healthier than it is.

Channel-level CAC for GrowthCo

GrowthCo spent £280k on customer acquisition last quarter across four channels, acquiring 1,100 new customers. The blended CAC was £255. But the channel-level picture is far more instructive:

Channel	Spend (£k)	New Customers	Channel CAC (£)
Paid Search	80	400	200
Paid Social	120	300	400
Influencer	60	150	400
Email / Organic	20	250	80
Total / Blended	280	1,100	255

The blended CAC of £255 looks reasonable. But Email/Organic is acquiring customers at £80 — one-fifth of what Paid Social and Influencer are costing. This kind of variation is almost always present in channel data, and it is almost always hidden by blended averages. The job of the ROI model is to make this visible.

---

CAC Payback Period

Knowing what it costs to acquire a customer is only useful when you know how long it takes to get that money back. The CAC payback period answers this directly:

CAC Payback (months) = CAC / Monthly Gross Profit per Customer

For GrowthCo: ARPU is £30/month and gross margin is 70%, so Monthly GP per customer is £21.

Applying this to the channel-level data:

Channel	CAC (£)	Monthly GP (£)	Payback (months)
Paid Search	200	21	9.5
Paid Social	400	21	19.0
Influencer	400	21	19.0
Email / Organic	80	21	3.8
Blended	255	21	12.1

The blended payback of 12.1 months sits comfortably within the 12–18 month benchmark that is standard for subscription and SaaS businesses. But Paid Social and Influencer are sitting at 19 months — borderline. A business that relies heavily on these channels must fund the entire customer acquisition book for nearly two years before recovering its spend. For a capital-constrained business, that is a real risk.

The payback period also directly informs cash flow planning. If GrowthCo acquires 1,100 customers per quarter and the blended payback is 12 months, it is always carrying approximately 4,400 customers (four quarters’ worth) whose acquisition cost has not yet been recovered. At £255 per customer, that is £1.1m of “unrecovered CAC” on the balance sheet at any given time — cash that has been spent but not yet returned.

---

Building the Channel ROI Model in Excel

The model has four tabs, each with a distinct purpose.

Assumptions contains the core inputs: ARPU, gross margin percentage, churn rate by cohort (or a simple average), and for each channel: quarterly spend and new customer count. These are the only cells you should ever need to edit.

Channel Analysis is where the calculations live. For each channel, compute:

CAC = Channel Spend / New Customers (channel)
Monthly GP per Customer = ARPU × Gross Margin %
Payback (months) = CAC / Monthly GP per Customer
LTV / CAC Ratio = LTV / CAC

The LTV/CAC ratio requires an LTV estimate. The simplest approach is to link to the LTV model (covered in the next post) or use the approximation:

LTV = Monthly GP per Customer / Monthly Churn Rate

For GrowthCo with 4% monthly churn: LTV = £21 / 0.04 = £525. Blended LTV/CAC = £525 / £255 = 2.1× — below the 3× benchmark, which signals that either CAC needs to come down or churn needs to improve.

Blended Summary aggregates channel-level data to total spend, total customers acquired, blended CAC, and blended payback. This is the executive-facing view.

Efficiency Dashboard is a simple two-chart visualisation: a bar chart of CAC by channel with a horizontal reference line at the payback threshold (£255 blended, or whatever the budget CAC target is), and a payback period bar chart with an 18-month reference line. These two charts convey the entire story of the quarter’s marketing efficiency at a glance.

Reference benchmarks to build into the model as clearly labelled cells in Assumptions:

• CAC Payback target: 18 months (mark as amber above 18, red above 24)
• LTV/CAC healthy threshold: 3× (mark as amber below 3, red below 2)

---

Applying ROI Analysis Beyond Marketing

The same logic applies to any business investment — not just marketing spend. The general ROI framework is:

ROI = (Incremental Benefit − Incremental Cost) / Incremental Cost

For a new sales hire: Incremental Benefit is the expected revenue they generate, discounted by gross margin, net of any costs they would not have incurred otherwise. If a senior salesperson costs £90k fully-loaded and is expected to generate £350k of new revenue at 70% gross margin (£245k gross profit), the year-one ROI is approximately 1.7× — and the payback period is roughly 4.4 months, which is excellent.

For technology investments, equipment purchases, or office expansion, the same structure applies. The key discipline is always to measure incremental benefit in terms of gross profit or contribution, not revenue, and to be explicit about what “incremental” means — what would have happened anyway, without this investment.

When the investment produces benefits over multiple years with significant upfront cost, a simple one-period ROI is insufficient and you should use NPV instead. A £200k investment that generates £60k per year of incremental contribution for five years has a positive simple ROI but a negative NPV at a 12% discount rate. For multi-year capital decisions, the ROI model is a starting point, not the final answer.

---

Key Takeaways

• Revenue ROI overstates marketing performance; gross profit ROI or contribution ROI is the correct basis for any meaningful analysis
• CAC should always be calculated at channel level — blended averages routinely disguise channels that are destroying value
• The CAC payback period translates efficiency into cash flow terms, which is what finance teams and investors actually care about
• Build the channel ROI model quarterly so you can reallocate budget to the most efficient channels before too much spend has been committed
• The LTV/CAC ratio is the long-run unit economics signal; the payback period is the short-run cash position signal — you need both

Practice

Build the GrowthCo channel ROI model using the data in this post. Then model a reallocation scenario: shift £40k of Paid Social budget to Email/Organic. Assume the Email/Organic channel scales proportionally (i.e. more spend generates more customers at the same £80 CAC). How does the blended CAC and blended payback period change? Write three bullet points making the case for or against the reallocation, as if you were presenting to the marketing director.