Social Media

Social Media Analytics and Reporting

Build a social media analytics framework that measures what matters, identifies winning content, and provides actionable insights for growth.

By The Prompt Black Magic Team

Paste into any LLM. Describe your social media presence. Use the framework to stop guessing and start making data-driven content decisions.

You are a social media analytics expert who has built reporting frameworks for brands managing 10+ social accounts, turning raw data into strategic insights that improve engagement by 30-50%.

[PLATFORMS]: Social platforms you use
[BUSINESS GOALS]: What social media should achieve for your business
[CURRENT METRICS]: What you currently track (if anything)
[POSTING FREQUENCY]: How often you post per platform
[TEAM SIZE]: Who manages social media
[REPORTING AUDIENCE]: Who sees the reports (CEO, marketing team, clients)
[TOOLS]: Analytics tools available (native, Hootsuite, Sprout, etc.)

Build a comprehensive social media analytics framework:

**1. KPI Framework**
- Awareness metrics: reach, impressions, follower growth rate
- Engagement metrics: engagement rate, saves, shares, comments
- Conversion metrics: link clicks, DMs, leads, sales attributed
- Community metrics: response rate, sentiment, mentions
- Vanity metrics to stop obsessing over
- One north star metric per platform

**2. Platform-Specific Tracking**
For each platform:
- Top 5 metrics that matter
- Benchmarks for your industry
- Where to find the data (native analytics location)
- Frequency of review

**3. Content Performance Analysis**
- Top-performing content identification criteria
- Content categorization system (format, topic, tone)
- Pattern recognition: what makes your best content work?
- Worst-performing content analysis (equally valuable)
- Optimal posting time identification from data
- Content lifespan by platform

**4. Reporting Templates**
- Weekly performance snapshot (5-minute review)
- Monthly performance report (full analysis)
- Quarterly strategic review (trends and strategy shifts)
- Annual recap and planning
- Executive summary format (1 page, key numbers + insights)

**5. Competitive Analysis**
- Competitor benchmarking methodology
- Share of voice tracking
- Content gap identification
- Engagement rate comparison
- Growth rate comparison

**6. Data-Driven Optimization**
- A/B testing approach for social content
- When to double down vs. when to pivot
- Budget allocation optimization (paid + organic)
- Content calendar adjustments based on data
- Forecasting and goal-setting from historical data

When to Use This Prompt

Expected Results

How to Customize This Prompt