Skip to content

Firefox desktop

metric-hub

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

browser_launched_to_handle_events

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        *
    FROM `mozdata.telemetry.events`
    WHERE event_category = 'browser.launched_to_handle'
)

firefox_desktop_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 = 'Firefox Desktop'
)

main

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        *,
        DATE(submission_timestamp) AS submission_date,
        environment.experiments
    FROM `moz-fx-data-shared-prod.telemetry_stable.main_v5`
)

crash

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        *,
        DATE(submission_timestamp) AS submission_date,
        environment.experiments
    FROM mozdata.telemetry.crash
)

events_memory

Client ID column: None

Submission Date column: submission_date

Definition: 
(
        SELECT
            *
        FROM `moz-fx-data-shared-prod.telemetry.events`
        WHERE
            event_category = 'memory_watcher'
            AND event_method = 'on_high_memory'
            AND event_object = 'stats'
    )

search_clients_engines_sources_daily

Client ID column: None

Submission Date column: submission_date

Definition: 
mozdata.search.search_clients_engines_sources_daily

clients_daily

Client ID column: client_id

Submission Date column: submission_date

Definition: 
mozdata.telemetry.clients_daily

clients_last_seen

Client ID column: client_id

Submission Date column: submission_date

Definition: 
mozdata.telemetry.clients_last_seen

search_clients_daily

Client ID column: None

Submission Date column: None

Definition: 
mozdata.search.search_clients_engines_sources_daily

main_summary

Client ID column: None

Submission Date column: None

Definition: 
mozdata.telemetry.main_summary

events

Client ID column: None

Submission Date column: None

Definition: 
mozdata.telemetry.events

newtab_interactions

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
mozdata.telemetry.newtab_interactions

normandy_events

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        *
    FROM mozdata.telemetry.events
    WHERE event_category = 'normandy'
)

cfr

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        *,
        DATE(submission_timestamp) AS submission_date
    FROM `moz-fx-data-derived-datasets`.messaging_system.cfr
)

activity_stream_events

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        *,
        DATE(submission_timestamp) AS submission_date
    FROM mozdata.activity_stream.events
)

Client ID column: None

Submission Date column: submission_date

Definition: 
mozdata.telemetry.sponsored_tiles_clients_daily

clients_first_seen_v2

Client ID column: None

Submission Date column: first_seen_date

Definition: 
moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2

urlbar_events

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
(
    SELECT * FROM `moz-fx-data-shared-prod.firefox_desktop.urlbar_events`
)

urlbar_events_unnested_results

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
(
    SELECT
        e.* EXCEPT (results),
        result
    FROM
        `moz-fx-data-shared-prod.firefox_desktop.urlbar_events` e
    CROSS JOIN
        UNNEST(e.results) AS result
)

serp_events

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
mozdata.firefox_desktop.serp_events

metrics

Client ID column: metrics.uuid.legacy_telemetry_client_id

Submission Date column: None

Definition: 
(
    SELECT
      p.*,
      DATE(p.submission_timestamp) AS submission_date
    FROM `mozdata.firefox_desktop.metrics` p
    )

newtab_visits_topsite_tile_interactions

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
(
    SELECT
        e.* EXCEPT (topsite_tile_interactions),
        topsite_tile_interactions
    FROM
        `moz-fx-data-shared-prod.telemetry.newtab_visits` e
    CROSS JOIN
        UNNEST(e.topsite_tile_interactions) AS topsite_tile_interactions
)

newtab_visits_search_interactions

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
(
    SELECT
        e.* EXCEPT (search_interactions),
        search_interactions
    FROM
        `moz-fx-data-shared-prod.telemetry.newtab_visits` e
    CROSS JOIN
        UNNEST(e.search_interactions) AS search_interactions
)

newtab_visits_pocket_interactions

Client ID column: legacy_telemetry_client_id

Submission Date column: submission_date

Definition: 
(
    SELECT
        e.* EXCEPT (pocket_interactions),
        pocket_interactions
    FROM
        `moz-fx-data-shared-prod.telemetry.newtab_visits` e
    CROSS JOIN
        UNNEST(e.pocket_interactions) AS pocket_interactions
)

newtab_clients_daily

Client ID column: legacy_telemetry_client_id

Submission Date column: None

Definition: 
moz-fx-data-shared-prod.telemetry.newtab_clients_daily

clients_first_seen_28_days_later

Client ID column: client_id

Submission Date column: first_seen_date

Definition: 
`moz-fx-data-shared-prod.telemetry.clients_first_seen_28_days_later`

desktop_cohort_daily_retention

Client ID column: NULL

Submission Date column: submission_date

Definition: 
`moz-fx-data-shared-prod.telemetry.desktop_cohort_daily_retention`

desktop_engagement_view

Client ID column: NULL

Submission Date column: submission_date

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

desktop_retention_view

Client ID column: NULL

Submission Date column: metric_date

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

glean_events_stream

Client ID column: legacy_telemetry_client_id

Submission Date column: None

Definition: 
(
    SELECT *, DATE(submission_timestamp) AS submission_date
    FROM `moz-fx-data-shared-prod.firefox_desktop.events_stream`
)

firefox_desktop_active_users_view

Client ID column: client_id

Submission Date column: submission_date

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

site_breakage_events

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        metrics.uuid.legacy_telemetry_client_id AS client_id,
        DATE(submission_timestamp) AS submission_date,
        ping_info.experiments AS experiments,
        event.name AS event_name,
    FROM `mozdata.firefox_desktop.events`
    CROSS JOIN UNNEST(events) AS event
    WHERE
        event.category = 'webcompatreporting'
)

protections_popup_events

Client ID column: None

Submission Date column: None

Definition: 
(
    SELECT
        metrics.uuid.legacy_telemetry_client_id AS client_id,
        DATE(submission_timestamp) AS submission_date,
        ping_info.experiments AS experiments,
        event.name AS event_name,
    FROM `mozdata.firefox_desktop.events`
    CROSS JOIN UNNEST(events) AS event
    WHERE
        event.category = 'security.ui.protectionspopup'
)