Social Media Campaign Performance Tracker

A data-driven project designed to analyze Facebook and Instagram ad campaigns by evaluating reach, engagement, CTR, conversions, and ROI. This tracker helps identify what works, what doesn’t, and how to optimize future campaigns using powerful visual dashboards.

📌 Project Overview

This project focuses on turning raw campaign data into actionable insights. It includes analysis on:

Campaign reach & impressions

Engagement metrics (likes, comments, shares, saves)

Click-Through Rate (CTR)

Cost & budget utilization

Conversion performance

Return on Investment (ROI)

Platform-wise breakdown (Facebook vs. Instagram)

🎯 Objectives

Measure campaign effectiveness

Compare audience behavior across platforms

Identify best-performing creatives, formats & segments

Provide dashboard-based storytelling

Support data-driven marketing decisions

🛠 Tools Used

Power BI – Interactive dashboards

Google Looker Studio – Web-based reporting

Excel / Google Sheets – Data cleaning & preprocessing

Canva (optional) – Visual design assets

📊 Deliverables

Cleaned dataset

Visual dashboards

Performance summary report

Key insights & recommendations

🚀 Skills Gained

Marketing Analytics

Campaign Optimization

Dashboard Creation & Storytelling

Data Analysis & Visualization