Describe how you use tools in marketing execution.
For this SQL exercise, translate the question into a report of marketing execution tool usage during January 2025. Include tools with no qualifying activity so usage gaps are visible.
tool_name, execution_count, distinct_campaigns, completed_count, completion_rate, and last_used_at.completion_rate descending, execution_count descending, then tool_name ascending.| Column | Type | Description |
|---|---|---|
| tool_idPK | INT | Unique marketing tool identifier |
| tool_name | VARCHAR(100) | Marketing tool name |
| category | VARCHAR(50) | Tool category |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique execution activity identifier |
| tool_id | INT | Marketing tool used for the activity |
| campaign_id | INT | Campaign associated with the activity |
| executed_at | DATE | Date the activity was executed |
| status | VARCHAR(20) | Execution status |
| channel | VARCHAR(30) | Marketing channel |