Active DAU and Active MAU
An Active User is defined as a client who has
total_daily_uri >= 5 URI for a given date.
- Dates are defined by
- A client's
total_daily_uriis defined as their sum of
scalar_parent_browser_engagement_total_uri_countfor a given date1.
Active DAU is the number of Active Users on a given day.
Active MAU is the number of unique clients who have been an Active User on any day in the last 28 days. In other words, any client that contributes to Active DAU in the last 28 days would also contribute to Active MAU for that day. Note that this is not simply the sum of Active DAU over 28 days, since any particular client could be active on many days.
For quick analysis, using
clients_daily_v6 is recommended. Below is an example query for getting Active DAU (aDAU) using
SELECT submission_date_s3, count(*) AS total_clients_cdv6 FROM clients_daily_v6 WHERE scalar_parent_browser_engagement_total_uri_count_sum >= 5 GROUP BY 1 ORDER BY 1 ASC
main_summary can also be used for getting aDAU. Below is an example query using a 1% sample over March 2018 using
SELECT submission_date_s3, count(DISTINCT client_id) * 100 as aDAU FROM (SELECT submission_date_s3, client_id, sum(coalesce(scalar_parent_browser_engagement_total_uri_count, 0)) as total_daily_uri FROM main_summary WHERE sample_id = '51' AND submission_date_s3 >= '20180301' AND submission_date_s3 < '20180401' GROUP BY 1, 2) as daily_clients_table WHERE total_daily_uri >= 5 GROUP BY 1 ORDER BY 1 ASC
client_count_daily can be used to get approximate aDAU. This dataset uses HyperLogLog to estimate unique counts. For example:
SELECT submission_date AS day, cardinality(merge(cast(hll AS HLL))) AS active_dau FROM client_count_daily WHERE total_uri_count_threshold >= 5 -- Limit to 7 days of history AND submission_date >= date_format(CURRENT_DATE - INTERVAL '7' DAY, '%Y%m%d') GROUP BY 1 ORDER BY 1
1: Note, the probe measuring
scalar_parent_browser_engagement_total_uri_count only exists in clients with Firefox 50 and up. Clients on earlier versions of Firefox won't be counted as an Active User (regardless of their use). Similarly,
scalar_parent_browser_engagement_total_uri_count doesn't increment when a client is in Private Browsing mode, so that won't be included as well.