Based on the following [[ https://phabricator.wikimedia.org/T141506#2554790 | comment ]] in T141506, we need to look closer at our [[ https://meta.wikimedia.org/wiki/Schema:WikipediaPortal | eventlogging schema ]] and fix as needed.
> Your query has couple issues : does not filter self-reported bots and it does not filter by http codes. A pageview should always be a 200. Please open another ticket cause your issue seems slightly different.
Indirectly related issue: T143045