Add Metric: Average Time Spent on App per Active User
I want to add metric in my board of Average time spent on APP: Total time spent on the app per active user of that day/week/month
I want to add metric in my board of Average time spent on APP: Total time spent on the app per active user of that day/week/month
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 add a metric for "Average time spent on APP: Total time spent on the app per active user of that day/week/month" in your Mixpanel board, you should use the "Session Duration (seconds)" property, which is automatically computed by Mixpanel for each session.Here's how you can set this up in Mixpanel: 1. Go to Insights Report: Create a new Insights report. 2. Select the Event: Choose the "Session Start" event. 3. Aggregate Property: Use the "Average" aggregation on the "Session Duration (seconds)" property. This will give you the average session duration across all sessions. 4. Per User Calculation: If you want the average total time spent per active user (e.g., DAU/WAU/MAU), use the "Aggregate Property per User" function. Select "Sum" for "Session Duration (seconds)" per user, then aggregate by "Average." This will sum the session durations for each user in the selected time period and then average across all active users. 5. Convert to Minutes (Optional): If you want the result in minutes, use a formula to divide the value by 60.This approach will give you the average total time spent on the app per active user for the selected time frame (day, week, or month). You can adjust the date range in the report to view DAU, WAU, or MAU as needed.References: - How to find average session duration and average session duration per user in Mixpanel - Aggregate Property per User in Insights - Sessions feature overviewThis setup will allow you to track and display the average time spent on your app per active user directly on your Mixpanel board.
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.