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,
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
- a distribution of how many users use my platform <1, 1-3, 3-5, 5-7 days a week (preferably showing which days they use)
- a 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
Best answer by Peishan
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!