Funnel Conversion Analysis
Single-pass PostgreSQL window function calculation (`LAG` / `FIRST_VALUE`)
CONVERSION WINDOW:
Step 1
Step 2
Step 3
Step 4
Conversion & Drop-off Results
Step 1: page_view125,000 users (100% converted)
Step 2: signup_step85,500 users (68.4% converted)
Drop-off: -39,500 users (31.6%)
Step 3: checkout_start42,100 users (49.2% converted)
Drop-off: -43,400 users (50.8%)
Step 4: checkout_complete28,900 users (68.6% converted)
Drop-off: -13,200 users (31.4%)