SQL Queries and Analysis on Bad Advertisers

Q: SQL Queries and Analysis on Bad Advertisers

This question evaluates SQL query writing, metric definition and normalization, ranking/aggregation techniques, and analytical reasoning for identifying problematic advertisers.

Q: How do I approach Analytics & Experimentation interview questions?

Analytics & Experimentation questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master analytics & experimentation interviews.

Question

Scenario

You are on the analytics team at TikTok and need to analyze the presence of bad content in ads and identify problematic advertisers.

Question 1

Propose a clear definition of a "top bad advertiser" and write an SQL query to identify them. Consider factors such as the number of reports an advertiser receives and appropriate normalization/ranking metrics.

Question 2

There is a positive correlation between ad page visits and reports on that ad being bad. Outline how you would investigate reasons behind this correlation. What hypotheses would you test?

Hints

Think about how to capture and rank bad advertisers using available data.
Reflect on why more page visits might lead to more reports (e.g., higher visibility, UI/reporting friction, confounding by exposure).

SQL Queries and Analysis on Bad Advertisers

Quick Overview

Scenario

Question 1

Question 2

Hints

Solution

Comments (0)