Your question is Monthly Campaign Performance Summary. Start with the requirements and the one table 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.
BrightAds wants a simple monthly view of marketing performance from its campaign delivery table. Write a SQL query to summarize campaign results for January 2024.
channel for campaigns with campaign_date in January 2024.total_clicks in descending order.| Column | Type | Description |
|---|---|---|
| campaign_idPK | INT | Unique campaign record identifier |
| channel | VARCHAR(50) | Marketing channel |
| campaign_name | VARCHAR(100) | Campaign name |
| campaign_date | DATE | Date the campaign ran |
| impressions | INT | Number of impressions |
| clicks | INT | Number of clicks |
| spend | DECIMAL(10,2) | Campaign spend amount |
| region | VARCHAR(50) | Campaign region |