MPKNOWLEDGEDROP

Lifecycle analysis and tracking movement of users between cohorts

  • 4 December 2019
  • 0 replies
  • 260 views
Lifecycle analysis and tracking movement of users between cohorts
Badge
  • Mixpanel Community Team
  • 1 reply

Every week, we will release tips to help you get the most out of Mixpanel. Follow the Topic Tag#mpknowledgedrop and subscribe to the Announcement subcategory to get alerted when they are posted.

 

Lifecycle Analysis with Cohorts
 

Lifecycle analysis is the process of breaking down your users into meaningful cohorts to determine which groups most significantly contribute to the growth (or shrinkage) of your user base. This kind of analysis is critical to sustaining the growth of your product.

This post shows how to use Cohorts and Insights to perform this type of analysis in Mixpanel.

 

Step 1. Define Activity and Usage Intervals

To answer meaningful questions with lifecycle analysis, start by determining the key event or set of events that matter to you. For example, the core function of a ride-sharing app is to book and complete a ride, so that could be a key event.

Mixpanel users often write into our support team, and they ask: what events are most important for me to track? The answer is inevitably it depends. What is the core function of your app? What do you want users to do? How do make money? Ask yourself these questions to figure out what your key event should be. It should feel straightforward — there’s no complicated grad school formula here.

Once you’ve identified a key event that you are interested in analyzing, determine what is an appropriate usage interval. That’s the natural frequency at which your customers use your product. It could be daily, weekly, monthly, etc. If you’re not sure what this is, use Mixpanel’s retention report to generate a “Power User Curve” to understand the natural usage frequency of your key event or do a cumulative distribution frequency function.

Users that perform your key event within your defined usage interval can be considered as active.

 

Step 2. Define Cohorts

In lifecycle analysis, the most commonly used cohorts are new users, resurrected users, retained users, and dormant users. The following table shows what each cohort represents. In your product’s use case, “Did action” would be replaced by your key event.

B4pIAJJbsUq93Q31hQcb75N2cvsxGgIdMXoMe3cbr2-bqXNfBSU9d6iuC-4SDljBJHzcXMJu0S1qLiXfUkjlAD7xvhiDasT7KrErMpcFr6Riwz25X7w8UgzWMmrbyKSue9l2ZL0C

 

Create cohorts in your project for each group of users. Take a look at examples of Retained, Resurrected, and Dormant cohorts here

The next screenshot is an example of the Retained User cohort, where the key event is called “Message Sent” and the usage interval is 7 days. Make sure to select rolling range, so the dates of the cohort criteria adjust based on the current day. Since this is the retained user cohort, according to the table above, I specified that I want to include users who performed “Message Sent” in the current period (last 7 days) and also the previous period (14 to 7 days ago).

 

8UngRyfNjHFui3FB8mLs2QX_ubSqkk8qHueK_XFqsRjhMtTpSyyp8myvHI2IFHX9NCL0iefwEVJ3qG72Hry5R2xywda0Z735f0T4cSQO33OAXvrcUMGG1rCGDnrIqTYI13bTBvmQ

 

Once you’ve created your 4 cohorts, you can visualize them over time in Insights to track how each group of users is changing over time. Expect to see something like this:

 

ar4iOjJj168I7YP1GgPBN4PWt7Gei0K9ck9M3ChA8BAO9ibEUrpiU6feTHEYFWPI6vqLnNF_R4hazq743Z8Sykhc2SSuiWuFShxDKcF-_OSjAjy8yj9ib19BExRjYwrUOfSGHhJP

 

Now that you have this graph of your most significant cohorts, you can ask questions to understand which user groups are impacting your growth and make decisions for how to influence growth.

Check out more examples of questions that you can answer with lifecycle analysis on our blog.

 

Measure Your Product’s Quick Ratio

 

Quick Ratio is the ratio of users added to your user base over users lost. Users added is made up of new and resurrected users. Therefore, you can use the cohorts that you created for lifecycle analysis to plot this metric.

