Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Compute CTR Per Advertiser

Medium
MediumSQL & Data ManipulationDate FunctionsJoinsAggregations

Problem

Given a table of user ad impressions and another table of ad clicks, write a SQL query to calculate the click-through rate (CTR) per advertiser for the last 30 days.

Take this as a live interview session →

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Next questions
PinterestCompute CTR Per AdvertiserMediumLg Ad SolutionsCTR by Publisher QueryMediumUnity TechnologiesCTR by Country SQLMedium