Loading interview...

Campaign Cost Effectiveness

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

Interview Prompt

The marketing team is evaluating return on ad spend and needs a cost-effectiveness metric for each campaign between 2025 and 2026 inclusive. Show each campaign alongside the ratio of total revenue to total clicks.

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