To calculate the Average Sessions per User per Month in Mixpanel, follow these steps: 1. Create an Insights Report.
2. Select the "Session Start" event as your metric. This event marks the beginning of each session.
3. Set the time interval to "Month" to group your data by month.
4. Change the measurement to "Frequency per User". This will calculate the number of sessions (Session Start events) per user.
5. Choose the aggregation "Average". This will give you the average number of sessions per user for each month.This approach uses Mixpanel’s "Frequency per User" measurement, which is designed to answer questions like "How many sessions did each user have?" and then aggregates that by average to get the result you want. You can further break down or filter by user properties if needed.Reference:
You can find more details about these measurement options and aggregations in the Mixpanel documentation: Insights: Measurements and Session Controls in Reports.
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.