← Back to Portfolio

Nykaa E-Commerce Performance Analysis

Analyzing revenue, profitability, customer behavior, discount effectiveness, and product performance to uncover opportunities for growth and operational improvement.

Business Problem

Nykaa runs multiple marketing campaigns across different channels and customer segments. However, understanding which campaigns generate the highest return, which audiences respond best, and how engagement translates into conversions is critical for maximizing marketing effectiveness and revenue growth.

The objective of this analysis was to evaluate marketing performance, identify the most effective campaign channels, understand customer behavior, analyze engagement and conversion patterns, and provide actionable recommendations to improve future campaign performance.

Key Metrics

  • Total Acquisition Cost
  • Click-Through Rate (CTR)
  • Average ROI
  • Total Revenue
  • Engagement Score
  • Lead-to-Conversion Rate

Analysis Objectives

  • Evaluate overall marketing performance across campaigns.
  • Identify the most effective campaign channels.
  • Understand customer segment behavior.
  • Analyze engagement and conversion patterns.
  • Develop data-driven recommendations for future marketing strategies.

Overview of Performance

Overall campaign performance was strong, delivering positive ROI and significant revenue generation. While engagement and conversion metrics remained healthy, performance fluctuated across channels and time periods, suggesting opportunities for optimization.

Revenue trends showed noticeable declines followed by recovery periods, indicating that campaign effectiveness was not entirely stable throughout the analysis period.

Campaign Performance Insights

  • Influencer and Social Media campaigns generated the highest Return on Investment (ROI).
  • Email Marketing consistently delivered the highest conversion rates, making it the strongest channel for turning interest into customers.
  • Paid Advertising and SEO provided stable performance but did not outperform other channels in ROI or engagement.

Customer Segment Analysis

  • Working Women generated the highest overall revenue.
  • Premium Shoppers produced strong ROI, demonstrating high marketing efficiency.
  • Students and Youth segments contributed less revenue but showed promising growth potential.

Engagement and Conversion Patterns

  • Engagement was highest across interactive channels such as Social Media and Influencer Marketing.
  • Email campaigns produced the strongest conversion rates.
  • A positive relationship was observed between campaign duration and ROI, suggesting longer campaigns can deliver better results when managed effectively.

Language-Based Insights

Campaign performance varied across language groups. Certain languages generated higher revenue and ROI than others, indicating the importance of regional preferences and audience-specific communication strategies.

This finding suggests that improving language targeting could further enhance campaign effectiveness and customer engagement.

Key Findings

  • Influencer campaigns delivered the highest ROI.
  • Email marketing generated the strongest conversion rates.
  • Working professionals were the largest revenue contributors.
  • Campaign effectiveness varied significantly across channels and customer segments.
  • Language preferences influenced revenue and campaign performance.

Recommendations

  • Increase investment in high-performing channels such as Influencer and Social Media campaigns.
  • Leverage Email Marketing more aggressively for conversion-focused initiatives.
  • Prioritize high-value customer segments while nurturing emerging segments for future growth.
  • Review campaign duration strategies to maximize ROI.
  • Improve language targeting based on audience and regional performance patterns.

Limitations

The dataset contained an incomplete month in both years, affecting the accuracy of monthly trend comparisons. Revenue, engagement, and conversion metrics for these periods may be understated and should be interpreted with caution.

Dashboard Preview

Nykaa Dashboard View Interactive Power BI Dashboard