- Data Reference
- Code Reference
clients_daily table is intended as the first stop for asking questions
about how people use Firefox. It should be easy to answer simple questions.
Each row in the table is a (
submission_date) and contains a
number of aggregates about that day's activity.
Many questions about Firefox take the form "What did clients with
characteristics X, Y, and Z do during the period S to E?" The
clients_daily table is aimed at answer those questions.
clients_daily table is accessible through re:dash using the
Telemetry (BigQuery) data source.
Here's an example query.
SELECT submission_date, approx_count_distinct(client_id) AS cohort_dau FROM telemetry.clients_daily WHERE submission_date > '2017-08-31' AND submission_date < '2017-10-01' AND profile_creation_date LIKE '2017-09-01%' GROUP BY 1 ORDER BY 1
SELECT normalized_channel, CASE WHEN pings_aggregated_by_this_row > 50 THEN 50 ELSE pings_aggregated_by_this_row END AS pings_per_day, approx_count_distinct(client_id) AS client_count FROM telemetry.clients_daily WHERE submission_date = '2017-09-01' AND normalized_channel <> 'Other' GROUP BY normalized_channel, pings_per_day ORDER BY pings_per_day, normalized_channel
The data is partitioned by
As of 2019-11-28, the current version of the
clients_daily dataset is
This dataset is generated by
Refer to this repository for information on how to run or augment the dataset.