The ROAS Formula Explained With Real Numbers

In shortThe ROAS formula is closed revenue divided by ad spend. Pull the revenue from your actual pipeline and closed deals, never from declared conversions.

The closer who treats the roas formula as ad-spend divided by platform-reported revenue is flying blind. The number that actually decides whether the campaign stays or dies is the cash that lands in the bank from deals that closed.

What is the ROAS formula?

ROAS equals revenue attributed to the campaign divided by the amount spent on that campaign.
Revenue must be the final invoice value of deals that moved from lead to signed contract. Spend is the actual media cost recorded for the same period.
Anything else inserted in the numerator turns the result into marketing fiction.

The formula itself stays simple because the complexity lives in the data sources, not the arithmetic. Once the revenue figure is locked to closed deals, the division produces a single number the closer can act on.

How the ROAS formula works with real numbers

Take a campaign that spent 4,800 on Meta in a given month. The leads entered the pipeline through UTM-tagged links. After follow-ups, calls, and pipeline movement, four deals closed for 3,200, 5,100, 2,800 and 7,400.

Total closed revenue attributed to that spend: 18,500.
ROAS calculation: 18,500 divided by 4,800 equals 3.85.

That 3.85 is the figure that decides budget allocation. If the same campaign shows 92 conversions inside the ad account but only four of them closed, the platform number is irrelevant. The closer keeps the campaign alive or kills it based on the 3.85.

Run the same process every month. When the ratio drops below the minimum required to cover cost of sale and target margin, pause or reallocate before the next spend cycle.

Where the revenue figure must come from

Revenue belongs in the formula only when it is the signed amount recorded after the contract is executed. That means pulling the number from the pipeline stage that marks a deal as won, not from any earlier step.

The source must also carry the original campaign identifier. Without the link between ad click and final invoice, attribution collapses into guesswork. A CRM built for closers stores the UTM or ad ID at lead creation and keeps it attached through every stage until the deal is marked closed-won.

When that connection exists, the monthly ROAS report becomes a direct export of closed revenue per campaign. No manual spreadsheet, no lost deals, no double-counted leads.

The trap of declared conversions

Ad platforms count a conversion the moment a form is submitted, a call is booked, or a pixel fires. None of those events guarantee cash.

When the numerator uses those counts instead of closed revenue, two distortions appear. First, campaigns that generate many low-quality leads look profitable. Second, campaigns that produce fewer but higher-value deals look weak. Both errors lead to budget decisions that starve the channels actually paying the bills.

The only fix is to stop importing platform conversion counts into the ROAS formula. Replace them entirely with the closed amounts that sit inside the sales pipeline.

How to keep the formula clean inside your workflow

Every new lead carries the campaign tag from the first touch.
Every call outcome and follow-up step updates the same record.
When the deal reaches closed-won, the revenue amount inherits the original tag automatically.

At month end the closer exports one table: campaign, spend, closed revenue. The division happens once. No reconciliation between separate tools, no lost attribution.

This workflow replaces the Excel export that most teams still run. The pipeline itself becomes the single source for the revenue side of the formula.

What changes when you switch to closed-revenue ROAS

Budget meetings stop revolving around vanity metrics.
The closer sees exactly which campaigns produce signed contracts and which ones only produce activity.
Reallocation decisions happen on the actual cash return instead of projected conversion value.

Teams that make this switch usually cut spend on two or three campaigns within the first 60 days and move that budget to the channels already clearing 4x or higher on closed revenue.

Key takeaways

• Use only closed-won revenue in the numerator of the roas formula.
• Keep the original campaign tag attached from lead creation through signature.
• Ignore every conversion count supplied by the ad platform.
• Export the final number directly from the pipeline, not from a separate spreadsheet.
• Reallocate budget monthly based on the closed-revenue ratio, not on lead volume.

If your current setup still mixes declared conversions with closed revenue, the next step is to connect the ad source to the actual pipeline stages so the formula finally reflects cash in the bank. Try Fennec to pull that revenue automatically. The approach above reflects the end-to-end tracking built by Sébastien De Bollivier.