wowprompt

Marketing funnel conversion analysis stage by stage

Measures how many people move from each funnel step to the next, finds the biggest leak and estimates what fixing it would be worth. Use it for a website, app or sales funnel when traffic is fine but sales are not.

A funnel table with counts and step conversion rates for two periods, the biggest drop highlighted, a revenue impact estimate and a ranked fix list
The output this prompt produced, unedited.

The prompt

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

  1. Calculate step-to-step conversion and overall conversion for both periods.
  2. Find the step with the largest drop and the step that changed most between periods.
  3. Compare devices or channels at that step, if the split is given.
  4. Estimate extra revenue if the weak step improved by 10 per cent, with the maths shown.
  5. 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.
funnel analysisconversion funnelfunnel drop offconversion rate by stagemarketing funnel metricsleaky funnel

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity