HubSpot time in deal stage report: how long deals really sit, and how long a sale takes
Stage duration is in the deal's property history, one deal at a time. The report a sales manager wants is the average and the median per stage, by pipeline and by rep, with the open deals counted too.
A Revenue Operations Manager at a small business wrote on G2 in May 2026 that what makes HubSpot useful day to day is "seeing deal stage duration, rep activity, and forecast accuracy all in one place, without stitching tools together." The same reviewer added that "the reporting customization hits a ceiling faster than it should." A reviewer in November 2025 put the ceiling in numbers: HubSpot "doesn't calculate averages as simply as Excel or allow the use of formulas like correlation or median numbers."
The raw material is there. Every stage change a deal makes is kept in its property history. The report that turns that history into a cycle length is the part the team builds by hand.
What the report shows
A time in stage report, on the first of each month, has three tables:
- days per stage: for each pipeline and stage, the average days, the median days and the number of deals
- sales cycle by pipeline: the average and median days from create to close
- sales cycle by rep: the same, per owner
It covers open deals as well as closed ones, and that is the whole point of the next rule.
The denominator rule
A cycle length averaged only over the deals that closed says the sale takes 30 days when the open ones have sat for 200. So an open deal's time in its current stage is counted up to the moment the report runs, never dropped. And the median is reported next to the average, never in place of it: one deal that sat for a year moves the average and leaves the median alone, and you want to see both.
Why it is worth a schedule
The usual method is a stage-history export and a spreadsheet, about an hour and a half each month, with the open deals quietly left out because they have no close date yet. The number that comes out is the one reps are measured against, so it is worth computing against the right denominator.
How Captain Hudson does it
Say it in a sentence ("on the first of the month, average and median days per stage and the sales cycle by pipeline and rep, open deals included"). Captain Hudson shows the plan before anything runs, then builds the report from the deals, their stage history, pipelines and owners in your own HubSpot account, counted the same way every month, with a note on how each number was produced. Your HubSpot data is used for your account only, never used to train a model, and deleted when you uninstall or ask. The ready-made version is below.