How do I get the average number of sessions per user per day using the session start event?
Hi Josh N., 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 get the average number of sessions per user per day using the Session Start event in Mixpanel, follow these steps: 1. Go to the Insights report in Mixpanel. 2. Select the "Session Start" event as your event of interest. 3. Change the measurement from the default (usually "Total Events" or "Unique Users") to "Frequency per User". This will calculate the number of sessions (Session Start events) per user. 4. Set the time interval to "day" to get daily values. 5. Choose the aggregation as "Average" to see the average number of sessions per user per day.This setup will show you, for each day, the average number of sessions (Session Start events) initiated per user.You can further break down or filter this by properties if needed, such as by user segment or device type. The "Frequency per User" measurement in Insights is specifically designed for this type of analysis, and the default aggregation is "Average," which is what you want for this metric. You can also use formulas if you need to customize the calculation further.For reference, see the documentation on measurements and aggregations in Insights, particularly the "Frequency per User" function and its aggregation options, which include average, distribution, median, percentiles, minimum, and maximum. This approach is also mentioned in the context of session analysis in Mixpanel reports Docs / Reports / 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.