Wikimedia Product/Data dictionary/unique_devices_per_domain_monthly
This page describes the data set unique_devices_per_domain_monthly that stores on Druid Datasources, which can be accessed via Superset/Turnilo. unique_devices_per_domain_monthly on Druid is directly loaded from wmf.unique_devices_per_domain_monthly on Hive, while unique_devices_per_domain_monthly on Hive is originally extracted from wmf.pageview_actor.
Schema
[edit]| Field name | data type | description | data example | source schema | source field |
|---|---|---|---|---|---|
| uniques_offset | int | Unique devices offset computed as 1-action sessions without cookies | 0 | wmf.pageview_actor | count(1) |
| uniques_underestimate | int | Under estimation of unique devices seen based on last access cookie, and the nocookies header | 8 | wmf.pageview_actor | x_analytics_map['WMF-Last-Access'], x_analytics_map['nocookies'], uri_host |
| country | string | Country name of the accessing agents (computed using maxmind GeoIP database) | Albania | wmf.pageview_actor | geocoded_data['country'] |
| domain | string | The lower cased domain defining a project | af.m.wikipedia.org | wmf.pageview_actor | uri_host |
| country_code | string | 2 letter country code | AL | wmf.pageview_actor | geocoded_data['country_code'] |
| uniques_estimate | int | Estimate of unique devices seen as uniques_underestimate plus offset | 8 | wmf.pageview_actor | x_analytics_map['WMF-Last-Access'], x_analytics_map['nocookies'], uri_host |
| year | int | Unpadded year of requests | 2020 | wmf.pageview_actor | year |
| month | int | Unpadded month of requests | 11 | wmf.pageview_actor | month |