Marketing KPIs

These marketing KPIs tell a marketing lead and the finance team whether spend pays for itself, and how soon. ROI counts only the gross profit the spend added, and CAC payback runs in months on fully loaded cost. The platforms' own return is set beside total revenue, so any sale credited twice shows.

Last reviewed · Virgo Analytics

CAC payback curve, example

Blended CAC is paid back in month 4. Paid-only CAC takes until month 11.

Example data

CAC payback curve

January 2026 cohort

New customers
2,000
First ordered through a paid channel
800
Paid media
£52,000
Agency fees
£6,000
Team and tools on paid
£8,000
Other marketing not tied to paid
£6,000
Fully loaded marketing cost
£72,000

Blended CAC

£36.00

Blended: £72,000 ÷ 2,000 new customers = £36.00

Paid-only CAC

£82.50

Paid-only: £66,000 ÷ 800 paid customers = £82.50
CAC payback curve, example. Blended CAC is paid back in month 4. Paid-only CAC takes until month 11. Curve from £14.00 in month 1 to £94.50 in month 12. Blended CAC £36.00, Paid-only CAC £82.50.£0£25£50£75£10024681012Months since first order7 monthsMonth 1: £14.00Month 2: £21.50Month 3: £29.00Month 4: £36.50Month 5: £43.75Month 6: £51.00Month 7: £58.25Month 8: £65.50Month 9: £72.75Month 10: £80.00Month 11: £87.25Month 12: £94.50CAC payback curve, example. Blended CAC is paid back in month 4. Paid-only CAC takes until month 11. Curve from £14.00 in month 1 to £94.50 in month 12. Blended CAC £36.00, Paid-only CAC £82.50.£0£25£50£75£100123456789101112Months since first order7 monthsMonth 1: £14.00Month 2: £21.50Month 3: £29.00Month 4: £36.50Month 5: £43.75Month 6: £51.00Month 7: £58.25Month 8: £65.50Month 9: £72.75Month 10: £80.00Month 11: £87.25Month 12: £94.50Cumulative gross profit£94.50Paid-only CAC£82.50Blended CAC£36.00CAC payback curve, example. Blended CAC is paid back in month 4. Paid-only CAC takes until month 11. Curve from £14.00 in month 1 to £94.50 in month 12. Blended CAC £36.00, Paid-only CAC £82.50.£0£25£50£75£100123456789101112Months since first order7 monthsMonth 1: £14.00Month 2: £21.50Month 3: £29.00Month 4: £36.50Month 5: £43.75Month 6: £51.00Month 7: £58.25Month 8: £65.50Month 9: £72.75Month 10: £80.00Month 11: £87.25Month 12: £94.50Cumulative gross profit£94.50Paid-only CAC£82.50Blended CAC£36.00CAC payback curve, example. Blended CAC is paid back in month 4. Paid-only CAC takes until month 11. Curve from £14.00 in month 1 to £94.50 in month 12. Blended CAC £36.00, Paid-only CAC £82.50.£0£25£50£75£100123456789101112Months since first order7 monthsMonth 1: £14.00Month 2: £21.50Month 3: £29.00Month 4: £36.50Month 5: £43.75Month 6: £51.00Month 7: £58.25Month 8: £65.50Month 9: £72.75Month 10: £80.00Month 11: £87.25Month 12: £94.50Cumulative gross profit£94.50Paid-only CAC£82.50Blended CAC£36.00
Example data: an invented January cohort of 2,000 new customers, 800 of whom first ordered through a paid channel. The curve is cumulative gross profit per customer, averaged over the whole cohort, including those who never ordered again. Both CAC lines are read against the same curve. If paid customers earn less than the cohort average, paid-only payback comes later than month 11.
Show the numbers
CAC payback curve, January 2026 cohort, example data
MonthGross profit that month, per customerCumulative
1£14.00£14.00
2£7.50£21.50
3£7.50£29.00
4£7.50£36.50
5£7.25£43.75
6£7.25£51.00
7£7.25£58.25
8£7.25£65.50
9£7.25£72.75
10£7.25£80.00
11£7.25£87.25
12£7.25£94.50

Marketing KPIs and how to calculate them

The order system, the ad platforms, the ledger and the test log feed this table, and each row says which.

