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.
Let me check the knowledge base for you again. One moment! 📚
Pick this sequence: - Measurement: Aggregate Property per User - In the modal: - Choose “Sum” (this is “sum of the property values per user”) - Property: Session Duration (Seconds) - Outer aggregation: AverageThis yields “sum of Session Duration per user” over the period, then averages across users = average session length per user. If you want minutes, add a Formula dividing by 60 (A/60) (Aggregate Property per User; Measurements; Session Properties; Sessions FAQ; Formulas).
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! 📚
Because Aggregate Property computes across all events, not per user. Session Duration (seconds) lives on each Session event; using Aggregate Property → Average would average all session events in the window (weighted by number of sessions), which answers “average session length per session,” not “per user.” Aggregate Property per User first aggregates the property per user (e.g., Sum of Session Duration per user over the period) and then lets you Average those user-level values, which yields “average session length per user” (Measurements; Aggregate Property; Aggregate Property per User; 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! 📚
A few checks that commonly inflate this metric: - You’re averaging “sum of Session Duration per user,” not “average session length per user.” If a user has many sessions, their total time will be large. That’s expected. To get average session length per user, use Aggregate Property per User → Average (property: Session Duration (seconds)), then set the outer aggregation to Average. This computes each user’s average session length first, then averages those user averages across users (rather than summing). Divide by 60 with a Formula to show minutes (A/60) (Aggregate Property per User; Measurements; Sessions FAQ).- Confirm your Sessions configuration and timeout. Very long sessions can result if the timeout is high, or if background/automated events keep sessions alive. Sessions also reset at midnight, which caps max duration at 24h but can still skew averages if sessions run long before reset (Sessions – How Sessions Work; Timeout-Based Sessions; Examples).- Consider filtering out non-user-action events that may extend sessions (e.g., periodic background pings), as recommended when estimating session length (Session Computation Deep-Dive).Quick setup to match “average session length per user”: - Event: Session Start (or Session End) - Measurement: Aggregate Property per User → Average - Property: Session Duration (seconds) - Outer aggregation: Average - Formula: A/60 (minutes)If you truly want “average session length per session” (not per user), use Aggregate Property → Average on Session Duration (seconds) instead (Aggregate Property).
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. In Insights you can add a Formula metric (e.g., A/60) and hide the underlying metric(s): - Add your base metric (Session Duration), then click +Formula and create the minutes conversion (e.g., A/60). (Formulas) - Hide the base metric by collapsing its block and toggling visibility off (eye icon) so only the formula shows in the chart/table. You can also rename the formula to “Avg Session Length (min)” for clarity. (Insights basics; Chart customization – metric units/name)
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.
