A growth manager at an online streaming service is tasked with creating a comprehensive dashboard that reflects various performance metrics to aid in content strategy decisions.
To accomplish this, the manager needs to guide the team on transforming and analyzing the raw data collected on user interactions, content views, and subscription details.
Consider the following sub-tasks required to prepare the KPIs:
- Sub-task I: Join user demographic data with the aggregated and normalized engagement metrics to segment the audience for targeted analysis.
- Sub-task II: Filter user data to focus on active subscribers and sort content by most viewed categories.
- Sub-task III: Aggregate the viewing times and subscription durations to calculate average engagement metrics.
- Sub-task IV: Normalize engagement metrics to ensure comparability across different time periods and content types.
What is the correct sequence of sub-tasks from first to last for effectively preparing the KPIs?