SQL Campaign Performance Query | Dataford Interview Questions

Write a SQL query to track campaign performance by channel, including spend, conversions, and conversion rate over time.

Use the provided campaign and daily performance data. Conversion rate should be calculated as conversions divided by clicks, expressed as a percentage. Include only performance dates from January and February 2025.

Output

One row per channel and month.
Columns: channel, performance_month, total_spend, total_conversions, and conversion_rate.
Sort by month ascending, then channel ascending, with NULL channels last.

Schema

campaigns

Column	Type	Description
campaign_idPK	INT	Unique campaign identifier
campaign_name	VARCHAR(120)	Campaign name
channel	VARCHAR(60)	Marketing channel associated with the campaign

campaign_daily_performance

Column	Type	Description
performance_idPK	INT	Unique daily performance record identifier
campaign_id	INT	Campaign identifier
performance_date	DATE	Date of the performance metrics
spend	DECIMAL(12,2)	Daily advertising spend
conversions	INT	Number of attributed conversions
clicks	INT	Number of campaign clicks

Your question is SQL Campaign Performance Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem