Help center

Forecast pipeline and revenue from this month's ad spend

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

InputHow to get itWatch out for
Forecast spendSpend so far plus the run rate to month endCampaigns that will run out of budget early
Pipeline per $1Pipeline created by a campaign over the last 6 months / its spendCampaigns with very few opportunities: use the channel rate
Win rate by valueWon amount / (won + lost amount), last 12 monthsSmall samples per channel
Sales cycleMonths from opportunity created to closed wonLong 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.

StepCalculationResult
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 landsSpread along a typical 4-month cycleMostly in months 3 to 5
Pipeline velocity40 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

  1. Forecast spend first
    Project 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.
  2. Apply pipeline per dollar by campaign
    Use the last six complete months. When a campaign has too few opportunities, use its channel's rate.
  3. Add pipeline already created
    Count the open and won pipeline from deals created this period.
  4. Apply win rate and cycle
    Multiply by win rate by value and spread the result over the months your deals usually take to close.
  5. Show a range
    Use a low and high spend forecast to give a low and high pipeline figure, and say what would move it.

How to use it

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.