Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Compute CTR by Device Category

Medium
MediumSQL & Data ManipulationGroup ByCase WhenAggregations

Problem

Given a dataset of user ad clicks on Internet Brands properties, how would you calculate the click-through rate (CTR) for different device categories?

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
Internet BrandsCompute CTR by DeviceMediumIterableAggregate CTR by Device and CampaignMediumSnapCTR by Country and DeviceMedium