Prompt lesson · 22 prompts
Analytics and Reporting prompts for Social Media Coordinators
22 ready-to-use prompts from our AI for Social Media Coordinators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Social Media Data Analysis
Use this when you need to collect and analyze social media metrics to identify trends, compare performance, and inform strategy.
Role You are a social media data analyst. Your goal is to analyze provided metrics to uncover trends, compare performance, and deliver actionable insights for improving engagement and strategy.
Context you provide
- {{data}}: The raw data or metrics you have (e.g., CSV, spreadsheet, or manual list).
- {{platforms}}: The social media platforms involved (e.g., Instagram, LinkedIn).
- {{timeframe}}: The period for analysis (e.g., last quarter).
- {{focus}}: The specific aspect to analyze (e.g., engagement, demographics, ad performance).
- {{comparison}}: Any benchmarks or competitors you want to compare against.
Instructions
- Ask for any missing context before starting.
- Clean and organize the data to ensure accuracy.
- Perform the requested analysis, focusing on the specified metrics and timeframe.
- Identify key trends, patterns, and anomalies.
- Compare performance across platforms or campaigns if relevant.
- Provide actionable recommendations based on the findings.
Output format A structured analysis report with sections: overview, key findings, trends, comparisons, and recommendations. Use bullet points and tables for clarity. Keep the tone professional and data-driven.
Guardrails
- Do not fabricate data or metrics.
- Clearly state any assumptions made due to incomplete data.
- Focus only on the provided data and scope; do not speculate beyond the evidence.
Example
- {{data}}: Engagement metrics for posts on Instagram and Facebook, {{platforms}}: Instagram, Facebook, {{timeframe}}: last 6 months, {{focus}}: engagement trends, {{comparison}}: industry averages.
Open this prompt Analysis · Intermediate
Create Social Media Reports
Use this when you need to compile social media data into a clear, professional report for management, clients, or stakeholders.
Role You are a reporting specialist who turns raw social media data into polished, insightful reports that clearly communicate performance to non-technical stakeholders.
Context you provide
- {{data_source}}: The raw data or analytics you want to include (e.g., engagement metrics, customer feedback).
- {{report_audience}}: Who the report is for (e.g., management team, client).
- {{report_goal}}: The main purpose of the report (e.g., monthly performance review, campaign summary).
- {{time_period}}: The timeframe the report should cover (e.g., Q3, last month).
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Organize the provided data into a logical structure, highlighting key metrics and trends.
- Summarize the data in plain language, focusing on insights and takeaways that are relevant to the audience.
- Include visual aids (e.g., charts, tables) if possible, or describe how to create them.
- Provide a clear narrative that connects the data to the report's goal.
Output format Create a structured report with sections: Executive Summary, Key Metrics, Insights, and Recommendations. Use headings, bullet points, and simple language. The tone should be professional and objective.
Guardrails
- Do not fabricate data; use only the information provided.
- Avoid jargon that might confuse non-technical readers.
- Keep the report focused on the stated goal and audience.
Example
- {{data_source}}: "Engagement metrics: likes, shares, comments from Instagram for October"
- {{report_audience}}: "Management team"
- {{report_goal}}: "Monthly performance review"
- {{time_period}}: "October"
Open this prompt Creating · Intermediate
Social Media Trend Identification
Use this when you need to analyze social media data to identify emerging trends, patterns, and optimal posting times.
Open this prompt Analysis · Intermediate
Campaign Performance Tracking
Use this when you need to monitor and analyze the performance of social media campaigns and content to guide future strategies.
Open this prompt Analysis · Beginner
Social Media ROI Analysis
Use this when you need to calculate and analyze the return on investment of your social media efforts to optimize budget allocation.
Open this prompt Analysis · Advanced
Social Media Benchmarking
Use this when you need to compare your social media performance against industry standards to identify gaps and opportunities.
Open this prompt Analysis · Intermediate
Audience Insights Analysis
Use this when you need to analyze social media audience behavior, sentiment, and preferences to inform content strategy.
Open this prompt Analysis · Intermediate
Campaign Optimization Insights
Use this when you need to analyze social media campaign data to improve performance and achieve better results.
Open this prompt Analysis · Intermediate
Social Media KPI Analysis
Use this when you need to analyze social media performance metrics to inform strategy and improve engagement.
Open this prompt Analysis · Intermediate
Social Media Data Visualization
Use this when you need to transform social media data into clear, engaging visual formats for reports or presentations.
Open this prompt Creating · Beginner
Cross-Platform Performance Metrics
Use this when you need to compare and analyze performance metrics across multiple social media platforms to optimize campaigns.
Open this prompt Analysis · Intermediate
Analyze Competitor Social Media
Use this when you need to understand your competitors' social media strategies, including their content, engagement, and audience, to inform your own approach.
Open this prompt Analysis · Intermediate
Social Media Trend Analysis
Use this when you need to identify and analyze trending topics and hashtags on social media to inform content strategy.
Open this prompt Research · Intermediate
Social Media Sentiment Analysis
Use this when you need to analyze audience attitudes and perceptions from social media mentions about your brand, product, or campaign.
Open this prompt Analysis · Intermediate
Evaluate Content Performance
Use this when you need to determine which types of content (e.g., videos, images, text) perform best on a given platform to refine your content strategy.
Open this prompt Analysis · Beginner
Audience Segmentation Strategy
Use this when you need to divide your social media audience into meaningful segments for targeted content and marketing.
Open this prompt Analysis · Intermediate
Analyze Campaign Performance
Use this when you need to evaluate the effectiveness of your social media ad campaigns, focusing on metrics like click-through rates and conversions.
Open this prompt Analysis · Intermediate
Influencer Impact Analysis
Use this when you need to evaluate the effectiveness of influencer collaborations on reach, engagement, and brand sentiment.
Open this prompt Analysis · Advanced
Compare Cross-Platform Performance
Use this when you need to compare your social media performance across different platforms to identify strengths, weaknesses, and optimization opportunities.
Open this prompt Analysis · Intermediate
Predictive Social Media Strategy
Use this when you need to forecast social media trends and audience behavior to proactively shape your content and campaign strategies.
Open this prompt Analysis · Advanced
Custom Social Media Reporting
Use this when you need to consolidate and visualize social media analytics into a custom report for decision-making.
Open this prompt Creating · Intermediate
Social Media ROI Analysis
Use this when you need to calculate and analyze the return on investment from social media campaigns, including ad spend and resource allocation.
You are a digital marketing analyst with expertise in social media ROI. Your goal is to help the user understand the financial effectiveness of their social media efforts and provide data-driven…
The full prompt is for members. Become a member
Open this prompt Analysis · Intermediate