What a Pipeline Aging Report Shows
A pipeline aging report buckets open opportunities by how long they have been open, or how long they have sat in their current stage, and totals the value inside each bucket. It answers a question a coverage number cannot: where is pipeline accumulating without moving?Two versions exist and they are not interchangeable. Total age measures time since the opportunity was created. Stage age measures time since the deal last advanced. Stage age is the sharper diagnostic, because a long total age with recent stage movement describes a healthy complex deal, while a short total age with no stage movement describes a deal that stalled almost immediately.
How to build one
Start from open opportunities only. Closed records belong in cycle-time analysis, and mixing them flatters the report.
Segment before you bucket. Aging bands have to come from the segment's own cycle. ORM predicts a close curve for each opportunity group, running from 1 to 80 weeks with most of the closing expectation before week 12, which is why one set of bands cannot serve enterprise and SMB at the same time.
| Bucket | Read | Action |
|---|---|---|
| Inside the expected window | On schedule | Work it normally |
| Just past the expected window | Early risk | Confirm the next step with the buyer |
| Well past the window, under 52 weeks | Likely stuck | Re-qualify or downgrade the forecast category |
| Past 52 weeks or 12 months untouched | Not real pipeline | Close lost or move to nurture |
Reading the report
- A fat late bucket. Value piling up past the expected window means deals are not being resolved. Win or lose, each one needs an outcome, and the absence of outcomes is a management problem rather than a rep problem. - One stage that swells. If a single stage holds most of the aged value, the exit criteria for that stage are unclear or the buyer requirement behind it is unrealistic. Fix the stage definition before coaching the reps. - Aged value carrying current-quarter close dates. This is the dangerous combination. ORM customer data shows only 20% of pipeline holding an in-quarter close date on day one of the quarter closes inside that quarter. Aged value is the first place to look when reconciling that gap.
Common errors
Aging the whole pipeline on one clock. A single threshold across segments produces a report nobody trusts, because half the flags are wrong in an obvious way. Once reps learn to ignore the flag, the report stops changing behavior. Reading aging without velocity. Aging tells you deals are sitting. It does not tell you how fast the healthy ones move, which is the comparison that makes the number actionable. Pair it with sales velocity and with pipeline coverage so the report explains the quarter instead of decorating it.Frequently Asked Questions
What should a pipeline aging report include?
Open opportunities only, bucketed by age, with total value in each bucket rather than deal counts. Include a second view by stage age, meaning time since the deal last advanced, because that separates a healthy long enterprise cycle from a deal that stalled early.
What aging buckets should we use?
Derive them from your own cycle rather than from round numbers. ORM predicts a close curve per opportunity group, and those curves range from 1 to 80 weeks with most closing expectation before week 12. A single company-wide band set will mark healthy enterprise deals as aged while letting stalled SMB deals pass.
How often should a pipeline aging report be reviewed?
Weekly, alongside the standard pipeline review. Quarterly aging reports arrive after the damage is already priced into the forecast. Weekly cadence turns aging into a working signal instead of a postmortem.
What is the difference between a pipeline aging report and time in stage?
Time in stage measures a single stage for a single deal. An aging report aggregates across the whole open pipeline and attaches value to each age band, which is what makes it useful for executives deciding where to intervene.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like pipeline aging report into prescriptive action for your team.
Schedule a Demo