Is it possible to research time spent on page? both sum and average ?
Best answer by cherise 11 September 2020, 00:55
In Mixpanel you can configure how you want to define a session in project settings > session settings. Sessions include the Session Start and Session End events which are virtual events calculated on Mixpanel's website based upon the session settings.
The length of the session is recorded on the Session Duration (Seconds) event property of the Session End event. To find the average session duration, you can aggregate the Session Duration (Seconds) event property on the Session End event and set the count as Average. The average Session Duration (seconds) is defined as total aggregated value of Session Duration (seconds) on the Session End event / total count of Session End events within the given time period (last 30 days).
Session Duration (Seconds)
Session Duration (seconds)
total aggregated value of Session Duration (seconds) on the Session End event
total count of Session End events within the given time period
The one caveat for measuring average session duration in this way is that the events that count towards a session is not restricted to events of a certain device type (iOS, Android, Web). It is looking at user's activity across all your platforms, if that can happen, but you can always play around with custom properties to narrow it down to specific platforms. I hope this is helpful!
If you need Time On Page from Mixpanel reports you can use the following approach as Mixpanel has a better option using Funnels and Time To Convert that we can use in this scenario.
Use the Funnel Report With Time To Convert.
Step 1 will be Page View/Screen View
Step 2 will be Page View/ Screen View
Breakdown will be Current URL of Step 1
Use Conversion Criteria to exclude the outliers or inactive users who came back the next day etc
Here is a screenshot of how you can built this report more accurately using Mixpanel Built-in Reports:
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.