This dataset contains social media performance metrics across three major platforms — Instagram, Facebook, and Twitter. It includes post-level engagement details, sentiment analysis, and content type classification.
📊 Social Media Analytics Dashboard
This dashboard provides insights into engagement metrics (likes, shares, and comments) across different platforms, post types, and posting times.
Key Highlights:
Engagement by Day of the Week (Top-left line chart):
Shows the total likes, shares, and comments received on different days.
Engagement is highest midweek (Wednesday–Friday) and drops on weekends.
Sentiment by Post Type (Top-right bar chart):
Analyzes sentiment scores for different types of posts.
Carousels and videos drive the most positive sentiment, while polls and images rank lower.
Overall Metrics (Center):
238K likes
20K comments
42K shares
Data snapshot taken on 1/1/2023, 20:00
Engagement by Platform (Bottom-left bar chart):
Instagram has the highest interaction, followed by Facebook and Twitter.
Likes are the dominant form of engagement across all platforms.
Posting Distribution (Bottom-middle pie chart):
Posts are fairly evenly distributed across Instagram (36%), Facebook (32%), and Twitter (32%).
Sentiment Distribution by Post Type (Bottom-right donut chart):
Positive sentiment is most frequent for carousel and text posts.
Polls and images have relatively lower sentiment scores.
Business Insight:
Midweek posts, especially carousels and videos on Instagram, perform best.
Increasing poll and image quality could improve engagement and sentiment balance.
Engagement Overview (by Platform):
This visualization highlights how likes, shares, and comments are distributed across Instagram, Facebook, and Twitter, along with posting frequency.
Key Insights:
Overall Engagement (Left Bar Chart):
Instagram leads with the highest total engagement (likes, shares, and comments).
Facebook shows decent engagement but trails behind Instagram.
Twitter has the lowest engagement, suggesting underperformance.
Platform Distribution (Right Pie Chart):
Instagram: 36% of total posts
Facebook: 32% of total posts
Twitter: 32% of total posts
Posting is relatively balanced, but engagement is not proportional—Instagram generates far better results.
Overall Metrics (Top Section):
238K Likes
42K Shares
20K Comments
Strategic Takeaways (Text Analysis):
Instagram should be the top priority for future campaigns.
Facebook shows potential but may require content optimization.
Twitter may need a new content strategy or reduced focus due to weak results.
Businesses can refine strategy by allocating more budget and effort to Instagram, while testing content optimization for Facebook.
Engagement Trend Over time:
This dashboard analyzes how likes, shares, and comments change across the days of the week, helping identify the best posting times for higher engagement.
Key Insights:
Overall Engagement (Left Line Chart):
Wednesdays and Fridays show the highest engagement in terms of likes, shares, and comments.
Engagement steadily declines from Sunday to Tuesday.
Saturdays and Mondays are the lowest-performing days, showing minimal user interaction.
Overall Metrics (Top Section):
238K likes
20K comments
42K shares
Post Timing (Right Section):
The first post in the dataset was on Friday, 1st January 2023 at 8:00 PM.
Evening posting times, especially on high-performing days, may influence better results.
Recommendations:
Prioritize content scheduling on Wednesdays and Fridays, preferably in the evening.
Reconsider or optimize posting strategies for Saturdays and Mondays, since they show the weakest engagement.
Experiment with content variations on lower-performing days to see if interaction can improve.
Post Type Performance:
This dashboard compares how different social media post types—carousel, video, text, image, and poll—perform based on their sentiment scores. It highlights which content formats resonate most positively with the audience.
Top Performing Post Types (by Sentiment):
🟦 Carousel posts rank highest (26 counts, 26%).
🟦 Video posts follow with 23 counts (23%).
🟦 Text posts take third with 21 counts (21%).
Lower Performing Post Types:
🟪 Image posts: 17 counts (17%).
🟪 Polls: 13 counts (13%).
Recommendations:
✅ Double down on carousel and video content since they consistently deliver stronger sentiment and engagement.
🔄 Test new approaches to boost the emotional impact of image and text posts.
Key Takeaway:
Carousel and video posts drive the highest positive audience reactions, while polls and images underperform and may require new strategies to remain effective.
Sentiment Score Analysis:
This visual evaluates the emotional reaction (sentiment) to posts across Instagram, Facebook, and Twitter. The sentiment score shows how positively users engage with content on each platform.
Key Findings:
Instagram leads with the highest sentiment score: 36
Indicates stronger emotional connection and higher positivity from users.
Facebook: 32
Twitter: 32
Both platforms show positive engagement but less emotionally impactful compared to Instagram.
Overall Metrics (Top Section):
238K Likes
20K Comments
42K Shares
Key Insight:
“Instagram generates the strongest positive sentiment, making it the most emotionally resonant platform. Facebook and Twitter show similar performance but with slightly lower emotional engagement.”
Conclusion:
The analysis clearly shows that Instagram is the strongest platform for generating engagement, both in terms of volume (likes, comments, shares) and positive sentiment. Facebook follows closely with steady engagement, while Twitter lags behind in both reach and sentiment. Engagement peaks on specific days, and content type plays a key role in driving interactions.
Overall, focusing more on Instagram-first content strategies, supported by Facebook for reach, and refining Twitter for niche conversations, will maximize impact. The sentiment results confirm that building visually appealing and emotionally resonant posts is the most effective way to connect with audiences.