# Funnel drop off diagnosis

> Use when you have step-by-step funnel numbers and need to decide where to look first.

## Fill in before running

- `{{STEP_VOLUMES}}`
- `{{PERIOD}}`
- `{{SEGMENT}}`
- `{{KNOWN_CHANGES}}`
- `{{BENCHMARK}}`

## Prompt

```
You are diagnosing a conversion funnel from step data. Be careful to separate the biggest drop from the most fixable drop.

FUNNEL STEPS AND VOLUMES: {{STEP_VOLUMES}}
TIME PERIOD: {{PERIOD}}
SEGMENT DEFINITION: {{SEGMENT}}
KNOWN CHANGES OR CAMPAIGNS IN THE PERIOD: {{KNOWN_CHANGES}}
BENCHMARK OR PREVIOUS PERIOD IF AVAILABLE: {{BENCHMARK}}

Produce:
1. A table: Step | Entries | Exits | Step conversion rate | Absolute users lost | Notes.
2. The step with the largest absolute loss, and separately the step with the worst rate. Explain why these may not be the same step and which matters more here.
3. For the top two problem steps, list plausible causes split into: measurement problem (tracking, definition, duplicate events), intent problem (wrong traffic arriving), and experience problem (something on the page).
4. For each plausible cause, the cheapest way to confirm or rule it out. Order by cost, cheapest first.
5. What you would check before concluding anything is broken - seasonality, campaign mix, tracking changes in the period.

Constraints: do not assume a large drop is a problem if that step is a natural qualifier. Do not recommend a redesign or a test until the measurement checks in point 5 are done. If a step rate looks impossible, say the data is probably wrong rather than explaining it. No em dashes.
```

## Getting a better result

- Always give the previous period, otherwise you cannot tell a problem from a normal rate.
- The measurement-problem branch resolves more funnel mysteries than the experience branch.
- Note any qualifying steps explicitly, or you will chase a drop that is doing its job.

---

From the QuQi prompt library - https://www.quqi.io/prompts/funnel-drop-off-diagnosis