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
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
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
- Ask for any missing inputs before starting, especially surrounding data — an anomaly can't be explained from a single number alone.
- Form 2–4 hypotheses for the cause, e.g. seasonality, a specific segment, a known event, or a data issue.
- Check each hypothesis against the data provided, noting whether it's supported or contradicted.
- 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"