Calculate and Report on the Time between Two Properties

Still Nothing from Hubspot, this feature would be fantastic

Great functionnality to be developed!

I would need to export data other than properties only (for example time spent in each lifcycle stages for deals)

Can we get an update on the status of this thread? Even when paying for Enterprise edition with calculated properties you still can’t achieve this. This is fundamental to sales reporting and would be great to understand what holds it back from being a functional part of the platform.

Thanks!

I would like to add my voice to this request - I’m sure we all agree that it can’t be understated just how useful this feature would be. Given that the data is already on the deals, you’d think it would be relatively simple to make that exportable? Of course I’m not a dev so it may be incredibly complicated for all I know, but this thread has been open for 2 years or so…

Hi,

I just finished reading this whole thread and can’t believe this is still not a feature.

We also are trying to find a way to track the time a deal is stuck in a deal stage. We want to take it up a notch and send an automatic email to the account manager and his suprvisor with the deals they have stuck per X amount of time.

Seems like there are a lot of people asking for this features, @jsg121 can we have a re-evaluation here?

Hi,

We really need to be able to alert our sales team on “stuck” leads, through one report mailer which canbe sent automatically, say- once a week… We are looking for a way that this report mailer will alert on the following:

* “You have 10 Leads that are currently still stuck in the same stage for more then ONE WEEK. These leads are: A, B, C…”

* “You have 4 Leads that are currently still stuck in the same stage for more then TWO WEEKs. These leads are: D, E, F…”

* “You have 3 Leads that are currently still stuck in the same stage for more then ONE MONTH. These leads are: G, H, I…”

This is in the core of our team’s productivity need… How come Hubspot does not have a way to setup that??? Isnt that a basic produstivity capabity?

Is the “Time in deal Stage” still not available as a regular feature (i.e. without using the APIs)?

I am asking since most entries on the “Time in deal stage” topic are from back in 2017.

Exporting of dates of when deals enter stages is critical to measuring deal velocity and for identifying potential bottlenecks during the Sales process. The fact that these dates are already being captured by the CRM shows that HubSpot agrees with the idea that these dates provide value.

The functionality to add these data points to a report already exists, it just currently displays that they are for ‘chart only’ and not exportable. Exposing these dates and allowing them to be exportable would add even more value to HubSpot as a product and eliminate a current pain point.

I used to be able to see time in deal stages in Pipedrive. You could set the goal time, and if a deal is longer in the stage it turns red. It showed the times on the stage at each deal where Hubspot shows close date. Our deals take nearly 8 months to close and we need the time shown in stage feature to see how long each deal sits in the stage so the customer team can follow up on those deals that are over their time in the stage.

Upping this as we definitely need this feature.

Awesome initiative! We really need this at our company too.

The number days in current stage is a basic operational view and this type of feature should be available or able to be created by admins.

So strange Pipedrive has been doing it for years and Hubspot can’t. Pipedrive lets you set a 'Rotting date" for each stage and the deal turns read when over the timeframe. You can also see how long each deal has been in the stage in the deal tile. Don’t you think it is time HubSpot does the same?

I’d love to have this feature as well!

When trying to work on pipeline velocity, this is a major step backward from the other CRMs on the market. As a first step, is it possible to export this type of data? The “Deal time in each stage” dashboard report is illustrating some of the value, but we need to be able to go deeper. There appears to be a large demand/desire from your customer base for this.

The irony is that if you go to a deal and look at the activity log, the Create date and date/time stamp for each deal is RIGHT THERE! That means that the data is also RIGHT THERE and since it is already in a database, it should be easy to get out as your system is ALREADY doing this. I would think an Activity report that shows Deal Created Date and Deal Created Time and that includes Time and Date when the Deal Stage was changed/modified, would be all that is needed.

Super critical feature in the sales process. You already have this data then why not using it?

Hi,

There is already a very useful “Time in Deal Stage” panel. It would ver very useful to have a “Time in Lifecycle stage” one.

Knowing how much time a contact spent in a stage and how much it takes to move thorugh the pipeline is a nice metric to improve sales and communication process. Very useful for and Account Excecutive or a VP of Sales or whoever is in charge of optimizing and getting better performance.

Thanks!

I agree. Marketo does this, Hubspot should as well.

Thank you for posting this idea @virginiam! I agree this would be a valuable feature and I hope it’s something we can see in the future.