name: social-media-analyzer
description: Analyzes social media performance data (Twitter/X, Instagram, LinkedIn, TikTok, etc.) to extract insights, identify patterns, and generate actionable recommendations. Use when the user uploads CSV/Excel files containing social metrics (impressions, engagements, followers, likes, shares, etc.) and asks for analysis, trends, performance review, content strategy advice, or data visualization.
Social Media Analytics
Analyze social media data to extract insights and generate strategic recommendations.
Analysis Framework
1. Data Ingestion & Validation
Read the uploaded file and identify available metrics. Common columns:
| Category | Metrics |
|---|
| Reach | Impressions, Reach, Views, Profile visits |
| Engagement | Likes, Comments, Replies, Shares, Reposts, Bookmarks, Saves |
| Growth | New followers, Unfollows, Net followers |
| Content | Posts created, Video views, Media views |
Validate data completeness. Note any missing or zero-value columns.
2. Calculate Key Performance Indicators
Engagement Rate = (Total Engagements / Total Impressions) × 100
Follow Conversion = (New Followers / Profile Visits) × 100
Net Growth = New Followers - Unfollows
Likes per Post = Total Likes / Posts Created
Impressions per Post = Total Impressions / Posts Created
3. Temporal Analysis
Identify patterns across time periods:
- Best performing days: Highest impressions, engagement rate, follower growth
- Worst performing days: Lowest metrics, potential issues
- Posting frequency correlation: Compare posts/day vs engagement/post
- Viral content detection: Days with 2x+ average performance
4. Engagement Composition Analysis
Break down total engagements by type:
- Likes (passive appreciation)
- Bookmarks/Saves (high-intent, reference value)
- Replies/Comments (active conversation)
- Shares/Reposts (amplification)
High bookmark rates suggest educational/reference content resonates. High reply rates indicate conversation-driving content.
5. Quality vs Quantity Assessment
Analyze the relationship between posting volume and performance:
for each day:
likes_per_post = likes / posts
impressions_per_post = impressions / posts
# Compare high-volume vs low-volume days
# Often: fewer high-quality posts > many low-quality posts
6. Growth Funnel Analysis
Track the conversion funnel:
Impressions → Engagements → Profile Visits → New Followers
Calculate conversion rates at each stage. Identify bottlenecks.
Visualization Guidelines
Create an interactive React dashboard with tabs:
- Overview: Key metrics cards, impressions/engagement trend, engagement breakdown pie chart
- Engagement: Daily engagement rate bar chart, likes per post analysis
- Growth: Follower gains/losses, profile visit to follower conversion
- Insights: Key findings cards with actionable recommendations
Use Recharts for charts:
- ComposedChart for dual-axis (impressions + engagements)
- BarChart for daily comparisons
- PieChart for engagement breakdown
Recommendation Categories
Posting Schedule Optimization
- Identify best/worst performing days
- Suggest optimal posting frequency based on quality vs quantity analysis
- Recommend content scheduling strategy
Content Strategy
- Analyze which content types drive bookmarks (save-worthy)
- Identify viral content patterns
- Suggest content pillars based on engagement composition
Growth Tactics
- Profile optimization suggestions based on follow conversion rate
- Engagement strategy (when to be active in replies)
- Audience retention insights from unfollow patterns
Output Structure
- Summary metrics: Total impressions, engagements, engagement rate, net followers
- Key findings: 3-5 bullet points of critical insights
- Interactive dashboard: React component with tabbed views
- Strategic recommendations: Prioritized action items with rationale
Example Insights
- "Monday drove 24% of weekly impressions—analyze what made it viral"
- "Tuesday underperformed despite 13 posts—consider reducing output"
- "30 posts yielded 99 likes/post vs 7 posts with 309 likes/post—quality over quantity"
- "5,312 bookmarks (6.8% of engagements) suggests save-worthy content resonates"
- "10.3% of profile visitors convert to followers—optimize bio for higher conversion"