Hi Tilman, Yes, you're right - I hadn't thought to look into that but of course it makes sense, since that's how we count the image views normally. I'd got confused by some of the comments on the wikitech page.
Am I right in saying that therefore this means: * one count each time a page including this file's thumbnail is loaded (as with images) - so, say, [[:en:Apollo 11]] means a hit for five video and one audio files * plus one count when it's played for a first time * plus one count any time it's restarted - with the vast majority of those coming from the first category. This helps explain a lot of the peaks - they're loaded with very popular pages. Do we have any numbers on how many videos are actually streamed, overall? Andrew. On 17 January 2016 at 11:36, Tilman Bayer <[email protected]> wrote: > 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 <[email protected]> > 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 >> [email protected] >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics > > > > -- > Tilman Bayer > Senior Analyst > Wikimedia Foundation > IRC (Freenode): HaeB > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > -- - Andrew Gray [email protected] _______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
