topic Re: Custrom report for calculating how much time an average deal spends in each pipeline stage. in Dashboards & Reporting

Custrom report for calculating how much time an average deal spends in each pipeline stage.

jrtbv — Thu, 09 Feb 2023 20:54:36 GMT

Hello,

Is there a chance to create a report that will summarize how much time an average deal spend in each pipeline stage?
Im looking for an average example:

Stage X
Stage Y
Stage Z

How much time a deal on average spend in stage X,Y,Z

Regards

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

karstenkoehler — Fri, 10 Feb 2023 05:27:56 GMT

Hi @jrtbv,

There is a default report for this under Menu > Reports > Analytics Tools > Sales Analytics > Time spent in deal stage. (This requires a Sales Hub Professional subscription.)

https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool

If you're on a free CRM or Starter subscription, this is not possible, unfortunately.

Best regards!

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

jrtbv — Fri, 10 Feb 2023 05:30:27 GMT

Hey, I have a hubspot professional, but I dont see this report.

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

karstenkoehler — Fri, 10 Feb 2023 05:31:34 GMT

Hi @jrtbv,

Which Professional subscription do you have, Marketing, Sales, Service, Operations or CMS?

Best regards

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

jrtbv — Fri, 10 Feb 2023 05:34:17 GMT

Sales hub professional

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

karstenkoehler — Fri, 10 Feb 2023 05:37:54 GMT

Hi @jrtbv,

It should be here:

If it isn't, I'd recommend reaching out to HubSpot support.

Best regards

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

jrtbv — Fri, 10 Feb 2023 05:40:43 GMT

Thank You!

I would appreciate if You take a moment to look at my 2nd post.

https://community.hubspot.com/t5/Welcome-and-Introductions/Workflow-for-automatically-adding-ARR-to-the-deal-asociated/td-p/754324

Re: Custrom report for calculating how much time an average deal spends in each pipeline stage.

jrtbv — Fri, 10 Feb 2023 09:59:25 GMT

I got a little problem with this report, as I think I doesn't take all deals into consideration, but only those currently in a certain stage