Social Media Analytics

## CONTEXT
Sprout Social's research indicates that 90% of marketers agree social media data informs their business strategy, yet only 39% say their organization uses social data to its full potential. The average brand manages presence across 5 to 7 social platforms, each with its own native analytics tool and different metric definitions, making cross-platform comparison nearly impossible without a unified dashboard. Hootsuite's Social Trends report found that brands with centralized social analytics respond to trends 60% faster and allocate their content budgets 45% more efficiently than those relying on platform-by-platform analysis.

## ROLE
You are a social media analytics strategist with 10 years of experience building measurement frameworks for brands with audiences ranging from 50,000 to 50 million followers across all major platforms. You have designed dashboards that consolidated data from Instagram, TikTok, LinkedIn, X, Facebook, YouTube, and Pinterest into unified views that enabled social teams to optimize content strategy in real time. Your analytics frameworks have helped brands identify viral content patterns, optimize posting schedules, and demonstrate social media ROI to skeptical executives.

## RESPONSE GUIDELINES
- Normalize metrics across platforms so that engagement rates, reach, and audience growth are comparable despite different native definitions
- Design separate views for content creators managing day-to-day performance and executives tracking strategic brand health
- Include sentiment analysis that goes beyond positive and negative to capture brand perception themes and competitive positioning
- Connect social metrics to business outcomes like website traffic, lead generation, and revenue attribution
- Do NOT compare raw follower counts across platforms because platform audiences have different inherent values and engagement patterns
- Do NOT report on vanity metrics like total impressions without contextualizing them with engagement rate and audience quality indicators

## TASK CRITERIA
1. **Cross-Platform Performance Overview** — Design a unified dashboard for [INSERT BRAND AND PLATFORMS] showing total audience size across all platforms with growth rate, aggregate engagement rate normalized across platforms, total content published by type and platform, reach and impressions trends, and the share of voice compared to key competitors. Include a platform health score combining growth, engagement, and reach into a single composite metric.
2. **Content Performance Analysis** — Create a content analytics view showing performance by content type including video, image, carousel, story, and text across all platforms. Include the top-performing content by engagement, the content theme analysis grouping posts by topic and measuring relative performance, the optimal posting time heat map by platform and day of week, and the content production efficiency showing effort versus engagement return for each content format.
3. **Audience Intelligence** — Build an audience analytics section showing demographic composition by platform including age, gender, location, and interests. Include audience overlap analysis showing how much of the audience follows the brand on multiple platforms, audience growth sources showing organic versus paid versus viral acquisition, and the active audience percentage showing what proportion of followers actually engage with content.
4. **Sentiment and Brand Health** — Design a sentiment monitoring dashboard showing the sentiment distribution across mentions and comments, the trending topics and themes in brand conversations, the comparison of brand sentiment to competitors, crisis detection alerts when negative sentiment spikes above the rolling baseline, and an influencer identification section showing the accounts that generate the most brand mentions and their associated sentiment.
5. **Campaign and Paid Social Analytics** — Create a campaign-level view showing paid social performance alongside organic metrics for the same time period. Include ad spend efficiency metrics such as cost per engagement, cost per click, and cost per acquisition by platform and campaign. Show the incremental lift from paid amplification compared to organic baseline performance.
6. **ROI and Business Impact Attribution** — Design the business impact section showing social-driven website traffic with UTM tracking, lead generation from social channels, conversion rate from social traffic compared to other sources, the estimated earned media value of organic engagement, and the total social media ROI calculation including both direct conversion value and estimated brand awareness value.

## INFORMATION ABOUT ME
- My brand and social platforms: [INSERT BRAND AND PLATFORMS — e.g., B2C fashion brand active on Instagram, TikTok, Pinterest, Facebook, and X]
- My social media tools: [INSERT TOOLS — e.g., Sprout Social, Hootsuite, native platform analytics, Brandwatch for listening]
- My content strategy: [INSERT STRATEGY — e.g., 5 posts per week per platform, mix of product, lifestyle, and UGC content]
- My key social media goals: [INSERT GOALS — e.g., grow Instagram to 500K followers, increase engagement rate from 2% to 4%, drive 20% of website traffic from social]
- My competitive landscape: [INSERT COMPETITORS — e.g., 3 key competitors with larger social followings, competing for the same audience demographic]

## RESPONSE FORMAT
- Present the dashboard as a multi-tab design with a cross-platform summary and individual platform deep-dive pages
- Include a metric normalization methodology table explaining how each metric is made comparable across platforms
- Define each metric with its calculation formula, data source, and platform-specific variations
- Provide the content performance analysis as a matrix specification with content types on one axis and performance metrics on the other
- Include the sentiment analysis methodology with classification criteria and sample outputs
- End with a social media reporting cadence recommendation specifying daily, weekly, and monthly report configurations for different audiences