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].

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Step-by-Step

Forces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

Open in Studio How to prompt AI correctly

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