topic Re: Create "time in deal stage" report in Dashboards & Reporting

Create "time in deal stage" report

dwightbailey — Tue, 19 Jan 2021 21:19:40 GMT

Can anyone help me? How do I create a report that looks like the below in Sales Starter:

Re: Create "time in deal stage" report

karstenkoehler — Wed, 20 Jan 2021 06:59:20 GMT

You should have this in your Report library. Navigate to Menu > Reports > Reports and click Reports library on the upper right. Search for "Deal time spent in each stage". (I had to filter the report library by deals first, using the sidebar, and scroll down a bit. The search doesn't work properly for me.)

I'm not sure whether you can further edit or customize the visualization of this report in Sales Hub Starter. I changed the frequency of my report from Weekly to Yearly.

Hope this helps!

Re: Create "time in deal stage" report

Josica — Tue, 22 Jun 2021 10:23:00 GMT

Hi @karstenkoehler , I've tried to create "Deal time spent in each stage" but no data was shown. Any Idea why is that so?

Re: Create "time in deal stage" report

Jwyoung — Wed, 27 Oct 2021 14:08:51 GMT

hi @karstenkoehler , same here... I don't have any deals popping up with the average deal time in a stage. Could you help us?

Re: Create "time in deal stage" report

SashaSalamandra — Tue, 30 Nov 2021 23:37:56 GMT

@Jwyoung It only comes in a summarized data table view - so you can only see average time numbers summarized based on a date property. I was looking for data split into individual deals but had no luck.

Re: Create "time in deal stage" report

annieg241 — Tue, 07 Dec 2021 21:26:26 GMT

I cannot find this in the reports library. Did they recently take it away?

Re: Create "time in deal stage" report

RRichards — Wed, 26 Jan 2022 19:52:46 GMT

This report appears to have been removed. What is the correct way to go about this at present?

Re: Create "time in deal stage" report

ASmolen — Mon, 21 Feb 2022 21:14:39 GMT

It's now called "Deal average time spent in each stage"!

Re: Create "time in deal stage" report

ASmolen — Mon, 21 Feb 2022 21:14:49 GMT

I think it was just renamed to "Deal average time spent in each stage"

Re: Create "time in deal stage" report

WaqasNabi — Wed, 13 Apr 2022 12:51:00 GMT

Hi @Josica ,

Here click the filter button on the top left corner. There choose the Pipeline, which data you want to show.

Hope it'll help.

Re: Create "time in deal stage" report

WaqasNabi — Wed, 13 Apr 2022 12:53:42 GMT

It is available there.

Select report library > from left filters select deals > then scroll down, you'll find it there.

Re: Create "time in deal stage" report

VIyengar — Fri, 19 May 2023 16:16:00 GMT

Hi Kevin,

I can't find this "Deal time spent in each stage" report anywhere. Has anything changed since your reply?

Re: Create "time in deal stage" report

kvlschaefer — Wed, 24 May 2023 15:52:19 GMT

Hi @VIyengar,

Thanks for reaching out!

The report is called "Deal average time spent in each stage" in my HubSpot portal.

I was able to find it in the reporting library by navigating to Sales > Reports > Create Report and searching for "Deal Time Spent in Each Stage".

Hope this helps!

Best,

Kristen

Re: Create "time in deal stage" report

Hildegaard — Tue, 28 Nov 2023 09:28:43 GMT

Please populate a today's date automatically

Re: Create "time in deal stage" report

LRehn — Wed, 28 Feb 2024 15:02:53 GMT

Hi! It's also possible to do your own solution using datasets if you have operations Hub.

I've made one for SQL date-> Close date using the "DATEDIFF" Function

Re: Create "time in deal stage" report

RPopovich — Sun, 31 Mar 2024 23:09:08 GMT

Hi there, I am also trying to find this report and I am not seeing the report name: Deal average time spent in each stage. Does anyone know if this has changed?

Re: Create "time in deal stage" report

PPlant4 — Tue, 23 Apr 2024 19:42:28 GMT

I don't have it either...so frustrating.

Re: Create "time in deal stage" report

LRehn — Wed, 24 Apr 2024 06:36:33 GMT

@RPopovich , @PPlant4 Im not sure about the out of the box report but it's very easy to build yourself using either single object och custom report builder.

Since a couple months ago there were new properties created as default called "cumulative time spent in "deal stage X""

Have a look at the screenshot below! 🙂

Re: Create "time in deal stage" report

V-Marketer — Mon, 03 Jun 2024 13:16:38 GMT

I do not have this standard report either.