Complete AI Training

Prompt · Social Media Coordinators

Social Media Data Analysis

Use this when you need to collect and analyze social media metrics to identify trends, compare performance, and inform strategy.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

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

  1. Ask for any missing context before starting.
  2. Clean and organize the data to ensure accuracy.
  3. Perform the requested analysis, focusing on the specified metrics and timeframe.
  4. Identify key trends, patterns, and anomalies.
  5. Compare performance across platforms or campaigns if relevant.
  6. 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.

Follow-up prompts

  • What specific trends did you identify in engagement over this period?
  • How do our metrics compare to industry benchmarks?
  • What content types drove the most interaction, and how can we replicate that?