How to Calculate Average Session Time Per User Per Week in Kapa.ai: Required Aggregations Explained
kapa.ai if i want to aptly calculate average session time per user per week, what are the aggregations i should apply?
kapa.ai if i want to aptly calculate average session time per user per week, what are the aggregations i should apply?
To calculate the average session time per user per week in Mixpanel, here's what you should do:
Step-by-step Setup in Insights
Select the Session Start (or Session End) event — Each session event comes with a "Session Duration (Seconds)" property that Mixpanel computes automatically. [Sessions use cases]
Use "Aggregate Property per User" → "Sum" — This will sum up all session durations for each individual user within the time period. [Sessions FAQ]
Set the outer aggregation to "Average" — This then averages those per-user sums across all users, giving you the average total session duration per user. [Sessions FAQ]
Set the time unit to "Week" — In the date picker, set the granularity to weekly so the calculation is performed per week interval. In Insights, for a line chart, the behavioral property computation is done on a per-interval basis, meaning each weekly interval will be calculated independently. [Computed Properties]
Optionally convert to minutes — Since the property is in seconds, you can apply a formula dividing by 60 to express the result in minutes. [Sessions FAQ]
Summary of Aggregations
Layer | Setting |
Measurement | Aggregate Property per User |
Property | Session Duration (Seconds) |
Per-user aggregation | Sum |
Outer aggregation | Average |
Time unit | Week |
This approach first sums each user's session durations within a week, then averages those sums across all users — giving you a meaningful "average session time per user per week" metric.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai how to get the average number of sessions per week for an event?
To get the average number of sessions per week that contain a specific event in Mixpanel Insights, here's what to do:
Steps in Insights
Select your event (e.g., "Product Purchase" or any event you want to analyze).
Change the measurement to "Sessions" — Click the Total drop-down beside the event and select Sessions. This counts the number of sessions that contained that event. [Session controls in reports]
Set the time unit to "Week" — This gives you session counts broken down per week.
To get the average sessions per user per week, instead use "Aggregate Property per User" → "Frequency per User" on the Session Start event, with the outer aggregation set to Average, and the time unit set to Week. [Measurements]
Which "average" do you need?
Goal | Approach |
Average sessions per week (total, not per user) | Select Session Start event → Total → set unit to Week, then observe the weekly trend |
Average sessions per user per week | Use Frequency per User on Session Start → outer aggregation: Average → unit: Week |
Sessions containing a specific event per week | Select your event → change measurement to Sessions → unit: Week [Session controls in reports] |
Choose the approach based on whether you want sessions across all users in aggregate, or averaged down to a per-user level.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.