Telemetry/Available Telemetry Datasets and their Applications: Difference between revisions

Added crash aggregates
(Added client count dataset)
(Added crash aggregates)
Line 30: Line 30:
The Client Count dataset is simply a count of clients in a time period, separated out into a set of dimensions.  
The Client Count dataset is simply a count of clients in a time period, separated out into a set of dimensions.  


This is useful for questions similar to: ''"How many X type of users were there during Y?"'' - where X is some dimensions, and Y is some dates. Examples of X are: E10s Enabled, Operating System Type, or Country. For a complete list of dimensions, see [https://github.com/mozilla/telemetry-batch-view/blob/master/src/main/scala/com/mozilla/telemetry/views/ClientCountView.scala#L22 here].
This is useful for questions similar to: ''How many X type of users were there during Y?'' - where X is some dimensions, and Y is some dates. Examples of X are: E10s Enabled, Operating System Type, or Country. For a complete list of dimensions, see [https://github.com/mozilla/telemetry-batch-view/blob/master/src/main/scala/com/mozilla/telemetry/views/ClientCountView.scala#L22 here].


Client Count does not contain a traditional int count column, instead the counts are stored as a HyperLogLogs in the hll column. The count of the hll is found using  <code>cardinality(cast(hll AS HLL))</code>, and different hll's can be merged using  <code>merge(cast(hll AS HLL))</code>. An example can be found in the [https://sql.telemetry.mozilla.org/queries/81/source#129 Firefox ER Reporting].
Client Count does not contain a traditional int count column, instead the counts are stored as a HyperLogLogs in the hll column. The count of the hll is found using  <code>cardinality(cast(hll AS HLL))</code>, and different hll's can be merged using  <code>merge(cast(hll AS HLL))</code>. An example can be found in the [https://sql.telemetry.mozilla.org/queries/81/source#129 Firefox ER Reporting].
Line 39: Line 39:


==Crash Aggregates==
==Crash Aggregates==
[https://github.com/mozilla/telemetry-batch-view/blob/master/docs/CrashAggregateView.md Complete Documentation]
The Crash Aggregates dataset compiles crash statistics over various dimensions for each day. Example dimensions include channel and country, example statistics include usage hours and plugin crashes. See the [https://github.com/mozilla/telemetry-batch-view/blob/master/docs/CrashAggregateView.md complete documentation] for all available dimensions and statistics.
This dataset is good for queries of the form ''How many crashes did X types of users get during time Y?'' and ''Which types of users crashed the most during time Y?''.


==Mobile Metrics==
==Mobile Metrics==
The android_events, android_clients, android_addons, and mobile_clients tables are documented here:
The android_events, android_clients, android_addons, and mobile_clients tables are documented here:
https://wiki.mozilla.org/Mobile/Metrics/Redash
https://wiki.mozilla.org/Mobile/Metrics/Redash
29

edits