SQL for Marketing Metrics | Dataford Interview Questions

Write a SQL query to extract specific marketing metrics from a dataset at Carvana.

Using the provided schema, calculate January 2025 performance for every campaign, including campaigns without January activity.

Output

One row per campaign, ordered by campaign_id ascending
Columns: campaign_id, campaign_name, channel, impressions, clicks, conversions, spend, ctr_percent, conversion_rate_percent, cost_per_click, and cost_per_conversion
Include only activity from January 1 through January 31, 2025; return zero totals and NULL cost metrics where appropriate

campaigns

Column	Type	Description
campaign_idPK	INT	Unique marketing campaign identifier
campaign_name	VARCHAR(100)	Campaign name
channel	VARCHAR(50)	Marketing acquisition channel

marketing_events

Column	Type	Description
event_idPK	INT	Unique marketing event record identifier
campaign_id	INT	Referenced campaign identifier
event_date	DATE	Date represented by the event metrics
impressions	INT	Number of campaign impressions
clicks	INT	Number of campaign clicks
conversions	INT	Number of attributed conversions
spend	DECIMAL(12,2)	Attributed marketing spend

Your question is SQL for Marketing Metrics. 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.