canmove, Confirmed users, Bureaucrats and Sysops emeriti
2,798
edits
Mobile/Metrics/Redash: Difference between revisions
m
no edit summary
MarkFinkle (talk | contribs) |
MarkFinkle (talk | contribs) mNo edit summary |
||
| Line 14: | Line 14: | ||
describe <table-name> | describe <table-name> | ||
Mobile telemetry data is split into | Mobile telemetry data is split into a few tables: <code>android_clients_v1</code>, <code>android_events_v1</code>, <code>android_addons_v1</code> and <code>mobile_clients_v1</code>. | ||
The <code>android_clients_v1</code> table holds data about common, mostly stable, information about individual Firefox installs. Each install has a unique <code>clientid</code> UUID. | The <code>android_clients_v1</code> table holds opt-in data about common, mostly stable, information about individual Firefox installs. Each install has a unique <code>clientid</code> UUID. | ||
clientid varchar unique identifier | clientid varchar unique identifier | ||
profiledate timestamp when the installation was created, based on the profile | profiledate timestamp when the installation was created, based on the profile | ||
| Line 32: | Line 32: | ||
Some of these fields can change during the lifetime of a Firefox installation. Some can't. A record is created for each telemetry ping, so it is possible to track the history of a client over time. You can see the default search engine change or the OS get updated, for a given client. | Some of these fields can change during the lifetime of a Firefox installation. Some can't. A record is created for each telemetry ping, so it is possible to track the history of a client over time. You can see the default search engine change or the OS get updated, for a given client. | ||
The <code>android_events_v1</code> table holds event data (UI Telemetry). Each event is a record. | The <code>android_events_v1</code> table holds opt-in event data (UI Telemetry). Each event is a record. | ||
clientid varchar unique identifier | clientid varchar unique identifier | ||
submissiondate timestamp when the telemetry record was received by the server | submissiondate timestamp when the telemetry record was received by the server | ||
| Line 44: | Line 44: | ||
submission varchar submission as a string 'YYYYMMDD' (partition) | submission varchar submission as a string 'YYYYMMDD' (partition) | ||
The <code>android_addons_v1</code> table holds add-on and lightweight theme data. This table only has data for clients that have either: at least one add-on installed, or an active lightweight theme. Clients that have no add-ons installed and have no active lightweight theme are not included in the table. Use a <code>left join</code> to <code>android_clients_v1</code> or <code>android_events_v1</code> to create a recordset with all clients included, but nulls for clients not in the <code>android_addons_v1</code> table. | The <code>android_addons_v1</code> table holds opt-in add-on and lightweight theme data. This table only has data for clients that have either: at least one add-on installed, or an active lightweight theme. Clients that have no add-ons installed and have no active lightweight theme are not included in the table. Use a <code>left join</code> to <code>android_clients_v1</code> or <code>android_events_v1</code> to create a recordset with all clients included, but nulls for clients not in the <code>android_addons_v1</code> table. | ||
clientid varchar unique identifier | clientid varchar unique identifier | ||
submissiondate timestamp when the telemetry record was received by the server | submissiondate timestamp when the telemetry record was received by the server | ||
| Line 51: | Line 51: | ||
channel varchar channel name (partition) | channel varchar channel name (partition) | ||
submission varchar submission as a string 'YYYYMMDD' (partition) | submission varchar submission as a string 'YYYYMMDD' (partition) | ||
The <code>mobile_clients_v1</code> table holds opt-out data about common, mostly stable, information about individual Firefox installs. Each install has a unique <code>clientid</code> UUID. | |||
clientid varchar unique identifier | |||
submissiondate timestamp when the telemetry record was received by the server | |||
profiledate timestamp when the installation was created, based on the profile | |||
creationdate timestamp when the telemetry record was generated by the client | |||
geocountry varchar country determined via client IP during submission | |||
locale varchar locale code | |||
os varchar name of the OS ('Android' or 'iOS') | |||
osversion varchar version OS (SDK number on Android and full version string on iOS) | |||
appversion varchar version of Firefox | |||
device varchar device identifier string | |||
arch varchar CPU architecture | |||
defaultsearch varchar current default search engine name | |||
distributionid varchar ID of the distribution partner, or null | |||
experiments varchar a/b experiments associated with the client (JSON array) | |||
channel varchar channel name (partition) | |||
submission varchar submission as a string 'YYYYMMDD' (partition) | |||
== Understanding Event Data == | == Understanding Event Data == | ||