100 Best Claude Social Media Report Prompts for Social Media Managers

Direct Answer

The best Claude prompts for social media report for social media managers are a comprehensive, ready-to-run set of tasks that produce executive-friendly summaries, platform comparisons, top posts analyses, audience sentiment snapshots, and actionable optimization guidance. Use these prompts to generate repeatable weekly reports with clear insights and recommended actions for stakeholders.

Introduction

This page is a practical prompt library crafted for social media managers who need structured, repeatable reports. It provides 100 Claude prompts designed to extract data-driven insights, benchmark performance, and drive decision-making across multiple social platforms.

The prompts are explicit, copyable, and ready to run without requiring readers to supply missing context. Each entry includes role, task, context, output format, and constraints to maximize usefulness.

How to Use These Claude Prompts

• Replace placeholders such as [industry], [audience], [product], [constraints], [data], [tone], and [format] with your own specifics.
• If a prompt asks for a table or bullets, specify the exact number of rows or bullets you want and the preferred units.
• Request consistent output formats to simplify reporting, such as 1-page summaries, bullet lists, or structured tables.
• Verify outputs by cross-checking with your analytics dashboard and adjusting the constraints to focus on the metrics you care about.
• When running multiple prompts, order them logically (summary first, then deeper analysis) to build a cohesive report.
• Adjust tone and output format to fit internal reporting standards and executive preferences.

100 Best Claude Social Media Report Prompts for Social Media Managers

