Here are the dates where the pageviews for the top three pages started to rise drastically, remaining on that high plateau since then:
AMGTV: August 14
Okto: July 14
Proyecto 40: around July 14
(On the other hand, xHamster as #4 on the list does not show such an unusual development during the past 3 months, although it may be abnormally high for other reasons.)

The dates actually do not coincide with the main page rises T141506 , but then again we already found there that these occurred on different dates (July 20 vs. July 22). I agree it could very well be related.

(CCing @JMinor as we have been talking just the other day on how this causes issues for the "Explore" feed of the iOS app.)

See T144333 for info on iOS take on this.

See T145043 for a possible approach.

One idea is to take advantage of the webrequest -> pageview_hourly transformation, which already groups by hour. We could add a column to pageview_hourly called "distinct_user_agent_count" or something like that. This could then be used to filter results for the top endpoint, per-article endpoint, etc. Or it could be used as a good guess about bots that don't identify themselves.

Closing as duplicate