mediumGrab · aggregationPro
Ad click-through conversion rate, per campaign
Marketing wants to know how well each ad campaign converts a click into real intent. For each campaign, compute the click-through conversion rate: the percentage of users who clicked the ad *and* went on to add an item to their cart.
Return campaign and conversion_rate (a percentage, rounded to 1 decimal place).
Schema
▸ad_clicks
| id | INT |
| user_id | INT |
| campaign | TEXT |
▸cart_adds
| id | INT |
| user_id | INT |
| campaign | TEXT |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.