Flipkart Analytics

Advertising Performance Dashboard

Sep 2024 - Aug 2025

Total Ad Spend

₹69,171
lacs
12 months

Average MAU

280M
users
-1.1% MoM

Best Platform

Hotstar
15.92x efficiency
Top ROI

YouTube Share

82%
of total spend
Rebalance needed

Channel Performance Overview

ROI Efficiency by Channel

Current vs Recommended Allocation

Monthly Trends & Correlations

Total Spend
MAU

Key Insights & Recommendations

Budget Reallocation Opportunity

Hotstar shows 15.92x efficiency vs YouTube's 0.15x. Reallocating 50% of YouTube budget to Hotstar could increase overall ROI by 300%.

Hotstar Performance Excellence

Hotstar delivers the highest MAU per rupee spent (15.92), making it the most cost-effective channel for user acquisition.

YouTube Efficiency Concern

YouTube shows negative correlation (-0.46) between spend and MAU growth, suggesting diminishing returns or ad fatigue.

TV Advertising Stability

TV shows moderate positive correlation (0.21) with steady efficiency, suitable for brand awareness campaigns.

Strategic Recommendations

High Priority

Immediate Budget Reallocation

Shift 40-50% of YouTube budget (₹22,673 lacs) to Hotstar to maximize efficiency and ROI.

Expected Impact: +300% ROI
Medium Priority

YouTube Strategy Optimization

Investigate ad fatigue and audience saturation. Consider creative refresh or audience expansion.

Expected Impact: Efficiency Recovery
Low Priority

TV Campaign Scaling

Gradually increase TV spend during peak seasons to leverage its stable performance for brand building.

Expected Impact: +15% Brand Reach