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(a)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(a)dunelm.org.uk
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics
--
Tilman Bayer
Senior Analyst
Wikimedia Foundation
IRC (Freenode): HaeB