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.

 

171 Replies
brittanyCP1
Participant

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

slepoidevin
Contributor

@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.

 

Screen Shot 2020-09-02 at 3.22.56 PM.png

Msyvrais
Key Advisor

@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
Contributor

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

xjessiec
Participant

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
Key Advisor | Platinum Partner

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

Msyvrais
Key Advisor

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

rwolupo
Top Contributor

need that too

shiri
Participant

Can I get access to the beta?

miikkaj
Participant

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
Top Contributor | Diamond Partner

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