Loading interview...

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
mid, senior

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision