Campaign Click-Through Rates
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
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.
Summary
Clicks per impression. Campaign by campaign.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision