Purchase Funnel Conversion
Medium
Analytics Case Studies
Count the distinct users reaching each stage (view, cart, purchase) and the percentage relative to the view stage, rounded to two decimals. Order by stage in funnel order.
Table schema
Events(user_id INT, event VARCHAR(10))Sample data
user_id | event
1 | view
1 | cart
1 | purchase
2 | view
2 | cart
3 | view
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.