To measure how much time your users spend watching videos each week in Mixpanel (for a media product), you should use the Aggregate Property measurement in an Insights report. Specifically, you want to sum the "watch time" property (e.g., "watch time (mins)" or "Duration") for your "Video Watched" event, and set your time interval to "Week".
Here’s how you can do it:
1. Create an Insights report.
2. Select the "Video Watched" event.
3. Choose the "Sum" aggregation for the "watch time" property (or whatever property tracks video duration).
4. Set the time interval to "Week" to see the total watch time per week.
This will show you the total amount of time (e.g., in minutes) that all users spent watching videos each week. If you want to see the average per user, you can use the "Aggregate Property per User" measurement and select "Average" as the aggregation option.
For example:
- Sum of watch time (mins) per week: Total time spent by all users.
- Average watch time (mins) per user per week: Average time spent by each user.
You can further break down this data by user segments or other properties if needed.
References:
- Aggregate Property in Insights
- Aggregate Property per User in Insights
- Numeric property use cases (e.g., watch time)
