Campaign ROI Calculator: Judge Campaigns on Margin, Not Lead Volume

Campaign ROI is a simple division sitting on top of a hard data problem. The arithmetic takes a second. Getting the numerator and denominator to describe the same campaign, in the same period, with all the costs and none of the borrowed revenue, is the actual work.

How it is done today

Most reporting stops at the ad platform. The dashboard shows spend, clicks, leads and a cost per lead, and that becomes the campaign report. It is accurate about the top of the funnel and silent about everything that determines whether the money was well spent.

The second common version is a monthly spreadsheet where someone types platform numbers into one tab and revenue from accounts into another. The two are joined by month rather than by campaign, so a strong month covers for a weak campaign and nobody can tell which is which.

Campaign record

• Campaign name, channel and date range.
• Media spend, taken from the platform.
• Creative and production cost, including shoots and design time.
• Tooling and landing page cost attributable to the campaign.
• Management or agency fee for running it.
• Total campaign cost — the sum, and the denominator.
• Attribution model stated — first touch, last touch or otherwise.

Lead and deal record

• Source, campaign and creative, stamped at capture and never overwritten.
• Created date and qualified date.
• Stage and current status, including lost with a reason.
• Deal value and gross margin percentage.
• Closed date, giving cycle length when compared with created date.
• Duplicate flag, so one person arriving twice counts once.

An illustrative example using indexed figures, not benchmark data. All three campaigns spent the same total of 100 units including production and fees, and all are read after the lag window has closed.

Campaign A wins on the metric most dashboards lead with and loses money once margin is applied. It produced five times the leads of Campaign C and fewer than half the deals. Read only to row three, A is the obvious choice to scale. Read to the bottom, it is the campaign to stop. This pattern is common enough that cost per lead should never appear on a report without cost per acquisition beside it.

Source survives the whole journey

A lead captured from a form, a WhatsApp message or a call arrives with its campaign attached, and that field is still there when the deal is marked won six weeks later.

Qualification becomes a stage, not an opinion

Once qualified is a pipeline stage with a definition, cost per qualified lead is computed rather than argued about, and campaigns can be compared on it.

The report is a query

Because costs sit on the campaign and outcomes sit on the deals, the monthly report stops being an assembly job. The useful discussion moves to what to do about Campaign A rather than to whether the numbers agree.

Counting only media spend

Production and management fees are real money and they change the ranking.

Using revenue instead of margin

Revenue rewards discounting. Margin is what funds the next campaign.

Reading results inside the lag window

Judging a considered purchase after two weeks measures impatience, not performance.

Letting source be overwritten

If a later touch replaces the original source field, every campaign report becomes a retelling of whichever channel spoke last.

Continue with lead management software, AI CRM and lead scoring, sales automation, WhatsApp CRM, the tools library, and pricing.