I have a funnel metric that looks at average session length (Session Start -> Session End), but the metric is average time to convert. I just want to know what the overall average session length is per user.
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 overall average session length per user, use Insights with Sessions’ computed properties instead of a funnel: - In Insights, select the Session Start (or Session End) event. - Choose Measurement: Aggregate Property per User. - Pick property: Session Duration (seconds). - Choose aggregation: Sum (this sums each user’s session durations), then change the final aggregation to Average to get the average per user. Optionally divide by 60 in a formula to show minutes. (Aggregate Property per User; Sessions FAQ – average session duration per user)Notes: - Funnels’ “Time to Convert” is for step-to-step conversion time and isn’t meant for “average session length per user” (it aggregates per conversion, not per user) (Counting Methods and Measurements; Time to Convert).
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! 📚
In Insights: 1) Add metric: choose Session Start (or Session End). 2) Click the measurement dropdown (defaults like “Total” or “Unique Users”) and select “Aggregate Property per User.” 3) You’ll be prompted to select a property; choose “Session Duration (Seconds).” Then set the aggregation to Sum, and the final aggregation to Average. Optionally add a Formula to divide by 60 to show minutes (use “/ 60”). (Aggregate Property per User; Measurements overview; Sessions FAQ – average per user; Session properties – duration)
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! 📚
You’re in the right place—Mixpanel’s flow for “Aggregate Property per User” asks you to pick the aggregation first, then the property. After you choose “Aggregate Property per User,” select the function (e.g., Sum), and then you’ll be prompted to pick the event property (choose “Session Duration (Seconds)”). Finally, set the outer aggregation to Average. If you want minutes, add a Formula to divide by 60 (/60) (see “Aggregate Property per User” and Measurements flow) (Aggregate Property per User; Measurements; Session Properties; Sessions FAQ).
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. Use a Formula to convert seconds to minutes: - In Insights, after you’ve built the metric, click +Formula and divide the metric by 60 (e.g., A / 60). This just changes the display from seconds to minutes. (Formulas) - This is the recommended approach since Session Duration is provided in seconds on Session Start/End; converting via formula is documented in the Sessions FAQ. (Sessions FAQ; Session Properties)
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! 📚
Short answer: almost—swap the inner aggregation to “Sum per user,” then use the outer aggregation “Average.”How to set it: - Metric: Session Start (or Session End) - Measurement: Aggregate Property per User - Aggregation inside the modal: Sum - Property: Session Duration (Seconds) - Outer aggregation (top of chart): AverageThis computes each user’s total session duration over the period (Sum per user), then averages those totals across users, which is “average session length per user” for the selected date range. To show minutes, add a Formula dividing by 60 (e.g., A/60) (Aggregate Property per User; Measurements; Session properties; Formulas; Sessions FAQ).
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.
