Calculate and Report on the Time between Two Properties

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.

 

HubSpot updates
Aug 19, 2020

Hey @andersks!

 

We have an ongoing thread that requests the ability to calculate "current time in stage" or "time until TODAY" here: https://community.hubspot.com/t5/HubSpot-Ideas/Time-in-Deal-Stage/idi-p/277082

 

I'd suggest popping over there to give it an upvote and leave us your feedback!

 

Best!
Joe
Ideas Forum Manager

Jul 24, 2020

Hey folks!

 

Here's a great resource that shows how to create a "time between" property: https://knowledge.hubspot.com/crm-setup/create-calculation-properties

 

Best,

Joe 

Ideas Forum Manager

Status updated to: Delivered
Jul 17, 2020

Hey all! It's been awesome to see so much interest in the Time Between properties beta. After consulting with the team, I'm going to move up the public release of this feature to Monday. Hang tight over the weekend and you'll have this feature soon! With that update, I am marking this community post as "delivered".

 

There were a whole bunch of comments added on to this post that are really about current time in stage, which as I mentioned previously, is a separate challenge altogether and something that will take considerable research to do right.

 

To make sure your input is heard, please take the conversation about that topic over to this Community post. Give it plenty of upvotes if you care, so we can prioritize it properly. Thanks!

Status updated to: In Beta
Jul 13, 2020

Hey all! It was really informative (if a little painful at times) to read all the comments on this post.

 

Excited to share we've released a new kind of calculated property into beta: "Time Between" properties.

 

Time Between properties take two existing date properties (like "became a lead date" and "became a customer date") and calculates the duration between them. It's just what you need for creating reports like "average time spent in lifecycle stage" or "average time for Enterprise leads from initial conversion to Go Live", etc. The feedback on the beta so far has been terrific, we're on target to release to all Pro and Enterprise customers in the coming weeks. If you want into the beta, just reply to this update and I'll get your hubs added.

Next: There are SO MANY comments on this post about wanting to measure time spent from entering a stage to today. I want to re-iterate that while that seems basic, creating that functionality that also works with the rest of the HubSpot tools (like Workflows and Reportings) is incredibly difficult to do well and at scale. While that functionality is not part of the initial Time Between properties launch, we are working very hard (think multiple conversations with many, many smart HubSpotters weekly) to figure out how we can make it work. I look forward to updating you all on that soon.

168 Replies
Regular Contributor

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

Regular 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

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.

Regular Contributor

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

Occasional Contributor

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. 

Advisor | Gold Partner

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

Advisor

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

Top Contributor

need that too