Generate weekly social performance reports

Generate founder-focused weekly/monthly social performance reports

Founder-led social teams who need a weekly cadence of performance insights without exhaustive daily dashboard management.

• · Metrics data for the period (from metrics-track)
• · A/B test results (from ab-test-analyze)
• · Content calendar (planned vs actual)
• · External events that influenced performance

• · Executive Summary (3-4 sentences, 30-second read)
• · Metrics at a Glance table (posts, impressions, ER per platform, follower growth, link clicks)
• · Top 3 Posts with analysis (why it worked)
• · Bottom 3 Posts with diagnosis (why it underperformed)
• · Format Analysis table (Thread ER% vs Carousel vs Single Post)
• · Pillar Performance table (which content pillars drive engagement vs conversion)
• · Key Learnings (3-5 specific learnings with supporting data)
• · Recommendations (2-3 specific, testable actions)

• · Metrics data collected for the full period
• · A/B test results available (optional but recommended)
• · Content calendar shows planned vs actual posts
• · Previous period data available for comparison (YoY or trend analysis)

• · Executive summary exceeds 30-second read (founder skips it)
• · Top/bottom 3 analysis lacks actionable hypothesis (just 'it did well')
• · Recommendations are vague ('post more', 'engage more') instead of specific
• · Doesn't track conversion funnel end-to-end (impressions → engagement → signups)
• · Fails if data missing for entire platform (incomplete comparison)

• · Output format explicitly designed for founder 30-second read (executive summary first)
• · Conversion funnel tracked end-to-end (impressions → engagement → profile visits → link clicks → signups)
• · Key Learnings extracted with specific supporting data (not generic advice)
• · Recommendations are testable and specific (e.g., 'Increase thread cadence from 2/week to 3/week targeting Tue/Thu mornings')
• · Always-on learnings doc implied (continuous improvement across weeks)