Pinpoint friction points in conversion funnels

Identify the exact bottleneck stage where prospective customers abandon your funnel. Use this when aggregate conversion drops without obvious reason.

You getFunnel Performance Table, primary Bottleneck Identification and top 3 Hypotheses

Prompt

Prompt
Act as a digital product analyst. Review the conversion funnel stage counts pasted below.
- Calculate the stage-by-stage drop-off rate and the absolute volume loss for every sequential step.
- Identify the single primary bottleneck causing the greatest aggregate conversion loss.
- Suggest realistic operational or UX hypotheses for the largest drop.
Output format:
1. Funnel Performance Table (Columns: Stage, Users Entering, Stage Conversion %, Cumulative Drop %)
2. Primary Bottleneck Identification (1 concise paragraph naming the critical leak)
3. Top 3 Hypotheses (bulleted UX, technical, or messaging causes)
4. Next Diagnostic Actions (3 specific tracking checks to run)
Here is my funnel data:

Example output

Example for: B2B onboarding funnel with 5 sequential steps

  1. Funnel Performance Table
StageUsers EnteringStage Conversion %Cumulative Drop %
Landing Page Visit25,000Baseline (100%)0.0%
Sign-up Form Started6,50026.0%74.0%
Email Confirmed5,85090.0%76.6%
Team Workspace Created1,46025.0%94.2%
First Project Launched1,11076.0%95.6%
  1. Primary Bottleneck Identification
    The critical leakage occurs between Email Confirmed and Team Workspace Created, where 75% of verified users (4,390 accounts) abandon the flow. While the top-of-funnel drop from landing page to sign-up is numerically larger, a 75% drop among users who already validated their email indicates immediate post-login onboarding friction.
  2. Top 3 Hypotheses
  • Mandatory workspace fields: Users are being prompted for complex configuration, company sizing, or teammate email invitations before seeing any product value.
  • SSO and Authentication redirects: Post-confirmation redirects may be breaking on specific mobile or enterprise browser configurations.
  • Delayed verification redirect: Users who verify email on mobile devices get stranded without an automatic handoff back to the desktop app.
  1. Next Diagnostic Actions
  2. Segment workspace creation rates by device type (desktop vs. mobile) and browser.
  3. Review error logs on the workspace creation API endpoint to check for validation bugs.
  4. Measure the median time between email confirmation and workspace creation to spot hesitation points.
Written by AI from this prompt. Your results will vary.

Paste your funnel step names and user volumes into ChatGPT, Claude, or Gemini directly following the prompt. For a helpful next step, ask the model to draft an event taxonomy to segment this leak by device or source.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis
Data Analysis

Interpret A/B test results plainly

Turn raw conversion figures into a clear summary that non-technical stakeholders can act on without statistical jargon.