how to see total time spent on a app of a user.
Hi Abhijeet S., 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 see the total time a user has spent on your app in Mixpanel, you should use the "Session Duration (seconds)" property, which is automatically computed for each session. To get the total time spent by a specific user, you can aggregate (sum) the "Session Duration (seconds)" across all their sessions.Here's how you can do this in Mixpanel: 1. In an Insights report, select the "Session End" event (or "Session Start" if you prefer). 2. Use the "Session Duration (seconds)" property as your measurement. 3. Choose the "Aggregate Property per User" function and select "Sum" to get the total session duration per user. 4. Optionally, divide by 60 in a formula to convert seconds to minutes.This will give you the total time spent by each user in your app. You can filter for a specific user if needed.For more details, see the Mixpanel documentation on session properties and aggregation options: Session Properties FAQ: Average Session Duration Insights Measurements
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 what should i select in select aggregation ?
Let me check the knowledge base for you again. One moment! 📚
To see the total time spent on the app by a user, in the aggregation step, you should select Sum under the "Aggregate Property per User" measurement for the "Session Duration (seconds)" property. This will sum up all session durations for each user, giving you the total time spent per user.If you want to convert the result from seconds to minutes, you can use a formula to divide the sum by 60.This approach is confirmed in the documentation:
"If you select 'Aggregate Properties per User' and then 'Sum', it will add up all Session Lengths for any given day and divide it by all unique users."
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.
how to do second step. 2. Use the "Session Duration (seconds)" property as your measurement. kapa.ai
Let me check the knowledge base for you again. One moment! 📚
To use the "Session Duration (seconds)" property as your measurement in Mixpanel Insights: 1. Start a new Insights report. 2. Select the "Session End" event (or "Session Start" event). 3. In the measurement dropdown (usually defaults to "Unique Users" or "Total"), select "Aggregate Property per User". 4. When prompted, choose "Session Duration (seconds)" as the property to aggregate.This property is automatically available on session events and represents the duration of each session in seconds. You can then proceed to select your aggregation (e.g., "Sum") to get the total time spent per user Session Properties Aggregate Property per User.If you do not see "Session Duration (seconds)" in the property list, ensure you are selecting a session event ("Session Start" or "Session End"), as this property is only attached to those events.
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.