Funnels

├── Step 1 → Step 2: 35% (3,500 / 10,000)
├── Step 2 → Step 3: 34% (1,200 / 3,500)
└── Step 3 → Step 4: 67% (800 / 1,200)

Average time:
├── Step 1 → Step 2: 2.5 hours
├── Step 2 → Step 3: 15 minutes
├── Step 3 → Step 4: 5 minutes
└── Total: 2 hours 50 minutes

Filter: country = "US" AND device_type = "mobile"

All steps will only include US mobile users

Step 1: page_view
  └── where: uri = "/swap" (step filter)
  
Step 2: wallet_connect
  └── where: wallet_type = "metamask" (step filter)

Filter: Users where
├── plan = "pro"
├── AND wallet_age_days > 30
└── AND is_whale = false

Funnel by utm_source:
├── twitter: 12% conversion
├── discord: 18% conversion
├── google: 8% conversion
└── direct: 15% conversion

Funnel by user type:
├── Whales: 25% conversion
├── Active traders: 15% conversion
└── New users: 6% conversion

Overall conversion rate by week:
├── Week 1: 7%
├── Week 2: 8%
├── Week 3: 9%
└── Week 4: 8%

Conversion by chain:
├── Ethereum: 12%
├── Polygon: 15%
├── Arbitrum: 18%
└── Base: 14%

A → B → C required
A → C → B does not convert

A, B, C required (any order)
A → C → B converts ✓
C → A → B converts ✓

User enters funnel multiple times:
├── Monday: Enters at Step 1
├── Tuesday: Enters at Step 1 again
└── → Only Monday entry counted

User enters funnel multiple times:
├── Monday: Entry 1
├── Tuesday: Entry 2
└── → Both entries counted

Time to complete funnel:
├── < 1 hour: 45%
├── 1-4 hours: 25%
├── 4-24 hours: 15%
├── 1-3 days: 10%
└── > 3 days: 5%

Hold constant: input_token

User swaps ETH in step 1, must swap ETH in transaction:
├── Step 1: swap_initiated (input_token = "ETH")
└── Step 4: Transaction with ETH → Counts ✓

├── Step 1: swap_initiated (input_token = "ETH")
└── Step 4: Transaction with MATIC → Does NOT count ✗

Step 1: page_view (landing page)
Step 2: button_clicked (CTA)
Step 3: wallet_connect
Step 4: swap_initiated (button click)
Step 5: [Transaction] swap on DEX

Filter: utm_source = "twitter"
Window: 7 days

Step 1: wallet_connect
Step 2: chain_selected
Step 3: [Transaction] any transaction

Breakdown: chain

Step 1: collection_viewed
Step 2: wallet_connect
Step 3: mint_initiated
Step 4: [Transaction] mint function

Breakdown: traffic_source

Step 1: feature_used (advanced_charts)
Step 2: [Transaction] any transaction

Compare to:
Step 1: page_view (any page)
Step 2: [Transaction] any transaction

├── Step 1 → Step 2: 35% (65% drop) ← Biggest drop!
├── Step 2 → Step 3: 80% (20% drop)
└── Step 3 → Step 4: 90% (10% drop)

Focus on: Why aren't users connecting wallets?

By device:
├── Desktop: 12% conversion
└── Mobile: 4% conversion ← Investigate mobile UX

By country:
├── US: 15% conversion
├── UK: 14% conversion
└── DE: 8% conversion ← Different market?

Users who convert in < 1 hour: 45%
→ Quick decision makers

Users who convert in > 24 hours: 15%
→ Need nurturing/reminders

✅ Good: 4-6 steps focused on one journey
page_view → wallet_connect → swap_init → transaction

❌ Avoid: 15 steps covering everything
page_view → click → scroll → hover → click → modal → ...

Quick actions (checkout): 1 hour - 1 day
Considered decisions (signup): 1-7 days
Long cycles (enterprise): 7-30 days

✅ Compare: 
- Twitter traffic funnel (filter: utm_source = twitter)
- Discord traffic funnel (filter: utm_source = discord)

❌ Misleading:
- All traffic funnel
- Mobile-only funnel (different population)