2.2 problem solving

Current Problem Overview

  • Revenue Decline: Advertising revenue has decreased by 35% over the last 8 weeks.

  • Active Users Drop: Active user engagement has decreased by 43%, contributing to the decline in revenue.

  • Cause of Revenue Loss: Fewer active users lead to less ad visibility, resulting in lower ad revenue.

Future Goals

  • Understand Revenue Drop: Investigate reasons behind the decline in advertising and active users.

  • Dashboards for Monitoring: Develop an interactive dashboard for real-time monitoring of ad revenue and active users, instead of delayed insights.

Bridging the Gap: Key Questions to Address

  1. Top Revenue-Contributing App Categories: Identify which app categories generate the most ad revenue to optimize focus for improvements.

    • Impact of Focus: Prioritizing revenue-generating categories can yield significant improvements where it matters.

  2. Reasons for Active User Decline: Analyze factors impacting user engagement.

    • New vs. Existing Users: Understand if the decline is due to a lack of new user acquisition or dropout of existing users.

    • Category Breakdown: Monitor engagement trends across different app categories to identify specific patterns.

  3. Ad Types Analysis: Evaluate the performance of different ad formats.

    • Short vs. Long Ads: Assess how different ad types impact revenue to determine if a shift has occurred in ad strategy.

    • Trends Over Time: Examine weekly performance trends to better understand the dynamics of revenue changes.

Data Analysis Necessity

  • Must utilize exploratory data analysis (EDA) to answer the above questions and generate actionable insights for restoring revenue and user engagement.