This project presents an Excel-based analysis of Myntra’s social media performance with the objective of extracting actionable insights.
The analysis focuses on user engagement, platform-wise performance, hashtag effectiveness, campaign impact, and weekly growth trends.

• Clean and preprocess raw social media data
• Analyze key engagement metrics (likes, comments, shares)
• Compare performance across multiple social media platforms
• Evaluate hashtag usage and content strategies
• Measure campaign effectiveness
• Track and visualize weekly growth patterns

Myntra-Social-Media-Analytics/
│
├── data/
│   ├── README.md
│   ├── 00_Myntra_Social_Media_Analytics.xlsx
│   └── 01_Data_Cleaning.xlsx
│
├── analysis/
│   ├── README.md
│   ├── 02_Engagement_Analysis.xlsx
│   ├── 03_Platform_Analysis.xlsx
│   ├── 04_Hashtag_Content_Strategy.xlsx
│   ├── 05_Campaign_Effectiveness.xlsx
│   └── 06_Weekly_Growth.xlsx
│
└── README.md

• 00_Myntra_Social_Media_Analytics.xlsx – Raw social media dataset
• 01_Data_Cleaning.xlsx – Cleaned and structured dataset

• 02_Engagement_Analysis.xlsx – Engagement metrics and trends
• 03_Platform_Analysis.xlsx – Platform-wise performance comparison
• 04_Hashtag_Content_Strategy.xlsx – Hashtag and content effectiveness
• 05_Campaign_Effectiveness.xlsx – Campaign impact evaluation
• 06_Weekly_Growth.xlsx – Weekly audience growth analysis

• Microsoft Excel
• Data Cleaning & Preprocessing
• Pivot Tables
• Data Visualization (Charts & Graphs)

• Identified high-performing platforms based on engagement metrics
• Determined effective hashtag and content strategies
• Evaluated the impact of social media campaigns
• Observed consistent trends in weekly audience growth