Hi everybody,

Just in time for the holidays, we're announcing the addition of Media Requests to our metrics catalog. Over the last few months we've been working on a dataset offering request numbers for every single image, audio, video and document in the Wiki universe, since 2015.

This means we have 3 new metrics available in the Analytics Query Service:

- Media requests per referrer: e.g. how many images, audio, videos... have been accessed from English Wikipedia in the last month? *73 billion for November http://stats.wikimedia.org/v2/#/en.wikipedia.org/content/total-mediarequests/normal%7Cbar%7C2-year%7C~total%7Cmonthly.* - Media requests per file: e.g. how many hits did this cool painting https://en.wikipedia.org/wiki/Christmas_tree#/media/File:Yggdrasil.jpg get in November? The answer is 483,791 hits https://wikimedia.org/api/rest_v1/metrics/mediarequests/per-file/all-referers/all-agents/%2Fwikipedia%2Fcommons%2Fb%2Fb9%2FYggdrasil.jpg/monthly/2019110100/2019120200 . - Top files by media requests: e.g. what was the most popular video yesterday, December 22nd? Fred Rogers testifying before the Senate Subcommittee on Communications http://stats.wikimedia.org/v2/#/en.wikipedia.org/content/top-mediarequests/normal%7Ctable%7Clast-month%7Cmedia_type~video%7Cmonthly. Fun! You can check out the top 1000 media files for any month or day, for any media type.

Media requests is, in terms of absolute numbers, a huge dataset, so the per file and top metrics are still being loaded with data all the way to 2015. We expect this loading to finish in mid January.

You can read more about this in Wikitech https://wikitech.wikimedia.org/wiki/Analytics/AQS/Mediarequests. As usual if you have any questions about the dataset or the new metrics please send them our way here on the list or via Phabricator.

Happy holidays! Francisco + the A team