Hi Daniel C., 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 total average time spent in the app per user using Mixpanel, you can follow these steps: 1. Use the "Session Duration (seconds)" property that comes with each Session event.
2. Create an Insights report.
3. Select the "Session Start" event.
4. Change the measurement from "Total" to "Aggregate Property".
5. Choose "Session Duration (seconds)" as the property.
6. Select "Sum" as the aggregation type.
7. Change the measurement from "Total" to "Average per User".This will give you the average total time spent in the app per user across all their sessions.For a more detailed explanation, you can refer to the Sessions documentation, which provides examples of how to analyze session duration.Additionally, if you want to express the result in minutes instead of seconds, you can apply a formula to divide the result by 60, as mentioned in the Sessions FAQ.Remember that this method calculates the average across all users. If you need to analyze the distribution of time spent or look at specific user segments, you may want to use additional Mixpanel features like breakdowns or filters.
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.
