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 tbayer@wikimedia.org 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 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

---

Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics

Hi,

I wonder what had been change since - do we have a tool to pull this numbers (for people without sql access)...

*Regards,Itzik Edri* Chairperson, Wikimedia Israel +972-(0)-54-5878078 | http://www.wikimedia.org.il Imagine a world in which every single human being can freely share in the sum of all knowledge. That's our commitment!

On Mon, Jan 18, 2016 at 12:43 AM, Federico Leva (Nemo) nemowiki@gmail.com wrote:

Andrew Gray, 17/01/2016 22:36:

...

Am I right in saying that therefore this means:

Browser requests are not easy. See https://www.mediawiki.org/wiki/Requests_for_comment/Media_file_request_count...

For the purposes of your blog post, it's probably best to only consider columns 4 and 17 (see https://wikitech.wikimedia.org/wiki/Analytics/Data/Mediacounts ).

Nemo

---

Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics