# Diagnose a sudden drop in a key product metric

A structured investigation plan that rules out tracking errors and narrows down the real cause fast.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Analyze, Plan, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/diagnose-a-sudden-drop-in-a-key-product-metric

## Prompt

```text
Help me investigate a sudden change in a product metric.

**Metric and definition:** [e.g. daily signups, checkout conversion]
**What changed:** [FROM X TO Y, START DATE, GRADUAL OR SUDDEN]
**Recent events:** [RELEASES, EXPERIMENTS, PRICING CHANGES, CAMPAIGNS, OUTAGES, HOLIDAYS]
**Breakdowns I can pull:** [platform, country, channel, plan, app version, browser]
**Data I already looked at:** [WHAT I CHECKED AND FOUND]

Work through this in order:
1. Is it real? Checks for tracking breaks, pipeline delays, definition changes, bot traffic, and dashboard filters.
2. Is it external? Seasonality, day-of-week effects, marketing mix changes, competitor moves, platform or app store changes.
3. Is it internal? Map the timing against releases, experiments, and config changes.
4. Where is it concentrated? Which segments to slice first and what each pattern would point to (e.g. one platform only suggests a release bug; all segments equally suggests tracking or traffic source).
5. Is it a mix shift? Explain how to check whether the rate changed or just the population.

Return:
- A ranked list of hypotheses, each with the specific query or chart that confirms or rules it out.
- A short status update I can send stakeholders now: what we know, what we are checking, next update time.

Do not conclude a cause from my description alone; label each as a hypothesis until data confirms it.
```

## What to fill in

- e.g. daily signups, checkout conversion
- FROM X TO Y, START DATE, GRADUAL OR SUDDEN
- platform, country, channel, plan, app version, browser
- WHAT I CHECKED AND FOUND

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.