asuS8y3jc5GlTrvyU9bS7zt-uwz_df3aLzjX83zSn7USPKq3JltTxQ2IKzkwwgfxAUWehLLA_axcYT1jc4bsroyzTaQtvPAN1UY9_p-TSB5zTjKwz-xnSn20PSBn7lv88cV1hs7j

 

Quick ratio determines whether your net user base is growing or shrinking. If the ratio is above 1, then your user base is growing. If it is below 1, then your user base is shrinking.

 

rpVkUBxFnX7lp800khJsE_sGd_UEnj4IJTyTVBjKzCO5z4UPiYdd0kAxh7UDGj53Zi1GjkydI6r5DqDpdtRzFD6HiFblm0CrQmcSJpa3k8YK1eS-UuiG7ochm7COmPal-wSzqLRK

 

 

 

Track Movement of Users Between Cohorts

 

You can also Cohorts and Insights to analyze the movement of users between your significant cohorts.

 

Define significant cohorts

A significant cohort is a group of users that have performed an event or share a property value that matters to the success of your product.

In this sample use case, an “occasional watcher” is a user that performs Watched Video 1 or 2 times in a 7 days period. A “core watcher” is a user that performs Watched Video between 3 and 10 times in a 7 days period. Finally, a “power watcher” is a user who performs Watched Video 11 or more times in a 7 day period.

The following screenshots show how to define cohorts that capture the number of users that move from the “Occasional watchers” and “Core watchers” group to the “Power watcher” category.

Occasional to Power: the number of users that were in the Occasional watchers group 14 to 8 days in the past but moved to Power watchers in the past 7 days.

7jdcJYZHe7Piwzr1pNqUhWdxxsFsYUziptzuZvuqOwzwM4wY4rAFw8IxV4O7PMlOINUy1M7GVQ05HbxQLCqN2dT5Oz5TKdc521goLE2F8dlgCaQnAYGrIE4vlAYaYksJg2BBNywf

Core to Power: the number of users that were in the Core watchers group 14 to 8 days in the past but moved to Power watchers in the past 7 days.

 

AN0q0D2c4AowD1Z3LMjHYhmQsEMNUWESNH6Fw-Ngvhl3TRSVu6-vhO3HuO0xXczGqx3OvD-THH1S7TXfRHPkdZxwc7PSe1THPT4qCDhxDbQQurWv0gqVFDZfw1yinj1-ZhvbSHgF

 

Visualize Cohorts in Insights and Explore

Now you can go to Insights and plot these cohort trends over time. You can plot these two cohort trends as a dashboard card or set an alert if you want to track this as a key metric.

QJO7l5Zvh76viXT8uCg_ZqmGKNGe5Iar0R-MTKJnJiiKlpu1RTAMf8rL6uN38Xt_ZOzqb1QYFIs-xH4g7CvRDD9uVWUYTJ6nfeIuwmzImhbQV1IWdQetFTPDM18b8LXHlo37wmoQ

6xGzNDvCYDrdiP4Nb3tVAK_YcHY_foGngqZrN-7C1lvxaNXm3UG1LYUOCBTfR_k1Cmxg7l-ddTB4auU8mLsRaF-AX1kMcacpd1gt1prpsviMMUMYaTox4kAAhDWUY1itqmlry6Dj

 

You can also go to Explore and view the exact set of users that moved between two cohorts, and click into specific user profiles.

 

ZHMwQvoHsXa8Kmk7clecNi6uHGghQHRk6AVxjtqsC-Oo5ZP-eG6QRNggKsqvYKfMjwQ5WyFe_efOB86pgGhKGHQaIAmWOh5jISRyo36gu5v4lN-h-F4Ikbu-4oagRF6FFXxwRTc6

 

You can even use these cohorts to send messages to users when they move from one group to another — but that’s for a different post!

Read more on Lifecycle Analysis through our blog post!


0 replies

Be the first to reply!

Reply