Creating User Cohorts: Continuous vs. Ad-Hoc Activity X Analysis

Nadeesha E. · 2025-01-09T20:06:44.388Z

Team, I want to identify both continuous users and ad-hoc users for my product based on a specific event, let's call it X. • *Continuous users*: These are users who have performed activity X consistently every month starting from their initial month. • *Ad-hoc users*: These are users who have performed activity X sporadically or in non-consecutive months starting from their initial month. how can I create 2 cohorts for this purpose ? I tried several things but no luck

Creating User Cohorts: Continuous vs. Ad-Hoc Activity X Analysis | Mixpanel Community

14 comments

· Sorted by Oldest

Nadeesha E.
·
·
Andrew S. will you be able to help me with this one ? its been while I requested this. please . Thanks in advance.
Nadeesha E.
·
·
I couldnt find anything similr being answered in other community forums
Andrew S.
·
·
this is the only thing I could come up with for getting close.
Loading attachments
Andrew S.
·
·
It is finding users who rated a product in 12 distinct months during the past 12 months. (would have to make it 24 if past 24 months). Issue is that it misses users who may have done 6 distinct months in the prior 6 months.
Andrew S.
·
·
You can do retention graphs like this, which would let you see the users at different points who satisfy the retention, but it's not really what you want.
Loading attachments
Nadeesha E.
·
·
yes , It cant miss the users who have done continuously 6 months since they login as they have been continuously using the product since then . we are using the retention graphs as u have specified. however I want to see other product metrics against those continuous users vs rest of the product users to compare and contrast. thats why I want to create a cohort for that group , so that i can use it as a breakdown for all other reports on the metrics
Andrew S.
·
·
can you get comfortable with some sort of shorter time period and use my first example with <12 months. Like who did X at least 1x each month for 3 months or 4 months?
Nadeesha E.
·
·
I will try that
Nadeesha E.
·
·
thats a good suggestion
Andrew S.
·
·
The other suggestion, to consider going forward (not backwards), you could have your back end do the analysis for whether a user registered X every month since created_at. And you could then have a boolean for your user profile that passes with your mixpanel data logging for "consistent: true" or whatever you want it to be. if they fall out (did it every month for 5 months but then not the 6th), then they would be "false". You could then do a simple cohort of users where consistent=true.
Nadeesha E.
·
·
I created the cohort , however seems its not picking the conditions - did X at least 1x EACH MONTH. my main criteria for continuous users are that they must have performed it EACH MONTH. the final results are similar whatever the criteria used. It just count users who have performed X and not check EACH MONTH.
Loading attachments
Andrew S.
·
·
in the first image change it to 6 not 1
Andrew S.
·
·
so you want the distinct count of the months = 6 in the past 6 months
Andrew S.
·
·
your first image is basically finding people who did the event in at least 1 month in the past 6 months

Nadeesha E.
·
·
Andrew S. will you be able to help me with this one ? its been while I requested this. please . Thanks in advance.
Nadeesha E.
·
·
I couldnt find anything similr being answered in other community forums
Andrew S.
·
·
this is the only thing I could come up with for getting close.
Loading attachments
Andrew S.
·
·
It is finding users who rated a product in 12 distinct months during the past 12 months. (would have to make it 24 if past 24 months). Issue is that it misses users who may have done 6 distinct months in the prior 6 months.
Andrew S.
·
·
You can do retention graphs like this, which would let you see the users at different points who satisfy the retention, but it's not really what you want.
Loading attachments
Nadeesha E.
·
·
yes , It cant miss the users who have done continuously 6 months since they login as they have been continuously using the product since then . we are using the retention graphs as u have specified. however I want to see other product metrics against those continuous users vs rest of the product users to compare and contrast. thats why I want to create a cohort for that group , so that i can use it as a breakdown for all other reports on the metrics
Andrew S.
·
·
can you get comfortable with some sort of shorter time period and use my first example with <12 months. Like who did X at least 1x each month for 3 months or 4 months?
Nadeesha E.
·
·
I will try that
Nadeesha E.
·
·
thats a good suggestion
Andrew S.
·
·
The other suggestion, to consider going forward (not backwards), you could have your back end do the analysis for whether a user registered X every month since created_at. And you could then have a boolean for your user profile that passes with your mixpanel data logging for "consistent: true" or whatever you want it to be. if they fall out (did it every month for 5 months but then not the 6th), then they would be "false". You could then do a simple cohort of users where consistent=true.
Nadeesha E.
·
·
I created the cohort , however seems its not picking the conditions - did X at least 1x EACH MONTH. my main criteria for continuous users are that they must have performed it EACH MONTH. the final results are similar whatever the criteria used. It just count users who have performed X and not check EACH MONTH.
Loading attachments
Andrew S.
·
·
in the first image change it to 6 not 1
Andrew S.
·
·
so you want the distinct count of the months = 6 in the past 6 months
Andrew S.
·
·
your first image is basically finding people who did the event in at least 1 month in the past 6 months