Funnel Analysis

Demo

Click to play with sound.

---
name: Funnel Analysis
description: Build conversion funnels with drop-off attribution and significance testing.
---

# Funnel Analysis

Measure where users drop off in a multi-step flow and find statistically real differences between segments.

## Define the funnel precisely

1. List the ordered steps (e.g. view -> add to cart -> checkout -> purchase).
2. Decide on the conversion window (e.g. complete within 7 days of step 1).
3. Choose ordered vs unordered: must steps happen in sequence, or just all occur?

Ambiguous definitions produce misleading funnels; write them down.

## Compute the funnel in SQL

```sql
with steps as (
  select user_id,
         min(case when event = 'view' then event_time end) as t_view,
         min(case when event = 'add_to_cart' then event_time end) as t_cart,
         min(case when event = 'checkout' then event_time end) as t_checkout,… install to load the full skill