Pipeline aging rate is a leading indicator, not a lagging one
Pipeline aging rate measures how quickly your open pipeline is accumulating days relative to the rate at which it is being resolved, giving you an early warning of close date drift before reps update their CRM fields. Most slippage becomes visible in official close date data only after it has already happened. Aging rate catches the trend while there is still time to act.A high aging rate does not mean every deal is bad. It means deals are staying in the pipeline longer on average than your historical baseline would predict. The signal is most useful compared to the same period last quarter, the same stage breakdown, or the segment where the change is concentrated.
Computing the rate
The core calculation compares average deal age at two points:
| Metric | Formula |
|---|---|
| Average deal age (point A) | Sum of days since creation for all open deals / count of open deals |
| Average deal age (point B) | Same calculation at a later date |
| Aging rate | (Point B age - Point A age) / days between measurements |
What an accelerating aging rate reveals
The aging rate accelerates for several reasons. Demand generation may have slowed, meaning fewer new, younger deals are entering the top of the funnel to pull down the average age. Existing deals may be stalling at a specific stage, usually a stage where buying committee sign-off is required or where technical evaluation drags. Or reps may be carrying deals they know are unlikely to close but have not yet disqualified.
Each cause has a different remediation. Reviewing aging rate alongside pipeline age analysis by stage helps separate a top-of-funnel volume problem from a mid-funnel progression problem.
Using aging rate in weekly reviews
The aging rate is most useful reviewed weekly or bi-weekly as a trend metric, not as a one-time snapshot. A team that tracks it consistently develops a baseline for what normal looks like during healthy quarters. Deviations from that baseline become actionable conversation starters, not vague concerns about pipeline health.
Pairing aging rate with deal age bucket data adds specificity: you can see not only that the pipeline is aging faster, but which cohort of deals is driving the acceleration.
Frequently Asked Questions
What is pipeline aging rate and how does it differ from average deal age?
Average deal age is a point-in-time snapshot of how old your open pipeline is. Aging rate is directional: it tracks whether that average is rising or falling over time. A rising aging rate means deals are accumulating days faster than they are closing, which is an early indicator of a pipeline health problem.
How do you measure pipeline aging rate in practice?
Compare your pipeline's average deal age at two points in time. If the average age of open opportunities was 35 days at the start of the month and is 48 days at the end of the month, the pipeline is aging faster than deals are moving through or closing. The rate can also be computed for specific stages or segments.
When does a high aging rate become a forecasting problem?
When the aging rate is outpacing your historical close rate by stage, it means deals are sitting longer without progressing. Reps tend to maintain optimistic close dates even as deals age, so an elevated aging rate is often the first signal of slippage that won't appear in official close date data for weeks.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like pipeline aging rate into prescriptive action for your team.
Schedule a Demo