Your question is Top Ad Campaigns by Conversion. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
InMobi Product Analytics needs to compare campaign efficiency across the InMobi Exchange. Write a PostgreSQL query to identify the five campaigns with the highest conversion rate during January 2025.
| Column | Type | Description |
|---|---|---|
| campaign_idPK | INT | Unique campaign identifier |
| campaign_name | VARCHAR(120) | Campaign name |
| advertiser | VARCHAR(100) | Advertiser or agency name |
| Column | Type | Description |
|---|---|---|
| performance_idPK | INT | Unique daily performance record |
| campaign_id | INT | Referenced campaign identifier |
| performance_date | DATE | Reporting date |
| impressions | INT | Number of ad impressions |
| clicks | INT | Number of ad clicks |
| conversions | INT | Number of attributed conversions |