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
)
sponsored_tiles_clients_daily
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
)