Your question is Summarize Campaign Results for Leadership. 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.
You are asked to prepare a simple leadership summary of marketing campaign performance from a single table used for PNC campaign reporting. Write a SQL query that returns one row per campaign for delivered campaigns only, showing the campaign name, total emails sent, total clicks, and average conversion rate. Sort the results so the strongest-performing campaigns appear first by total clicks.
| Column | Type | Description |
|---|---|---|
| campaign_idPK | INT | Unique row identifier |
| campaign_name | VARCHAR(100) | Name of the marketing campaign |
| channel | VARCHAR(50) | Marketing channel used |
| send_date | DATE | Date the campaign was sent |
| emails_sent | INT | Number of emails sent |
| clicks | INT | Number of clicks generated |
| conversion_rate | DECIMAL(5,2) | Conversion rate percentage for the send |
| delivery_status | VARCHAR(20) | Status of the send record |