How to measure real marketing ROI without a data team

Most small teams measure marketing the way the ad platforms want them to: clicks, impressions, cost-per-lead, a dashboard full of green arrows. It feels like progress. But none of it answers the only question your CEO actually cares about — did the money we spent come back as revenue, and then some?

The good news: you do not need a data team or expensive software to answer that. You need three numbers you already have and about an hour a month. This guide walks you through the honest version of marketing ROI — one that ties spend to real money, not vanity metrics.

Why most ROI numbers are wrong

When your Google or Meta dashboard tells you a campaign drove "£40,000 in conversions," it is reporting what it can see — and what it can see stops at the form-fill. The platform counts a lead the moment someone submits their email. It has no idea whether that lead bought anything or was a tyre-kicker who ghosted your sales rep.

Two problems flow from this:

• Platform numbers are inflated. Every platform claims credit for conversions, often the same one. Add up what Google, Meta and LinkedIn each say they drove and the total can exceed your actual sales. They are optimistic by design.
• Your data is siloed. Ad spend lives in the ad platforms. Real revenue lives in your CRM. Nobody connects the two, so "ROI" gets measured on the half of the picture that looks best.

The result is a number that rewards cheap leads instead of profitable customers. We dug into how this plays out in why your ROAS is lying — the short version is that the metric on your screen and the money in your account are rarely the same thing.

The one equation that matters

Strip away the dashboards and real marketing ROI is one simple ratio:

Notice what is not here: clicks, leads, cost-per-click, impressions. Those are inputs you manage day to day, not the result. The only revenue that counts is money you actually won — what your CRM calls "closed-won" — not the value the platform guessed at.

The data you actually need

You can run this with three numbers, all of which you can pull yourself.

• Spend. Total amount you paid the ad platforms in the month. This is the easiest one — it is on every invoice.
• Leads. How many leads or enquiries that spend produced. You will use this to sanity-check quality, not to claim revenue.
• Closed-won revenue from your CRM. The deals that actually closed and were traced back to marketing. This is the number that turns activity into money.

That third number is where the honesty lives. If your CRM tags where each lead came from — even a rough "source" field — you can tie revenue back to the channel that produced it. No tracking pixel can do this; only your CRM knows who paid.

A simple monthly method any marketer can run

Here is a method you can run in a spreadsheet on the first Monday of every month — no engineers required.

• Step 1 — Pull spend. One row per channel: Google, Meta, LinkedIn, and so on.
• Step 2 — Pull closed-won revenue by source. Filter your CRM to deals that closed this period and group by lead source.
• Step 3 — Line them up. Put spend and revenue side by side for each channel.
• Step 4 — Apply the equation. Subtract, divide, done.

A worked example with round numbers:

• Google: spent £10,000, closed £40,000 → ROI = (£40,000 − £10,000) ÷ £10,000 = 3.0
• Meta: spent £10,000, closed £18,000 → ROI = (£18,000 − £10,000) ÷ £10,000 = 0.8
• LinkedIn: spent £5,000, closed £20,000 → ROI = (£20,000 − £5,000) ÷ £5,000 = 3.0

Look what that reveals. Meta might have shown the lowest cost-per-lead all month — cheap form-fills galore. But on real revenue it is barely breaking even, while LinkedIn quietly returned 3x. Judge on platform metrics and you would shift budget the wrong way. This is the journey we map in from click to revenue.

Connecting CRM revenue back so the platforms learn

Measuring ROI honestly is step one. The bigger win is using that revenue data to make your future spend smarter. The ad platforms optimise for whatever you feed them. Feed them form-fills, and they will hunt for the cheapest form-fills — which, as we just saw, can mean your worst customers.

Feed the real € value of each closed deal back to Google and Meta instead, and the algorithms start chasing revenue. They learn what a good lead looks like and go find more of them. This is the core idea behind value-based bidding — telling the platforms what each lead was actually worth so they optimise for profit, not volume. Doing it by hand is fiddly, which is the gap PipeValue fills — but even uploading offline conversion values once a month puts you ahead of most competitors.

Pitfalls to watch for

A few traps that trip up small teams.

• Attribution windows. If your sales cycle is 60 days, this month's spend will not show its revenue for two months. Compare spend and revenue over a window that matches how long buyers take to decide, or you will declare campaigns dead before they pay off.
• Blended vs last-click. Last-click hands 100% of the credit to the final ad someone touched, over-crediting bottom-of-funnel channels. Blended — total marketing revenue divided by total spend — is cruder but harder to fool yourself with. Start blended, then refine.
• Double-counting. If two platforms both claim the same sale, you overstate revenue. Your CRM, with one source per deal, is the tie-breaker.

FAQ

Do I need analytics software to measure marketing ROI?

No. If you know your monthly ad spend and track closed-won revenue in your CRM, you can calculate ROI in a spreadsheet in under an hour. Tools help you do it faster, but they are not required for an honest number.

Why is the ROI in my ad platform higher than my real ROI?

Ad platforms count conversions they can see — clicks, form-fills, leads — and claim credit generously. They cannot see which leads became paying customers. Your CRM can. That gap is why platform-reported ROI is almost always inflated.

Should I use last-click or blended attribution?

For a simple monthly view, start blended: total revenue you attribute to paid marketing divided by total spend. Use channel-level numbers to compare campaigns, but treat them as directional rather than exact.

How long should I wait before judging a campaign's ROI?

Match your measurement window to your sales cycle. If deals take 60 days to close, this month's spend will not show its full revenue for two months. Judge campaigns on a rolling window that fits how long buyers take to decide.