Solved

Session Frequency by day and Total Session Length by User by time period

  • 7 August 2020
  • 5 replies
  • 151 views

Hi,

I would’ve thought this would be easy to get or someone else would’ve asked but it seems not:

I’m looking at defining my User Segments by Usage Behaviour on my platform,
e.g

Daily Bitesize User - (users that spend ~30 minutes on the platform on weekdays)

Weekend Crammers - (users that spend 2-3 hours on the platform only at weekends)

 

I’d like to see

  • distribution of how many users use my platform <1, 1-3, 3-5, 5-7 days a week (preferably showing which days they use)
  • distribution of total session length by user per day (either total session length or distribution of session length and distribution of number of sessions per day)
  • if I can, the ability to then cross this data, such that I can define segments around how long they use the platform per day and how frequently over the week

I’ve tried playing around with the sessions although they seem restrictive to an average instead of a distribution

icon

Best answer by Peishan 18 August 2020, 08:41

Hi HRaven,

 

You can definitely answer these questions in Insights. Let’s tackle them one at a time.

 

Distribution of users who use your platform by days a week

We just released the date filter as a feature in in-line queries, so your question is timely! 

https://mixpanel.com/s/1CzQvS, for example, that 3.4k users use your platform 2 days a week.

 

Distribution of session length per user per day

Example report here.

 

Report on average duration spent by users who visit only 1 day a week vs. 2 days a week etc

This is a little trickier, but you can still leverage our Insights report for this. Here’s an example: https://mixpanel.com/s/1CVfF8

What I did here was to construct the average duration of users, filtered by cohorts of users who did the event 1x a week vs. 2 days a week etc.

 

Here’s how you could create those cohorts for use in your filters:

 

 

Hope that helps!

View original

5 replies

Userlevel 2
Badge

Hi HRaven,

 

You can definitely answer these questions in Insights. Let’s tackle them one at a time.

 

Distribution of users who use your platform by days a week

We just released the date filter as a feature in in-line queries, so your question is timely! 

https://mixpanel.com/s/1CzQvS, for example, that 3.4k users use your platform 2 days a week.

 

Distribution of session length per user per day

Example report here.

 

Report on average duration spent by users who visit only 1 day a week vs. 2 days a week etc

This is a little trickier, but you can still leverage our Insights report for this. Here’s an example: https://mixpanel.com/s/1CVfF8

What I did here was to construct the average duration of users, filtered by cohorts of users who did the event 1x a week vs. 2 days a week etc.

 

Here’s how you could create those cohorts for use in your filters:

 

 

Hope that helps!

That’s great thanks for sending that through! Definitely a lot closer to seeing something useful here. 

I see that the date range is ‘in the last seven days’, this will give me insight into what has happened over this past week, although wouldn’t be an accurate representation of a given week. 

  • Do you know if I’m able to aggregate a month, 3 months, 6 months of data into the ‘seven days’? 
    • such that I can see, during a seven day period, over the last 3 months on average users spent one day on the platform 30% of the time, 2 days on the platform 40% of the time,…

Thanks again

Userlevel 2
Badge

This is a sort of workaround, but I think allows you to get to understand the trend: https://mixpanel.com/s/4oaYFK

 

That doesn’t really solve it, I’d need to go through week by week and collate the data. 

That’s a shame, no worries - thanks for your help anyway

Peishan, I appreciate the help - I’ve found that you can add a Breakdown of Date > Day of Week https://mixpanel.com/s/NBPjb

Do you think there’s anything we can do with this to organise by week but aggregate over a large period of time? 

Thanks

Reply