Investigating Correlation Between Ad Visits and Reports

Scenario

You are part of the analytics team at a social media platform. Recently, it has been observed that there is a positive correlation between the number of page visits to an advertisement and the reports labeling it as bad content. An investigation is warranted to understand this phenomenon better.

Question

Define what constitutes a 'top bad advertiser' using SQL. What metrics and conditions would you apply to identify advertisers with high incidents of reported ads?

Propose a method to investigate the positive correlation between ad page visits and the frequency of reports. Develop a hypothesis and outline the steps you would take to validate or refute it.

Hints

Consider the appropriateness of correlation vs. causation.

Analyze potential factors contributing to higher report rates, including ad content, engagement types, and user demographics.

Describe the data fields and SQL queries you might use to break down and assess these patterns.