Social Media Engagement Dashboard

Project Overview

The Social Media Engagement Dashboard encompasses data on various engagement metrics (such as reach, impressions, engagement rate, average view time, etc.) derived from leading social media platforms including Facebook, Instagram, TikTok, YouTube, Twitter, LinkedIn, and Pinterest. The dashboard utilizes a range of visualization techniques such as column charts, line graphics, pie charts, and combo charts to present these metrics in an aesthetically captivating manner. As a result, users can effortlessly discern and compare the performance of these metrics across different platforms with minimal effort.

  • Trebuchet MS  
  • Century Gothic

#5E1AE5

#7338E8

#A1E51A

#F8FC4A

#3C1193 

Excel Workbook (.xlsx)

388 KB

What's Included

  • Dataset
  • Pivot Tables
  • 2 Dashboards (Comparison Dashboard-Channel Overview Dashboard)

Comparison Dashboard

  • Utilize a scatter chart with x and y dimensions to visually represent all channels in a circular model, highlighting the maximum value (engagement rate) for each month.
  • Employ an area chart to visually display the engagement rate of each channel in a graphical format.
  • Employ a combination chart that incorporates a column chart to represent the total reactions per month for each channel, alongside a line chart showing the individual percentage based on the overall percentage of all platforms.
  • Utilize a bar chart to compare the actual reach and engagement rate with the target values, presenting the outcome with numerical values.
  • Develop interactive weekly performance reports for each channel, focusing on reach, impressions, and engagement rate metrics.
  • Develop interactive quarterly performance reports for each channel, focusing on reach, impressions, and engagement rate metrics.

Channel Overview Dashboard

  • Bar charts that display all other metrics for each channel by month separately.
  • Pivot tables & Formulas
  • Interactive Navigation Buttons
  • No VBA/macros