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/ Using that and the other data available on webrequest, you can get the breakdowns you need.blob/master/oozie/last_access_ uniques/daily/last_access_ uniques_daily.hql 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/ot
her/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
_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics