


๐ Key Findings
Engagement is highly concentrated on both Instagram and Facebook.
40%+ of all reactions, comments, and shares sit in just the top 10 % of posts.
Potential problems:
โ Uneven performance: A small set of โhitโ posts carries the account, while the majority underperform, making overall results volatile and harder to forecast.
โ Algorithm risk: If new posts donโt match those top-tier engagement levels quickly, the platform may reduce organic reach for everything else.
โ Click-through dilution: Highly saturated hashtags bury our content under millions of competing posts, so the click-through rate drops.
โ Misaligned targeting: Broad hashtags attract untargeted traffic that doesnโt convert.
Solution:
Audience is most active between 10 AM โ 12 PM and 3 PM โ 5 PM.
Recommended action:
โ Schedule the primary post of the day inside these two windows.
โ Reserve time-sensitive Stories or Live sessions for 10 AM or 3 PM sharp to ride the initial engagement spike.
The โbiggestโ hashtag isnโt the best performer.
The hashtag with the highest saturation index draws fewer clicks than the hashtag ranked third by saturation.
๐ ๏ธ Tools used: Power BI, DAX.
1 like ยท 14 views ยท Jun 30, 2025
Analyzed social media engagement and hashtag performance using Power BI and DAX.