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
- L3
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.
Summary
Money in, conversions out. What is the ratio?
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