How to Build a HubSpot Time in Deal Stage Report

Which HubSpot properties track time in a deal stage?

Six stage properties do the work: date entered and date exited for each stage, latest time and cumulative time in each stage, plus date entered current stage and time in current stage. Only the last two fill in while a deal is still in the stage, which is why they are the ones for a stalled deals report.

HubSpot also has default deal properties based on the owner's history, such as the owner's average time in the current stage and a timestamp for when a deal counts as stalled. Check how they behave in your portal before building on them.

Which HubSpot tier do you need?

When we checked in October 2026, stage calculated properties and calculation properties needed Professional or Enterprise. The sales analytics reports, including time spent in deal stage and the deal funnel, were available from Sales Hub Starter, with funnel customization on Enterprise. Check your portal, because HubSpot changes tiers often.

How do you build a stalled deals report in HubSpot?

Turn on the stage properties, create a single-object deals report, filter to open stages and a Time in current stage above your threshold, add the columns a manager needs to act, sort longest first, then save it to the pipeline dashboard. A second report on cumulative time shows how long each stage really takes.

1. Turn on stage properties. In Settings > Data Management > Objects > Deals > Pipelines, choose the pipeline and switch on the stage calculated properties for each stage, or enable them all at once. They are off by default for new pipelines and stages, and values fill in for past deals once switched on.
2. Create a deals report in the custom report builder.
3. Filter it: the pipeline you are reviewing, deals in open stages only, and Time in current stage greater than your threshold. Use one filter group per stage if thresholds differ.
4. Add columns: deal name, owner, stage, amount, date entered current stage, time in current stage, close date and last activity date.
5. Visualize it as a table sorted by time in current stage, longest first, and as a bar chart by stage, broken down by owner.
6. Add the history view: a second report averaging cumulative time in each stage for closed deals, so thresholds come from your own data.
7. Optional nudge: a workflow that creates a task for the owner when date entered current stage is more than a set number of days ago. Do not trigger on latest or cumulative time; they do not fill in while the deal is still in the stage.

For time between two stages, a calculation property of the "time between" type can measure, say, date entered one stage to date entered the next. Note that "time since" calculation properties cannot be used as report filters.

What about HubSpot's built-in time in stage reports?

They are useful, but for the past. The sales analytics reports cover time spent in each deal stage, the deal funnel, deal velocity and sales velocity. The time in stage report works from deals with a close date in the selected range, so it describes how stages performed rather than which open deals are stuck today.

• Use them in a monthly review of how long stages take and where deals drop out.
• Use your own Time in current stage report for the weekly list of deals to act on.

How do you set a stage aging threshold?

Per stage, from your own closed-won deals, not one number for the whole pipeline. Look at how long deals that went on to close usually spent in each stage, using cumulative time, and flag open deals that have been there noticeably longer. Revisit the thresholds every month or so as the history grows.

How do you use the report in a weekly pipeline review?

Open the stalled list, longest first, and go through it owner by owner. For every deal, agree one outcome: a dated next step, a corrected stage, a corrected close date, or closed lost with a reason. A deal should not leave the meeting still stalled with no decision.

• Keep the meeting to the list; it is the agenda.
• Cross-check with HubSpot's deal push rate and deal change history in sales analytics.
• The wider review rhythm is in the weekly pipeline review.

Can deal board cards show time in stage?

You can add properties to deal board cards, and the cards can flag deals with no activity for a set number of days. Adding Time in current stage to the card shows reps the same number the report uses. Customizing card contents depends on your tier and on HubSpot's newer board views.

Stage report checklist