Loading...
Promo Campaign Cost per Acquisition
A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- junior
Problem
For promo campaigns (campaign names containing 'promo'), compute the cost-per-acquisition by year: total notifications divided by total opens. Show the campaign, year, and the resulting ratio.
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.