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