Re: [Analytics] most popular articles per country

Hi Amir, As Tilman has suggested, your best bet is to query the pageview_hourly table. I was going to be lazy and give you a query to just find out the most viewed article for a given country, but then I made a few experiments and this is the query I came up with to generate a list of countries

Re: [Analytics] most popular articles per country

One can use the pageview_hourly table for this. On Mon, Jul 9, 2018 at 1:18 AM, Amir E. Aharoni < amir.ahar...@mail.huji.ac.il> wrote: > Hi, > > Is there a way to find what are the most popular articles per

[Analytics] most popular articles per country

Hi, Is there a way to find what are the most popular articles per country? Finding the most popular articles per language is easy with the Pageviews tool, but languages and countries are of course not the same. One thing I tried is going to Turnilo, webrequest_sampled_128, and filtering by

Re: [Analytics] most popular articles per country

I think as long as you put in a filter so that the minimum pageviews is maybe 1000, you should be fine privacy wise. I can't speak too much to your second question. On Mon, Jul 9, 2018 at 1:59 PM, Amir E. Aharoni < amir.ahar...@mail.huji.ac.il> wrote: > Thank you so much! In many countries it's

Re: [Analytics] most popular articles per country

Thanks. Another question: For some countries, the result is "-", for example Germany: Germany-en.wikipedia1275634 Any idea why? (I modified the query a bit and added the "project" column. And yes, the fact that en.wikipedia is at the top in Germany is also quite odd.) -- Amir

Re: [Analytics] most popular articles per country

Thank you so much! In many countries it's A couple of questions: 1. Are any of the results of this query private? Or can I talk about them to people? 2. Is anything like this already published anywhere? If it isn't, it may be nice to publish such a thing, similarly to Google Zeitgeist. -- Amir

Re: [Analytics] most popular articles per country

Amir: FYI that this data has couple caveats: 1) the "-" is pageviews for a page for which we cannot extract a title. 2) data very much affected by bot spikes (you can mitigate that by filtering by agent_type="user" but still, a significant portion of bot traffic is not label as such).