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 https://wikitech.wikimedia.org/wiki/Analytics/Data/Mediacounts. For instance, the Ward Cunningham interview https://commons.wikimedia.org/wiki/File:Ward_Cunningham,_Inventor_of_the_Wiki.webm (#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