Deal Stages report on time spent in each deal stage

Hi,

I am having trouble building a report for deal stages the way I want it so am hoping I find an answer here instead… I am looking to build a report that shows me the total (or average) time deals have spent in each stage until they were converted/won. We want to analyse the time it took (in average) for the deals to move throughout the different stages and where they are spending the most time. I have attached a screenshot of what I’m trying to get to.

Hi @NHoff,

There is a default report in the report library which you might useful. Navigate to Menu > Reports > Reports > Report library and search for “Deal time spent in each stage”.

It’s a table view and not a funnel view like you’re looking for. Your ideal report has unfortunately too many dimensions (conversion rate, time, count of deals) to display in one report.

Let me know if this report works for you!

Best regards

Hi @karstenkoehler ,

Thanks, I looked at that report earlier… What if I was going to remove a dimension such as total amount deals per stage and just show average time spent per stage?

Hi @NHoff,

What would you then like to display instead?

Best regards

Hye , how can we check for separate deal time spent in each deal ?

Hi @karstenkoehler , here’s an example:

Deal Stage 1: 2 weeks in average

Deal Stage 2: 1 week average

Deal Stage 3: 4 weeks average

etc

Hi @NHoff,

That’s exactly what the “Deal time spent in each stage” report in the report library is showing :slightly_smiling_face:

Are you missing anything here? The deal stage would be the header row, the average in the totals row at the bottom.

Best regards

Hey Karsten,

I had a different question but along a similar metric.

Have posted it here:

https://community.hubspot.com/t5/Sales-Hub-Tools/Sum-of-time-spent-in-deal-stage-vs-Deal-Velocity/td-p/583597

Could you please take a look if you have time? Would really appreciate it. Thx!

Best,

Nausherwan

Yeah, but the deal has to leave the stage for the days in stage to be calculated. It would be more helpful to have a running clock for time spent in the current stage.

Hi @karstenkoehler is this report still available? I can’t find it

Nevermind - found a template from the instructions in your other post!

how do i export this report in csv format?

What’s the best property to use for this report: Close Date or Create Date? And why?