Calculate and Report on the Time between Two Properties

[virginiam]

I would like to create a custom report where i can see how much time my contacts spend in each stage of their Contact Lifecycle. I am looking for something much like the "time in deal stage" available for deals.

I know that hubspot has the "became a lead date", "became an opportunity", "became a customer date" properties, but I can't seem to get any good report using these.

[brittanyCP1]

I cannot believe this isn't available with Hubspot! It should be done ASAP.

[slepoidevin]

@brittanyCP1 it's available now 🙂 

Create a new "Calculation" type field, and then change "Count" to "Time Between" from the dropdown on the next panel. Not super intuitive, took me awhile to find it.

[Melly2022]

@JoeMayallI went to upvote but that specifically speaks to deals I think?

The majority of this thread wasnts it at the lead levels subscriber to lead lead to MQL MQL to SQL etc. Currently trying suggested screen shot above - what doesn't work is what if that contact never hit subscriber? or jumped lead to MQL from subscriber - it wont calculate with current suggestion.

[slepoidevin]

@JoeMayall if they're skipping steps you may have to set up a workflow that stamps the date of the skipped step? 

[xjessiec]

I hope the feature to monitor time spend in each stage will available soon as this is very much needed to monitor and track the performace of our ticket team. 

[HubSpotMaster]

The feature needs to eliminate the need to "go through each stage sequentially"

[Melly2022]

@HubSpotMastertell me about it.. there isnt even a valid workaround that makes sense for this and conversion funnels are basically useless

[rwolupo]

need that too

[shiri]

Can I get access to the beta?

[miikkaj]

Being able to make a report based on "Ticket time spent in each ticket status" (quite like "Deal time spent in each stage") would really be needed.

[NicoleSengers]

@jeffvincent how do we get added to the Beta for Time in stage?

[Layal]

Is there an update on this?

[KeithBaker]

So has anyone been able to simply create a report that shows the time spent between each lifecycle stage??? (just like the deal stage average time spent in each stage)

[Melly2022]

@KeithBaker  I have created something in the place of for now yes. 

Steps: 

You need to create a calculation property for each stage transition selecting time between as your property type and the appropriate drop down options

build your report to show these filters

Your dashboard should look like this ( You will need one for each stage change....)  

[KeithBaker]

@Melly2022 Thanks for this. Only problem is that with a limit of 5 user calculated fields available on the professional subscription I cant actually create the report.

Come on HubSpot, how can you expect users to manage the throughput of contact lifecycle stages without creating the above calculated fields (just like you have done for Deals)..... 

[comoglu1]

This feature will be very useful. Please put it on your agenda. Thanks in advance

[jmorelos]

We need to be able to export the time between stages! We use the time between stages to compensate our collaborators. We just need the time between stages report, or being able to export to Excel each Deal with a column for the date/time of each stage so we can calculate the time.

[feedback]

So.. it's been 2 years. Doesn't look like this is happening.

[JRocchietti]

How is this not done yet? Have users found a soluton? The workflow thing is not gona work for me. 

[Hildegaard]

Please populate a today's date automatically