Solved

Creating New Users Cohort

  • 11 December 2019
  • 1 reply
  • 368 views

Badge

Following the post about Lifecycle analysis, how do I create a New Users cohort?


@Marco from Mixpanel Education - maybe you can share screenshots for all the cohorts you mentioned in the post?


icon

Best answer by marco 24 January 2020, 18:51

Hey @sharod,

 

Here's an example of the cohort builder for a new user cohort. Here are the assumptions for this example:

1. The key event that matters to me for this product is "Watch Video".

2. The usage interval that aligns with this product is 7 days.


Based on that, I define new users a someone who performed "Watch Video" in the last 7 days (that's A in the screenshot below), but did NOT perform "Post video" between 14 and 7 days ago (B), or 21 to 14 days ago (C).

The whole point of B and C is just to make sure that this is actually a new user. So depending on your use case, you B and C could be longer. The main thing would be to avoid accidentally counting a user that was active a long time ago and then came back, cause you'd wanna put that user into a resurrected cohort, not a new user one.

 


For my product here, I don't think I have any users who were around before April 23rd of this year, so I don't have to worry about that.

 

Here are some screenshots of how I would define the other cohorts with the same key event and usage interval:

 

RETAINED (perform event in two consecutive intervals)

 

RESURRECTED (performed event, then didn't, then did it again in the most recent interval)

DORMANT (performed key event in previous usage interval, but did not in the current one)

And notice how I did rolling range with all the dates so that it's regularly looking for users who meet that criteria!

 

hope this helps! —

View original

1 reply

Userlevel 1
Badge

Hey @sharod,

 

Here's an example of the cohort builder for a new user cohort. Here are the assumptions for this example:

1. The key event that matters to me for this product is "Watch Video".

2. The usage interval that aligns with this product is 7 days.


Based on that, I define new users a someone who performed "Watch Video" in the last 7 days (that's A in the screenshot below), but did NOT perform "Post video" between 14 and 7 days ago (B), or 21 to 14 days ago (C).

The whole point of B and C is just to make sure that this is actually a new user. So depending on your use case, you B and C could be longer. The main thing would be to avoid accidentally counting a user that was active a long time ago and then came back, cause you'd wanna put that user into a resurrected cohort, not a new user one.

 


For my product here, I don't think I have any users who were around before April 23rd of this year, so I don't have to worry about that.

 

Here are some screenshots of how I would define the other cohorts with the same key event and usage interval:

 

RETAINED (perform event in two consecutive intervals)

 

RESURRECTED (performed event, then didn't, then did it again in the most recent interval)

DORMANT (performed key event in previous usage interval, but did not in the current one)

And notice how I did rolling range with all the dates so that it's regularly looking for users who meet that criteria!

 

hope this helps! —

Reply