Looking at Daily Active Users report, what's the best way to view number of sessions per user during a given day, potentially viewing them as buckets, ie 1-5 sessions on a given day, 5-10 etc?
Hi Shane, 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 view the number of sessions per user during a given day and bucket users by session count (e.g., 1–5, 6–10 sessions, etc.), you can use Mixpanel’s Insights report with the following approach:
1. Aggregate Sessions per User: In Insights, select the “Session Start” event. Then, use the “Frequency per User” measurement. This will calculate the number of sessions each user had during the selected day.
2. Apply Bucketing to Session Counts: After calculating sessions per user, use the custom buckets feature to group users into desired session count ranges (e.g., 1–5, 6–10, etc.). You can do this by adding a breakdown on the session count property and then customizing the buckets to your preferred ranges. Mixpanel allows you to define even or varied bucket sizes for numeric properties, which is ideal for this use case. For example, you can set buckets as 1–5, 6–10, 11–20, etc. - To do this: Add a breakdown on the session count property, open the custom buckets modal, and define your bucket ranges. Apply the changes to see users grouped by session count buckets[Custom Buckets][Numeric property Use Cases].
3. Set the Date Range to a Single Day: Make sure your Insights report is filtered to the specific day you want to analyze, so the session counts are calculated per user for that day.
Summary of Steps in Mixpanel UI: - Go to Insights. - Select “Session Start” as the event. - Choose “Frequency per User” as the measurement. - Set the date range to the desired day. - Add a breakdown on the session count property. - Use custom buckets to group users by session count ranges.
This will give you a clear view of how many users had 1–5 sessions, 6–10 sessions, etc., on a given day.
For more details on custom bucketing and aggregating per user, see the documentation on Custom Buckets and Numeric property Use Cases.
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.
Let me check the knowledge base for you again. One moment! 📚
Yes, "Distribution" is the correct option to select if you want to see how users are distributed across different session count buckets (e.g., 1–5, 6–10 sessions per user). When you use "Frequency per User" as your measurement in Insights, the "Distribution" aggregation will show you the number of users who fall into each session count range. You can then apply custom buckets to group these counts as needed[Additional Aggregation Option Examples][Aggregate Property per User].
So, to bucket users by their number of sessions per day, select "Frequency per User" and then "Distribution" as the aggregation option.
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.
Let me check the knowledge base for you again. One moment! 📚
If the "session count" property does not appear under Breakdown, you can still achieve your goal by using the Frequency per User measurement with the Distribution aggregation in the Insights report. This approach will show you how many users had 1, 2, 3, etc., sessions during the selected time period.
Here’s how you can proceed:
1. Select the "Session Start" event in your Insights report. 2. Choose "Frequency per User" as the measurement. 3. Set the aggregation to "Distribution". This will display the distribution of users by the number of sessions they had in the selected period. 4. Set your date range to the specific day you want to analyze.
This method does not require a separate session count property, as "Frequency per User" directly calculates the number of sessions per user for the chosen event and time period. You can then visually interpret or export the distribution to see how many users fall into each session count bucket (e.g., 1–5, 6–10 sessions, etc.)[Aggregate Property per User][Measurements].
If you want to further group these counts into custom buckets (like 1–5, 6–10), you can use the Custom Buckets feature on the distribution chart, if available for your property type[Custom Buckets].
If you do not see the option to create custom buckets, or if the property is not available for bucketing, the knowledge sources do not provide an alternative built-in method for bucketing session counts per user in the UI. In that case, you may need to export the data and bucket it externally.
Let me know if you need more details on any of these steps.
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 was able to achieve this by selecting Customize Range so I could set the interval to 1 instead the default of 5. The next task I have is to calculate the % of 1..2…times users from the DAUs for the month. For example if DAUs are 40K and 30K had 1 session then the % is 75%. Adding a formula to which divides Sessions / DAU (A/B) returns 0. Is it possible to apply a formula on Frequency Distribution and buckets and if not, is there an alternative way to do this?
Let me check the knowledge base for you again. One moment! 📚
I'm sorry, but the knowledge sources do not explicitly mention the ability to apply formulas directly to the results of a Frequency Distribution or custom buckets in Mixpanel Insights. While you can use formulas to combine metrics (such as dividing one metric by another), formulas in Mixpanel are designed to operate on top-level metrics (like DAU, WAU, event counts, etc.), not on the output of a distribution or bucketed breakdown[Formulas in Insights].
As a result, you cannot directly create a formula that divides the number of users in a specific frequency bucket (e.g., users with 1 session) by the total DAU within the Mixpanel UI. The formula feature does not support referencing the results of a breakdown or bucketed distribution as variables in a formula.
Alternative Approach: The knowledge sources suggest that if you need to calculate the percentage of users in a specific session frequency bucket (e.g., 1 session) out of the total DAU, you may need to: - Export the distribution data (number of users per session count) and the DAU metric. - Perform the percentage calculation externally (e.g., in a spreadsheet).
If you need to automate this within Mixpanel, the current documentation does not provide a built-in way to do so directly in the UI.
If you have further questions or need help with exporting data, let me know!
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.
