Problem
Chime’s Growth team wants a quick read on how well the sign-up landing page converts visitors into completed account sign-ups. Write a SQL query to calculate the conversion rate using a single event table.
Requirements
- Use only events from the
signup_landingsurface. - Count distinct visitors who had a
landing_page_visitevent as the denominator. - Count distinct visitors who had a
completed_signupevent as the numerator. - Return the number of landing page visitors, the number of completed sign-ups, and the conversion rate as a percentage rounded to 2 decimal places.
Table Definition
growth_funnel_events
| column_name | type | description |
|---|---|---|
| event_id | INT | Unique event row identifier |
| user_id | INT | Visitor or member identifier |
| event_name | VARCHAR(50) | Name of the funnel event |
| surface_name | VARCHAR(50) | Chime product surface where the event happened |
| event_date | DATE | Date of the event |
| device_type | VARCHAR(20) | Device used for the event |
Schema
growth_funnel_events
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event row identifier |
| user_id | INT | Visitor or member identifier |
| event_name | VARCHAR(50) | Name of the funnel event |
| surface_name | VARCHAR(50) | Chime product surface where the event occurred |
| event_date | DATE | Date of the event |
| device_type | VARCHAR(20) | Device used for the event |
You are practicing as a guest. Sign up free to run your code against the sample data. Your draft stays right here.
