Calculate click-through rate by channel

#1 · 1 of 5Free sample

Exercises (5)

Instructions

Compare channels on spend and click-through rate (clicks divided by impressions).

Return four columns: channel, spend rounded to 2 decimals, clicks, and rounded to 2 decimals. Order by from highest to lowest.

ctr_pct

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 →