Creating a User Cohort Based on Event Participation
Hi there, I would like to create a cohort of users who experienced at least X events in the Y days that followed their first Z event, is that possible?
Hi there, I would like to create a cohort of users who experienced at least X events in the Y days that followed their first Z event, is that possible?
Concretely: I would like to create a cohort of high call volume users, ie who experienced at least 30 end_of_call events in the 14 days that followed their first end_of_call event
Hi Alex, My name's Scott and I'm a Support Engineer at Mixpanel. Thanks for writing in — happy to help. It is possible to answer this question with Mixpanel but it requires some tweaking in the Funnels report. Before getting to that solution, you may be interested in a Cohort, like this: Inline Attachment: image.png Here, we're looking at users that performed an event a certain number of times during a certain period of time, and then did any other event a specified number of times. If that works for you, here are the steps to build that cohort: 1. Add a filter for your first event. In the example above, this is 'Clicked Mixpanel Link'. You can specify a time period ('Last 30 days') and a frequency ('Greater than or equal to'). 2. Add a filter for your second event, or select 'Any Event' if it doesn't matter which particular event they performed. Again, you can specify how many times to perform this event. If that doesn't quite get to the answer you're after, let's take a look at the Funnel report. Unless the X events in your example are specific events, you'll want to create a Custom Event made up of all of the events of interest. You would then use this custom event in the Funnels report, duplicating it as many times as you're interested in, like this: Inline Attachment: image.png In the Conversion Criteria, you'll update the 'Within 7 days' to reflect the Y number of days. Then, in the Funnels report itself, click on the Converted segment of the last funnel step and select View Users: Inline Attachment: image.png And, in the Users sidebar that appears, click the Create Cohort icon: Inline Attachment: image.png Cohorts created from Funnels can't be edited, but this should address your request. Does that help, Alex? Please let me know if I missed the mark, or if there's anything else I can help with. Sincerely, Scott MarinoffSupport Engineer II --------------------💬 Liked my support? Please share your feedback in the survey you'll receive soon.
the second screenshot does, I think, what you want: checks if the event happens X times within 7 days of the anchor event
Hey Fredo, Taking over for Scott here, I am Dorothy, and I'd be happy to help! Thank you for responding Vlad, I believe you are right! If you'd like to cover the following criteria: Y days that followed their first Z event, you can use our Funnels report. Inline Attachment: image.png You can update the Y value by updating the conversion window from "Within 7 days" to "Within Y days". Here is a sample funnels report using our demo dataset as reference: https://mixpanel.com/s/3H8GvC In this case, I have set the Y value as "3 days". You can then create the cohort by clicking the relevant segment on the Funnel, clicking "View Users" and click "Create Cohort". Please note that Cohorts created from Funnels can't be edited, but this should address your request. Here is our Funnels documentation for reference: https://docs.mixpanel.com/docs/reports/funnels/funnels-quickstart Would this work for you? Please let me know if you have any further questions! Warm regards,Dorothy Support Engineer @ Mixpanel | Singapore (GMT +8)
