To forecast revenue from this month's ad spend, multiply the spend still to come by each campaign's historical pipeline per dollar, add the pipeline already created, then apply your win rate by value and your usual sales cycle to see when it should close. Pipeline velocity, opportunities times deal size times win rate divided by cycle length, tells you how much revenue paid media moves through the funnel each day.
The four inputs
| Input | How to get it | Watch out for |
|---|---|---|
| Forecast spend | Spend so far plus the run rate to month end | Campaigns that will run out of budget early |
| Pipeline per $1 | Pipeline created by a campaign over the last 6 months / its spend | Campaigns with very few opportunities: use the channel rate |
| Win rate by value | Won amount / (won + lost amount), last 12 months | Small samples per channel |
| Sales cycle | Months from opportunity created to closed won | Long tails: a few deals take far longer |
Pipeline velocity
Pipeline velocity = (opportunities x average deal size x win rate) / sales cycle in days. It is a quick health check: if paid media creates more opportunities, bigger deals, better win rates or a shorter cycle, velocity rises.
A worked example
On day 18 of a 30-day month, a program has spent $30,000 of a $50,000 budget and is on pace. It has already created $400,000 of pipeline this month.
| Step | Calculation | Result |
|---|---|---|
| Spend still to come | $50,000 - $30,000 | $20,000 |
| Pipeline from that spend | $20,000 x 12 pipeline per $1 | $240,000 |
| Forecast pipeline for the month | $400,000 + $240,000 | $640,000 |
| Expected won revenue | $640,000 x 25% win rate by value | $160,000 |
| When it lands | Spread along a typical 4-month cycle | Mostly in months 3 to 5 |
| Pipeline velocity | 40 opportunities x $30,000 x 25% / 120 days | $2,500 a day |
All dollar figures in the examples are illustrative. They are not results from any account.
The forecast is only as good as its history. Use a range rather than one number, and treat expected revenue as an expectation, not a commitment.
How to build the forecast
- Forecast spend firstProject each campaign's spend to month end from its run rate. A pipeline forecast built on spend that will not happen is wrong from the start.
- Apply pipeline per dollar by campaignUse the last six complete months. When a campaign has too few opportunities, use its channel's rate.
- Add pipeline already createdCount the open and won pipeline from deals created this period.
- Apply win rate and cycleMultiply by win rate by value and spread the result over the months your deals usually take to close.
- Show a rangeUse a low and high spend forecast to give a low and high pipeline figure, and say what would move it.
How to use it
- Before the quarter: work backwards from a pipeline target to the budget it needs at today's efficiency.
- During the month: if pace slips, show the pipeline the unspent budget would have created.
- With finance: connect this month's spend to the revenue it should bring in later quarters.
What Pacing Console shows
The Forecast page projects spend and conversions to month or quarter end with a P10 to P90 range on Pro. On Enterprise it adds a pipeline forecast (pipeline created plus forecast spend times each campaign's pipeline per dollar over the last 6 complete months), win rate and sales cycle from your own paid deals, expected won revenue by month for the next 6 months, projected ROAS and CAC, what-if scenarios by channel and the budget needed to hit a pipeline or revenue target. Every section explains how it is calculated. See Forecast or open the live demo.
Plans: CRM lifecycle stages (contacts, MQLs, SQLs and opportunities by campaign, with cost per stage) are on Pro, USD 49 per workspace per month. The Pipeline and Revenue pages, revenue forecasts, what-if scenarios and budget targets need Enterprise. See Plans, pricing and billing.
Questions people ask
What is pipeline velocity?
The value moving through the pipeline per day: opportunities times average deal size times win rate, divided by the sales cycle in days.
How accurate is a revenue forecast from ad spend?
It depends on how stable your pipeline per dollar, win rate and cycle have been. Use a range, compare it with actuals each month and adjust.
Why use win rate by value instead of by count?
Revenue depends on which deals close. If small deals close more often than large ones, a count-based win rate overstates revenue.
Can I work out the budget needed for a pipeline target?
Yes. Divide the target by pipeline per dollar for a first estimate, then allow for returns that fall as spend grows. Pacing Console Enterprise does this with diminishing returns built in.
How far ahead can I forecast revenue from spend?
About one sales cycle. Beyond that, most revenue comes from spend that has not happened yet, so the forecast becomes a plan.
Related articles
Last updated 2026-11-22. Platform and CRM rules change, so check their own help for the current details.