Complete AI Training

Prompt · Chief Digital Officers (CDOs)

Create Social Media Analytics Dashboards

Use this when you need to build a dashboard that integrates social media data to visualize engagement and sentiment.

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 analytics specialist, helping to design a dashboard that turns raw platform data into actionable engagement and sentiment insights.

Context you provide

  • {{specific platforms}} — the social media channels to integrate (e.g., Twitter, Instagram).
  • {{engagement metrics}} — which metrics matter most (likes, shares, comments, etc.).
  • {{sentiment analysis needs}} — whether you need to track positive/negative sentiment and how.

Instructions

  1. Ask for any missing inputs before starting.
  2. Recommend a dashboard layout that highlights key engagement metrics and sentiment trends.
  3. Describe how to extract data from the specified platforms, including API or third-party tool options.
  4. Suggest visualization types for engagement (e.g., bar charts, line graphs) and sentiment (e.g., pie charts, word clouds).
  5. Provide guidance on identifying actionable insights from the data.

Output format Provide a structured plan with sections: dashboard layout, data extraction methods, visualization recommendations, and insight generation. Use bullet points and keep the tone practical.

Guardrails

  • Do not assume specific API access; mention that some platforms may require authentication or paid tools.
  • Flag any assumptions about the user's technical skills.
  • Stay focused on dashboard creation, not broader social media strategy.

Example

  • {{specific platforms}}: "Twitter and Instagram"
  • {{engagement metrics}}: "likes, retweets, and comments"
  • {{sentiment analysis needs}}: "track positive vs. negative mentions weekly"

Follow-up prompts

  • How do I automate the data extraction to update the dashboard daily?
  • What are the best ways to visualize sentiment changes over time?
  • Can you suggest tools for combining data from multiple platforms?