Complex~34min
The Viewability Metric That Counts Empty Loads
PUB-07 reports 90% viewability — the best of any publisher — but only 0.4% of its viewable impressions ever get a real click or hover, versus 15% everywhere else. PUB-03 also engages below normal at 8%, but that's a documented older-demographic audience effect, not fraud. Only PUB-07's near-zero engagement despite top-of-class viewability is the real red flag — a prefetch load technically satisfying the viewability definition without a human ever seeing it.
Tables you'll query
publishersimpressions
What you'll learn
CTEs (WITH clause)Window FunctionsAggregations & GROUP BY