Count Changes in Calculated Properties

SOLVE
Highlighted
Occasional Contributor

Here is what I need to create:

Report answers the following question. Broken out by month, what is the average time between each Lifecycle Stage? Run data YTD (Jan 1, 2020 - Aug/September, 2020).

  • Lifecycle stages: Lead, MQL, SQL, Opportunity, Customer
  • Include number of Contacts that moved into each stage

I have created caluclated fields to determine the average amount of time it took contacts to migrate from Lead to MQL, MQL to SQL, SQL to Opportunity, and Opportunity to Customer. (leaving me with 1 available calculated field of the 5 max allowed)

I have this in a report:

average-time-in-lifecycles.png

 

This shows me what I need to know as far as time between lifecycles, but what I still need is to be able to display how many contacts were counted to create those totals of days. 

 

What I did was create another report to try and display this. However, this chart is showing how many people ended those months in those lifecycle stages. These numbers are close, but they're not exactly correct. I just want to display how many contacts moved from Lead to MQL, how many moved from MQL to SQL, etc. Not how many contacts were in the SQL stage at the end of the month. 

 

Here is my second report that is not correct:

contact-totals-by-lifecycle.png

 

I would like to consolidate this information into one report if possible. If not, how can I display how many customers migrated from one lifecycle to the next? 

 

All advice appreciated.

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Solution
Regular Advisor

Hey @Jacob311, since it's unlikely you can get this all in one report.  To report on the count of people that moved from one stage to another I think you can utilize the "Became a X date" and create a report per lifecycle that you track.  This would give you a count of users who became a lead, MQL, SQL, etc. in the date range that you specify.  

 

Hope this helps!

Chris Bryant | Your Dedicated HubSpot Expert

View solution in original post

4 Replies 4
Highlighted
Community Manager

Hi @Jacob311,

 

Thanks for reaching out.
I want to tag in some thought leaders to see if they can assist with this.
Hi @Dan1 @warrendavey @MAC-MCB, would you be able to share your thoughts with @Jacob311?

Thanks,
Jess 


We are excited to announce that the Community will be launching a weekly newsletter on November 2, 2020!
Sign up today!
Highlighted
Occasional Contributor

Thank you @JessicaH 

 

This hasn't been resolved yet so I appreciate anyone you can tag that might have some insight. Thanks!

 

Jake

Reply
0 Upvotes
Highlighted
Community Manager

Hi @Jacob311,

 

Let me tag some more subject matter experts, to see if they can assist with this.

Hi @Bryantworks @AdamLPW @AM8 do you have any suggestions?

 

Thanks!

Jess 


We are excited to announce that the Community will be launching a weekly newsletter on November 2, 2020!
Sign up today!
Highlighted
Solution
Regular Advisor

Hey @Jacob311, since it's unlikely you can get this all in one report.  To report on the count of people that moved from one stage to another I think you can utilize the "Became a X date" and create a report per lifecycle that you track.  This would give you a count of users who became a lead, MQL, SQL, etc. in the date range that you specify.  

 

Hope this helps!

Chris Bryant | Your Dedicated HubSpot Expert

View solution in original post