D
ABrightAds 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 |
| campaign_id | channel | campaign_name | campaign_date | impressions | clicks | spend | region |
|---|---|---|---|---|---|---|---|
| 1 | Social | Winter Promo | 2024-01-15 | 12000 | 480 | 950.00 | North America |
| 2 | New Year Blast | 2024-01-03 | 8000 | 640 | 300.00 | Europe | |
| 3 | Search | Brand Terms | 2024-01-20 | 15000 | 750 | 1200.00 | North America |
| 4 | Social | Retargeting Push | 2024-01-08 | 9000 | 360 | 700.00 | Asia Pacific |
| 5 | Display | Awareness Banner | 2024-01-25 | 20000 | 220 | 1500.00 | Europe |
| 6 | Weekend Nudge | 2024-02-02 | 6000 | 420 | 250.00 | North America |
| channel | total_impressions | total_clicks | avg_spend |
|---|---|---|---|
| Search | 15000 | 750 | 1200.00 |
| 12000 | 730 | 250.00 | |
| Social | 21000 | 840 | 825.00 |
| Display | 20000 | 220 | 1500.00 |
| 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 |
{"marketing_campaigns":[["1","Social","Winter Promo","2024-01-15","12000","480","950.00","North America"],["2","Email","New Year Blast","2024-01-03","8000","640","300.00","Europe"],["3","Search","Brand Terms","2024-01-20","15000","750","1200.00","North America"],["4","Social","Retargeting Push","2024-01-08","9000","360","700.00","Asia Pacific"],["5","Display","Awareness Banner","2024-01-25","20000","220","1500.00","Europe"],["6","Email","Weekend Nudge","2024-02-02","6000","420","250.00","North AOutput[["Content Syndication","14373","null","445.00"],["Paid Social","11210","1422","357.00"],["Social","37201","1354","995.00"],["Programmatic","33455","1039","482.00"],["Search","15000","750","1200.00"],["Email","12000","730","250.00"],["Webinars","4678","708","-75.00"],["Marketplace","859","485","411.00"],["Radio","9672","339","1546.00"],["Native","31457","320","1539.50"],["Retargeting","16112","226","1034.00"],["Display","20000","220","1500.00"],["Organic Social","22273","170","1175.00"],["null",
