Jump to content

Wikimedia Product/Data dictionary/unique_devices_per_domain_monthly

From mediawiki.org


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

Dashboards which use this table

[edit]

Known issues and changes

[edit]

Further reading

[edit]