Loading...

Campaign Cost Effectiveness

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain
SQL
Difficulty
medium
Seniority
junior, mid

Problem

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.

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.