Top Pinnacle Campaigns by Spend | Dataford Interview Questions

You are given a table of daily spend records from Pinnacle campaign reporting. Write a SQL query to return the top 3 campaign names by total spend, considering only rows where channel = 'Paid Search'. The result should show each campaign name and its total spend, sorted from highest to lowest total spend.

Schema

pinnacle_campaign_spend

Column	Type	Description
spend_idPK	INT	Unique row identifier for each spend record
campaign_name	VARCHAR(100)	Pinnacle campaign name
channel	VARCHAR(50)	Marketing channel tied to the spend record
spend_date	DATE	Date of the spend entry
spend_amount	DECIMAL(10,2)	Spend amount recorded for that row

Your question is Top Pinnacle Campaigns by Spend. Start with the requirements and the one table 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

Schema

pinnacle_campaign_spend

Column	Type	Description
spend_idPK	INT	Unique row identifier for each spend record
campaign_name	VARCHAR(100)	Pinnacle campaign name
channel	VARCHAR(50)	Marketing channel tied to the spend record
spend_date	DATE	Date of the spend entry
spend_amount	DECIMAL(10,2)	Spend amount recorded for that row

Your question is Top Pinnacle Campaigns by Spend. Start with the requirements and the one table 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.