Company SQL Question

Ad Campaign Performance

Practice this Meta style SQL interview question with live execution and instant feedback.

Problem Statement

Analyze ad campaign performance by calculating CTR (Click-Through Rate) and conversion rate. Show ad title, page name, impressions, clicks, conversions, CTR percentage, and conversion rate percentage. Only include ads with at least 1000 impressions.

Relevant Tables

adspages

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

Running Totals & Moving AveragesWindow Functions
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
ROW_NUMBER, RANK, DENSE_RANKWindow Functions