Jump to content

Wikimedia Product/Data dictionary/unique_devices_per_project_family_daily

From mediawiki.org


This page describes the data set unique_devices_per_project_family_daily that stores on Druid Datasources, which can be accessed via Superset/Turnilo. unique_devices_per_project_family_daily on Druid is directly loaded from wmf.unique_devices_per_project_family_daily on Hive, while wmf.unique_devices_per_project_family_daily on Hive is originally extracted from wmf.pageview_actor.

Schema

[edit]
Field name data type description data example source schema source field
project_family string The lower cased project-family (wikipedia for instance)' wiktionary wmf.pageview_actor normalized_host.project_class
country string Country name of the accessing agents (computed using maxmind GeoIP database)', Barbados wmf.pageview_actor geocoded_data['country']
country_code string 2 letter country code BB wmf.pageview_actor geocoded_data['country_code']
uniques_underestimate int Under estimation of unique devices seen based on last-access-global cookie, and the nocookies header 45 wmf.pageview_actor x_analytics_map['WMF-Last-Access'], x_analytics_map['nocookies'], uri_host
uniques_offset int Unique devices offset computed as fresh sessions (only 1 action without last-access-global cookie)' 103 wmf.pageview_actor count(1)
uniques_estimate int Estimate of unique devices seen as uniques_underestimate plus offset' 148 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

Dashboards which use this table

[edit]

Known issues and changes

[edit]

Further reading

[edit]