TikTok
Analytics Reporting Track · Hard · 35 min
One-Month Creator Retention
Growth wants a basic cohort view for creator retention. For signup_month values from 2024-01-01 through 2024-03-01, return the cohort size, the number of cre...
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.
Growth wants a basic cohort view for creator retention. For signup_month values from 2024-01-01 through 2024-03-01, return the cohort size, the number of creators active in the following month, and the one-month retention_pct rounded to two decimals. Sort by signup_month.
This is a Pro question
Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.
Upgrade to Pro — unlock all 254 problemsSQL 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.