Attribute purchase revenue to campaign objective

#3 · 3 of 5Free sample

Exercises (5)

Instructions

Attribute purchase revenue to the campaign that generated the lead and compare campaign objectives.

Return three columns: objective, purchases, and revenue rounded to 2 decimals. Order by revenue from highest to lowest.

Loading the practice editor and dataset…

Tables

4 tables · 23 columns

campaigns7 cols

campaign_idTEXT PRIMARY KEY
campaign_nameTEXT NOT NULL
channelTEXT NOT NULL
objectiveTEXT NOT NULL
start_dateTEXT NOT NULL
end_dateTEXT NOT NULL
budgetREAL NOT NULL

daily_spend6 cols

spend_idTEXT PRIMARY KEY
campaign_idTEXT NOT NULL
spend_dateTEXT NOT NULL
impressionsINTEGER NOT NULL
clicksINTEGER NOT NULL
spendREAL NOT NULL

leads5 cols

lead_idTEXT PRIMARY KEY
campaign_idTEXT NOT NULL
created_atTEXT NOT NULL
lead_sourceTEXT NOT NULL
lead_scoreINTEGER NOT NULL

conversions5 cols

conversion_idTEXT PRIMARY KEY
lead_idTEXT NOT NULL
converted_atTEXT NOT NULL
conversion_typeTEXT NOT NULL
revenueREAL NOT NULL

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →