Setting Up a User Cohort in the 90th Percentile of Events
I want to set a cohort of users who are in 90th percentile of that specific event. How should I set it up?
Hi Alina B., 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 in the 90th percentile for a specific event in Mixpanel, you can use the Cohort Builder feature. Here's how you can set it up:1. Go to the Cohort Builder in Mixpanel.2. In the Cohort Builder, you'll want to use the "Aggregate Property" measurement, which allows you to calculate percentiles.3. Set up your cohort filter with the following criteria: - Select the specific event you're interested in - Choose "Aggregate Property" as the measurement - Select the event property you want to measure (if applicable) - Choose "Percentiles (P25,P75,P90,P99)" as the aggregation option - Set the condition to be greater than or equal to the 90th percentile4. Specify the time range for your analysis (e.g., last 30 days)5. Save and name your cohortThis approach leverages Mixpanel's ability to calculate percentiles for event properties, as described in the Aggregate Property documentation. The 90th percentile option is specifically mentioned as one of the available percentile calculations.By setting up the cohort this way, you'll be creating a group of users who performed the selected event at a level that puts them in the top 10% of all users for that particular event or property.Remember that cohorts in Mixpanel are dynamic by default, meaning they will update automatically as user behavior changes over time. This ensures your 90th percentile cohort remains current.
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.
Alina B.··I don't have an option to calculate percentile from the Cohort builder