how can I create a cohort of users who are the top 10% of users who login the most?
Hi David D., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To create a cohort of users who are the top 10% of users who login the most in Mixpanel, you can use the Cohort Builder. Here's how you can do it:1. Go to the Cohort Builder in Mixpanel.2. In the Cohort Builder, you'll want to set up a filter that captures users based on their login frequency. 3. You can use a filter similar to this: "Users who did 'login' more than X times in the last Y days", where X would be the threshold for the top 10% of users, and Y is your desired time frame.4. To determine the exact threshold for the top 10%, you might need to first analyze your login data in an Insights report to understand the distribution of login frequencies among your users.5. Once you've set up the filter, you can save this group as a cohort.This approach is based on the information provided in the Cohorts documentation. The document states:"The Cohort Builder lets you define cohorts based on a precise set of conditions. These conditions are either of the form 'Users who did <event>
more/less than <some threshold>
' or 'Users where <profile property>
is equal to/more/less than <value>
'."While the documentation doesn't provide an exact example for the top 10% of users, you can use the principles described to create a cohort that approximates this group based on login frequency.Remember that once you've created this cohort, you can use it in various Mixpanel reports to analyze the behavior of your most active users, as mentioned in the Using Cohorts in Analysis section of the documentation.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.