What is a stage aging report — and how do you use it to clean pipeline?

Direct Answer

A stage aging report shows how long each open opportunity has been sitting in its current pipeline stage, measured against a benchmark — usually the median time other deals spend in that same stage. It surfaces what is stuck without forcing managers to read every AE's notes. For mid-market B2B SaaS the typical medians are 7-14 days in qualified, 10-21 days in discovery, 14-30 days in demo, 14-30 days in proposal, and 7-21 days in verbal.

Anything past 2.5x the stage median is a stuck-deal red flag; past 4x with zero buyer activity is almost always dead.

TL;DR

• Stage aging measures days-in-current-stage, not days-since-opportunity-created — those are completely different signals.
• Mid-market B2B SaaS benchmarks (Gong Labs 2024): 7-14 / 10-21 / 14-30 / 14-30 / 7-21 days across the five stages.
• 2.5x stage median equals stuck; 4x median plus no buyer activity equals dead — pull from forecast.
• Stage-2 aging creeping up by 30 percent QoQ means top-of-funnel quality is dropping; stage-4 aging creeping up means pricing, legal, or procurement is the friction.
• The report only works if you triage it weekly with named owners and actions — otherwise it becomes dashboard wallpaper.

Median Aging Benchmarks by Stage

The benchmarks below are mid-market B2B SaaS medians from Gong Labs' 2024 Pipeline Velocity study, cross-referenced with Clari's Pipeline Inspection aggregate data and ICONIQ's 2024 Operating Metrics. They are starting points — every business should recalibrate against its own closed-won history after one full quarter of data.

Two cohort effects matter when reading these numbers. First, deal size shifts the medians up — $100K-plus ACV opportunities run roughly 1.5x to 2x the medians above because procurement and InfoSec add real cycle time. Second, repeat buyers and warm referrals run 30-40 percent faster in discovery and demo, so segment your benchmarks before triaging or you will harass good AEs running fast deals.

The 4 Diagnostic Patterns

Pattern 1: Opp at 2.5x stage median equals stuck. A deal sitting at stage 3 for 75 days against a 30-day median is not "still working" — it is stuck. The buyer has either de-prioritized the project, lost the internal champion, or is shopping you against an incumbent renewal. Action: schedule a multi-threaded call within seven days or pull from forecast.

Pattern 2: Opp at 4x stage median plus zero buyer activity equals dead. When a deal is 4x the median AND there has been no inbound email, no meeting accepted, and no asset opened in 21 days, it is almost certainly closed-lost no-decision. Gong's 2024 data shows under 4 percent of deals matching this pattern ever close.

Move them to closed-lost and reclaim AE capacity.

Pattern 3: Stage 2 average aging up 30 percent QoQ equals top-of-funnel quality dropping. If discovery aging quietly drifts from 15 days to 20 days quarter over quarter, marketing-sourced lead quality has slipped or SDRs are pushing through unqualified meetings to hit activity targets.

Worked example: a $30M ARR Series C SaaS company analyzed stage aging and found median stage-2-to-3 days had crept from 14 days to 27 days over four quarters. Root cause was AEs over-promising discovery quality early — demos showed buyers were not ready. They tightened discovery qualification (mandatory pain, budget signal, and timeline before stage advance), stage 2-to-3 returned to 16 days, and stage-3-to-4 win rate rose 9 percentage points.

Pattern 4: Stage 4 aging up 30 percent equals pricing, legal, or procurement friction. When proposal-stage aging balloons but earlier stages look healthy, the deal is dying in paperwork. The usual suspects are list-price increases that have not been pre-socialized, MSA redlines stuck with legal, or InfoSec questionnaires sitting with a single overloaded security engineer.

Fix: build a standing Friday legal-and-procurement standup with a named owner per deal.

The 3 Report Failure Modes That Make It Wallpaper

Failure 1: Measuring days-open instead of days-in-current-stage. A 90-day-open opportunity that just advanced from demo to proposal yesterday is healthy. A 30-day-open opportunity that has been stuck at stage 2 for 28 of those days is concerning. Days-open averages every stage together and washes out the signal.

The correct field is the delta between today and the most recent OpportunityFieldHistory change of the StageName field — Salesforce Pipeline Inspection and Clari Pipeline Flow compute this natively. If your team is reading days-open, your report is lying to you.

Failure 2: No per-stage benchmark. A 25-day stage-3 deal sounds long until you see the median is 22 days — it is normal. A 25-day stage-1 deal sounds short until you see the median is 9 days — it is stuck. Without a stage-specific benchmark column on every row, managers cannot distinguish normal from stuck, and AEs argue every flag in deal reviews.

Put the stage median and the 2.5x threshold on the report itself, not in a wiki.

Failure 3: Report not triaged weekly. The report is a tool, not an artifact. If no one pulls the over-benchmark list every Monday, assigns owners by Tuesday, runs AE actions by Wednesday, and reviews exceptions at the Thursday forecast call, the dashboard becomes wallpaper. Sales teams that triage stage aging weekly run 18-22 percent shorter average cycle time than teams that look at it ad hoc (Pavilion 2024 RevOps Benchmark).

Tooling matters less than discipline. Salesforce Pipeline Inspection is free, native, and the default for most teams. Clari Pipeline Flow adds buyer-activity overlays.

Sigma or Looker dashboards directly on the OpportunityFieldHistory table give the most flexibility for custom benchmarks and cohort cuts. Pick one, instrument the stage-median column, and run the weekly triage shown below.

Frequently Asked Questions

Days-open vs days-in-stage — which one matters? Days-in-current-stage. Days-open averages all stages and hides where the deal is actually stuck. A deal can be 120 days open and perfectly healthy if it just advanced.

How do you treat re-opened opps? Reset the stage clock on re-open and flag them as a separate cohort. Re-opened deals run 40-60 percent longer than fresh deals (Clari 2024) and will skew your medians if you blend them.

What is the right benchmark — enterprise vs SMB? Roughly double the medians for enterprise ($100K+ ACV) and halve them for transactional SMB (under $15K ACV). Always recalibrate against your own closed-won cohort after a full quarter — published benchmarks are starting points, not gospel.

Sources

• Gong Labs. *2024 Pipeline Velocity and Stage Aging Study* — median stage durations across 5,000+ B2B SaaS opportunities.
• Clari. *Pipeline Inspection Benchmarks 2024* — buyer-activity overlays and re-opened deal cohort data.
• Salesforce. *Pipeline Inspection Documentation* — OpportunityFieldHistory field tracking and stage-duration calculation.
• Pavilion. *2024 RevOps Benchmark Report* — weekly triage cadence impact on cycle time (18-22 percent reduction).
• Force Management. *Command of the Message — Stage Qualification Criteria* — discovery-quality framework referenced in worked example.
• ICONIQ Growth. *2024 Operating Metrics for Cloud Companies* — ACV-tier impact on stage duration (1.5x to 2x for enterprise).
• SaaStr. *Jason Lemkin on Stuck Deals and No-Decision Loss* — the 4x median plus no-activity equals dead heuristic.
• RevOps Co-op. *Stage Aging Triage Playbooks 2024* — Mon-through-Fri workflow patterns from member RevOps teams.