Neighbourhood | HubSpot Hacks

How To Calculate Time Between and Reduce Bottlenecks

Written by Geordie Roberts | Jun 3, 2024 5:04:10 AM

Why is this hack helpful?

You can use custom calculation properties to calculate things like the time between two properties. These calculation properties will help you to make more data driven decisions and avoid bottle-necking. 

This hack will show you how to use calculation properties to measure the time between two properties. There are lots of other ways to use calculation properties so keep your eyes peeled for more hacks.

 

Step by Step Tutorial

1. Create a calculation property on the object you want to measure.

For this example we will be using the Deal Object.  

2. Select the Time Between option for the calculation property type

You will see there are other awesome options like Min, Max, Count and Average.

 

3. Select your two date properties for the start and end date

HubSpot will calculate the amount of time between the start date property and end date property. You may need to create a custom date property if you are looking to measure specific timelines.

 

4. Add conditions to ensure your calculation is working when you want it to

For this example, we have set it so that HubSpot doesn't calculate the time between until the Deal has been Won. 

5. That's it! HubSpot will now start to measure the time between the two date properties when it reaches the Closed Won stage.