Social Media Analytics Report
The Prompt
The Logic
1. Engagement Rate Trumps Follower Count for Real Performance
The most common mistake in social media analytics is obsessing over follower count while ignoring engagement rate—yet engagement rate is the only metric that truly indicates audience connection and algorithm favor. This framework prioritizes engagement analysis because a 10,000-follower account with 8% engagement rate (800 engaged people per post) dramatically outperforms a 100,000-follower account with 0.5% engagement (500 engaged people per post). The former has better algorithmic distribution, higher conversion potential, and more valuable audience relationships. Engagement rate also reveals content resonance: declining engagement despite growing followers signals audience mismatch or content quality issues. The framework calculates engagement multiple ways (total engagements / followers, engagements / reach, engagement velocity) because each reveals different insights. Platforms reward high engagement with greater organic reach, creating a compounding effect—strong engagement drives more reach, which drives more engagement. Focusing optimization efforts on engagement rate improvement yields far greater ROI than follower growth tactics that attract low-quality, unengaged audiences.
2. Content Type Performance Reveals Algorithm Preferences and Audience Behavior
Different content formats perform radically differently on each platform because algorithms prioritize certain formats and audiences consume content differently. This framework mandates content type analysis because Instagram's algorithm heavily favors Reels (often 2-5x the reach of static posts), TikTok obviously prioritizes video, LinkedIn rewards text posts and documents over links, and Twitter/X engages most with conversational threads. By analyzing performance by content type, you discover which formats your audience prefers and which the algorithm amplifies—often these differ from what you assume or prefer creating. Many brands keep producing static Instagram posts despite data showing Reels get 400% more reach, simply because they haven't systematically analyzed content type performance. The analysis also reveals content-specific optimal strategies: carousel posts might have lower engagement rates but higher save rates (indicating reference value), while Reels have high engagement but low conversion rates. Understanding these nuances enables strategic content mix optimization—using each format for its strength rather than treating all content equally.
3. Top Performer Analysis Identifies Replicable Success Patterns
Most social media managers treat viral posts as lucky accidents rather than data points revealing success formulas. This framework demands deep analysis of top-performing content because patterns emerge when you examine multiple high-performers: specific hooks that stop scrolling, content structures that drive completion, topics that trigger sharing, CTAs that generate clicks. By systematically documenting what made each top post successful (topic, format, caption style, posting time, hook, CTA, visual style), you build a success playbook rather than hoping for another lucky break. The analysis often reveals non-obvious patterns—perhaps your educational content outperforms promotional despite you posting 80% promotional, or Wednesday posts consistently outperform Monday despite conventional wisdom. Many brands discover their "best" content (what they think is high-quality) differs dramatically from their highest-performing content (what the audience actually engages with), creating opportunity for strategic pivot. The framework also identifies anti-patterns from low performers, creating clear "what to avoid" guardrails.
4. Temporal Analysis Unlocks Algorithmic Distribution and Audience Availability
Social media algorithms use recency as a primary ranking signal, and audience availability varies dramatically by time, making when you post nearly as important as what you post. This framework includes comprehensive temporal analysis because posting when your specific audience is most active (not generic "best times") can increase engagement 30-100%. The analysis examines day-of-week patterns (perhaps your B2B audience engages more Tuesday-Thursday, avoiding Monday chaos and Friday checkout), time-of-day patterns (early morning commuters, lunch scrollers, evening relaxers), and seasonal patterns (summer vacation drops, holiday engagement spikes, industry-specific cycles). Most brands use platform-provided "best times" which are generic averages, not their specific audience patterns. Your software company's audience might be most active 8-10am EST when checking updates, while your fashion brand's audience peaks 7-9pm when evening scrolling. The temporal analysis also reveals when NOT to post—times when your content gets buried by algorithmic competition or audience unavailability, wasting content that could perform better at optimal times.
5. Competitive Benchmarking Reveals Relative Performance and Opportunity Gaps
Analyzing your metrics in isolation provides incomplete perspective—1,000 followers might be excellent or terrible depending on industry, niche, and competitive context. This framework mandates competitive benchmarking because relative performance reveals your true market position and identifies exploitable gaps. If your engagement rate is 3.5% but competitors average 5-7%, you have an engagement problem despite an "acceptable" absolute number. Conversely, if competitors average 1.2% engagement and you're at 2.8%, you're winning even though industry benchmarks suggest 4%+ is ideal. The competitive analysis also identifies strategic opportunities: if all competitors post promotional content and ignore educational, educational content becomes your differentiation wedge. If competitors post daily but engagement is diluted, your strategic 3x weekly might capture more attention per post. Competitor content analysis reveals what works in your niche (validated by their engagement data) without requiring you to experiment blindly. The framework transforms competition from threat into intelligence source—their experiments inform your strategy, their failures warn you away from ineffective tactics, their successes provide tested templates to adapt.
6. Conversion Tracking Connects Social Metrics to Business Outcomes
Vanity metrics (followers, likes, impressions) are meaningless without business impact—this framework connects social performance to actual business results because executive buy-in and budget allocation require ROI demonstration. The analysis tracks the full funnel: impressions → profile visits → link clicks → website traffic → leads → customers → revenue. Many social media managers celebrate "great engagement" while contributing zero to business goals because they haven't mapped social metrics to conversions. The framework identifies which content types and topics drive not just engagement but valuable actions: profile visits from potential customers (not random scrollers), link clicks from qualified prospects, leads from ideal customer profiles. It also reveals conversion optimization opportunities: perhaps your posts get high engagement but low link clicks (weak CTA or offer), or high clicks but low website conversion (traffic-to-landing page mismatch). For e-commerce, the analysis attributes revenue to specific social posts. For B2B, it tracks lead generation by content type. This transforms social media from "brand awareness activity" into measurable revenue channel with clear ROI, justifying increased investment in what works and eliminating what doesn't drive business outcomes.
Example Output Preview
Sample Output for @FitnessFusion - Instagram/TikTok Analytics (December 2025)
EXECUTIVE SUMMARY
Social Media Health Score: 7.2/10 (Up from 6.4 in November)
Overall Assessment: Strong growth momentum with engagement improvements, but reach plateau requires attention. TikTok emerging as breakout platform while Instagram needs content strategy refresh.
🏆 TOP 3 WINS:
- TikTok Explosion: 847% follower growth (2,400 → 22,700 followers) driven by 3 viral videos breaking 500K+ views each
- Engagement Rate Surge: Instagram engagement rate improved from 4.2% to 6.8% (+62%) by shifting to 70% Reels vs. 30% static posts
- Conversion Improvement: Link clicks increased 127% (1,240 → 2,814 clicks) with new "link in bio" CTA strategy, driving 340 trial sign-ups (+215% vs November)
⚠️ TOP 3 CHALLENGES:
- Instagram Reach Plateau: Despite 12% follower growth, reach only increased 3% - algorithmic suppression of non-Reels content hurting overall visibility
- TikTok Engagement Inconsistency: Massive following growth but engagement rate dropped from 18% (small account) to 6.2% (larger account) - need to maintain community feel
- Content Production Bottleneck: Only posted 18 times in December vs. goal of 25 - inconsistency impacting algorithm favor and audience retention
PRIMARY RECOMMENDATION:
Double down on short-form video (Reels + TikTok) with systematic content batching. Data shows video content delivers 4.3x the engagement and 7.1x the reach of static posts. Implement weekly batch recording (6-8 videos per session) to solve production bottleneck while capitalizing on algorithm preference for Reels. Expected impact: 40-60% reach increase, sustained engagement rate above 6%, follower growth acceleration to 15-20%/month.
INSTAGRAM PERFORMANCE ANALYSIS (December 2025):
GROWTH METRICS: Followers: 34,200 (start) → 38,300 (end) = +4,100 (+12%) November growth: +8.5% (slower acceleration) Follower Growth Quality: EXCELLENT - Engagement rate of new followers: 7.4% (above account avg 6.8%) - Profile visit-to-follow conversion: 22% (industry avg: 15%) - Unfollows: 280 (0.8% churn rate - very low) REACH & IMPRESSIONS: Total Reach: 487,000 accounts (vs 473,000 Nov, +3%) Reach Rate: 21.4% (487K reach / 38.3K avg followers) - Analysis: LOW - should be 40-60% for healthy account - Root cause: Static posts averaging only 8% reach rate Total Impressions: 1,240,000 (+8% vs Nov) Impression-to-Reach Ratio: 2.54 (users saw content avg 2.5x) Reach Breakdown: - Reels: 384,000 reach (79% of total) from only 15 Reel posts - Static Posts: 68,000 reach (14%) from 8 static posts - Stories: 35,000 reach (7%) - daily stories Avg Reach per Reel: 25,600 (67% of followers) Avg Reach per Static Post: 8,500 (22% of followers) Insight: Reels get 3x the reach - shift content mix urgently ENGAGEMENT ANALYSIS: Total Engagements: 26,010 (up from 15,840 Nov, +64%) Engagement Rate: 6.8% (26,010 / 383,500 avg followers) - November: 4.2% (+62% improvement ✅) - Industry Benchmark (Fitness): 3.8-5.2% - Position: ABOVE BENCHMARK (top 25% of fitness accounts) Engagement Breakdown: - Likes: 22,400 (86% of engagements) - Comments: 2,180 (8%) - avg 95 comments/post - Shares: 890 (3.4%) - strong shareability - Saves: 540 (2.1%) - good for educational content Engagement by Content Type: - Reels: 8.9% avg engagement rate (23,550 engagements, 15 posts) - Static Posts: 2.1% avg engagement rate (1,680 engagements, 8 posts) - Carousels: 3.8% avg engagement rate (780 engagements, 2 posts) Comment Sentiment Analysis: - Positive: 78% (questions, praise, motivation) - Neutral: 18% (tags, emojis) - Negative: 4% (criticism, spam) Healthy community engagement - strong positive sentiment TRAFFIC & CONVERSIONS: Profile Visits: 12,800 (up from 9,200 Nov, +39%) Visit-to-Follow Rate: 32% (4,100 new follows / 12,800 visits) Link Clicks: 2,814 (vs 1,240 Nov, +127% 🔥) Link Click Rate: 0.23% (2,814 clicks / 1,240,000 impressions) External Website Traffic from IG: 2,340 sessions Trial Sign-ups Attributed: 340 (14.5% conversion from web visits) Instagram Platform Health Score: 7.8/10 Strengths: Strong engagement growth, excellent Reel performance Weaknesses: Static post suppression, need higher posting frequency Opportunities: Stories optimization, IGTV/long-form content testing Threats: Algorithm increasingly favoring video - must adapt fully
TOP PERFORMING CONTENT ANALYSIS:
#1 POST: "5 Exercises You're Doing WRONG" Reel Format: 45-second Reel, fast cuts, on-screen text Reach: 84,200 (220% of followers!) Engagement: 9,840 (11.7% engagement rate) - Likes: 8,420 - Comments: 940 (highest of month - lots of questions) - Shares: 380 - Saves: 100 Success Factors: ✓ Hook: Started with "STOP doing squats like this" - instant attention ✓ Value: Corrected common form mistakes - highly practical ✓ Format: Quick cuts between "wrong" and "right" form - engaging ✓ CTA: "Which one surprised you? 👇" - drove comments ✓ Timing: Posted Tuesday 6:30am - caught morning gym-goers ✓ Trend: "You're doing X wrong" format trending on Reels #2 POST: "10 Min Morning Stretch Routine" Reel Reach: 67,300 Engagement: 6,730 (10.0% engagement rate) Saves: 340 (5.0% save rate - highest of month!) Success Factors: ✓ Value: Full workout routine - high save value for reference ✓ Length: 60-second Reel covering 10 movements - satisfying completion ✓ Accessibility: "No equipment needed" - broad appeal ✓ Timing: Posted Sunday 8pm - evening planners saved for Monday ✓ Hook: "Save this for tomorrow morning 🌅" - save-focused #3 POST: "Gym Etiquette PSA" Reel (Humorous) Reach: 58,900 Engagement: 5,300 (9.0% engagement rate) Shares: 280 (highest share rate - 5.2%) Success Factors: ✓ Entertainment: Funny take on annoying gym behaviors - relatable ✓ Shareability: "Tag someone who needs to see this" - share driver ✓ Format: Point-of-view style - engaging perspective ✓ Community: Inside jokes for gym-goers - strong community resonance COMMON SUCCESS PATTERNS IDENTIFIED: 1. Video format (Reels) = 3-5x reach of static content 2. Educational + entertaining hybrid performs best 3. Strong hooks in first 2 seconds (stop scrolling) 4. CTAs that drive specific action (comment, save, share) 5. Length: 45-60 seconds optimal (completion rate drops after 60s) 6. Trending audio + original content = best of both worlds 7. On-screen text for sound-off viewing 8. Morning posts (6-8am) capture pre-workout audience
TIKTOK PERFORMANCE (BREAKOUT PLATFORM):
EXPLOSIVE GROWTH METRICS: Followers: 2,400 (Dec 1) → 22,700 (Dec 31) = +20,300 (+847% 🚀) Growth Driver: 3 viral videos (500K, 680K, 1.2M views) Total Video Views: 3.8 Million Total Engagement: 267,000 Engagement Rate: 6.2% (down from 18% at 2K followers) - Analysis: Normal decline with rapid growth - maintaining quality - Still ABOVE TikTok fitness average (4.5-5.5%) Profile Visits: 48,200 Visit-to-Follow Rate: 42% (20,300 / 48,200) - EXCELLENT VIRAL CONTENT ANALYSIS: Video #1: "Gym Crush Motivation" POV (1.2M views) - 18,400 followers gained from this single video - Why it worked: Relatable humor + trending audio + POV format - Shares: 4,200 (viral sharing to friends) Video #2: "Transformation: 90 Days" Time-lapse (680K views) - 8,700 followers gained - Why it worked: Inspiring results + trending "glow up" format - High completion rate (78% watched to end) Video #3: "Things I Wish I Knew Before Starting Gym" (500K views) - 6,200 followers gained - Why it worked: Beginner-focused education + vulnerable storytelling TikTok Platform Health Score: 6.5/10 Strengths: Viral growth, strong follower acquisition Weaknesses: Inconsistent posting (12 videos only), engagement rate declining Opportunities: Establish consistent posting (1-2x daily for algorithm) Threats: Rapid follower growth without engagement maintenance = dead account
STRATEGIC RECOMMENDATIONS (PRIORITIZED):
IMMEDIATE ACTIONS (Next 2 Weeks):
- Implement Video Content Batching: Schedule one 3-hour batch recording session weekly to create 6-8 Reels. This solves production bottleneck and ensures consistent daily posting. Use trending audio library to pre-plan content around hot sounds.
- Optimize Instagram Content Mix: Shift to 80% Reels, 15% Carousels, 5% static (only for announcements). Archive or delete lowest-performing static posts to improve account-wide engagement rate.
- TikTok Consistency Sprint: Post 1-2x daily for 30 days to capitalize on current algorithm momentum. Viral accounts that go silent lose favor quickly - strike while hot.
30-DAY FOCUS (January 2026):
- Content Type: Double down on "exercise form correction" series - proven high engagement
- Posting: 5-7 Reels/week on Instagram, 10-14 videos/week on TikTok
- Growth Target: 6,000 Instagram followers (+15%), 15,000 TikTok followers (+66%)
- Engagement Goal: Maintain 6.5%+ IG engagement, improve TikTok to 7%+
- Conversion Goal: 450 trial sign-ups (+32% vs December)
90-DAY EXPERIMENTS TO TEST:
- Instagram Stories series: Daily "Form Fix Friday" spotlighting follower form videos (UGC + engagement)
- TikTok series: "Gym Storytime" - narrative content about fitness journey (builds personal connection)
- Cross-platform strategy: Tease TikTok content on Instagram Stories to drive cross-following
- Paid amplification test: $500 budget boosting top 3 Reels to lookalike audiences
Prompt Chain Strategy
Step 1: Data Collection & Organization
Expected Output: Platform-specific data collection checklist with metric definitions, locations in analytics dashboards, export instructions, and competitor tracking guidance. This ensures you collect the right data systematically for comprehensive analysis.
Step 2: Comprehensive Analytics Report
Expected Output: Full social media analytics report with platform performance, content analysis, audience insights, competitive benchmarking, conversion tracking, and strategic recommendations with 90-day roadmap.
Step 3: Content Strategy Optimization & Calendar
Expected Output: Optimized content strategy with specific content mix percentages, detailed posting schedule with dates/times, replicable content templates for high-performers, and 20 ready-to-execute content ideas in calendar format. This transforms analysis into immediate execution.
Human-in-the-Loop Refinements
1. Audience Cohort Analysis
After receiving your report, request deeper audience segmentation: "My analytics show mixed performance across demographics. Segment my audience into cohorts: (1) Age groups (18-24, 25-34, 35-44, 45+), (2) Geographic regions (top 3 locations), (3) New followers (last 30 days) vs. long-time followers (90+ days). For each cohort, analyze: engagement rate differences, content preferences, active times, conversion rates. Which cohort has highest lifetime value potential? Should I create different content for different segments?" This reveals whether you're trying to serve everyone and pleasing no one, or if specific segments deserve focused attention. Many brands discover their highest-engaging cohort is different from their largest cohort, enabling strategic targeting.
2. Competitor Content Gap Analysis
Request specific competitive intelligence: "Analyze my top 3 competitors' content strategies: [Competitor1], [Competitor2], [Competitor3]. For each, identify: (1) Content types they post that I don't, (2) Topics they cover that I'm ignoring, (3) Engagement tactics they use successfully, (4) Posting frequency and timing differences, (5) Their top 5 performing posts from last 30 days. Then identify opportunity gaps: what topics or formats are neither I nor competitors exploiting? Create a 'competitive differentiation matrix' showing where I can win." This prevents creating content in a competitive vacuum and reveals untapped positioning opportunities. Often the biggest wins come from zigging while competitors zag.
3. Conversion Funnel Mapping
Request full-funnel analysis: "Map my social media funnel from awareness to conversion: Impressions → Reach → Engagement → Profile Visit → Link Click → Website Visit → Lead/Purchase. Calculate conversion rates between each stage. Where is the biggest drop-off? If I could improve one stage by 50%, which would have the largest revenue impact? Then for each content type (Reels, posts, Stories), show which funnel stage it serves best. Create a funnel-optimized content mix that moves people through stages efficiently." This connects social metrics to business outcomes and identifies whether you have a top-of-funnel problem (reach), middle problem (engagement/credibility), or bottom problem (conversion/offer).
4. Algorithm Reverse Engineering
Request platform-specific algorithm insights: "For [PLATFORM], analyze my content that the algorithm loves vs. suppresses. Compare high-reach posts (>40% of followers) vs. low-reach posts (<15%). Identify patterns: hooks used, video length, caption length, hashtag count, posting time, topic, format. What algorithm signals am I sending that help or hurt distribution? Based on latest algorithm updates for [PLATFORM], which ranking factors should I optimize for? Create an 'algorithm checklist' I can use before posting each piece of content." This transforms vague algorithm understanding into specific, testable optimization tactics. Algorithms change constantly; continuous reverse-engineering maintains competitive advantage.
5. Seasonal and Event-Based Planning
Request forward-looking opportunity calendar: "Based on my industry ([INDUSTRY]) and audience behavior patterns, identify upcoming seasonal opportunities, holidays, trending events, and cultural moments for the next 90 days. For each opportunity: date, expected audience interest level, content ideas to capitalize, historical performance data from similar past moments (if any). Also identify 'avoid dates' when my audience is typically inactive. Create a 90-day opportunity calendar with pre-planned content themes, posting intensification periods, and quiet periods for batch content creation." This enables proactive content planning rather than reactive scrambling, and capitalizes on high-engagement periods when algorithms favor timely, relevant content.
6. Performance Prediction Modeling
Request predictive analysis: "Based on my current growth trends, engagement patterns, and planned strategy changes, project my social media metrics 90 days forward: follower count, engagement rate, reach, website traffic, conversions. Create three forecasts: (1) If I continue current strategy unchanged, (2) If I implement your recommended optimizations, (3) Best-case scenario with perfect execution + viral boost. For each forecast, show assumptions and confidence level. Also identify 'early warning indicators'—metrics that if they drop in Week 2-4, signal I'm off track and need to adjust." This creates accountability benchmarks and helps set realistic expectations with stakeholders. Many social strategies fail not because of poor execution but because of unrealistic timeline expectations.