How does ad ROAS grow over a long sales cycle?
Track how your ad spend matures over time. Enter your spend once, then update revenue as deals close. See why B2B campaigns that look like failures at 30 days are often winners at 180.
What is cohort ROAS?
In B2B, leads don't turn into revenue overnight. A campaign that launched in January might not close its first deal until April. If you check ROAS in February, the number is 0x and the campaign looks like it's failing.
Cohort reporting fixes this by grouping all leads by when the money was spent, then tracking what those leads produce over time. Instead of asking "what did ads do this month?" you ask "what did January's ad spend eventually turn into?"
The same $25,000 in spend can look like a total loss at 30 days, break-even at 90 days, and a 10x return at a year. The spend didn't change. The deals just needed time to close.
How to use this calculator
- Enter your ad spend for a specific period (a month, a quarter, whatever you're measuring).
- At each time checkpoint (30 days, 60 days, etc.), enter the total pipeline value and total closed revenue from leads that spend generated.
- The calculator shows your ROAS at each checkpoint so you can see the return building over time.
- Come back and update the numbers as more deals close. The whole point is watching the same cohort mature.
We've pre-filled example data so you can see how it works. Replace the numbers with your own.
Pick regular intervals to check in on this cohort. We've set common B2B checkpoints below but you can rename them to whatever makes sense for your sales cycle.
Pipeline = total value of open deals from these leads. Closed Revenue = actual revenue from deals that have signed. ROAS = closed revenue divided by your ad spend above.
| CHECKPOINT | PIPELINE ($) | CLOSED REVENUE ($) | ROAS | |
|---|---|---|---|---|
| — | ||||
| — | ||||
| — | ||||
| — | ||||
| — |
This chart shows the same ad spend producing more return as deals close over time. If the bars are growing to the right, your cohort is maturing. This is the visual you show leadership when they ask why a campaign that "isn't working" needs more time.
When to make budget decisions
Don't cut a campaign based on ROAS until you've waited at least 1.5x your average sales cycle. If deals typically take 90 days to close, wait at least 135 days before judging whether the spend was worth it.
Before that point, use pipeline as your early signal. If spend is generating pipeline, the revenue will follow. If it's not generating pipeline after 60 days, that's a real problem worth investigating.
Related tools
Use the ROAS Calculator for a quick ratio check, or the Weighted Pipeline ROAS Calculator to project return before your sales cycle completes. For the full framework, see our guide to calculating B2B ROAS.