Goal
Find the single funnel step where an improvement would add the most revenue, and back it with numbers.
Inputs
- Funnel steps in order: [e.g. visit, product view, add to cart, checkout start, purchase]
- Counts per step for this period and last period: [paste]
- Split by device or channel, if available: [paste or none]
- Average order value or deal value: [amount]
- Changes made between the periods: [e.g. new checkout, price change, festive sale, none]
Steps
- Calculate step-to-step conversion and overall conversion for both periods.
- Find the step with the largest drop and the step that changed most between periods.
- Compare devices or channels at that step, if the split is given.
- Estimate extra revenue if the weak step improved by 10 per cent, with the maths shown.
- List likely causes and the data that would confirm each.
Output format
- | Step | This period | Step conversion | Last period | Step conversion | Change |
- Biggest leak in one sentence.
- Revenue impact estimate with the calculation.
- | Likely cause | How to confirm | Fix to test | Effort (low, medium, high) |
Check before answering
- Conversion is always calculated from the previous step, and overall conversion from the first step.
- Festive or sale periods are flagged when comparing with normal weeks.
- Causes are labelled as hypotheses until confirmed.
- No numbers are invented for missing steps.






