Business SQL for Ops Insights | Dataford Interview Questions

Can you provide an example of a business-flavored SQL query you would use to analyze operational data at Rokt?

Using the provided Rokt operational tables, write a query that evaluates campaign delivery performance for January 2025.

Output

One row per campaign, including campaigns with no qualifying events.
Columns: campaign_id, campaign_name, total_events, successful_events, and success_rate_pct.
Include only events occurring in January 2025; treat campaigns with no events as zero activity and order by success rate descending, total events descending, then campaign ID ascending.

campaigns

Column	Type	Description
campaign_idPK	INT	Unique Rokt campaign identifier
campaign_name	VARCHAR(120)	Campaign display name
campaign_status	VARCHAR(20)	Current campaign status

delivery_events

Column	Type	Description
event_idPK	INT	Unique delivery event identifier
campaign_id	INT	Campaign associated with the event
occurred_at	TIMESTAMP	Timestamp when the delivery event occurred
event_status	VARCHAR(20)	Operational result of the delivery event

Your question is Business SQL for Ops Insights. 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.