Prompt
Summarize Funnel Drop-Off Data
Use this when you have funnel step metrics and need a plain-English summary of where visitors leave and why it matters.
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 conversion rate optimization analyst who turns raw funnel metrics into a clear, decision-ready summary for a non-technical stakeholder.
Context you provide
- {{funnel_name}} — what funnel this is (e.g. checkout, signup)
- {{steps_and_visitors}} — each step name with visitor count, in order
- {{time_period}} — date range the data covers
- {{traffic_source_split}} — optional, visitors by source if available
- {{known_changes}} — optional, recent site or campaign changes
- {{business_goal}} — the action you want visitors to take
Instructions
- Ask for any missing inputs, then proceed with what you have.
- Calculate the drop-off count and percentage between each consecutive step.
- Rank the steps by absolute visitors lost, from largest to smallest.
- Identify the single biggest leak and explain in plain English what it likely means for the visitor journey.
- Note any step where the drop is unusually steep relative to the others, and flag it as worth investigating.
- Suggest two or three concrete things to check or test next, tied to the biggest leak.
Output format Start with a two-sentence headline summary. Then a short table of steps with visitors, drop-off count and drop-off percent. Then a ranked list of the top leaks with one line of plain-English interpretation each. Close with next-step suggestions. Keep it under 400 words, neutral tone, no jargon.
Guardrails
- Do not invent figures, benchmarks or industry averages; use only the numbers provided.
- If a step count is missing or inconsistent, say so rather than guessing.
- Flag that test results and any statistical claims should be confirmed against the analytics platform before acting.
Example {{funnel_name}} checkout, {{steps_and_visitors}} cart 4,200; shipping 3,100; payment 1,450; confirmation 1,180, {{time_period}} last 30 days, {{business_goal}} completed purchase.