KPIFormulaA good readingThe common mistake
Return on spend
Marketing ROI on incremental gross profit(Incremental gross profit − marketing cost) ÷ marketing cost × 100. Above zero over the period the budget is set for, with the test's interval stated beside it Putting credited revenue where incremental gross profit belongs. A channel can show a strong return on revenue and lose money once product cost, and the orders that would have come anyway, are taken out.

How to read it

Incremental gross profit is incremental orders × gross profit per order, with the incremental orders taken from a holdout test or a marketing mix model.

Marketing efficiency ratioTotal revenue ÷ total marketing cost, for the whole business, in the period Steady or rising while spend grows, read beside the platforms' own figures Using it to judge a channel. It moves with price rises, the season and returning customers, so it speaks for the whole budget and for no single channel.
ROAS, as the platform reports itRevenue an ad platform credits to its own ads ÷ spend on that platform Used to compare campaigns inside one platform, and checked against a test before money moves between platforms Adding the platforms' credited revenue together. If the sum is more than total revenue, some sales are credited twice, so compare the sum with total revenue before quoting any one of them.
Acquisition cost and payback
Blended CAC(Paid media + agency and freelance fees + team and tools on paid + other marketing cost not tied to paid) ÷ all new customers, in the month Stable as spend grows, quoted with its cost list beside it Counting media spend alone. Fees, salaries and tools are part of what a customer costs, and leaving them out shortens payback on paper.
Paid-only CAC(Paid media + agency and freelance fees for paid + team and tools on paid) ÷ new customers whose first order came through a paid channel, in the month Read against paid-only payback for each paid channel Dividing paid cost by every new customer. Customers who arrived with no paid help then lower the cost of the paid ones.
CAC payback, monthsCAC ÷ gross profit per new customer per month. Shorter than the time the business can wait for its cash to come back, a limit the finance lead sets Building the curve on revenue, so product cost, delivery and returns never come off. The curve then crosses CAC too early.

How to read it

Where the first order carries most of the profit, read it as the first month in which cumulative gross profit per customer passes CAC. Run it on blended CAC, and again on paid-only CAC for a paid channel. This row is per customer, from a cohort's own gross profit. The SaaS analytics page works the same idea on new MRR for subscription products.

Organic share of new customersNew customers whose first order had no paid touch ÷ all new customers, in the month Read beside blended CAC. A rising organic share lowers blended CAC with no change in paid. Counting first orders with no tracked source as organic. Orders lost to consent declines or broken tags land there, and the share rises for reasons nobody chose.
Leads and testing
Cost per qualified leadMarketing cost ÷ leads that met the written qualification rule, in the month Falling or steady, with the rule unchanged across every period compared Changing the rule mid-quarter, or letting marketing and sales each keep their own. The cost then falls because the bar moved.
Share of spend testedSpend in channels with a holdout or lift result from a window the team sets, 12 months here ÷ total marketing spend × 100 Rising, with the biggest channels tested first Counting an inconclusive test as a pass. The channel's effect is still unknown, and the readout names the test that would settle it.

Example data, ROI: paid social cost £21,200 over a four-week geo holdout test and brought 212 incremental orders, the figures from the marketing measurement page's example. The £38 gross profit per order is this page's own example figure. That gives £8,056 of incremental gross profit, and ROI of (£8,056 − £21,200) ÷ £21,200, or −62.0%. Across the test's interval of 96 to 328 incremental orders, ROI runs from −82.8% to −41.2%.

Example data, efficiency ratio: £1,240,000 of revenue in a quarter on £155,000 of marketing cost gives a ratio of 8.0. If the platforms between them credit their ads with £1,410,000, they claim £170,000 more than the business took.

