Loading problem...
5009. Full Funnel: Clicks to Conversions
00:00
5009. Full Funnel: Clicks to Conversions
HardSQLITE260 / 1625
Business Problem
You are a Full-Funnel Analyst at Amazon Ads. The performance marketing team needs a campaign-level summary showing how many valid clicks each campaign received and how many of those clicks converted, along with the total conversion value. This helps the team identify campaigns with high click volume but low conversion rates, indicating potential funnel leakage. Only campaigns from active advertisers should be included.
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to ProRelevant companies
T
TikTok/ByteDanceCompany names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Tags
#inner-join#left-join#multi-table#aggregation#group-by#adtech
5009. Full Funnel: Clicks to Conversions
Hard260 / 1625
Business Problem
You are a Full-Funnel Analyst at Amazon Ads. The performance marketing team needs a campaign-level summary showing how many valid clicks each campaign received and how many of those clicks converted, along with the total conversion value. This helps the team identify campaigns with high click volume but low conversion rates, indicating potential funnel leakage. Only campaigns from active advertisers should be included.
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to ProRelevant companies
T
TikTok/ByteDanceCompany names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Tags
#inner-join#left-join#multi-table#aggregation#group-by#adtech
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to Pro