Pipeline Age Analysis

What Pipeline Age Analysis Reveals

Pipeline age analysis is defined as the evaluation of how long deals have been in the pipeline relative to historical benchmarks. Deals closing within 45 days achieve a 68% win rate. Beyond 90 days, win rates drop to 23% (Forecastio, 2024). Yet 20-35% of the average B2B pipeline sits beyond historical norms (Clari, 2024). This aged pipeline is not just unlikely to close. It actively harms forecasting by inflating pipeline coverage numbers and creating the illusion of more opportunity than actually exists.

How to Run Pipeline Age Analysis

Calculate the age of every open deal and compare it to the historical average for its segment.

Age Category	Definition	Historical Close Rate	Action
Healthy	Within historical average cycle time	25-35%	Normal pipeline management
Aging	1.0-1.5x historical average	15-20%	Investigate, apply intervention plan
Aged	1.5-2.0x historical average	8-12%	Downgrade forecast category, intensive review
Stale	2.0x+ historical average	Below 5%	Remove from active pipeline or set realistic timeline

The historical average should be calculated by segment, deal size, and source. An enterprise deal with a 120-day average cycle is not "aged" at day 100. An SMB deal with a 30-day average cycle is critically aged at day 60. One-size-fits-all age thresholds miss these differences.

The Impact of Aged Pipeline on Forecasting

Aged deals distort every metric that depends on pipeline data. Pipeline coverage looks healthy because the raw number includes deals that will never close. Weighted pipeline coverage is less distorted (if probabilities are calibrated) but still carries aged deals at higher probabilities than they deserve. Forecast accuracy suffers because reps include aged deals in best-case forecasts that repeatedly miss.

The fix is disciplined pipeline hygiene. Set age thresholds by segment. Automatically flag deals that exceed those thresholds. Require rep justification for keeping any deal in pipeline beyond 2x the historical cycle time. Deals without compelling justification get moved to a "nurture" or "future" category that is excluded from active pipeline coverage and forecast calculations.

Running a Pipeline Hygiene Review

Conduct a pipeline hygiene review monthly, separate from the weekly forecast review. The purpose is different. Weekly reviews focus on advancing deals. Monthly hygiene reviews focus on pipeline truthfulness. Pull every deal older than the historical average. For each deal, answer three questions: Is there a confirmed next step? Has there been buyer-initiated activity in the last 21 days? Has the close date been pushed more than twice?

Deals that fail all three questions should be removed from active pipeline. Deals that fail two should be downgraded. This exercise is uncomfortable because it shrinks the pipeline number. But a smaller, accurate pipeline is infinitely more useful for planning than a large, inflated one. Teams that run monthly hygiene reviews consistently report 10-15% better forecast accuracy because they are forecasting on real pipeline, not wish lists.

Age Analysis and Sales Coaching

Pipeline age patterns by rep reveal coaching opportunities. If one rep consistently has 40% of pipeline in the "aged" category while peers average 15%, that rep likely has a qualification or deal progression problem. The age data makes it specific. Instead of "your pipeline looks weak," the conversation is "you have 12 deals that have been in Stage 3 for more than 60 days. What is blocking them?" Time-in-stage analysis provides the deal-level detail for these coaching conversations, while pipeline age analysis provides the portfolio-level view.