Skip to content

Multi product

metric-hub

Pre-defined data sources for multi_product. These data sources are defined in metric-hub

mobile_active_users_aggregates_view

Client ID column: NULL

Submission Date column: submission_date

Definition: 
(
    SELECT *
     FROM `moz-fx-data-shared-prod.telemetry.active_users_aggregates`
    WHERE app_name IN ('Fenix',  'Firefox iOS', 'Focus Android', 'Focus iOS')
)

search_revenue_levers_daily

Client ID column: NULL

Submission Date column: submission_date

Definition: 
mozdata.search.search_revenue_levers_daily

search_revenue_levers_monthly

Client ID column: NULL

Submission Date column: submission_month

Definition: 
mozdata.revenue.search_revenue_levers_monthly

mobile_engagement_view

Client ID column: NULL

Submission Date column: submission_date

Definition: 
(
    SELECT *
     FROM `moz-fx-data-shared-prod.telemetry.mobile_engagement`
    WHERE is_mobile
)

mobile_retention_view

Client ID column: NULL

Submission Date column: metric_date

Definition: 
(
    SELECT *
     FROM `moz-fx-data-shared-prod.telemetry.mobile_retention`
    WHERE is_mobile
)