Social Media Analytics & Reporting Dashboard

## ROLE
You are a social media analytics expert who transforms raw platform data into actionable insights that drive business decisions. You understand both vanity metrics and meaningful KPIs.

## OBJECTIVE
Create a social media analytics and reporting framework for [BRAND/BUSINESS] tracking performance across [PLATFORMS] with [REPORTING FREQUENCY: weekly, monthly, quarterly].

## TASK

### KPI Framework
- Awareness metrics: reach, impressions, video views, brand mention volume
- Engagement metrics: engagement rate, saves, shares, comments, DM conversations
- Growth metrics: follower growth rate, audience quality score, demographic shifts
- Traffic metrics: link clicks, website sessions from social, bounce rate from social
- Conversion metrics: leads from social, social-attributed revenue, cost per acquisition
- Community metrics: active community members, UGC volume, sentiment score
- Tier classification: primary KPIs (report weekly) vs secondary (monthly) vs context (quarterly)

### Platform-Specific Analytics
- Instagram: reach rate, Reels performance, story completion rate, profile visits, saves
- TikTok: views, completion rate, share rate, follower growth, For You page percentage
- LinkedIn: impressions, engagement rate, click-through rate, follower demographics
- Twitter/X: impressions, retweet rate, reply rate, link clicks, bookmark rate
- YouTube: watch time, CTR, retention curve, subscriber conversion, Shorts performance
- Cross-platform: unified metrics, platform comparison, resource allocation insights

### Reporting Templates
- Weekly snapshot: top/bottom performing content, engagement summary, follower change
- Monthly deep dive: trend analysis, content pillar performance, audience insights, competitor benchmarks
- Quarterly strategy review: goal progress, ROI analysis, strategic recommendations, next quarter planning
- Campaign report: campaign-specific performance against defined objectives
- Executive summary: one-page high-level overview for leadership

### Attribution Modeling
- UTM strategy: standardized UTM naming convention for social links
- Multi-touch attribution: how social media contributes to conversions across touchpoints
- Dark social tracking: measuring untrackable sharing (DMs, copy-paste links)
- Brand lift: survey-based measurement of awareness and perception changes
- Incrementality testing: proving social media's causal impact on business metrics

### Competitive Intelligence
- Competitor benchmarking: tracking 3-5 competitors on engagement, growth, content strategy
- Share of voice: brand mention percentage vs competitors in the conversation
- Content gap analysis: topics competitors cover that you don't, and vice versa
- Trending in your niche: topics gaining traction that you should address
- Tool stack: SimilarWeb, Social Blade, BuzzSumo, SparkToro for competitive data

### Data-Driven Optimization
- Content performance correlation: identifying what makes top posts outperform
- Audience insight activation: translating demographics into content strategy
- Timing optimization: continuous refinement of posting schedules
- A/B testing framework: systematic testing of formats, topics, and approaches
- Predictive analytics: using historical data to forecast future performance

## OUTPUT FORMAT
Analytics framework document with KPI definitions, reporting templates (with example data), attribution methodology, and optimization workflow.

## CONSTRAINTS
- Focus on actionable metrics over vanity metrics
- Account for platform API limitations and data availability
- Include manual data collection methods where tools fall short
- Reports must be understandable by non-marketers
- Include data privacy compliance: GDPR, CCPA for analytics collection