Identifying Power Users: Charting User Actions Over a Week
kapa.ai I would like to compute a chart that finds my power users: the users that did action X at least 3 days during a given week. How could I do that ?
kapa.ai I would like to compute a chart that finds my power users: the users that did action X at least 3 days during a given week. How could I do that ?
Please stand by Laurent G. as I search the knowledge base. I normally take about 15 seconds or so. đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To compute a chart that identifies your power users—specifically, users who performed action X on at least 3 different days within a given week—you can use Mixpanel’s cohort and frequency analysis features: 1. Create a Cohort of Power Users: - Use the Cohort Builder to define a cohort with the condition: “Users who did [action X] on at least 3 unique days in the last 7 days.” - This leverages Mixpanel’s ability to filter users by event frequency over a time window. You can access the cohort builder from the query builder in any report by clicking “Create Custom > Cohort” and setting your criteria accordingly. This will allow you to save and analyze this group as your “power users” cohort Creating Cohorts.2. Visualize the Cohort Over Time: - In an Insights report, select your newly created power users cohort from the “Events and Cohorts” menu. This will generate a line chart showing the size of the cohort (i.e., number of power users) over time, so you can track trends week by week Using Cohorts in Analysis.3. Alternatively, Use Frequency View in Retention Reports: - Go to Reports > Retention, and select the Frequency option. - Set the event to [action X], the interval to “days in a week,” and use the cumulative frequency mode to see how many users did the event on at least 3 unique days in a week. This will show you the distribution of user engagement and help you identify your power users Frequency View.This approach will let you both identify and visualize your power users—those who are highly engaged with action X during any given week—in Mixpanel.
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.
kapa.ai I am not sure that this would work. I want to count, each week, the number of users who did X on 3 different days, but they aren't necessarily the same users each week.
Let me check the knowledge base for you again. One moment! đź“š
You're correct—if you want to count, for each week, the number of users who did action X on at least 3 different days (and the users can change week to week), you should use Mixpanel's Frequency View in the Retention report.Here’s how you can do it: 1. Go to Reports > Retention. 2. Select the Frequency option under the retention toggle. 3. Set the event to your action X. 4. Set the interval to "days in a week." 5. Choose cumulative frequency to see the number of users who did the event on at least X unique days. 6. Look for the value at 3 days—this will show, for each week, how many users did action X on at least 3 different days in that week.This approach will give you, week by week, the count of users who meet your "power user" criteria, regardless of whether they are the same users each week. The buckets in Frequency View measure the number of unique time buckets (in this case, days) a user was active within each week, which matches your requirement perfectly Frequency View.If you want to further analyze or segment these users, you can click on the relevant bucket to view or create a cohort for deeper analysis.Let me know if you need step-by-step UI guidance!
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.