Marketing AI Skill

Social Media Analytics

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...

Social Media Analytics & Reporting

Comprehensive tracking, analysis, and reporting of social media performance across every platform.

Workflow

Define social media KPIs aligned with business objectives (awareness, engagement, conversion, retention).
Connect all social media platforms to analytics tools and data warehouse.
Build multi-platform dashboard: Overview, platform-specific views, content performance, audience insights.
Implement tracking: UTM parameters, conversion pixels, social referral tracking, link shorteners.
Configure automated data collection and weekly/monthly report generation.
Conduct monthly performance analysis: Trend identification, content optimization, audience shifts.
Benchmark against competitors and industry standards.
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