Write a SQL query to identify the retention rate of players who joined through a specific paid social media campaign versus organic channels over a 30-day period.
Use the supplied campaign identifier and count a player as retained when they have at least one activity record during the first 30 days after joining, excluding the 30th-day boundary. Include only the specified paid social campaign and organic players.
channel, eligible_players, retained_players, and retention_rate.| Column | Type | Description |
|---|---|---|
| player_idPK | INT | Unique player identifier |
| joined_at | DATE | Date the player joined |
| acquisition_channel | VARCHAR(30) | Player acquisition channel |
| campaign_name | VARCHAR(100) | Paid campaign associated with the player |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique activity record identifier |
| player_id | INT | Player associated with the activity |
| activity_date | DATE | Date of player activity |