Stage dwell time

Average, median and 90th-percentile time a lead spent in each stage before moving on, with the sample size behind every bar.

What it is

A horizontal bar chart in canonical stage order with two bars per stage — average and median hours. The tooltip adds the 90th percentile and the count of leads that actually left that stage, so a stage measured on three deals reads differently from one measured on forty.

Also called: how long deals sit in each stage · stage time · average days in stage · where deals go cold

See it
Stage dwell time
Won
31%
Avg cycle
17d
Pipeline
$667k
JanSep
'Stage Dwell Time (avg / median hrs)' — a vertical list of stages with paired teal/blue bars, hovering shows avg, median, 90th pct and 'Based on 45 leads'. StageDurationsSection in AnalyticsView.tsx. Sample data — no customer information appears here.
How it works
  1. 1Every stage_move row carries duration_seconds for the stage it left; the route groups those by from-stage.
  2. 2Average, median (linear-interpolated midpoint) and p90 (nearest-rank, clamped) are computed per stage.
  3. 3Stages are sorted by the canonical journey order, unknown stages last.
  4. 4Only stages with at least one observed dwell are drawn, and the chart is never capped — every stage with data shows.
Why we built it

P90 exists because averages hide the disasters: the tooltip footer spells out 'Based on N leads that left this stage'. The tooltip standard the app follows demands it — 'A bar showing "8.0d avg" is a different fact when n=2 than when n=30, and the chart cannot show that.'

The problem
  • No measurement existed for how long a lead sat in any given step.
  • A single stalled deal skewed the only number anyone had.
  • Small samples were presented with the same confidence as large ones.
Sound familiar?
What you get
The slowest step in the sales process is identifiable in one look.
Median plus p90 separates a habit from a one-off disaster.
Sample size is always on screen, so the number can be trusted or discounted honestly.

See it on your own jobs

Twenty minutes, your numbers, no slide deck. We’ll build one of your real buildings in front of you and send you the estimate link at the end — yours to keep either way.

or keep browsing features →