Funnel and Cohort Visualization AI Prompt

Design visualizations for funnel analysis and cohort retention.

Funnel stages: {{funnel_stages}}
Cohort definition: {{cohort_definition}}
Metric: {{metric}} (retention rate, revenue, engagement)

1. Funnel visualization options:

   Standard funnel chart:
   - Trapezoid shapes decreasing in width at each stage
   - Width proportional to the count at that stage
   - Show: absolute count AND conversion rate (%) between each stage
   - Color: use color to highlight the stage with the biggest drop-off
   - Limitation: difficult to compare multiple funnels (e.g. mobile vs desktop)

   Bar-based funnel:
   - Horizontal bars ranked by stage, sorted top to bottom
   - Easier to read exact values than the trapezoid format
   - Add conversion rate labels between bars: '→ 42% converted'
   - Add a secondary bar showing the 'lost' volume in each stage (grey bar)

   Funnel comparison (best for multiple segments):
   - Grouped or overlaid bars for each stage
   - Each group = one stage; bars within = one segment each
   - Better for: mobile vs desktop, new vs returning users, A vs B variant

   Waterfall funnel:
   - Shows how volume flows from one stage to the next
   - Each bar shows: volume entering the stage, volume converting (green), volume lost (red)
   - Good for showing absolute loss at each stage rather than just conversion rate

2. Cohort retention heatmap (standard format):
   - Rows: cohorts (typically by acquisition month/week)
   - Columns: periods since acquisition (Period 0, Period 1, Period 2...)
   - Cell value: retention rate (% of cohort still active in that period)
   - Color: sequential scale — dark = high retention, light = low retention
   - Period 0 is always 100% (the baseline)
   - Reading the diagonal: shows same calendar period across different cohorts (seasonality effect)

3. Retention visualization variants:
   - Line chart overlay: multiple cohort lines on the same chart — shows which cohorts retain better
   - Cumulative retention: useful for subscription products (when does the subscriber cancel?)
   - Retention cliff: annotate the period where the sharpest drop occurs

4. Actionable design:
   - For funnels: highlight the single biggest drop-off stage in red
   - For cohort heatmaps: add reference lines at 30-day and 90-day columns
   - Add a 'benchmark' row to the cohort heatmap showing the company average

Return: funnel chart design (type, labels, color coding), cohort heatmap specification, color scale, and actionability annotations.