Your question is Landing Page to Sign-Up Conversion. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
signup_landing surface.landing_page_visit event as the denominator.completed_signup event as the numerator.| 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 |