Segment conversion funnel drop-offs by device and marketing channel

Uncover hidden conversion bottlenecks across mobile, desktop, and paid channels. Use this when top-line conversion dips but sitewide funnels show no obvious break.

You getCritical Leaks, cross-Segment Comparison Table and diagnostic Hypotheses

Prompt

Prompt
Act as a growth analytics specialist. Evaluate the multi-step conversion funnel data segmented by device and acquisition channel pasted below.

Rules:
- Calculate step-by-step conversion drop-off percentages for each device-channel combination.
- Identify the specific step where the highest absolute volume of users drops off.
- Isolate device-specific failure points that do not appear on other platforms.
- Rank the top three highest-leverage friction points based on user volume lost.

Output format:
1. Critical Leaks: Bulleted summary of the 3 largest conversion breaks by channel and device.
2. Cross-Segment Comparison Table: Columns for Step, Segment (Channel + Device), Visitors In, Drop-off Count, Step Loss Rate, Severity (High, Medium, Low).
3. Diagnostic Hypotheses: Concrete technical or UX reasons for the top anomalies observed.
4. Immediate Testing Priorities: 2 prioritized fixes or tests to run first.

My funnel data is below:

Example output

Example for: signup to checkout funnel across mobile web and desktop for paid search and organic

1. Critical Leaks
  • Mobile Web Paid Search at Payment Step: Loses 68.4% of users who reach the payment form, compared to 28.1% on Desktop Paid Search.
  • Desktop Organic at Account Creation: Shows an unexpected 42% drop between landing and form submission, heavily skewed toward Safari users.
  • Mobile Web Paid Social at Cart to Shipping: 54% drop-off indicates friction entering address details on small screens.
2. Cross-Segment Comparison Table
StepSegment (Channel + Device)Visitors InDrop-off CountStep Loss RateSeverity
Cart -> AddressPaid Social (Mobile)14,2007,66854.0%High
Address -> PaymentPaid Search (Mobile)8,9006,08768.4%High
Landing -> SignupOrganic (Desktop)22,0009,24042.0%High
Cart -> AddressPaid Search (Desktop)11,5002,76024.0%Medium
Address -> PaymentOrganic (Mobile)6,1002,13535.0%Medium
Payment -> CompleteAll Segments (Desktop)16,8001,84811.0%Low
3. Diagnostic Hypotheses
  • Mobile Payment Gateway: The 68.4% Mobile Paid Search drop suggests mobile wallet integration (Apple Pay/Google Pay) is failing to render or triggering validation errors on mobile viewport widths.
  • Address Autofill: The high mobile drop at the address step indicates address validation scripts are blocking submission without clear inline error messages.
4. Immediate Testing Priorities
  • Test standardizing one-click wallet payments on mobile checkout pages.
  • Audit mobile address entry form for auto-complete compatibility and keyboard layout switching.
Written by AI from this prompt. Your results will vary.

Copy and paste your table of funnel steps broken down by device type and channel directly into Claude, ChatGPT or Gemini. Follow up by asking the model to estimate total visitors recovered if the top leak is halved.

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.