--- name: social-media-analytics description: Track and analyze social media performance across all platforms including engagement metrics, audience growth, content performance, competitor benchmarking, and ROI attribution. Use when building social media analytics dashboards, analyzing engagement rates, tracking follower growth, measuring social media ROI, conducting content performance audits, or generating social media reports. Triggers on phrases like "social media analytics", "social media report", "engagement rate", "social media ROI", "content performance", "follower growth", "social media dashboard", "social media metrics", "social media KPIs", "social listening report", "share of voice". --- # Social Media Analytics & Reporting Comprehensive tracking, analysis, and reporting of social media performance across every platform. ## Workflow 1. Define social media KPIs aligned with business objectives (awareness, engagement, conversion, retention). 2. Connect all social media platforms to analytics tools and data warehouse. 3. Build multi-platform dashboard: Overview, platform-specific views, content performance, audience insights. 4. Implement tracking: UTM parameters, conversion pixels, social referral tracking, link shorteners. 5. Configure automated data collection and weekly/monthly report generation. 6. Conduct monthly performance analysis: Trend identification, content optimization, audience shifts. 7. Benchmark against competitors and industry standards. 8. Generate executive reports with actionable insights and recommendations. ## KPI Framework ``` SOCIAL MEDIA KPI HIERARCHY ============================ LEVEL 1 — AWARENESS METRICS: Reach: → Definition: Number of unique users who saw content → Formula: Sum of unique impressions per post → Benchmark: Varies by platform and follower count → Target: 20-30% of follower count per post (organic) Impressions: → Definition: Total number of times content was displayed → Note: One user can generate multiple impressions → Impressions-to-reach ratio: 1.5-3.0x is typical → Above 4.0x: Content being shown too frequently (potential fatigue) Follower Growth: → Net new followers: New followers − Unfollowers → Growth rate: Net new followers / Total followers × 100 → Benchmark: 1-3% monthly growth (healthy), 5%+ (excellent) → Churn monitoring: Track unfollows (spike indicates content issue) Share of Voice (SOV): → Definition: Brand mentions / (Brand mentions + Competitor mentions) × 100 → Measurement: Social listening tools (Brandwatch, Sprout Social, Talkwalker) → Benchmark: Varies by market position (leader: 25%+, challenger: 10-20%) → Target: Increase SOV by 5%+ quarterly Hashtag Reach: → Total impressions from branded hashtag content → Growth trend: Week-over-week comparison → UGC contribution: % of hashtag reach from user-generated content LEVEL 2 — ENGAGEMENT METRICS: Engagement Rate (multiple formulas): → By Reach: (Total Engagements / Reach) × 100 Best for: Comparing across platforms and audience sizes → By Followers: (Total Engagements / Followers) × 100 Best for: Overall account health → By Impressions: (Total Engagements / Impressions) × 100 Best for: Content-specific performance What counts as engagement: → Like / reaction (weight: 1) → Comment (weight: 2-3, higher intent) → Share / retweet (weight: 3-5, highest value) → Save / bookmark (weight: 3, high intent) → Click (weight: 2, action-oriented) → View (weight: 0.5, lowest intent) Engagement Rate Benchmarks by Platform (2024): Instagram: Average 1.22%, Good > 3.5%, Excellent > 5.0% Facebook: Average 0.09%, Good > 0.20%, Excellent > 0.50% Twitter/X: Average 0.05%, Good > 0.15%, Excellent > 0.30% LinkedIn: Average 1.50%, Good > 3.5%, Excellent > 5.0% TikTok: Average 3.50%, Good > 8.0%, Excellent > 12.0% YouTube: Average 2.00% (comments/views), Good > 4.5% Pinterest: Average 0.30%, Good > 1.0%, Excellent > 2.0% Engagement Mix: → Likes vs. Comments ratio: Target < 10:1 (more comments = deeper engagement) → Share rate: % of engagements that are shares (target > 5%) → Save rate: % of engagements that are saves (target > 3%, high intent signal) Response Metrics: → Response rate: % of comments/messages that receive a response (target > 80%) → Response time: Average time to first response (target < 1 hour) → Sentiment of responses: Positive/neutral/negative breakdown LEVEL 3 — CONVERSION METRICS: Click-Through Rate: → CTR: Clicks / Impressions × 100 → Instagram bio link: 1-3% of profile visits → Facebook post link: 0.5-2.0% of impressions → LinkedIn article: 1-5% of impressions → Story link sticker: 0.5-2.0% of story views Traffic from Social: → Total sessions from social (Google Analytics) → % of total website traffic from social (benchmark: 5-15%) → Bounce rate from social traffic (benchmark: 40-60%) → Avg. session duration from social (benchmark: 1-3 minutes) Conversions from Social: → Goal completions attributed to social channels → Revenue attributed to social (GA4 multi-channel attribution) → Cost per acquisition via social (organic + paid combined) → Social-assisted conversions: Social appears in path but not last click LEVEL 4 — ADVANCED METRICS: Content Velocity: → Posts per week by platform → Consistency score: % of planned posts published on schedule → Peak performance hours: When content generates most engagement Audience Sentiment: → Positive: % of mentions with positive sentiment → Negative: % of mentions with negative sentiment → Sentiment trend: Week-over-week shift → Crisis detection: Sudden negative sentiment spike (> 30% shift) Amplification Rate: → (Shares + Retweets) / Followers × 100 → Measures content virality potential → Benchmark: > 1.0% is strong Conversation Rate: → (Comments + Replies) / Followers × 100 → Measures discussion generation → Benchmark: > 0.5% is strong ``` ## Dashboard Structure ``` SOCIAL MEDIA ANALYTICS DASHBOARD ================================== VIEW 1 — CROSS-PLATFORM OVERVIEW: ┌─────────────────────────────────────────────────────────────────┐ │ SOCIAL MEDIA PERFORMANCE — May 2024 │ │ Period: May 1-31 │ Updated: 4 hours ago │ ├─────────────────────────────────────────────────────────────────┤ │ │ │ 125K 4.2% +2,340 18.5% │ │ Total Reach Avg Eng Rate New Followers Traffic Share │ │ ▲ 15.3% ▲ 0.8% ▲ 22.1% ▼ 2.1% │ │ vs. Apr vs. Apr vs. Apr vs. Apr │ │ │ ├─────────────────────────────────────────────────────────────────┤ │ PLATFORM PERFORMANCE: │ │ │ │ ┌─────────┬────────┬────────┬────────┬────────┬────────┐ │ │ │ Platform │ Reach │ Follow │ Eng Rate│ Posts │ Traffic│ │ │ │ │ │ ers │ │ Mo │ (sess) │ │ │ ├─────────┼────────┼────────┼────────┼────────┼────────┤ │ │ │ Instagram│ 45K │ +890 │ 3.8% │ 28 │ 3,200 │ │ │ │ TikTok │ 38K │ +650 │ 5.2% │ 22 │ 2,100 │ │ │ │ LinkedIn │ 22K │ +420 │ 2.9% │ 15 │ 1,800 │ │ │ │ Facebook │ 12K │ +180 │ 0.18% │ 20 │ 900 │ │ │ │ X/Twitter│ 8K │ +200 │ 0.12% │ 35 │ 600 │ │ │ │ YouTube │ 5K │ +130 │ 2.4% │ 4 │ 1,200 │ │ │ └─────────┴────────┴────────┴────────┴────────┴────────┘ │ │ │ └─────────────────────────────────────────────────────────────────┘ VIEW 2 — CONTENT PERFORMANCE: ┌─────────────────────────────────────────────────────────────────┐ │ TOP PERFORMING CONTENT (May 2024) │ ├──────────────────┬──────────┬────────┬────────┬────────────────┤ │ Post Preview │ Platform │ Reach │ Eng Rate│ Type │ ├──────────────────┼──────────┼────────┼────────┼────────────────┤ │ [Video: Behind │ TikTok │ 18K │ 8.5% │ Educational │ │ the scenes] │ │ │ │ │ │ [Carousel: 5 │ IG │ 12K │ 5.2% │ How-to │ │ tips for ...] │ │ │ │ │ │ [Post: Industry │ LinkedIn │ 8K │ 4.1% │ Thought │ │ report launch] │ │ │ │ Leadership │ │ [Reel: Product │ IG │ 15K │ 6.8% │ Product Demo │ │ unboxing] │ │ │ │ │ │ [Image: Customer │ IG │ 6K │ 4.5% │ Social Proof │ │ testimonial] │ │ │ │ │ └──────────────────┴──────────┴────────┴────────┴────────────────┘ VIEW 3 — AUDIENCE INSIGHTS: ┌─────────────────────────────────────────────────────────────────┐ │ AUDIENCE DEMOGRAPHICS (Instagram + TikTok) │ │ │ │ Age Distribution: Gender Split: │ │ 18-24: █████████░░░░░░░ 32% Male: █████████░░░░ 54% │ │ 25-34: ██████████████░░ 41% Female: ████████░░░░ 44% │ │ 35-44: ██████░░░░░░░░░░ 16% Other: █░░░░░░░░░░░ 2% │ │ 45-54: ████░░░░░░░░░░░░ 8% │ │ 55+: ██░░░░░░░░░░░░░░ 3% │ │ │ │ Top Locations: │ │ 1. United States: 42% │ │ 2. United Kingdom: 12% │ │ 3. Canada: 8% │ │ 4. Australia: 5% │ │ 5. Germany: 4% │ │ │ │ Top Interests: │ │ Technology, Fitness, Entrepreneurship, Marketing, Design │ │ │ └─────────────────────────────────────────────────────────────────┘ VIEW 4 — COMPETITIVE BENCHMARKING: ┌─────────────────────────────────────────────────────────────────┐ │ SHARE OF VOICE & COMPETITOR COMPARISON │ │ │ │ SOV Distribution: │ │ Our Brand: ████████████████░░░░░░░░░░ 35% │ │ Competitor A: ████████████░░░░░░░░░░░░░░ 28% │ │ Competitor B: █████████░░░░░░░░░░░░░░░░░ 22% │ │ Competitor C: █████░░░░░░░░░░░░░░░░░░░░░ 15% │ │ │ │ Engagement Rate Comparison: │ │ Our Brand: 4.2% (▲ vs. industry avg 2.8%) │ │ Competitor A: 3.1% │ │ Competitor B: 2.5% │ │ Competitor C: 3.8% │ │ │ └─────────────────────────────────────────────────────────────────┘ ``` ## Reporting Templates ``` MONTHLY SOCIAL MEDIA REPORT ============================= EXECUTIVE SUMMARY: Reporting Period: [Month, Year] Overall Performance: [Summary in 3-5 sentences] Key Achievement: [Top win of the month] Key Challenge: [Primary issue to address] Recommendation: [Top priority action for next month] PERFORMANCE HIGHLIGHTS: ✓ Reach increased [X]% month-over-month ([number] total reach) ✓ Engagement rate improved to [X]% (from [Y]% prior month) ✓ [Platform] drove [X]% of all social traffic ([number] sessions) ✓ [Content type] generated highest engagement ([X]% engagement rate) ✓ Follower growth: +[number] net new followers across all platforms PLATFORM-BY-PLATFORM ANALYSIS: INSTAGRAM: Followers: [number] (+[number], [X]% growth) Reach: [number] ([+/- X]% vs. prior month) Impressions: [number] Engagement Rate: [X]% ([+/- X]pp vs. prior month) Top post: [description] — [number] engagements, [X]% engagement rate Stories avg. reach: [number] ([X]% of followers) Reels avg. views: [number] Key insight: [Observation and recommendation] TIKTOK: Followers: [number] (+[number], [X]% growth) Views: [number] total Engagement Rate: [X]% Top video: [description] — [number] views, [X]% engagement rate Avg. watch time: [X] seconds Key insight: [Observation and recommendation] LINKEDIN: Followers: [number] (+[number], [X]% growth) Impressions: [number] Engagement Rate: [X]% Top post: [description] — [number] engagements Click-through Rate: [X]% Key insight: [Observation and recommendation] CONTENT ANALYSIS: Content mix: [X]% educational, [X]% promotional, [X]% UGC, [X]% entertaining Best-performing format: [Format] at [X]% engagement rate Best-performing topic: [Topic] at [X]% engagement rate Best posting time: [Day] at [Time] ([X]% higher engagement) Content gap identified: [Topic/format not being covered] AUDIENCE INSIGHTS: Growth: +[number] followers this month across all platforms Demographic shifts: [Notable changes in audience composition] Active hours: [Peak engagement hours by platform] New audience segments: [Recently discovered audience groups] COMPETITIVE ANALYSIS: Share of voice: [X]% (vs. [X]% prior month) Competitor A launched [campaign/initiative] — impact assessment Competitor B's [content type] performed well — learnings we can apply Industry trend: [Notable trend observed across competitors] NEXT MONTH PRIORITIES: 1. [Priority] — Expected impact: [Metric improvement] 2. [Priority] — Expected impact: [Metric improvement] 3. [Priority] — Expected impact: [Metric improvement] ``` ## Integration Points - **Native Platform Analytics**: Instagram Insights, Facebook Page Insights, Twitter Analytics, LinkedIn Analytics, TikTok Analytics, YouTube Studio - **Sprout Social**: Cross-platform analytics, custom reports, competitive benchmarking, social listening, presentation-ready reports - **Hootsuite Analytics**: Multi-platform dashboards, custom report builder, scheduled reporting, team collaboration - **Agorapulse**: Performance analytics, social inbox integration, audience insights, competitor comparison - **Google Analytics 4**: Social referral tracking, conversion attribution, UTM parameter analysis, social-assisted conversions - **Brandwatch / Talkwalker**: Social listening, share of voice, sentiment analysis, trend identification, competitive monitoring - **Later / Iconosquare**: Instagram-focused analytics, content planning integration, hashtag performance tracking - **Socialbakers / Rival IQ**: Competitive benchmarking, content gap analysis, share of voice, influencer identification - **Looker Studio / Data Studio**: Custom dashboard building, automated report scheduling, data visualization - **Supermetrics**: Data connector between social platforms and BI tools (automated sync) - **Buffer Analyze**: Multi-platform analytics, content performance, audience insights ## Edge Cases - **Platform API restrictions and data access changes**: Platforms frequently restrict third-party API access - Instagram Graph API: Changed in 2018 (removed public feed), again in 2021 (business accounts only) - Twitter API: November 2023 changes restricted free tier significantly (1,500 tweets/month read limit) - TikTok API: Limited third-party access, frequent policy updates - Mitigation: Use native platform exports when API blocked, maintain multiple tool providers - Data backup: Export raw data quarterly to spreadsheet/data warehouse for historical reference - Vendor diversification: Don't rely on single analytics tool (have backup providers) - **Engagement rate calculation inconsistencies**: Different tools use different formulas - By followers: (Engagements / Followers) × 100 — common but skewed by inactive followers - By reach: (Engagements / Reach) × 100 — more accurate for content performance - By impressions: (Engagements / Impressions) × 100 — useful for ad performance - Industry benchmarks: Often use "by followers" formula — ensure consistency when comparing - Recommendation: Report BOTH "by reach" and "by followers" for complete picture - Tool discrepancies: Different tools may show 10-20% variance in engagement rate - **Social media ROI attribution**: Connecting social activity to business outcomes - Direct conversions: UTM-tracked links, platform pixel conversions - Assisted conversions: Social appears in customer journey but not last click - Brand lift: Survey-based measurement of awareness, consideration, favorability - Earned media value (EMV): Theoretical ad spend equivalent of organic reach (controversial metric) - Approach: Use multi-touch attribution in GA4 for realistic picture - Reporting: Show assisted conversions alongside direct conversions - Minimum viable: Track social referral traffic + conversions + lead form submissions - **Bot and fake engagement detection**: Inflated metrics from inauthentic accounts - Detection: Unusual engagement patterns (1000 likes, 0 comments), bot-like comment patterns - Impact: Engagement rate appears healthy but real engagement is low - Tools: HypeAuditor, Social Blade, platform-native audience quality scores - Action: Report "organic engagement rate" excluding suspected bot activity - Prevention: Focus on meaningful engagement metrics (comments, saves, shares) over vanity metrics (likes, followers) - **Cross-platform identity resolution**: Same user across multiple platforms counted separately - Challenge: Can't definitively identify same person across Instagram, TikTok, LinkedIn - Impact: Reach numbers may double-count same person - Solution: Use social referral data in GA4 (cookie-based identity) for deduplicated reach - Solution: Implement login-based tracking (users who connect social accounts) - Reporting: Note identity resolution limitations in reports - Advanced: CDP (Customer Data Platform) for unified customer profiles - **Seasonal and event-driven anomalies**: Spikes or drops not representative of normal performance - Holiday spikes: December typically sees 20-40% higher engagement - Viral events: Brand mentioned in trending topic (temporary spike) - Algorithm changes: Platform updates can cause sudden metric shifts - Documentation: Annotate dashboard with key events for context - Analysis: Compare against same-period last year to isolate true performance - Adjustment: Use 3-month moving average for trend analysis to smooth anomalies