TikTok
Analytics Reporting Track · Medium · 25 min
Seven-Day Trial Conversion
The growth team wants to compare acquisition channels for January trial signups. For each acquisition_channel, return the number of users who converted withi...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a TikTok-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
The growth team wants to compare acquisition channels for January trial signups. For each acquisition_channel, return the number of users who converted within 7 days of signup, the total number of signups, and the conversion rate as a percentage rounded to two decimals. Sort by acquisition_channel.
trial_signups
| user_id | signup_date | acquisition_channel |
|---|---|---|
| 101 | 2024-01-03 | Creator Ads |
| 102 | 2024-01-05 | Creator Ads |
| 103 | 2024-01-08 | Organic |
| 104 | 2024-01-10 | Referral |
| 105 | 2024-01-12 | Organic |
subscription_events
| event_id | user_id | event_type | |
|---|---|---|---|
| 1 | 101 | converted | 2024-01-07 |
| 2 | 102 | cancelled | 2024-01-09 |
| 3 | 103 | converted | 2024-01-20 |
| 4 | 104 | converted | 2024-01-15 |
| 5 | 105 | converted | 2024-01-14 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.