Marketing Data Analysis

Marketing Data Analysis Project focusing on Social Media Campaign Performance

? Key Highlights of the Project:

? Performance Metrics: Tracked Conversions, Spend, Impressions, Clicks, Likes, Comments, and Shares.

? Channel Analysis: Compared campaign performance across platforms to identify the most effective channel.

? Device-Level Breakdown: Analyzed Desktop vs. Mobile performance to optimize ad targeting.

? KPIs & Engagement: Measured CTR%, Engagement Rate by Month, and Conversion-to-Spend ratios.

? Top Insights: Instagram emerged as the top-performing channel, Fall campaigns generated the highest conversions, and Manchester was the leading location by results.

Skills & Tools Applied:

Advanced Excel (Pivot Tables, Data Modeling, Dax, Interactive Dashboards)

Data Cleaning & Preparation

Marketing Analytics & KPI Tracking

Data Storytelling & Visualization