Meta's Product Growth team wants to measure 30-day stickiness for a new Instagram Reels feature. Treat a user as an adopter on the date of their first feature_open event for reels_new_editor.
Write a PostgreSQL query that measures D30 feature retention for adopter cohorts from April 1 through April 5, 2025.
feature_open or reels_save event exactly 30 days after adoption.stickiness_pct as retained adopters divided by cohort adopters, expressed as a percentage.cohort_date, cohort_users, retained_d30, and stickiness_pct.cohort_date ascending.event_date is on or after the user's signup_date.feature_name equal to reels_new_editor.stickiness_pct to two decimal places.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Meta user identifier |
| signup_date | DATE | Date the user joined Meta |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| user_id | INT | User who generated the event |
| event_date | DATE | Calendar date of the event |
| feature_name | VARCHAR(100) | Instagram Reels feature identifier |
| event_name | VARCHAR(50) | Recorded feature action |