How to Forecast Pipeline Creation for Next Quarter

Most forecasting work is spent on deals that already exist. Reps grade them, managers challenge the grades, and a number comes out. The deals that will be created and closed inside the quarter get no equivalent treatment, even though they routinely carry a meaningful share of the number.

Forecasting creation is a separate model with separate inputs. It is also the part of the quarter you can still influence when the quarter starts.

What is pipeline creation forecasting?

A prediction of how much new qualified pipeline will be created by source and by week, and how much of it will convert inside the same period.

Two outputs, not one. Volume of creation is the easier prediction. In-quarter conversion of that creation is the harder and more valuable one, since it determines whether the new pipeline funds this quarter or the next.

The distinction matters because teams often hit a creation target and still miss revenue. The pipeline arrived. It arrived in week ten of a segment with a fourteen-week cycle.

Why does the forecast break when you only model existing pipeline?

A quarter has three revenue sources and only one of them is visible on day one.

Carry-over deals sit in the pipeline already with an expected in-quarter close. In-quarter deals are created, qualified, and closed inside the period without ever appearing in the opening number. Pull-forward deals come from later quarters, often with a discount attached and a gap left behind next period.

Teams over-trust the visible pipeline and under-model the invisible portion. They look closely at deals already in the CRM and do not adequately forecast how much revenue will be created and closed in-quarter. They also understate the cost of pulling future deals forward to protect the current number.

There is a hard limit on how far carry-over alone can take you. ORM's data shows that of the pipeline carrying an in-quarter close date on the first day of the quarter, roughly 20 percent closes in that quarter. If your model assumes the day-one pipeline is the quarter, it is modeling a fifth of the answer.

How do you build a creation baseline?

Take four to eight quarters of qualified opportunity creation, split by source and by month within the quarter, then normalize for capacity changes.

Build this table from your own history. The indices convert an average into a dated expectation, which is what makes weekly tracking possible.

Illustrative structure (replace every number with your own) Normalize for headcount before you trust the baseline. If SDR headcount rose 30 percent last quarter, the creation total rose with it while the per-rep rate may have fallen. Forecast per-rep creation multiplied by ramped capacity rather than forecasting the total directly.

Measure creation at the qualified stage. Creation counted at the top of the funnel moves with activity levels rather than with buying intent, and it will not predict revenue.

How do you adjust for seasonality?

Apply both the quarter-level and the month-within-quarter patterns, because they compound.

Q2 and Q4 typically run stronger than Q1 and Q3. Within any quarter, the third month runs stronger than the first and second. A Q4 month three carries both effects at once.

Most teams handle seasonality poorly or skip it entirely, then react to a weak month one as if it were a crisis. Apply the indices, and the same weak month one reads as on-plan. That is the difference between a forecast that generates a useful signal and one that generates fire drills.

Fiscal-year boundaries in your customer base matter as well. If many of your buyers close their books in December, December creation drops and January creation spikes for reasons unrelated to your team.

How do you convert created pipeline into in-quarter revenue?

Multiply creation by the share of each cohort that historically closes within the same quarter, by source.

The in-quarter close rate is source-specific and stage-specific. Expansion opportunities inside the installed base close inside the quarter far more often than new-logo outbound.

The close-timing data sets the boundaries. ORM groups opportunities with a machine learning model and predicts a close curve for each group. Curves run from 1 to 80 weeks. Most groups peak before week 12, and very few extend past week 52. Pipeline created in week nine of a quarter belongs to a group whose curve determines whether it can land in week 13 or not. In segments with longer curves, late-quarter creation is next quarter's revenue no matter how it is dated.

Compute the in-quarter conversion rate from cohorts rather than from open-pipeline snapshots. Group opportunities by creation week and source, then measure what share closed won inside the same fiscal quarter. That percentage is the multiplier.

What signals tell you creation is falling behind?

Weekly qualified dollars against the dated plan, plus the average value of what is being created.

Dollars alone hide two failure modes. A source hitting its dollar target with half the usual opportunity count is producing concentration risk. A source hitting its count with half the usual value is filling the funnel with deals too small to move the number.

Watch the value gap as well. A pipeline averaging $80,000 per opportunity against closed-won deals averaging $40,000 is inflated at entry, and creation reports built on those values overstate progress by roughly two times.

The earliest warning is quieter. Opportunities that get created and then show no change in stage, close date, or amount are not really in the funnel. ORM treats those three fields as the definition of meaningful activity, and creation that never generates one of them is administrative rather than commercial.

How does creation forecasting change the revenue forecast?

It converts the forecast from a snapshot of the visible pipeline into a description of how the quarter will happen.

A better forecast states what will close from existing pipeline, what has to be created and closed in-quarter, what might be pulled forward, and the risk attached to each path. That structure lets a leadership team act. A single number does not.

Timing is the whole point. Getting the forecast right in the last week of the quarter helps nobody, because the quarter has already happened by then. The value sits in knowing the likely shape on day one, early enough to change it. That is also the standard sales forecasting should be held to, and the reason how you build the forecast matters more than how often you revise it.

What accuracy should you expect?

Around 90 percent on new and expansion revenue is achievable with heavy manual effort, and it degrades as conditions change.

That version of accuracy is expensive to produce and static once produced. It is built by hand, and it stops reflecting the market the moment the market moves. ORM targets 95 percent without manual adjustments, holding from day 1 through day 90 of the quarter and updating as the quarter progresses.

The gap between those two approaches is responsiveness. Forecasts miss because something in the business or the market changed and the model is still running on old assumptions. Creation forecasting is where that shows up first, because creation reacts to market conditions weeks before closed-won does. Track forecast accuracy on creation separately from accuracy on closed revenue, and you will see the change coming.