What the comparison reveals
Created vs. closed pipeline answers whether you are building the funnel or running it down. If created pipeline consistently exceeds closed pipeline, the total available opportunity pool grows. If the reverse is true, each period starts with less to work from than the last.This matters most across multi-quarter planning horizons. Teams focused only on the current quarter's performance can miss a slow erosion of future-period pipeline that will only surface as a coverage problem later. The created vs. closed comparison makes that trend visible in the present.
Reading the balance: three scenarios
| Scenario | Created vs. Closed | What it means |
|---|---|---|
| Growing | Created > Closed | Future quarters have more coverage; capacity may need to scale |
| Flat | Created = Closed | Pipeline is being replenished exactly; watch for quality drift |
| Shrinking | Created < Closed | Future coverage is deteriorating; generation must accelerate |
Breaking down the closed figure
Closed pipeline has two very different components. Closed-won deals represent revenue realized. Closed-lost deals represent pipeline consumed without return. A period where closed pipeline is dominated by losses, even if the creation figure looks healthy, signals a quality or competitive problem that the aggregate comparison will not surface on its own.
Segment the closed figure by: win rate by source, loss reasons by stage, and average deal size won versus lost. Those cuts tell you whether the pipeline being created is worth creating.
Connecting to coverage and generation planning
The created vs. closed comparison is a direct input to pipeline coverage analysis and pipeline generation planning. Coverage ratios tell you how much pipeline exists relative to quota. The created vs. closed trend tells you whether that ratio is improving or deteriorating over time.
For planning purposes, net new ARR targets should flow upstream into pipeline creation targets: if you know what you need to close and what your conversion rate is, you can calculate the minimum creation volume required each period to sustain coverage.
Frequently Asked Questions
What does created vs. closed pipeline measure?
It compares the total value of new opportunities opened in a period to the total value of deals that exited the pipeline in the same period, either by closing won, closing lost, or being removed. The difference tells you whether pipeline is accumulating or depleting.
Why does this comparison matter for revenue planning?
If a team is closing more pipeline than it creates, the pipeline balance shrinks. This may look fine in the current quarter but it guarantees a coverage problem in future quarters. Teams that track this ratio can catch a negative trend months before it becomes a forecast miss.
Should closed-lost deals be included in the closed figure?
Yes. Both closed-won and closed-lost deals consume pipeline. Including only closed-won understates consumption and overstates the health of the funnel. The comparison is most useful when you break down the closed figure by reason so you can see what proportion of consumed pipeline was won versus lost.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like created vs. closed pipeline into prescriptive action for your team.
Schedule a Demo