Solved

Time Tracking for Users

  • 27 July 2020
  • 9 replies
  • 559 views

Hello Team,
I want to track my website user engagement. Basically, i want to track user time spent on my website on a daily basis. And, I want to export those data on my system or my database.

Any help will be appreciated!

icon

Best answer by Peishan 18 August 2020, 09:14

Let’s see if the following works for you.

We capture session duration by default. So if you change your session definition to 24 hours, you’d be able to calculate the average user time spent. 

You can change the session definition if you’re a project owner or admin, under the project settings.

 

You can then run the following report in Insights to get the average duration: https://mixpanel.com/s/1dGIgd

 

Check out our API documentation to export the data into your data warehouse: https://developer.mixpanel.com/reference/data-export-api

View original

9 replies

Userlevel 3
Badge +1

Let’s see if the following works for you.

We capture session duration by default. So if you change your session definition to 24 hours, you’d be able to calculate the average user time spent. 

You can change the session definition if you’re a project owner or admin, under the project settings.

 

You can then run the following report in Insights to get the average duration: https://mixpanel.com/s/1dGIgd

 

Check out our API documentation to export the data into your data warehouse: https://developer.mixpanel.com/reference/data-export-api

@Peishan 

Your answer were very helpful for me too. 
In addition t@Sonakshi brought to the table, I would like to know if and how I’m able to see how much in average time was spent on a page.

 

What I was trying to do is to use the session duration and breakdown by pages, but for some reason it gave me empty report.
I did add a virtual page event and then adding the breakdown, but data seems to be off.
Any advise here? 

Userlevel 3
Badge +1

This is currently a gap unfortunately. We don’t have that much details for sessions yet. As of now, the detailed breakdown we have for events are Session Event Start Name and Session Event End Name: https://mixpanel.com/s/2PtEIx. But, keep watching this space. If we have any updates, we can let you know.

@Peishan 

Thankyou for the reply.

Is it possible to track per user average time spent in a day?

Userlevel 3
Badge +1

Yes - if you change the session timeout to 24 hours, then using this report I’d shared above, https://mixpanel.com/s/1dGIgd, you should get the per user average time spent a day.

 

Hi @Peishan

I have query related to session timeout set to 24 hours in Timeout Based approach.

  1. Does mixpanel keep track of user’s idle time as well?
  2. If a particular user open the same website in multiple tabs and does not perform any events in multiple tabs for some time and close the browser or individual tabs then in that case time from different tabs related to same website get added to particular user’s total time?

Thanks

Looking forward to your reply

Hi,

I am looking to report on average session length and total number of sessions to date per unique user, would I copy this Insights report and then a simple ‘session start’ one and filter each time by unique user ID or email, or is there an easier way? 

Also can we change session length to report in minutes instead of seconds?

Userlevel 3
Badge +1

Hi vikramsingh,

 

Sorry I missed your question earlier. Per our sessions definition, we don’t capture idle time. Let’s say you open a web page, and you click on certain links. Then you become idle. If you’re using a session time out definition of say 30 minutes, then after 30 minutes of inactivity, we take your session duration as the length of time from your first event triggered to the last event triggered (e.g. link click). Hope that helps.

Userlevel 3
Badge +1

Hi colcassPM,

 

You can do a breakdown by the userID / Email, like in this report: https://mixpanel.com/s/4AvtSw. However, please note that we have a limit of 10k rows in our reports. May I ask why you need this breakdown per unique user? Typically, we find that the information at the unique user level isn’t as actionable, and if you’re trying to regroup the data for further analyses, perhaps we can help?

 

Yes, you can change your session duration to minutes instead of seconds. You can use the formula bar to do that - e.g .https://mixpanel.com/s/2T5FhK

 

Hope that helps.

Reply


Mixpanel