✅Social Media Analysis – May 2025 (﹙˓ 📶 ˒﹚)

🧭 Purpose of the Dashboard

To enable marketers, analysts, and business decision-makers to track, analyze, and optimize the performance of social media content and campaigns using real-time KPI visualizations and trend analysis

❇️KPI's (Key Performance Indicator) Requirements 📊

💡Important KPIs :

KPI Name Field Formula Insight Gained

(1.) Total Reach : SUM(Reach) - Audience size

(2.) Total Engagements : SUM(Engagements) - Interaction level

(3.) Total Impressions : SUM(Impressions) - Content visibility

(4.) Total Followers : SUM(Followers_Gained) - Growth measurement

(5.) Avg. CTR (%) : AVERAGE(Click_Through_Rate (%)) - Link performance

❇️Chart's Requirements 📶

1️⃣ Total Reach Per Platform

📶 Chart Type : Clustered Column Chart.
🎯 Purpose : Compare audience size per platform.
💹 Axis : Platform
🧮 Values : Total Reach(Sum)

2️⃣ Average CTR By Platform

📶Chart Type : Bar Chart
💹 Axis : Platform
🧮 Values : Click_Through_Rate (%) (Average)
🎯 Purpose : Discover which platform drives more clicks

3️⃣ Engagements By Post Type

📶Chart Type : Stacked Column
💹 Axis : Post_Type
🧮 Values : Engagements
🗃️Legend : Platform
🎯 Purpose : Assess content format effectiveness

4️⃣ Post-Level Breakdown

𝄜 Chart Type : Table
ᯓ★ Columns : Post_ID, Platform, Post_Type, Reach, Engagements, CTR, Followers_Gained
🎯 Purpose : Detailed analysis

5️⃣ Add Slicers

📶Chart Type : Add Slicers for dynamic filtering:

🚉 Platform

6️⃣ Engagements by Post Type

📶Chart Type : Ribbon Chart
💹 Axis : Platform
🧮 Values : Total Likes, Comment,and Shares.
🗽 Legend : Platform
🎯 Purpose : Assess content format effectiveness