Katkat
Back

SQL Queries and Analysis on Bad Advertisers

TikTokData Scientist · Technical Screen
MediumData ScientistTechnical ScreenData Manipulation (SQL/Python)

Last updated

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

Scenario

You are part of the analytics team at TikTok and are tasked with analyzing the presence of bad content on the platform, particularly focusing on adverts.

Question 1

Write an SQL query to define and identify what constitutes a 'top bad advertiser'. Consider factors such as the number of reports an advertiser receives and other relevant ranking metrics.

Question 2

Given the information that there is a positive correlation between ad page visits and reports on that ad being bad, outline your approach to investigate the reasons behind this correlation. What would be your hypothesis?

Hints

Consider how you would capture and rank bad advertisers using available data.

Reflect on potential reasons for the positive correlation (e.g., higher visibility leading to more scrutiny).