You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org
Analytics/Data Lake/Traffic/Unique Devices
Main documentation page: Analytics/Unique Devices
How is this data computed
As of 2016-02, there are two 'last access' tables available on Hive. last_access_uniques_daily stores unique devices counts per project split by country per day, last_access_uniques_monthly stores unique devices counts per project split by country per month.
|uri_host||string||Lower cased host defining a project (en.wikipedia.org for instance)|
|country||string||Country name of the accessing agents (computed using maxmind GeoIP database)|
|country_code||string||2 letter country code|
|uniques_underestimate||int||Under estimation of unique devices based on last access cookie, and the nocookies header. Unqiue Devices that came to a given project at least twice.|
|uniques_offset||int||Unique devices offset computed as 1-action sessions without cookies.|
|uniques_estimate||int||Estimate of total unique devices seen as uniques_underestimate plus offset|
|year||int||Unpadded year of requests|
|month||int||Unpadded month of requests|
|day||int||Unpadded day of requests|
Sample query to get total uniques for a given project for a day
select sum(uniques_estimate) from last_access_uniques_daily where year=2015 and month=12 and day=24 and uri_host like 'es.wikipedia%'
Changes and Known Problems with Dataset
- 2016-02-19: Monthly data is available as of January 2016.
- Visualization on the Vital Signs dashboard (example): https://vital-signs.wmflabs.org/#projects=frwiki,eswiki/metrics=UniqueDevices
- API documentation (see also April 2016 announcement)