Loading...
Campaign Click-Through Rates
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid, senior
Problem
The ad analytics team wants to measure each campaign's reach as a percentage of the total registered user base who clicked. For every campaign, compute what percentage of all registered users clicked at least one ad in that campaign. Campaigns with zero clicks should still appear. Round to the nearest whole number and present from highest reach to lowest.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.