Hi Andrew,

very interesting, thank you! However, I think the post should make it a bit clearer that these numbers include video thumbnail views, and are presumably dominated by them. (A list of the most played videos would look quite different, and presumably not be 100% SFW.) The meaning of the fields is documented on Wikitech. For instance, the Ward Cunningham interview (#9 on your list and the top CC-licensed one) had indeed over 7 million views in 2015, but most of them were thumbnail views - it was played (or had a video version downloaded) 76,315 times, 43,545 times in form of the original WEBM file and 32,770 times in a transcoded version. 


hive (default)> SELECT SUM(total) AS total, SUM(original) AS original, SUM(transcoded_image) AS transcoded_image, SUM(transcoded_movie) AS transcoded_movie FROM wmf.mediacounts where year = 2015 AND base_name = "/wikipedia/commons/3/31/Ward_Cunningham%2C_Inventor_of_the_Wiki.webm";

total original transcoded_image transcoded_movie
7385568 43545 7309253 32770


On Fri, Jan 15, 2016 at 1:28 AM, Andrew Gray <andrew.gray@dunelm.org.uk> wrote:
> Hi all,
>
> I hacked up a very quick count of the 2015 video viewing aggregate
> figures, using the data that Bartosz put together last year - with the
> caveat that the data only goes up to 10 December, but it's probably
> indicative of whole-year trends. I haven't yet tried to merge in the
> 11-31/12 data. Nothing very insightful but I don't recall seeing it
> done before, so it might be of interest!
>
> http://www.generalist.org.uk/blog/2016/most-popular-videos-on-wikipedia/
>
> The headline figure is that we had about three billion (!!)
> video/audio plays during the year, and that some of the most popular
> items are insanely popular - the most popular was viewed an average of
> 42,000 times a day, every day.
>
> Pine: the video you asked about in the other thread was viewed 187,899
> times from 31/10/15 to 10/12/15. So there's half your answer :-)
>
> --
> - Andrew Gray
>   andrew.gray@dunelm.org.uk
>
> _______________________________________________
> Analytics mailing list
> Analytics@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/analytics



--
Tilman Bayer
Senior Analyst
Wikimedia Foundation
IRC (Freenode): HaeB