Wikimedia Product/Data dictionary/unique_devices_per_domain_daily
Appearance
This page describes the data set unique_devices_per_domain_daily
that stores on Druid Datasources, which can be accessed via Superset/Turnilo. unique_devices_per_domain_daily
on Druid is directly loaded from wmf.unique_devices_per_domain_daily
on Hive, while unique_devices_per_domain_daily
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 |
day | int | Unpadded day of requests | 1 | wmf.pageview_actor | day |