1. Executive summary highlights: You are a skilled social media analyst. Task: Produce a concise executive summary of the latest social media performance in plain language. Context: The data covers the last 7 days across platforms: Facebook, Instagram, X, YouTube, LinkedIn. Include top performing post, engagement rate, follower growth, share of voice, and a one-sentence takeaway for leadership. Output format: bullet list, 1 page max, with short sentences. Constraints: no platform-specific jargon beyond common terms, avoid numbers unless critical, use a neutral tone.
2. Platform comparison overview: Role: Social media strategist. Task: Create a platform-by-platform comparison of performance metrics for the last month. Context: Metrics include reach, impressions, engagement, clicks, video views, and follower change. Output format: table-like bullets with columns for Platform, Metric, Last Month, Trend. Constraints: emphasize actionable insight and recommendations for optimization.
3. Top posts recap: Role: Content analyst. Task: List the top five performing posts across all platforms this period with reasons for success. Context: Include post type, caption length, creative format, and call-to-action effectiveness. Output format: numbered list with bullet points for each post, 2–4 sentences of justification.
4. Audience sentiment snapshot: Role: Brand listener. Task: Generate a sentiment snapshot for the audience across all platforms. Context: Include overall sentiment score range, notable positive themes, and recurring questions or concerns. Output format: short paragraph plus 4 impact bullets.
5. Content gap analysis: Role: Content strategist. Task: Identify content gaps by topic, format, and time period. Context: Compare posted content vs. audience interest signals from last 90 days. Output format: bullet list of gaps with proposed formats and quick test ideas.
6. Influencer impact view: Role: Partnerships lead. Task: Assess influencer-driven posts performance and conversion lift if data exists. Context: Include engagement rate, reach, and any attributed conversions. Output format: concise table and 2 recommended next steps.
7. Paid vs organic lift: Role: Campaign analyst. Task: Compare paid vs organic performance for the last month. Context: Include CTR, cost per result, engagement, and follower change. Output format: side-by-side bullets with a 1-sentence takeaway per row.
8. Content mix health check: Role: Social media editor. Task: Evaluate content mix health by format and topic alignment. Context: Last 60 days, include video, image, carousel, story, and live formats. Output format: chart-friendly bullets and 3 actionable tweaks.
9. Creative performance signals: Role: Creative lead. Task: Extract creative signals linked to performance (color palette, copy length, CTA type). Context: Use last 6 weeks of posts. Output format: bullets with 1–2 sentence rationale for each signal.
10. Publish timing optimization: Role: Scheduling lead. Task: Recommend optimal posting windows per platform for next 30 days. Context: Based on historical engagement by hour and day. Output format: per-platform bullet list with 3 suggested windows and a brief justification.
11. Competitive benchmark: Role: Competitive intelligence analyst. Task: Create a benchmark report against 3 named competitors. Context: Compare share of voice, engagement rate, posting frequency, and content themes. Output format: structured bullets with 1 paragraph of takeaway per competitor.
12. Story performance insights: Role: Story editor. Task: Analyze story/shorts performance across platforms and suggest 3 optimizations. Context: Focus on completion rate, taps forward, and sticker interactions. Output format: numbered list with metrics and recommended changes.
13. Hashtag effectiveness: Role: Hashtag strategist. Task: Assess hashtag sets by performance and relevance. Context: Last 60 posts across all platforms. Output format: table-like bullets with hashtag, reach, engagement, and suggested adjustments.
14. Audience growth opportunities: Role: Growth lead. Task: Identify 4 high-potential audience segments to target next month. Context: Based on interest signals and demographic data. Output format: bullets with segment description, suggested content, and forecast impact.
15. Crisis readiness check: Role: Communications lead. Task: Prepare a 1-page social response playbook for potential issues. Context: Include escalation steps, approved language, and post templates. Output format: concise list with 6 ready-to-use templates.
16. Top questions from comments: Role: Community manager. Task: Compile top 10 questions from user comments that require responses or content ideas. Context: Across all platforms this week. Output format: numbered list of Q&A pairs, each 1–2 sentences.
17. UGC performance view: Role: Community programs manager. Task: Review user-generated content performance and identify 3 high-potential UGC ideas. Context: Include engagement and alignment with brand values. Output format: bullet list with rationale.
18. Story highlights health: Role: Social editor. Task: Audit story highlights and save-worthy moments for archive. Context: Last 90 days, include saves and shares. Output format: short summary and 2 recommended highlights to pin.
19. Video performance score: Role: Video strategist. Task: Score video posts on a 5-point scale using length, hook, retention, and CTA. Context: Last 45 days. Output format: table-like bullets with scores and brief notes.
20. Caption testing plan: Role: Copywriter. Task: Design a caption A/B test plan for next 10 posts. Context: Variables include length, tone, CTA, and opening line. Output format: test matrix and decision rules.
21. Engagement by hour: Role: Data analyst. Task: Report engagement by hour for each platform. Context: Last 14 days. Output format: per-platform hourly breakdown with peak hours and recommended posting times.
22. Audience retention trends: Role: Analytics lead. Task: Identify 4 retention trends across video and carousel posts. Context: Last 60 days. Output format: bulleted findings with implications for content calendar.
23. Content repurposing plan: Role: Content strategist. Task: Propose a 4-week repurposing plan for evergreen content. Context: Include formats, platforms, and reuse sequence. Output format: list with week, format, platform, and expected impact.
24. Story vs feed comparison: Role: Social strategist. Task: Compare performance of stories versus feed posts for the last month. Context: Include reach, saves, shares, and clicks. Output format: side-by-side bullets and a 2-sentence recommendation.
25. Sentiment drift alert: Role: Brand manager. Task: Set up a drift alert for sudden sentiment changes. Context: Thresholds for positive/negative shifts. Output format: alert rule description and example notification.
26. Assistive analytics template: Role: Analytics lead. Task: Deliver a ready-to-use analytics report template for weekly social performance. Context: Include KPI list, charts, and executive notes. Output format: template outline with placeholders.
27. Content calendar health: Role: Planning lead. Task: Audit the current content calendar for balance and pacing. Context: Last 6 weeks. Output format: bullets with gaps and 2-3 improvement ideas.
28. Platform dos and don'ts: Role: Social media trainer. Task: Create a dos and don'ts checklist for best practices per platform. Context: Align with latest platform features. Output format: bullet list with 2 examples per platform.
29. KPIs by stakeholder: Role: PM/Consultant. Task: Align KPIs to three stakeholder groups: executives, marketing, product. Context: Provide a one-page KPI briefing. Output format: bullet list per stakeholder with KPI examples.
30. Impressions quality review: Role: Data quality analyst. Task: Review impression data quality and flag anomalies. Context: Last 30 days. Output format: numbered list of anomalies with potential causes and fixes.
31. Audience persona focus: Role: Research lead. Task: Match top performing content to audience personas and revise the persona brief. Context: Last quarter. Output format: bullets with persona-id and suggested content tweaks.
32. Post timing experiments: Role: Experimentation lead. Task: Design a 2-week post timing experiment with control and test groups. Context: Include success criteria and sample sizes. Output format: experiment plan and expected results.
33. Video thumbnail ideas: Role: Creative designer. Task: Generate 8 thumbnail concepts that improve video click-through. Context: For YouTube and platform shorts. Output format: list of concepts with brief rationale.
34. Caption localization plan: Role: Localization specialist. Task: Localize captions for two key markets while preserving tone. Context: Language variants and cultural considerations. Output format: translation notes and 2 sample captions per market.
35. Adjacency content map: Role: Content strategist. Task: Map adjacent topics to current content to increase discoverability. Context: Last 90 days. Output format: bullets linking topics and suggested post ideas.
36. Crisis comms templates: Role: Communications lead. Task: Prepare crisis response templates for social channels. Context: Include escalation steps and approved language. Output format: 6 template blocks.
37. Conversion signal lift: Role: Growth analyst. Task: Identify content-driven signals associated with conversions. Context: If available, use last 60 days data. Output format: bullets with signal and action.
38. Organic reach recovery plan: Role: Growth strategist. Task: Develop plan to recover organic reach after algorithm changes. Context: Include 4 tactics and success metrics. Output format: bullet list per tactic.
39. Mentions and brand lift: Role: Brand analyst. Task: Quantify brand lift from social mentions. Context: Last 90 days, include sentiment and share of voice. Output format: brief summary and 3 implications.
40. Audience geography map: Role: Insights specialist. Task: Visualize audience by region and country. Context: Last 6 months. Output format: regional bullet list with key metrics.
41. Product feedback extraction: Role: Product liaison. Task: Extract product feedback from comments and categorize by theme. Context: Last 30 posts. Output format: categorized list with top 3 themes.
42. Event-driven content plan: Role: Campaign lead. Task: Build a content plan around an upcoming event. Context: Event date and themes. Output format: 2-week plan with formats and posting times.
43. Story sequence optimization: Role: Content designer. Task: Create a high-engagement story sequence for a campaign. Context: Include CTAs, stickers, and transitions. Output format: sequence outline with timing.
44. Conversion-friendly captions: Role: Copywriter. Task: Write 12 captions optimized for conversion. Context: Include a clear CTA and value proposition. Output format: 12 captions with character counts.
45. Metrics dashboard starter: Role: BI engineer. Task: Deliver a starter dashboard outline for weekly social metrics. Context: Include key metrics and visuals. Output format: dashboard sections and data sources.
46. Seasonality plan: Role: Planner. Task: Build seasonality-aligned content ideas for upcoming quarter. Context: Include holidays and events. Output format: list with week, theme, and platform.
47. Listener feedback loop: Role: Community manager. Task: Design a feedback loop to capture insights from followers. Context: Include cadence and channels. Output format: 1-page loop with templates.
48. Cohort performance view: Role: Analytics analyst. Task: Compare performance by follower cohorts. Context: Last 3 cohorts, across all platforms. Output format: cohort bullets with key metrics and implications.
49. Video length optimization: Role: Video strategist. Task: Recommend optimal video lengths per platform. Context: Based on retention data from last 8 weeks. Output format: per-platform length guidance and rationale.
50. Caption tone consistency: Role: Brand editor. Task: Audit captions for tone consistency with brand voice. Context: Last 100 posts. Output format: findings with 3 before/after examples.
51. UGC rights checklist: Role: Legal/Brand. Task: Create a rights and attribution checklist for UGC campaigns. Context: All platforms. Output format: checklist with examples.
52. Curation vs creation balance: Role: Strategy lead. Task: Recommend balance between curated and original content. Context: Last 60 days. Output format: bullets with percentages and rationale.
53. Story highlights audit: Role: Social editor. Task: Audit story highlights and update archive. Context: Last 120 days. Output format: list of recommended highlights and rationales.
54. Social commerce readiness: Role: Commerce lead. Task: Assess readiness for social shopping features. Context: Platform by platform. Output format: readiness score and 2 actionable steps per platform.
55. Post reuse scorecard: Role: Content ops. Task: Score older posts for reuse viability. Context: Last 12 months. Output format: table with score and suggested reuse formats.
56. Accessibility check: Role: Accessibility lead. Task: Ensure captions and alt text meet accessibility standards. Context: Last 50 posts. Output format: list of issues and fixes.
57. Content approvals log: Role: Compliance officer. Task: Maintain a post-creation approvals log. Context: Include stakeholders and dates. Output format: simple table.
58. Bot and automation guardrails: Role: Platform engineer. Task: Define guardrails for automated posts and responses. Context: Across platforms. Output format: rules with examples.
59. Campaign ROI snapshot: Role: Finance/Marketing. Task: Calculate ROI for a social media campaign. Context: Include spend, reach, conversions, and revenue. Output format: 1-page summary with formula.
60. Cohesive brand narrative: Role: Brand strategist. Task: Align posts to a cohesive brand narrative. Context: Last 60 days of content. Output format: narrative map with 5 key themes.
61. Crisis scenario drills: Role: Communications lead. Task: Run a 1-page crisis drill using social posts. Context: 2 hypothetical scenarios. Output format: drill steps and response templates.
62. Top creators spotlight: Role: Partnerships lead. Task: Feature 5 top creators and summarize impact. Context: Last 90 days. Output format: bullets with metrics and next collaboration ideas.
63. Sentiment by platform: Role: Insights analyst. Task: Break down sentiment by platform and provide platform-specific actions. Context: Last 60 days. Output format: per-platform bullets and tips.
64. Content policy compliance: Role: Compliance officer. Task: Verify content adheres to platform guidelines. Context: Last 30 posts. Output format: checklist with fixes.
65. Listening alerts setup: Role: Social listening lead. Task: Configure alerts for spikes in mentions or sentiment shifts. Context: All platforms. Output format: alert rules and example messages.
66. Audience interest index: Role: Research lead. Task: Build a 10-item index of audience interest topics. Context: Based on engagement signals. Output format: numbered list with rationale.
67. Cross-channel content map: Role: Omnichannel strategist. Task: Create a map linking content topics to channels. Context: Last 90 days. Output format: bullets with channel-specific tips.
68. Owned vs earned analysis: Role: Analytics lead. Task: Compare owned content performance vs earned media mentions. Context: Last 60 days. Output format: side-by-side bullets and insights.
69. Influencer collaboration briefs: Role: Partnerships manager. Task: Draft 2 ready-to-ship collaboration briefs for influencers. Context: Brand voice aligned, deliverables listed. Output format: briefs with metrics and deadlines.
70. Automation efficiency check: Role: Ops lead. Task: Assess automation workflows and efficiency. Context: All platforms. Output format: bullets with estimated time savings and risks.
71. Hashtag strategy expansion: Role: Social strategist. Task: Propose 6 new hashtag sets for different themes. Context: Per platform. Output format: list with expected reach and caveats.
72. Engagement decay fix: Role: Community manager. Task: Diagnose and fix engagement decay on a platform. Context: Past 30 days. Output format: root cause bullets and 2 remedies.
73. Creative asset inventory: Role: Asset manager. Task: Inventory creative assets and plan re-use. Context: All campaigns. Output format: categorized inventory list with usage status.
74. Landing page alignment: Role: Content strategist. Task: Align social posts with landing page messaging. Context: Campaign-specific. Output format: bullets mapping posts to page sections.
75. Language and tone check: Role: Copy editor. Task: Verify language tone aligns with brand voice across posts. Context: Last 50 posts. Output format: issues and suggested edits.
76. Content approval timeline: Role: Project manager. Task: Create a timeline for content approvals. Context: Team members and dependencies. Output format: simple Gantt-like bullets.
77. Retention-focused formats: Role: Content planner. Task: Recommend formats that boost retention (how-to, stories, series). Context: Past 2 months. Output format: list with format and expected retention impact.
78. Follower growth forecast: Role: Growth analyst. Task: Forecast follower growth for next quarter. Context: Based on past performance and campaigns. Output format: bullet list with monthly targets.
79. Content localization diversity: Role: Localization lead. Task: Propose culturally diverse variants for 3 markets. Context: Include translations and cultural notes. Output format: per-market bullets.
80. Audience accessibility notes: Role: Accessibility advocate. Task: Provide accessibility notes for 4 posts. Context: Include captions and alt text. Output format: bullet list.
81. Post ideas from data: Role: Data-driven writer. Task: Generate 6 post ideas directly from analytics insights. Context: Last 30 days. Output format: idea with hook and 2 supporting data points.
82. Visual style guidelines: Role: Creative director. Task: Deliver 1-page visual style guidelines for posts. Context: Include color, typography, and layout rules. Output format: concise guidelines.
83. Audience Q&A plan: Role: Community manager. Task: Plan weekly Q&A threads based on audience questions. Context: Most common topics last month. Output format: calendar with prompts and prompts for answers.
84. Campaign recap briefing: Role: PM/Communications. Task: Create a 1-page recap of a completed campaign for executives. Context: Include goals, outcomes, lessons. Output format: brief bullets.
85. Platform feature leverage: Role: Strategy lead. Task: List 4 platform features to leverage for engagement. Context: Per platform. Output format: bullets with expected impact.
86. Dark-post performance: Role: Media buyer. Task: Analyze dark posts performance and provide optimization tips. Context: Last campaign. Output format: bullets with insights and next steps.
87. Event-triggered content: Role: Campaign manager. Task: Outline content that aligns with a live event. Context: Event date and activity. Output format: 1-page plan with posts and timing.
88. Data-dense report template: Role: BI/Analytics. Task: Deliver a dense data report template for social metrics. Context: Include charts, tables, and executive notes. Output format: outline with placeholders.
89. Content risk assessment: Role: Compliance lead. Task: Assess risk of posted content before publishing. Context: Last 20 posts. Output format: risk score and mitigation steps.
90. Mentions landscape: Role: Social listening analyst. Task: Map mentions by sentiment and source. Context: Last 7 days. Output format: bullet map with notes.
91. Campaign tagging taxonomy: Role: Data steward. Task: Propose a taxonomy for tagging content for analytics. Context: All campaigns. Output format: taxonomy list with examples.
92. Reverse engineering wins: Role: Growth lead. Task: Describe why top-performing posts succeeded and how to replicate. Context: Last 6 weeks. Output format: structured explanation and replication steps.
93. User journey touchpoints: Role: UX strategist. Task: Identify social touchpoints in the user journey. Context: Product funnel. Output format: bullets with suggested improvements.
94. Video series plan: Role: Content producer. Task: Outline a 4-episode video series for awareness. Context: Theme and CTA. Output format: episode briefs with hooks.
95. Story sequence profitability: Role: Creator strategist. Task: Design profitable story sequence with affiliate links. Context: Campaign. Output format: sequence outline and revenue notes.
96. Share of voice growth: Role: Market analyst. Task: Track share of voice changes and suggest actions. Context: Last 90 days. Output format: bullets with trend and actions.
97. Post-performance glossary: Role: Documentation specialist. Task: Create a glossary of performance terms used in reports. Context: Internal use. Output format: brief definitions for 15 terms.
98. Annual report prep: Role: Analyst. Task: Prepare a social media section outline for an annual report. Context: Include highlights, metrics, and trends. Output format: outline with placeholders.
99. Audience affinity signals: Role: Insights analyst. Task: Identify affinity signals linking content to audience passions. Context: Last 180 days. Output format: bullets with signal and example post.
100. Automation-friendly briefing: Role: Ops/Content lead. Task: Deliver a social media reporting briefing that is ready for automation via a simple script. Context: Include data sources, required fields, and output format. Output format: concise briefing with 1-page instructions.

