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 aims to answer these questions. Each row in
the table is a (
submission_date) and contains a
number of aggregates about that day's activity.
clients_daily table is accessible through STMO using the
Telemetry (BigQuery) data source.
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 BigQuery ETL. The query that generates the dataset is