How to build a marketing dashboard

  • Data sources

    Daily spend by campaign from each ad platform, invoices for agency and freelance fees, marketing salaries and tools from the ledger, and the order system with customer ID, first order date and first-order source. Gross profit per order needs product cost, delivery and returns. Leads come from the CRM with their qualification status, and the test log holds each holdout result with its interval and date.

  • Grain

    One row per customer per month since first order, for the payback curve. Spend at one row per channel per day. Leads at one row per lead, with the date it qualified.

  • Refresh cadence

    Spend daily. Fees, salaries and tools monthly after close, so CAC and payback for the latest month carry a “provisional” label until then. ROI changes when a test reads out.

  • Who counts as new, and what counts as cost

    Write both down. A customer is new on their first order under one match rule, the one set out on the ecommerce analytics page for guest and account checkouts. The cost list names every line inside blended and paid-only CAC, so each means the same thing in March as in May.

  • Which incremental number feeds ROI

    For each channel, the latest holdout result while it is current, or the marketing mix model estimate where no test exists. The row names its source, and the team agrees how long a result stays in use before the channel is tested again. Credit inside a platform still ranks campaigns against each other, which is the job of attribution modelling.

First-order source depends on tracking that survives consent choices and the checkout. If it doesn't, the organic share goes wrong first, and the fix is in the tracking. If the organic share rises during a brand campaign, SEO analytics can show whether non-brand search grew with it or the campaign only sent people to search your name.

Questions it should answer, starting with marketing ROI

“Is paid social paying for itself?”ROI on incremental gross profit, from the latest holdout.
“How long before a new customer has paid us back?”CAC payback, blended and paid-only side by side.
“Are the platforms claiming more than we sold?”The platforms' credited revenue added up, against total revenue, beside the efficiency ratio.
“Did lead quality hold when cost per lead fell?”Cost per qualified lead, with the version of the rule shown.
“Which channel do we test next?”Share of spend tested, with untested channels sorted by spend.

Marketing metrics in each tool

  • Power BI

    In Power BI the payback curve is a cohort table: first-order month down the side, months since first order across, cumulative gross profit per customer in each cell. Keep CAC in its own table by cohort month. Both CAC lines are then measures over it, and the curve never mixes one month's customers with another's.

  • Data Studio (formerly Looker Studio)

    Data Studio connects directly to Google Ads, Google Analytics, BigQuery and Google Sheets, so platform spend and the platforms' own figures arrive with no export. Gross profit per order and the test log still come from a sheet or warehouse table someone keeps up to date.

  • Excel

    Excel suits the ROI review that goes to finance. With one tab per test holding the readout, the gross profit per order and the ROI sum, finance can check each line before any budget moves.

  • Google Sheets

    Spend from Meta Ads, Google Ads and Microsoft Advertising can arrive in the sheet on a schedule through Fresh Sheets, our Google Sheets add-on. That fills the paid media line for spend on those three platforms. Spend anywhere else, fees, salaries and gross profit come from finance and go into the same sheet.

Payback lands in month 4 or month 11 depending on which costs and customers go into CAC, so on your own spend and order data, through our dashboards and BI service, we write down the cost list and the new-customer rule first.

Questions about ROI and CAC payback

How long does a holdout result count for in ROI?

As long as your team agrees, with the period written beside the ROI row. In the example a holdout or lift result counts for 12 months. Once it ages out, ROI for that channel goes back to the marketing mix model estimate until the next test, and the row names its source.

How do you calculate marketing ROI?

Take the gross profit from orders that would not have happened without the spend, subtract the spend, and divide by the spend. The incremental orders come from a holdout test or a marketing mix model. Worked on credited revenue, the same sum tells you how much revenue a platform saw near its ads, which is a different question.

What is a good CAC payback period?

A good payback is one the business can afford to wait for. Payback is how long the cash spent winning a customer takes to come back as gross profit, so the limit comes from cash: how much the business holds and what else needs it. Set the limit with the finance lead, then judge each channel's paid-only payback against it.

What should a marketing dashboard show first?

Return and payback go at the top, because the budget decision rests on them. Spend, credited revenue and lead counts go underneath as inputs. Each figure names its source, whether the order system, an ad platform, a test readout or the ledger, so nobody mistakes a platform's own figure for the business's.

Why is blended CAC lower than paid CAC?

Because blended CAC divides all marketing cost by every new customer, including people who found you with no paid help. Paid-only CAC divides paid cost by the customers whose first order came through a paid channel. Blended falls whenever more people arrive on their own, so judge paid channels on the paid-only figure and test it with a holdout.

How long do your paid customers take to pay back?

One month's media spend and that month's first orders are enough to draw your payback curve with both CAC lines on it.

Book a call

Free 30 min call