Best Practices

• Test prompts on a small data slice first to refine placeholders and constraints.
• Save prompts as templates to reuse across campaigns and quarters.
• Combine multiple prompts into a single narrative for a comprehensive report.
• Review outputs for bias and ensure numbers align with your analytics platform.
• Maintain a clean prompt library with versioning to track improvements.

Common Mistakes to Avoid

• Using vague prompts that lack clear metrics or timeframes.
• Failing to replace placeholders with actual data or context.
• Overloading prompts with too many output constraints, causing incomplete results.
• Ignoring output validation and accepting every result as final.
• Not updating prompts to reflect platform changes or new features.

FAQ

What is the best way to use these prompts for a weekly report?

Run the summary prompts first to frame the week, then add platform comparisons and top posts prompts to fill the detailed report.

How do I ensure the outputs are executive-ready?

Ask for an executive-friendly format with a concise headline, 3 to 5 bullets of insights, and a one-paragraph takeaway.

Can I customize prompts for specific platforms?

Yes, replace placeholders with platform names and tailor metrics to each platform’s native analytics.

What if data is missing for a metric?

Specify a fallback metric or request data quality checks before the analysis and note any gaps in the output.

How do I automate these prompts for ongoing reports?

Store prompts as templates, integrate with your analytics API, and schedule automated runs with consistent output formats.

Are there prompts for crisis management and brand health?

Yes, there are prompts focused on sentiment, crisis readiness, and brand lift with ready-to-use templates.