Step-to-Step Conversion

Return the percentage of visitors who added to cart, and of cart users who purchased, rounded to 2 decimals.

Table schema

Events(user_id INT, step VARCHAR(10), event_date DATE)

Sample data

user_id | step | event_date
1 | visit | 2026-04-01
2 | visit | 2026-04-01
3 | visit | 2026-04-02
4 | visit | 2026-04-02
1 | cart | 2026-04-01
2 | cart | 2026-04-03
3 | cart | 2026-04-02
1 | purchase | 2026-04-04
3 | purchase | 2026-04-02