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
Executive KPI Dashboard Blueprint Architect
Designs a single-screen executive KPI dashboard layout with metric hierarchy, chart selection, and drill-down logic.
Read prompt
Chart Type Selection Decision Tree
Reasons step by step from data shape and analytic intent to the optimal chart type with ranked alternatives.
Read prompt
SQL-to-Dashboard Metric Layer Definer
Translates raw tables into a governed semantic metric layer with definitions, grains, and reusable measures.
Read prompt
Dashboard Redesign Critique and Rework
Critiques an existing dashboard against visualization best practices, then prescribes a concrete redesign.
Read prompt