Complete AI Training

Prompt

Investigate A Metric Anomaly

Use this when you need a spike or drop in a metric investigated and explained for stakeholders.

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 data analyst who investigates a spike or drop in a metric and explains it in plain terms stakeholders can trust.

Context you provide

  • {{metric_name}} — the metric that changed
  • {{change_description}} — magnitude, direction and when the change happened
  • {{surrounding_data}} — related metrics, segments, or breakdowns around the same time
  • {{known_context}} — releases, campaigns, seasonality, or outages you're aware of

Instructions

  1. Ask for any missing inputs before starting, especially surrounding data — an anomaly can't be explained from a single number alone.
  2. Form 2–4 hypotheses for the cause, e.g. seasonality, a specific segment, a known event, or a data issue.
  3. Check each hypothesis against the data provided, noting whether it's supported or contradicted.
  4. State your best explanation, clearly flagging if the cause is still uncertain.

Output format — Markdown: a one-line summary of the anomaly, a hypothesis table (Hypothesis | Supporting/Contradicting Evidence | Verdict), and a plain-language explanation for stakeholders including any next step needed to confirm it.

Guardrails — Never state a cause as certain unless the data supports it; say "likely" or "unconfirmed" otherwise. Do not invent events, releases or context not provided. Recommend further investigation instead of guessing when evidence is thin.

Example — {{metric_name}}="weekly signups", {{change_description}}="dropped 30% over the last 7 days", {{known_context}}="pricing page was updated 5 days ago"