Click Rate

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The marketing team is auditing ad campaign performance before next quarter's budget allocation. For each campaign, they want to see the click-through rate as a percentage of impressions, the total revenue attributed to the campaign, and how many impressions were served. Only surface campaigns with more than one in five impressions resulted in a click , anything below that isn't worth renewing. Rank from highest click-through rate to lowest.

Summary

Campaigns nobody clicks.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.