How can I measure % of users doing [event] in 3+ different sessions per week
To measure the percentage of users doing a specific event in 3 or more different sessions per week in Mixpanel, you can use the following approach: 1. Use the Insights Report: In Insights, you can analyze events and break them down by session and time period.2. Set Up Your Query: - Select your target event (e.g., "Purchase", "Login", etc.). - Set the measurement to "Frequency per User" and choose "Sessions" as the unit. This will calculate how many sessions each user performed the event in. - Set the time range to "Weekly" to analyze per week.3. Apply a Filter or Breakdown: - Use a filter or breakdown to segment users by those who performed the event in 3 or more sessions within the week. - You can use the distribution or percentiles aggregation to see the count or percentage of users who meet this threshold.4. Calculate the Percentage: - The distribution view will show you how many users performed the event in 1, 2, 3, etc., sessions. From here, you can see the percentage of users who did the event in 3 or more sessions.Note: Mixpanel’s Insights report allows you to perform these calculations using the "Frequency per User" measurement, and you can aggregate by average, distribution, or percentiles to get the breakdown you need. The distribution aggregation is particularly useful for this use case, as it shows the number of users at each frequency level, allowing you to identify those with 3+ sessions per week Insights: Measurements.If you want to automate or further customize this analysis, you can use cohorts to group users who meet the "3+ sessions per week" criteria and then analyze their behavior further.Summary of Steps: - Go to Insights. - Select your event. - Set measurement to "Frequency per User" (Sessions). - Set time range to "Weekly". - Use distribution aggregation. - Identify users with 3+ sessions and calculate their percentage.If you need to export this data or automate the process, you can use the Mixpanel Query API to fetch frequency data and process it programmatically Query Frequency Report.Let me know if you need step-by-step UI instructions or API examples!
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 there is no (Sessions) option under Frequency per User measurement
Let me check the knowledge base for you again. One moment! 📚
Sorry Gabriel W., I'm currently experiencing some technical difficulties. Please try again in a few minutes. If this issue persists, please reach out to the administrators of this Slack workspace.