Advanced · 30 XP
Calculate 7-Day User Retention Cohort
Calculate the percentage of users who returned to perform an activity within 7 days of their initial signup date.
Show Step-by-Step Hint
- • Use a LEFT JOIN between the cohort signup date and event timestamps within 7 days.
Type: Sql
Runtime: SQL
SQL solutionCHALLENGE #7