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.marketing_campaigns
| Column | Type | Description |
|---|---|---|
| campaign_id | INT | Unique campaign record ID |
| channel | VARCHAR(50) | Marketing channel such as Email or Search |
| campaign_name | VARCHAR(100) | Campaign name |
| campaign_date | DATE | Date the campaign ran |
| impressions | INT | Number of impressions delivered |
| clicks | INT | Number of clicks received |
| spend | DECIMAL(10,2) | Amount spent on the campaign |
| region | VARCHAR(50) | Geographic region |
| 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 |
You are practicing as a guest. Sign up free to run your code against the sample data. Your draft stays right here.
