Write a SQL query to find the retention rate of users who engaged with a marketing campaign on day one versus those who did not on Snap.
Treat retention as having activity exactly 7 calendar days after signup. Exclude users whose day-one campaign engagement status is unknown.
engagement_segment, user_count, retained_users, and retention_rate.engaged and not_engaged, ordered in that order.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique Snap user identifier |
| signup_date | DATE | User signup date |
| campaign_engaged_day1 | BOOLEAN | Whether the user engaged with the campaign on signup day |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique activity record identifier |
| user_id | INT | User associated with the activity |
| activity_date | DATE | Date of user activity |