You forecast marketing-sourced pipeline by modeling creation. Take the leads each channel will produce, apply the conversion rates that move those leads to opportunities, apply the deal size that channel typically produces, and spread the result across the weeks when those opportunities will actually appear. The spend-to-pipeline ratio most teams use skips all four steps and reports the answer as if it were the method.
Build it channel by channel
Each channel converts at its own rate and produces its own deal size, so a blended model averages away the information you need.
The figures below are illustrative, not benchmarks.
| Channel (illustrative) | Leads | Lead to opp | Opps | Avg deal | Pipeline |
|---|---|---|---|---|---|
| Paid search | 500 | 12% | 60 | $42,000 | $2,520,000 |
| Webinars | 300 | 15% | 45 | $38,000 | $1,710,000 |
| Content syndication | 1,000 | 3% | 30 | $30,000 | $900,000 |
Add the timing curve
Leads created in a month do not all become opportunities in that month. Measure the historical distribution: what share converts in week one, weeks two to four, and beyond. Apply that curve to each channel and the model produces a weekly creation schedule instead of a single quarterly total. This is the step that makes the number usable, because a plan calling for pipeline that all arrives in the final three weeks of a quarter is a plan that will not close in that quarter.
Discount for what actually closes
Created pipeline is not delivered revenue, and the gap is larger than most plans assume. Across ORM's customer base, 10% or more of pipeline is stale and has not been touched in 12 months, and of the pipeline carrying in-quarter close dates on the first day of a quarter, about 20% closes in that quarter. Apply that discipline to your own created-pipeline forecast by tracking what share of each channel's created opportunities convert within the period the plan assumes, then feed the survivors into the revenue forecast rather than the gross creation number.
Check it against coverage, then against reality
Compare projected creation against the pipeline coverage the sales plan requires, and the conversation shifts from whether marketing hit a spend target to whether the quarter has enough opportunity to work with. Validate the model each quarter by holding out the completed period and scoring projected creation against actual creation by channel. That backtest is what turns the model into something the sales leader will plan against, and it is the same discipline that moves forecast accuracy on new business.
Frequently Asked Questions
Why not forecast marketing pipeline from a spend-to-pipeline ratio?
Because the ratio is an outcome, not a mechanism. It bundles lead volume, conversion, deal size, and timing into one number that cannot tell you which of them moved. When the ratio slips, a team using it has no way to diagnose whether the cause was weaker traffic, a lower acceptance rate, or smaller deals.
How far ahead can marketing-sourced pipeline be forecast?
One full lead-to-opportunity cycle with reasonable confidence, and two with wider ranges. Most of the pipeline that will be created in the next 30 to 60 days comes from leads that already exist, which is why the near-term forecast is far more reliable than the one for a quarter that has not started.
Should the forecast be in opportunity count or dollars?
Build it in counts and convert to dollars at the end. Conversion rates apply to records, and average deal size varies by segment and channel. Forecasting dollars directly hides a mix shift, where a stable dollar total is produced by more small deals replacing fewer large ones.
How do you validate the model?
Hold out a completed quarter, run the model against it, and compare projected creation to what actually got created by channel. Do the comparison on the created-in-quarter pipeline, not on closed revenue, because closing depends on sales execution the marketing model does not control.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like how do you forecast marketing-sourced pipeline? into prescriptive action for your team.
Schedule a Demo