For those details you have to query the internal-only wmf.webrequest table, Erik. Here's an example of doing that to produce the unique numbers on dumps: https://github.com/wikimedia/analytics-refinery/blob/master/oozie/last_access_uniques/daily/last_access_uniques_daily.hql Using that and the other data available on webrequest, you can get the breakdowns you need.

On Thu, Nov 10, 2016 at 8:28 AM, Erik Zachte <ezachte@wikimedia.org> wrote:

Hi, I am looking for monthly unique devices per device type (desktop, smartphone, tablet, maybe 'other').

I found this https://dumps.wikimedia.org/other/unique_devices/2016/2016-09/
file unique_devices_monthly-2016-09.gz

But this totals unique devices per platform, e.g.

en.m.wikipedia.org 380212837
en.wikipedia.org 221721511

Is there another place I can find this?

Thanks,
Erik

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