Calculating Video Watch Percentage per User per Week

Hi Akshay J., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

To calculate what percentage of users watch videos 3 days a week in Mixpanel, you can use the Retention report with frequency criteria. Here's how to do it: 1. Use the Retention report in Mixpanel, which is designed to help you assess user engagement over time.2. Switch to the Frequency mode in the Retention report. As mentioned in the documentation, this allows you to "visualize retention trends over time using frequency mode, which can answer questions like: 'What percent of users performed an action on four days last week?'" Why marketers should choose Mixpanel over Google Analytics 4 (GA4)3. Set up your frequency criteria to calculate users who did the video watching event on exactly 3 unique days in your desired time period (a week). According to the documentation, you can "Filter to users that watched a video on at least 3 unique days in the previous 30 days" Cohorts: Group users by demographic and behavior4. For the specific time window, you can use the "Understanding Frequency Criteria" feature which lets you "Define retention analysis to calculate users who did the event in at least X unique intervals or in exactly X unique intervals." Track User RetentionThe Frequency report in Mixpanel will show you the distribution of users based on how many days they performed the specified action (watching videos), allowing you to see what percentage of your users watch videos on exactly 3 days per week.For a deeper analysis, you could also create a cohort of these users and use it in other reports to understand their behavior better.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.