Reporting on Average Time in Lifecycle Stage

[KMoser317]

Hello,

I've recently created a calculated contact property called Time in SQL. It calculates the time between becoming an SQL and becoming the next stage in our process - Sales Working.

I'd like to create a report that shows me the average Time in SQL over time for all of our contacts.

Any ideas of how to do that? 

[JWestover]

@GSnow7 Not sure if you solved this at all or not, but the way to get this is as you started on below. You need custom-calculated properties for each lifecycle stage that is taking into account the time from one stage to the next. 

This one shows you velocity trends for lifecycle stages across created dates for contacts. 

[GSnow7]

Nice work. No I didn't solve it. Love to know how you created the above graph.

I discovered the HS property "Cumulative time in a lifecycle stage" is non zero only if they have left the stage ... sort of annoying for the contacts still in the stage. I guess I need to create a function to calculate current date - date entered stage for contacts that haven't left the stage. My custom function HS skills aren't up to scratch for this yet.

[GSnow7]

@karstenkoehler You didn't really answer the question. You showed him how to set the report up, but not specifically how to report on the length of time a contact is in the lifecyclestage.

I also want to do this. I want to report on how long the contact is in each lifecyclestage, but there does not appear to be a proprty to do this.  I can do Cumulative time in "lead" etc, but that's not going to work. Essentially what I want is a graph like this: 

So I can set a benchmark, targets and monitor performance. Do I need to create properties and calculatons, if so how?

[karstenkoehler · Accepted solution]

Hi @KMoser317,

Happy to help!

Navigate to Menu > Reports > Reports > Create report > Single object > Contacts.

Then, under Filters in the top left corner, select your date range. To start, I'd recommend "Create date is all time".

Next, in the Data tab, find your calculation property.

In the Visualization tab, pick the Summary visualization, then drag and drop your calculated property into the Displaying area. HubSpot now gives you the option to choose from a few measure, this is where you select Average.

Here's an example with another number property:

Hope this helps!