📊 MoovBuddy Analytics Dashboard

A comprehensive analytics dashboard for conversion and monetization optimization analysis across 7 countries.

🎯 Project Overview

This dashboard analyzes your mobile app's performance data including:

• Conversion Rates: User journey from LaunchScreen → EmailEntered → PaymentSuccessful
• Revenue Forecasts: Projected revenue for 1, 3, and 6-month subscriptions
• User Retention: 30-day retention metrics by country
• Pricing Strategy: Transaction volume and pricing analysis
• Performance Insights: Key metrics and optimization recommendations

🚀 Quick Start

Prerequisites

• Python 3.8 or higher
• pip (Python package installer)

Installation

1. Clone or download the project files

   # Make sure you have the following files in your directory:
   # - dashboard.py
   # - requirements.txt
   # - README.md

2. Install dependencies

   pip install -r requirements.txt

3. Run the dashboard

   streamlit run dashboard.py

4. Open your browser

   • The dashboard will automatically open at http://localhost:8501
   • If it doesn't open automatically, manually navigate to the URL

📊 Dashboard Features

🎯 Key Metrics

• Total Revenue Forecast: $276,430 across all countries
• Average Conversion Rate: 0.34% across all subscription periods
• Average 7-Day Retention: 11.1% across all countries
• Total Transactions: 384 across all countries

📈 Analysis Sections

1. Revenue Analysis

   • Revenue forecast by country
   • Revenue distribution pie chart
   • Interactive filtering by country

2. Conversion Rate Analysis

   • Conversion rates by subscription period (1, 3, 6 months)
   • Grouped bar charts for easy comparison
   • Percentage-based visualization

3. User Retention Analysis

   • Retention rate heatmap
   • Retention trends over time (Day 1, 7, 30)
   • Country-wise retention comparison

4. Pricing Strategy Analysis

   • Average price by country (USD equivalent)
   • Transaction volume analysis
   • Currency and pricing insights

5. Performance Insights

   • Top performing countries
   • Optimization opportunities
   • Actionable recommendations

🔧 Interactive Features

• Country Filter: Select specific countries to analyze
• Responsive Design: Works on desktop and mobile
• Real-time Updates: Charts update based on filter selections
• Detailed Data Tables: Raw data available in tabbed format

📋 Data Sources

The dashboard analyzes data from your CSV files:

• Conversion Rates for 7 Countries. (3).csv
• Price per Product in 7 Countries. (2).csv
• Retension table for the 7 countries in the interval of 1,3,7,14 and 30 days.csv
• Revenue forecasted for 1 months, 3 months & 6 months (1).csv

🎯 Key Insights

🏆 Top Performers

• United States: Highest revenue ($99,057) and transaction volume (171)
• Switzerland: Best 1-month conversion rate (6.57%)
• Germany: Strongest Day 1 retention (45.45%)
• United Kingdom: Second highest revenue ($77,961)

📊 Optimization Opportunities

• India: Low conversion rates but high market potential
• Spain: Low transaction volume, needs pricing optimization
• Switzerland: High conversion but low volume - expand marketing
• Germany: Strong retention, expand marketing efforts

🛠️ Technical Details

Built With

• Streamlit: Web application framework
• Plotly: Interactive charts and visualizations
• Pandas: Data manipulation and analysis
• NumPy: Numerical computing

Features

• Modern UI: Gradient cards and professional styling
• Interactive Charts: Hover effects and zoom capabilities
• Responsive Layout: Adapts to different screen sizes
• Data Caching: Optimized performance with cached data loading

📱 Usage Tips

1. Filtering: Use the sidebar to select specific countries for focused analysis
2. Charts: Hover over chart elements for detailed information
3. Tables: Use the tabbed interface to view raw data
4. Insights: Check the recommendations section for actionable insights

🔄 Data Updates

To update the dashboard with new data:

1. Replace the data in the load_data() function in dashboard.py
2. Restart the Streamlit application
3. The dashboard will automatically refresh with new data

📞 Support

For questions or issues:

1. Check that all dependencies are installed correctly
2. Ensure Python 3.8+ is being used
3. Verify that all required files are in the same directory

📊 Dashboard Screenshots

The dashboard includes:

• Modern gradient metric cards
• Interactive bar charts and pie charts
• Retention heatmaps and line charts
• Pricing analysis visualizations
• Detailed data tables with filtering

---

Data Period: 2024-07-29 to 2025-07-29
Countries Analyzed: United States, United Kingdom, India, Italy, Spain, Germany, Switzerland
Total Revenue Forecast: $276,430
Total Transactions: 384