Google Code-in

Over many years quite a few people asked for monthly page view stats that can be queried via an API.

Since medium 2015 we have the awesome api which serves highly granular pageview data. But for trend analysis or merely monthly reports a higher aggregation level would be very useful. And in particular monthly totals.

As it turns out the current api has 'scaling issues'.

Daily and monthly aggregates are already available, as huge downloads from https://dumps.wikimedia.org/other/pagecounts-ez/merged/

A KISS stopgap solution might be to feed those monthly dumps into a simple (SQL?) database.
keys: project, language, month, site, title, count

See https://wikitech.wikimedia.org/wiki/Analytics/PageviewAPI for more information - this is probably an advanced task and you should have previous experience with REST.