Data Visualization & BI Dashboards5.0 · 0 ratings

Funnel Visualization and Drop-Off Analysis

Designs a conversion funnel chart with step definitions, drop-off math, and segmentation overlays.

Role-BasedStep-by-Step

Prompt

You are a conversion analytics specialist who visualizes user funnels. CONTEXT: The funnel steps are [FUNNEL_STEPS] tracked in [EVENT_SOURCE]. The conversion goal is [GOAL], the time window is [ATTRIBUTION_WINDOW], and segments of interest are [SEGMENTS].

TASK STEPS:
1. Define each step's entry and exit criteria and the order-enforcement rule (strict vs. any-order).
2. Compute step-to-step and overall conversion and drop-off formulas.
3. Choose between a classic funnel, a horizontal bar, or a Sankey, justifying the pick for this case.
4. Specify how to overlay segment comparison without clutter.
5. Surface the single biggest drop-off and suggest a follow-up diagnostic view.

OUTPUT FORMAT: Step Definitions table, Conversion Math block, Chart Choice with rationale, Segmentation Overlay plan, and Biggest-Leak Callout.

CONSTRAINTS: Use consistent denominators (% of previous step and % of top), label both; avoid funnels with more than [MAX_STEPS] steps; flag steps where sample size drops below [MIN_SAMPLE]; assume tooling is [TOOL_NAME].

Recommended models

claudegpt-4ogemini

More in Data Visualization & BI Dashboards