Multi product
metric-hub
Pre-defined metrics for multi_product. These metrics are defined in metric-hub
mobile_daily_active_users_v1
Mobile DAU
This is the official DAU reporting definition. The logic is
detailed on the Confluence DAU page
and is automatically cross-checked, actively monitored, and change controlled.
Whenever possible, this is the preferred DAU reporting definition to use for Mobile products.
This metric needs to be aggregated by submission_date. If it is not aggregated by submission_date,
it is similar to a "days of use" metric, and not DAU.
For more information, refer to [the DAU description in Confluence](https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric).
For questions please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: mobile_active_users_aggregates_view
Definition:
SUM(dau)
mobile_dau_kpi_v1
Mobile DAU KPI
The average Mobile DAU in the 28-day period ending on December 15th. This is the official
Mobile DAU KPI reporting definition. The logic is
detailed on the Confluence DAU page
and is automatically cross-checked, actively monitored, and change controlled.
To reconstruct the annual Mobile DAU KPI, this metric needs to be aggregated by
EXTRACT(YEAR FROM submission_date).
For more information, refer to [the DAU description in Confluence](https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric).
For questions please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: mobile_active_users_aggregates_view
Definition:
SUM(IF(FORMAT_DATE('%m-%d', submission_date) BETWEEN '11-18' AND '12-15', dau, 0)) / 28
mobile_engagement_rate_v1
Mobile Engagement Rate
The Engagement Rate is calculated as the ratio between DAU and MAU. For each day, we use the single-day DAU number and divide it by the MAU corresponding to the 28-day period ending on that day. For OKR reporting, we then calculate a 28-day moving average of this number. More information is provided on the New Profiles, Retention and Engagement Rate Confluence Page.
Data Source: mobile_engagement_view
Definition:
SUM(dau) / SUM(mau)
mobile_retention_rate_v1
Mobile Retention Rate
The Retention Rate is calculated as the proportion of clients that are active on the 4th week after the metric date.
Data Source: mobile_retention_view
Definition:
SUM(retained_week_4) / SUM(active_metric_date)
mobile_new_profile_retention_rate_v1
Mobile New Proflie Retention Rate
The New Profile Retention Rate is calculated as the proportion of new profiles that are active on the 4th week after the metric date. More information is provided on the New Profiles, Retention and Engagement Rate Confluence Page.
Data Source: mobile_retention_view
Definition:
SUM(retained_week_4_new_profiles) / SUM(new_profiles_metric_date)
search_forecasting_daily_active_users
Daily Active Users
Counts the number of daily active users (DAU) for search revenue forecasting purposes.
Data Source: search_revenue_levers_daily
Definition:
{{agg_sum("dau")}}
search_forecasting_daily_active_users_w_google_default
Daily Active Users with Google as Default
Counts the number of daily active users (DAU) with Google as default search engine for search revenue forecasting purposes.
Data Source: search_revenue_levers_daily
Definition:
{{agg_sum("dau_w_engine_as_default")}}
search_forecasting_daily_active_searchers_w_google_default
Daily Active Users who Search with Google as Default
Counts the number of daily active users (DAU) with Google as default search engine who also conduct a search for search revenue forecasting purposes.
Data Source: search_revenue_levers_daily
Definition:
{{agg_sum("dau_engaged_w_sap")}}
search_forecasting_search_count
SAP search volume
Counts the number of searches a user performed through Firefox's Search Access Points. Learn more in the search data documentation.
Data Source: search_revenue_levers_daily
Definition:
{{agg_sum("sap")}}
search_forecasting_ad_clicks
Ad click volume
Counts clicks on ads on search engine result pages with a Mozilla partner tag.
Data Source: search_revenue_levers_daily
Definition:
{{agg_sum("ad_click")}}
search_forecasting_revenue_per_ad_click
Revenue per Ad Click
Revenue paid to Mozilla per Ad Click.
Data Source: search_revenue_levers_monthly
Definition:
SUM(revenue)/ SUM(ad_click)