Count Changes in Calculated Properties

Marketing & Content Hub Reporting & Analytics
1

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:

32099i2B150098B43B93C1.png
32099i2B150098B43B93C1.png997×314 51.5 KB

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:

32100i99BA0E88B6A4EB29.png
32100i99BA0E88B6A4EB29.png997×208 28.9 KB

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.

2

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

3

Thank you @JessicaH

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

Jake

4

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

5

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!