Skip to content

Telemetry

Views on data from legacy Firefox telemetry, plus many other general-purpose datasets

Source Directory

accessibility_clients

Accessibility Clients

telemetry.accessibility_clients

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
normalized_channel String Yes
nvda Integer Yes
jaws Integer Yes
oldjaws Integer Yes
we Integer Yes
dolphin Integer Yes
serotek Integer Yes
cobra Integer Yes
zoomtext Integer Yes
kazaguru Integer Yes
youdao Integer Yes
unknown Integer Yes
uiautomation Integer Yes
visperoshared Integer Yes
magnifier Integer Yes
narrator Integer Yes
on_screen_keyboard Integer Yes
speech_recognition Integer Yes
touch_keyboard_and_handwriting_panel Integer Yes
voice_over Integer Yes
other Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived accessibility_clients_v1

Source Directory | View Definition | Metadata File


active_profiles

Active Profiles

telemetry.active_profiles

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
recency Integer Yes
frequency Integer Yes
num_opportunities Integer Yes
max_day String Yes
min_day String Yes
locale String Yes
normalized_channel String Yes
os String Yes
normalized_os_version String Yes
country String Yes
prob_active Float Yes
e_total_days_in_next_7_days Float Yes
e_total_days_in_next_14_days Float Yes
e_total_days_in_next_21_days Float Yes
e_total_days_in_next_28_days Float Yes
prob_daily_usage Float Yes
prob_daily_leave Float Yes
prob_mau Float Yes
sample_id Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived active_profiles_v1

Source Directory | View Definition | Metadata File


active_users_aggregates

Active Users Aggregates

telemetry.active_users_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_desktop active_users_aggregates
moz-fx-data-shared-prod telemetry active_users_aggregates_mobile

Source Directory | View Definition | Metadata File


active_users_aggregates_attribution

Active Users Aggregates Attribution

telemetry.active_users_aggregates_attribution

Please provide a description for the query

Schema
Column Description Type Nullable
attribution_campaign String Yes
attribution_content String Yes
attribution_experiment String Yes
attribution_medium String Yes
attribution_source String Yes
attribution_variation String Yes
city String Yes
country String Yes
first_seen_year Integer Yes
is_default_browser Boolean Yes
app_name String Yes
submission_date Date Yes
dau Integer Yes
wau Integer Yes
mau Integer Yes
new_profiles Integer Yes
ad_clicks Integer Yes
organic_search_count Integer Yes
search_count Integer Yes
search_with_ads Integer Yes
uri_count Integer Yes
active_hours Float Yes
attributed Boolean Yes
adjust_network The type of source of a client installation String Yes
install_source The source of a client installation String Yes
qdau_desktop Count of distinct, qualified Desktop clients that we received a main ping from on a given day. In mobile DAU = QDAU. Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived active_users_aggregates_attribution_v1

Source Directory | View Definition | Metadata File


active_users_aggregates_device

Active Users Aggregates Device

telemetry.active_users_aggregates_device

Please provide a description for the query

Schema
Column Description Type Nullable
app_version String Yes
attributed Boolean Yes
attribution_medium String Yes
attribution_source String Yes
country String Yes
device_model String Yes
first_seen_year Integer Yes
is_default_browser Boolean Yes
app_name String Yes
channel String Yes
os String Yes
os_version String Yes
os_version_major Integer Yes
os_version_minor Integer Yes
submission_date Date Yes
dau Integer Yes
wau Integer Yes
mau Integer Yes
new_profiles Integer Yes
ad_clicks Integer Yes
organic_search_count Integer Yes
search_count Integer Yes
search_with_ads Integer Yes
uri_count Integer Yes
active_hours Float Yes
qdau_desktop Count of distinct, qualified Desktop clients that we received a main ping from on a given day. In mobile DAU = QDAU. Integer Yes
os_grouped String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived active_users_aggregates_device_v1

Source Directory | View Definition | Metadata File


active_users_aggregates_mobile

Active Users Aggregates Mobile

telemetry.active_users_aggregates_mobile

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod fenix active_users_aggregates
moz-fx-data-shared-prod firefox_ios active_users_aggregates
moz-fx-data-shared-prod focus_android active_users_aggregates
moz-fx-data-shared-prod focus_ios active_users_aggregates
moz-fx-data-shared-prod klar_ios active_users_aggregates

Source Directory | View Definition | Metadata File


addon_aggregates

Addon Aggregates

telemetry.addon_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry addon_aggregates_v2

Source Directory | View Definition | Metadata File


addon_aggregates_v2

Addon Aggregates V2

telemetry.addon_aggregates_v2

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
submission_date Date Yes
sample_id Integer Yes
client_id String Yes
normalized_channel String Yes
app_version String Yes
locale String Yes
n_self_installed_addons Integer Yes
n_shield_addons Integer Yes
n_foreign_installed_addons Integer Yes
n_system_addons Integer Yes
n_web_extensions Integer Yes
first_addon_install_date String Yes
profile_creation_date String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addon_aggregates_v2

Source Directory | View Definition | Metadata File


addon_install_blocked

Historical Pings for telemetry/addon-install-blocked

telemetry.addon_install_blocked

A historical view of pings sent for the telemetry/addon-install-blocked document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable addon_install_blocked_v4

Source Directory | View Definition | Metadata File


addon_names

Addon Names

telemetry.addon_names

Please provide a description for the query

Schema
Column Description Type Nullable
addon_id String Yes
addon_name String Yes
occurrences Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addon_names_v1

Source Directory | View Definition | Metadata File


addons

Addons

telemetry.addons

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
sample_id Integer Yes
document_id String Yes
client_id String Yes
subsession_start_date String Yes
normalized_channel String Yes
addon_id String Yes
blocklisted Boolean Yes
name String Yes
user_disabled Boolean Yes
app_disabled Boolean Yes
version String Yes
scope Integer Yes
type String Yes
foreign_install Boolean Yes
has_binary_components Boolean Yes
install_day Integer Yes
update_day Integer Yes
signed_state Integer Yes
is_system Boolean Yes
is_web_extension Boolean Yes
multiprocess_compatible Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addons_v2

Source Directory | View Definition | Metadata File


addons_daily

Addons Daily

telemetry.addons_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
addon_id String Yes
name String Yes
most_common_default_search_engine String Yes
dau Integer Yes
wau Integer Yes
mau Integer Yes
is_system Boolean Yes
active_hours_sum Float Yes
total_uri_count_sum Integer Yes
tab_open_event_count_sum Integer Yes
devtools_toolbox_opened_count_sum Integer Yes
sap_searches Record Yes
tagged_sap_searches Record Yes
tagged_follow_on_searches Record Yes
organic_searches Record Yes
searches_with_ads Record Yes
ad_clicks Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addons_daily_v1

Source Directory | View Definition | Metadata File


addons_v2

Addons V2

telemetry.addons_v2

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
submission_date Date Yes
sample_id Integer Yes
document_id String Yes
client_id String Yes
subsession_start_date String Yes
normalized_channel String Yes
addon_id String Yes
blocklisted Boolean Yes
name String Yes
user_disabled Boolean Yes
app_disabled Boolean Yes
version String Yes
scope Integer Yes
type String Yes
foreign_install Boolean Yes
has_binary_components Boolean Yes
install_day Integer Yes
update_day Integer Yes
signed_state Integer Yes
is_system Boolean Yes
is_web_extension Boolean Yes
multiprocess_compatible Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addons_v2

Source Directory | View Definition | Metadata File


adm_engagements_daily

Adm Engagements Daily

telemetry.adm_engagements_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
country String Yes
placement String Yes
partner String Yes
version String Yes
normalized_channel String Yes
n_engagements Integer Yes
interaction String Yes
phase String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived adm_engagements_daily_v1

Source Directory | View Definition | Metadata File


advancedtelemetry

Historical Pings for telemetry/advancedtelemetry

telemetry.advancedtelemetry

A historical view of pings sent for the telemetry/advancedtelemetry document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable advancedtelemetry_v4

Source Directory | View Definition | Metadata File


anonymous

Historical Pings for telemetry/anonymous

telemetry.anonymous

A historical view of pings sent for the telemetry/anonymous document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable anonymous_v4

Source Directory | View Definition | Metadata File


applications

Applications

telemetry.applications

Please provide a description for the query

Schema
Column Description Type Nullable
app_channel App Channel String Yes
app_description App Description String Yes
app_id App ID String Yes
app_name App Name String Yes
bq_dataset_family Dataset name ping data is stored in String Yes
canonical_app_name Human readable app name String Yes
document_namespace Document Namespace String Yes
notification_emails Set of emails that will receive any app-related notifications String No
url Repository URL String Yes
v1_name V1 App Name String Yes
is_glean Whether the application is using Glean Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived applications_v1

Source Directory | View Definition | Metadata File


bhr

Historical Pings for telemetry/bhr

telemetry.bhr

A historical view of pings sent for the telemetry/bhr document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
application Record Yes
client_id String Yes
creation_date String Yes
environment Record Yes
id String Yes
payload Record Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable bhr_v4

Source Directory | View Definition | Metadata File


block_autoplay

Historical Pings for telemetry/block-autoplay

telemetry.block_autoplay

A historical view of pings sent for the telemetry/block-autoplay document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable block_autoplay_v4

Source Directory | View Definition | Metadata File


buildhub2

Buildhub2

telemetry.buildhub2

Please provide a description for the query

Schema
Column Description Type Nullable
build_hash String Yes
build Record Yes
metadata Record Yes
created_at Timestamp Yes
s3_object_key String Yes
s3_object_etag String Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-buildhub2-prod-4784 build_metadata buildhub2

Source Directory | View Definition | Metadata File


certificate_checker

Historical Pings for telemetry/certificate-checker

telemetry.certificate_checker

A historical view of pings sent for the telemetry/certificate-checker document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable certificate_checker_v4

Source Directory | View Definition | Metadata File


client_probe_counts

Client Probe Counts

telemetry.client_probe_counts

Please provide a description for the query

Schema
Column Description Type Nullable
os String Yes
app_version Integer Yes
app_build_id String Yes
channel String Yes
metric String Yes
metric_type String Yes
key String Yes
process String Yes
first_bucket Integer Yes
last_bucket Integer Yes
num_buckets Integer Yes
client_agg_type String Yes
agg_type String Yes
total_users Integer Yes
aggregates Record No
non_norm_aggregates Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_histogram_probe_counts_v1
moz-fx-data-shared-prod telemetry_derived clients_scalar_probe_counts_v1
moz-fx-data-shared-prod telemetry_derived histogram_percentiles_v1
moz-fx-data-shared-prod telemetry_derived scalar_percentiles_v1

Source Directory | View Definition | Metadata File


client_probe_processes

Client Probe Processes

telemetry.client_probe_processes

Please provide a description for the query

Schema
Column Description Type Nullable
metric String Yes
processes String No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived client_probe_processes_v1

Source Directory | View Definition | Metadata File


clients_daily

Clients Daily

telemetry.clients_daily

A daily aggregate of main and event pings from each Firefox desktop client.

Clustering fields: normalized_channel, sample_id

See also: clients_last_seen, clients_first_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_daily_v6

Source Directory | View Definition | Metadata File


clients_daily_histogram_aggregates

Clients Daily Histogram Aggregates

telemetry.clients_daily_histogram_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_daily_histogram_aggregates_v1

Source Directory | View Definition | Metadata File


clients_daily_scalar_aggregates

Clients Daily Scalar Aggregates

telemetry.clients_daily_scalar_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_daily_scalar_aggregates_v1

Source Directory | View Definition | Metadata File


clients_daily_v6

Clients Daily V6

telemetry.clients_daily_v6

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
submission_date Date Yes
client_id String Yes
aborts_content_sum Integer Yes
aborts_gmplugin_sum Integer Yes
aborts_plugin_sum Integer Yes
active_addons_count_mean Float Yes
active_addons Record No
active_hours_sum Float Yes
addon_compatibility_check_enabled Boolean Yes
app_build_id String Yes
app_display_version String Yes
app_name String Yes
app_version String Yes
attribution Record Yes
blocklist_enabled Boolean Yes
channel String Yes
client_clock_skew_mean Float Yes
client_submission_latency_mean Float Yes
cpu_cores Integer Yes
cpu_count Integer Yes
cpu_family Integer Yes
cpu_l2_cache_kb Integer Yes
cpu_l3_cache_kb Integer Yes
cpu_model Integer Yes
cpu_speed_mhz Integer Yes
cpu_stepping Integer Yes
cpu_vendor String Yes
crashes_detected_content_sum Integer Yes
crashes_detected_gmplugin_sum Integer Yes
crashes_detected_plugin_sum Integer Yes
crash_submit_attempt_content_sum Integer Yes
crash_submit_attempt_main_sum Integer Yes
crash_submit_attempt_plugin_sum Integer Yes
crash_submit_success_content_sum Integer Yes
crash_submit_success_main_sum Integer Yes
crash_submit_success_plugin_sum Integer Yes
default_search_engine String Yes
default_search_engine_data_load_path String Yes
default_search_engine_data_name String Yes
default_search_engine_data_origin String Yes
default_search_engine_data_submission_url String Yes
devtools_toolbox_opened_count_sum Integer Yes
distribution_id String Yes
e10s_enabled Boolean Yes
env_build_arch String Yes
env_build_id String Yes
env_build_version String Yes
environment_settings_intl_accept_languages String No
environment_settings_intl_app_locales String No
environment_settings_intl_available_locales String No
environment_settings_intl_requested_locales String No
environment_settings_intl_system_locales String No
environment_settings_intl_regional_prefs_locales String No
experiments Record No
first_paint_mean Float Yes
flash_version String Yes
country String Yes
city String Yes
geo_subdivision1 String Yes
geo_subdivision2 String Yes
isp_name String Yes
isp_organization String Yes
gfx_features_advanced_layers_status String Yes
gfx_features_d2d_status String Yes
gfx_features_d3d11_status String Yes
gfx_features_gpu_process_status String Yes
histogram_parent_devtools_aboutdebugging_opened_count_sum Integer Yes
histogram_parent_devtools_animationinspector_opened_count_sum Integer Yes
histogram_parent_devtools_browserconsole_opened_count_sum Integer Yes
histogram_parent_devtools_canvasdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_computedview_opened_count_sum Integer Yes
histogram_parent_devtools_custom_opened_count_sum Integer Yes
histogram_parent_devtools_dom_opened_count_sum Integer Yes
histogram_parent_devtools_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_fontinspector_opened_count_sum Integer Yes
histogram_parent_devtools_inspector_opened_count_sum Integer Yes
histogram_parent_devtools_jsbrowserdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_jsdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_jsprofiler_opened_count_sum Integer Yes
histogram_parent_devtools_layoutview_opened_count_sum Integer Yes
histogram_parent_devtools_memory_opened_count_sum Integer Yes
histogram_parent_devtools_menu_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_netmonitor_opened_count_sum Integer Yes
histogram_parent_devtools_options_opened_count_sum Integer Yes
histogram_parent_devtools_paintflashing_opened_count_sum Integer Yes
histogram_parent_devtools_picker_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_responsive_opened_count_sum Integer Yes
histogram_parent_devtools_ruleview_opened_count_sum Integer Yes
histogram_parent_devtools_scratchpad_opened_count_sum Integer Yes
histogram_parent_devtools_scratchpad_window_opened_count_sum Integer Yes
histogram_parent_devtools_shadereditor_opened_count_sum Integer Yes
histogram_parent_devtools_storage_opened_count_sum Integer Yes
histogram_parent_devtools_styleeditor_opened_count_sum Integer Yes
histogram_parent_devtools_webaudioeditor_opened_count_sum Integer Yes
histogram_parent_devtools_webconsole_opened_count_sum Integer Yes
histogram_parent_devtools_webide_opened_count_sum Integer Yes
install_year Integer Yes
is_default_browser Boolean Yes
is_wow64 Boolean Yes
locale String Yes
memory_mb Integer Yes
normalized_channel String Yes
normalized_os_version String Yes
os String Yes
os_service_pack_major Integer Yes
os_service_pack_minor Integer Yes
os_version String Yes
pings_aggregated_by_this_row Integer Yes
places_bookmarks_count_mean Float Yes
places_pages_count_mean Float Yes
plugin_hangs_sum Integer Yes
plugins_infobar_allow_sum Integer Yes
plugins_infobar_block_sum Integer Yes
plugins_infobar_shown_sum Integer Yes
plugins_notification_shown_sum Integer Yes
previous_build_id String Yes
profile_age_in_days Integer Yes
profile_creation_date String Yes
push_api_notify_sum Integer Yes
sample_id Integer Yes
sandbox_effective_content_process_level Integer Yes
scalar_combined_webrtc_nicer_stun_retransmits_sum Integer Yes
scalar_combined_webrtc_nicer_turn_401s_sum Integer Yes
scalar_combined_webrtc_nicer_turn_403s_sum Integer Yes
scalar_combined_webrtc_nicer_turn_438s_sum Integer Yes
scalar_content_navigator_storage_estimate_count_sum Integer Yes
scalar_content_navigator_storage_persist_count_sum Integer Yes
scalar_parent_aushelper_websense_reg_version String Yes
scalar_parent_browser_engagement_max_concurrent_tab_count_max Integer Yes
scalar_parent_browser_engagement_max_concurrent_window_count_max Integer Yes
scalar_parent_browser_engagement_tab_open_event_count_sum Integer Yes
scalar_parent_browser_engagement_total_uri_count_sum Integer Yes
scalar_parent_browser_engagement_unfiltered_uri_count_sum Integer Yes
scalar_parent_browser_engagement_unique_domains_count_max Integer Yes
scalar_parent_browser_engagement_unique_domains_count_mean Float Yes
scalar_parent_browser_engagement_window_open_event_count_sum Integer Yes
scalar_parent_devtools_accessibility_node_inspected_count_sum Integer Yes
scalar_parent_devtools_accessibility_opened_count_sum Integer Yes
scalar_parent_devtools_accessibility_picker_used_count_sum Integer Yes
scalar_parent_devtools_accessibility_select_accessible_for_node_sum Record No
scalar_parent_devtools_accessibility_service_enabled_count_sum Integer Yes
scalar_parent_devtools_copy_full_css_selector_opened_sum Integer Yes
scalar_parent_devtools_copy_unique_css_selector_opened_sum Integer Yes
scalar_parent_devtools_toolbar_eyedropper_opened_sum Integer Yes
scalar_parent_navigator_storage_estimate_count_sum Integer Yes
scalar_parent_navigator_storage_persist_count_sum Integer Yes
scalar_parent_storage_sync_api_usage_extensions_using_sum Integer Yes
search_cohort String Yes
search_count_abouthome Integer Yes
search_count_contextmenu Integer Yes
search_count_newtab Integer Yes
search_count_searchbar Integer Yes
search_count_system Integer Yes
search_count_urlbar Integer Yes
search_count_all Integer Yes
search_count_tagged_sap Integer Yes
search_count_tagged_follow_on Integer Yes
search_count_organic Integer Yes
search_count_urlbar_handoff Integer Yes
session_restored_mean Float Yes
sessions_started_on_this_day Integer Yes
shutdown_kill_sum Integer Yes
subsession_hours_sum Numeric Yes
ssl_handshake_result_failure_sum Integer Yes
ssl_handshake_result_success_sum Integer Yes
sync_configured Boolean Yes
sync_count_desktop_mean Float Yes
sync_count_mobile_mean Float Yes
sync_count_desktop_sum Integer Yes
sync_count_mobile_sum Integer Yes
telemetry_enabled Boolean Yes
timezone_offset Integer Yes
update_auto_download Boolean Yes
update_channel String Yes
update_enabled Boolean Yes
vendor String Yes
web_notification_shown_sum Integer Yes
windows_build_number Integer Yes
windows_ubr Integer Yes
fxa_configured Boolean Yes
trackers_blocked_sum Integer Yes
submission_timestamp_min Timestamp Yes
ad_clicks_count_all Integer Yes
search_with_ads_count_all Integer Yes
scalar_parent_urlbar_impression_autofill_about_sum Integer Yes
scalar_parent_urlbar_impression_autofill_adaptive_sum Integer Yes
scalar_parent_urlbar_impression_autofill_origin_sum Integer Yes
scalar_parent_urlbar_impression_autofill_other_sum Integer Yes
scalar_parent_urlbar_impression_autofill_preloaded_sum Integer Yes
scalar_parent_urlbar_impression_autofill_url_sum Integer Yes
scalar_parent_telemetry_event_counts_sum Record No
scalar_content_telemetry_event_counts_sum Record No
scalar_parent_urlbar_searchmode_bookmarkmenu_sum Record No
scalar_parent_urlbar_searchmode_handoff_sum Record No
scalar_parent_urlbar_searchmode_keywordoffer_sum Record No
scalar_parent_urlbar_searchmode_oneoff_sum Record No
scalar_parent_urlbar_searchmode_other_sum Record No
scalar_parent_urlbar_searchmode_shortcut_sum Record No
scalar_parent_urlbar_searchmode_tabmenu_sum Record No
scalar_parent_urlbar_searchmode_tabtosearch_sum Record No
scalar_parent_urlbar_searchmode_tabtosearch_onboard_sum Record No
scalar_parent_urlbar_searchmode_topsites_newtab_sum Record No
scalar_parent_urlbar_searchmode_topsites_urlbar_sum Record No
scalar_parent_urlbar_searchmode_touchbar_sum Record No
scalar_parent_urlbar_searchmode_typed_sum Record No
scalar_parent_os_environment_is_taskbar_pinned Boolean Yes
scalar_parent_os_environment_launched_via_desktop Boolean Yes
scalar_parent_os_environment_launched_via_taskbar Boolean Yes
scalar_parent_os_environment_launched_via_other Boolean Yes
scalar_parent_os_environment_launched_via_start_menu Boolean Yes
scalar_parent_os_environment_launched_via_other_shortcut Boolean Yes
n_logged_event Integer Yes
n_created_pictureinpicture Integer Yes
n_viewed_protection_report Integer Yes
search_count_webextension Integer Yes
search_count_alias Integer Yes
search_count_urlbar_searchmode Integer Yes
scalar_parent_browser_ui_interaction_preferences_pane_home_sum Record No
scalar_parent_urlbar_picked_autofill_sum Integer Yes
scalar_parent_urlbar_picked_autofill_about_sum Integer Yes
scalar_parent_urlbar_picked_autofill_adaptive_sum Integer Yes
scalar_parent_urlbar_picked_autofill_origin_sum Integer Yes
scalar_parent_urlbar_picked_autofill_other_sum Integer Yes
scalar_parent_urlbar_picked_autofill_preloaded_sum Integer Yes
scalar_parent_urlbar_picked_autofill_url_sum Integer Yes
scalar_parent_urlbar_picked_bookmark_sum Integer Yes
scalar_parent_urlbar_picked_dynamic_sum Integer Yes
scalar_parent_urlbar_picked_extension_sum Integer Yes
scalar_parent_urlbar_picked_formhistory_sum Integer Yes
scalar_parent_urlbar_picked_history_sum Integer Yes
scalar_parent_urlbar_picked_keyword_sum Integer Yes
scalar_parent_urlbar_picked_remotetab_sum Integer Yes
scalar_parent_urlbar_picked_searchengine_sum Integer Yes
scalar_parent_urlbar_picked_searchsuggestion_sum Integer Yes
scalar_parent_urlbar_picked_switchtab_sum Integer Yes
scalar_parent_urlbar_picked_tabtosearch_sum Integer Yes
scalar_parent_urlbar_picked_tip_sum Integer Yes
scalar_parent_urlbar_picked_topsite_sum Integer Yes
scalar_parent_urlbar_picked_unknown_sum Integer Yes
scalar_parent_urlbar_picked_visiturl_sum Integer Yes
default_private_search_engine String Yes
default_private_search_engine_data_load_path String Yes
default_private_search_engine_data_name String Yes
default_private_search_engine_data_origin String Yes
default_private_search_engine_data_submission_url String Yes
search_counts Record No
user_pref_browser_search_region String Yes
search_with_ads Record No
ad_clicks Record No
search_content_urlbar_sum Record No
search_content_urlbar_handoff_sum Record No
search_content_urlbar_searchmode_sum Record No
search_content_contextmenu_sum Record No
search_content_about_home_sum Record No
search_content_about_newtab_sum Record No
search_content_searchbar_sum Record No
search_content_system_sum Record No
search_content_webextension_sum Record No
search_content_tabhistory_sum Record No
search_content_reload_sum Record No
search_content_unknown_sum Record No
search_withads_urlbar_sum Record No
search_withads_urlbar_handoff_sum Record No
search_withads_urlbar_searchmode_sum Record No
search_withads_contextmenu_sum Record No
search_withads_about_home_sum Record No
search_withads_about_newtab_sum Record No
search_withads_searchbar_sum Record No
search_withads_system_sum Record No
search_withads_webextension_sum Record No
search_withads_tabhistory_sum Record No
search_withads_reload_sum Record No
search_withads_unknown_sum Record No
search_adclicks_urlbar_sum Record No
search_adclicks_urlbar_handoff_sum Record No
search_adclicks_urlbar_searchmode_sum Record No
search_adclicks_contextmenu_sum Record No
search_adclicks_about_home_sum Record No
search_adclicks_about_newtab_sum Record No
search_adclicks_searchbar_sum Record No
search_adclicks_system_sum Record No
search_adclicks_webextension_sum Record No
search_adclicks_tabhistory_sum Record No
search_adclicks_reload_sum Record No
search_adclicks_unknown_sum Record No
update_background Boolean Yes
user_pref_browser_search_suggest_enabled String Yes
user_pref_browser_widget_in_navbar String Yes
user_pref_browser_urlbar_suggest_searches String Yes
user_pref_browser_urlbar_show_search_suggestions_first String Yes
user_pref_browser_urlbar_suggest_quicksuggest String Yes
user_pref_browser_urlbar_suggest_quicksuggest_sponsored String Yes
first_seen_date Date Yes
second_seen_date Date Yes
user_pref_browser_urlbar_quicksuggest_onboarding_dialog_choice String Yes
scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum Integer Yes
user_pref_browser_newtabpage_enabled String Yes
user_pref_app_shield_optoutstudies_enabled String Yes
contextual_services_quicksuggest_click_sum Record No
contextual_services_quicksuggest_impression_sum Record No
contextual_services_quicksuggest_help_sum Record No
contextual_services_topsites_click_sum Integer Yes
contextual_services_topsites_impression_sum Integer Yes
user_pref_browser_urlbar_suggest_quicksuggest_nonsponsored String Yes
user_pref_browser_urlbar_quicksuggest_data_collection_enabled String Yes
scalar_a11y_hcm_foreground Integer Yes
scalar_a11y_hcm_background Integer Yes
a11y_theme Record No
contextual_services_quicksuggest_help_nonsponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_help_sponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_block_nonsponsored_sum Integer Yes
contextual_services_quicksuggest_block_sponsored_sum Integer Yes
contextual_services_quicksuggest_block_sponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_block_nonsponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_click_sponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_click_nonsponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_impression_sponsored_bestmatch_sum Integer Yes
contextual_services_quicksuggest_impression_nonsponsored_bestmatch_sum Integer Yes
user_pref_browser_urlbar_suggest_bestmatch String Yes
scalar_parent_browser_ui_interaction_textrecognition_error_sum Integer Yes
text_recognition_interaction_timing_sum Integer Yes
text_recognition_interaction_timing_count_sum Integer Yes
scalar_parent_browser_ui_interaction_content_context_sum Record No
text_recognition_api_performance_sum Integer Yes
text_recognition_api_performance_count_sum Integer Yes
text_recognition_text_length_sum Integer Yes
text_recognition_text_length_count_sum Integer Yes
scalar_parent_os_environment_launched_via_taskbar_private Boolean Yes
dom_parentprocess_private_window_used Boolean Yes
os_environment_is_taskbar_pinned_any Boolean Yes
os_environment_is_taskbar_pinned_private_any Boolean Yes
os_environment_is_taskbar_pinned_private Boolean Yes
bookmark_migrations_quantity_chrome Integer Yes
bookmark_migrations_quantity_edge Integer Yes
bookmark_migrations_quantity_safari Integer Yes
bookmark_migrations_quantity_all Integer Yes
history_migrations_quantity_chrome Integer Yes
history_migrations_quantity_edge Integer Yes
history_migrations_quantity_safari Integer Yes
history_migrations_quantity_all Integer Yes
logins_migrations_quantity_chrome Integer Yes
logins_migrations_quantity_edge Integer Yes
logins_migrations_quantity_safari Integer Yes
logins_migrations_quantity_all Integer Yes
main_crash_count Integer Yes
content_crash_count Integer Yes
gpu_crash_count Integer Yes
rdd_crash_count Integer Yes
socket_crash_count Integer Yes
utility_crash_count Integer Yes
vr_crash_count Integer Yes
search_count_urlbar_persisted Integer Yes
search_content_urlbar_persisted_sum Record No
search_withads_urlbar_persisted_sum Record No
search_adclicks_urlbar_persisted_sum Record No
media_play_time_ms_audio_sum Integer Yes
media_play_time_ms_video_sum Integer Yes
contextual_services_quicksuggest_block_dynamic_wikipedia_sum Integer Yes
contextual_services_quicksuggest_block_weather_sum Integer Yes
contextual_services_quicksuggest_click_dynamic_wikipedia_sum Integer Yes
contextual_services_quicksuggest_click_nonsponsored_sum Integer Yes
contextual_services_quicksuggest_click_sponsored_sum Integer Yes
contextual_services_quicksuggest_click_weather_sum Integer Yes
contextual_services_quicksuggest_help_dynamic_wikipedia_sum Integer Yes
contextual_services_quicksuggest_help_nonsponsored_sum Integer Yes
contextual_services_quicksuggest_help_sponsored_sum Integer Yes
contextual_services_quicksuggest_help_weather_sum Integer Yes
contextual_services_quicksuggest_impression_dynamic_wikipedia_sum Integer Yes
contextual_services_quicksuggest_impression_nonsponsored_sum Integer Yes
contextual_services_quicksuggest_impression_sponsored_sum Integer Yes
contextual_services_quicksuggest_impression_weather_sum Integer Yes
scalar_parent_sidebar_opened_sum Record No
scalar_parent_sidebar_search_sum Record No
scalar_parent_sidebar_link_sum Record No
places_searchbar_cumulative_searches_sum Integer Yes
places_searchbar_cumulative_filter_count_sum Integer Yes
places_previousday_visits_mean Float Yes
places_library_cumulative_bookmark_searches_sum Integer Yes
places_library_cumulative_history_searches_sum Integer Yes
places_bookmarks_searchbar_cumulative_searches_sum Integer Yes
scalar_parent_library_link_sum Record No
scalar_parent_library_opened_sum Record No
scalar_parent_library_search_sum Record No
startup_profile_selection_reason_first String Yes
first_document_id String Yes
partner_id String Yes
distribution_version String Yes
distributor String Yes
distributor_channel String Yes
env_build_platform_version String Yes
env_build_xpcom_abi String Yes
geo_db_version String Yes
apple_model_id String Yes
max_subsession_counter Integer Yes
min_subsession_counter Integer Yes
startup_profile_selection_first_ping_only String Yes
browser_version_info Record Yes
total_uri_count Integer Yes
total_uri_count_normal_mode Integer Yes
total_uri_count_private_mode Integer Yes
has_adblocker_enabled Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_daily_joined_v1

Source Directory | View Definition | Metadata File


clients_first_seen

Clients First Seen

telemetry.clients_first_seen

Identical in schema to clients_daily except that each client appears only once over all time; includes fields first_seen_date and second_seen_date for determining user "activation".

Note that first_seen_date and second_seen_date are also pulled into clients_last_seen to avoid needing to join with this view. Use this view directly only when you're investigating client activation questions.

Clustering fields: normalized_channel, sample_id

See also: clients_daily, clients_last_seen

Schema
Column Description Type Nullable
first_seen_date Date Yes
second_seen_date Date Yes
client_id String Yes
aborts_content_sum Integer Yes
aborts_gmplugin_sum Integer Yes
aborts_plugin_sum Integer Yes
active_addons_count_mean Float Yes
active_addons Record No
active_experiment_branch String Yes
active_experiment_id String Yes
active_hours_sum Float Yes
addon_compatibility_check_enabled Boolean Yes
app_build_id String Yes
app_display_version String Yes
app_name String Yes
app_version String Yes
attribution Record Yes
blocklist_enabled Boolean Yes
channel String Yes
client_clock_skew_mean Float Yes
client_submission_latency_mean Float Yes
cpu_cores Integer Yes
cpu_count Integer Yes
cpu_family Integer Yes
cpu_l2_cache_kb Integer Yes
cpu_l3_cache_kb Integer Yes
cpu_model Integer Yes
cpu_speed_mhz Integer Yes
cpu_stepping Integer Yes
cpu_vendor String Yes
crashes_detected_content_sum Integer Yes
crashes_detected_gmplugin_sum Integer Yes
crashes_detected_plugin_sum Integer Yes
crash_submit_attempt_content_sum Integer Yes
crash_submit_attempt_main_sum Integer Yes
crash_submit_attempt_plugin_sum Integer Yes
crash_submit_success_content_sum Integer Yes
crash_submit_success_main_sum Integer Yes
crash_submit_success_plugin_sum Integer Yes
default_search_engine String Yes
default_search_engine_data_load_path String Yes
default_search_engine_data_name String Yes
default_search_engine_data_origin String Yes
default_search_engine_data_submission_url String Yes
devtools_toolbox_opened_count_sum Integer Yes
distribution_id String Yes
e10s_enabled Boolean Yes
env_build_arch String Yes
env_build_id String Yes
env_build_version String Yes
environment_settings_intl_accept_languages String No
environment_settings_intl_app_locales String No
environment_settings_intl_available_locales String No
environment_settings_intl_requested_locales String No
environment_settings_intl_system_locales String No
environment_settings_intl_regional_prefs_locales String No
experiments Record No
first_paint_mean Float Yes
flash_version String Yes
country String Yes
city String Yes
geo_subdivision1 String Yes
geo_subdivision2 String Yes
isp_name String Yes
isp_organization String Yes
gfx_features_advanced_layers_status String Yes
gfx_features_d2d_status String Yes
gfx_features_d3d11_status String Yes
gfx_features_gpu_process_status String Yes
histogram_parent_devtools_aboutdebugging_opened_count_sum Integer Yes
histogram_parent_devtools_animationinspector_opened_count_sum Integer Yes
histogram_parent_devtools_browserconsole_opened_count_sum Integer Yes
histogram_parent_devtools_canvasdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_computedview_opened_count_sum Integer Yes
histogram_parent_devtools_custom_opened_count_sum Integer Yes
histogram_parent_devtools_developertoolbar_opened_count_sum Integer Yes
histogram_parent_devtools_dom_opened_count_sum Integer Yes
histogram_parent_devtools_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_fontinspector_opened_count_sum Integer Yes
histogram_parent_devtools_inspector_opened_count_sum Integer Yes
histogram_parent_devtools_jsbrowserdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_jsdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_jsprofiler_opened_count_sum Integer Yes
histogram_parent_devtools_layoutview_opened_count_sum Integer Yes
histogram_parent_devtools_memory_opened_count_sum Integer Yes
histogram_parent_devtools_menu_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_netmonitor_opened_count_sum Integer Yes
histogram_parent_devtools_options_opened_count_sum Integer Yes
histogram_parent_devtools_paintflashing_opened_count_sum Integer Yes
histogram_parent_devtools_picker_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_responsive_opened_count_sum Integer Yes
histogram_parent_devtools_ruleview_opened_count_sum Integer Yes
histogram_parent_devtools_scratchpad_opened_count_sum Integer Yes
histogram_parent_devtools_scratchpad_window_opened_count_sum Integer Yes
histogram_parent_devtools_shadereditor_opened_count_sum Integer Yes
histogram_parent_devtools_storage_opened_count_sum Integer Yes
histogram_parent_devtools_styleeditor_opened_count_sum Integer Yes
histogram_parent_devtools_webaudioeditor_opened_count_sum Integer Yes
histogram_parent_devtools_webconsole_opened_count_sum Integer Yes
histogram_parent_devtools_webide_opened_count_sum Integer Yes
install_year Integer Yes
is_default_browser Boolean Yes
is_wow64 Boolean Yes
locale String Yes
memory_mb Integer Yes
normalized_channel String Yes
normalized_os_version String Yes
os String Yes
os_service_pack_major Integer Yes
os_service_pack_minor Integer Yes
os_version String Yes
pings_aggregated_by_this_row Integer Yes
places_bookmarks_count_mean Float Yes
places_pages_count_mean Float Yes
plugin_hangs_sum Integer Yes
plugins_infobar_allow_sum Integer Yes
plugins_infobar_block_sum Integer Yes
plugins_infobar_shown_sum Integer Yes
plugins_notification_shown_sum Integer Yes
previous_build_id String Yes
profile_age_in_days Integer Yes
profile_creation_date String Yes
push_api_notify_sum Integer Yes
sample_id Integer Yes
sandbox_effective_content_process_level Integer Yes
scalar_combined_webrtc_nicer_stun_retransmits_sum Integer Yes
scalar_combined_webrtc_nicer_turn_401s_sum Integer Yes
scalar_combined_webrtc_nicer_turn_403s_sum Integer Yes
scalar_combined_webrtc_nicer_turn_438s_sum Integer Yes
scalar_content_navigator_storage_estimate_count_sum Integer Yes
scalar_content_navigator_storage_persist_count_sum Integer Yes
scalar_parent_aushelper_websense_reg_version String Yes
scalar_parent_browser_engagement_max_concurrent_tab_count_max Integer Yes
scalar_parent_browser_engagement_max_concurrent_window_count_max Integer Yes
scalar_parent_browser_engagement_tab_open_event_count_sum Integer Yes
scalar_parent_browser_engagement_total_uri_count_sum Integer Yes
scalar_parent_browser_engagement_unfiltered_uri_count_sum Integer Yes
scalar_parent_browser_engagement_unique_domains_count_max Integer Yes
scalar_parent_browser_engagement_unique_domains_count_mean Float Yes
scalar_parent_browser_engagement_window_open_event_count_sum Integer Yes
scalar_parent_devtools_accessibility_node_inspected_count_sum Integer Yes
scalar_parent_devtools_accessibility_opened_count_sum Integer Yes
scalar_parent_devtools_accessibility_picker_used_count_sum Integer Yes
scalar_parent_devtools_accessibility_select_accessible_for_node_sum Record No
scalar_parent_devtools_accessibility_service_enabled_count_sum Integer Yes
scalar_parent_devtools_copy_full_css_selector_opened_sum Integer Yes
scalar_parent_devtools_copy_unique_css_selector_opened_sum Integer Yes
scalar_parent_devtools_toolbar_eyedropper_opened_sum Integer Yes
scalar_parent_dom_contentprocess_troubled_due_to_memory_sum Integer Yes
scalar_parent_navigator_storage_estimate_count_sum Integer Yes
scalar_parent_navigator_storage_persist_count_sum Integer Yes
scalar_parent_storage_sync_api_usage_extensions_using_sum Integer Yes
search_cohort String Yes
search_count_abouthome Integer Yes
search_count_contextmenu Integer Yes
search_count_newtab Integer Yes
search_count_searchbar Integer Yes
search_count_system Integer Yes
search_count_urlbar Integer Yes
search_count_all Integer Yes
search_count_tagged_sap Integer Yes
search_count_tagged_follow_on Integer Yes
search_count_organic Integer Yes
search_count_urlbar_handoff Integer Yes
session_restored_mean Float Yes
sessions_started_on_this_day Integer Yes
shutdown_kill_sum Integer Yes
subsession_hours_sum Numeric Yes
ssl_handshake_result_failure_sum Integer Yes
ssl_handshake_result_success_sum Integer Yes
sync_configured Boolean Yes
sync_count_desktop_mean Float Yes
sync_count_mobile_mean Float Yes
sync_count_desktop_sum Integer Yes
sync_count_mobile_sum Integer Yes
telemetry_enabled Boolean Yes
timezone_offset Integer Yes
total_hours_sum Numeric Yes
update_auto_download Boolean Yes
update_channel String Yes
update_enabled Boolean Yes
vendor String Yes
web_notification_shown_sum Integer Yes
windows_build_number Integer Yes
windows_ubr Integer Yes
fxa_configured Boolean Yes
trackers_blocked_sum Integer Yes
submission_timestamp_min Timestamp Yes
ad_clicks_count_all Integer Yes
search_with_ads_count_all Integer Yes
scalar_parent_urlbar_impression_autofill_about_sum Integer Yes
scalar_parent_urlbar_impression_autofill_adaptive_sum Integer Yes
scalar_parent_urlbar_impression_autofill_origin_sum Integer Yes
scalar_parent_urlbar_impression_autofill_other_sum Integer Yes
scalar_parent_urlbar_impression_autofill_preloaded_sum Integer Yes
scalar_parent_urlbar_impression_autofill_url_sum Integer Yes
scalar_parent_telemetry_event_counts_sum Record No
scalar_content_telemetry_event_counts_sum Record No
scalar_parent_urlbar_searchmode_bookmarkmenu_sum Record No
scalar_parent_urlbar_searchmode_handoff_sum Record No
scalar_parent_urlbar_searchmode_keywordoffer_sum Record No
scalar_parent_urlbar_searchmode_oneoff_sum Record No
scalar_parent_urlbar_searchmode_other_sum Record No
scalar_parent_urlbar_searchmode_shortcut_sum Record No
scalar_parent_urlbar_searchmode_tabmenu_sum Record No
scalar_parent_urlbar_searchmode_tabtosearch_sum Record No
scalar_parent_urlbar_searchmode_tabtosearch_onboard_sum Record No
scalar_parent_urlbar_searchmode_topsites_newtab_sum Record No
scalar_parent_urlbar_searchmode_topsites_urlbar_sum Record No
scalar_parent_urlbar_searchmode_touchbar_sum Record No
scalar_parent_urlbar_searchmode_typed_sum Record No
scalar_parent_os_environment_is_taskbar_pinned Boolean Yes
scalar_parent_os_environment_launched_via_desktop Boolean Yes
scalar_parent_os_environment_launched_via_taskbar Boolean Yes
scalar_parent_os_environment_launched_via_other Boolean Yes
scalar_parent_os_environment_launched_via_start_menu Boolean Yes
scalar_parent_os_environment_launched_via_other_shortcut Boolean Yes
search_count_webextension Integer Yes
search_count_alias Integer Yes
search_count_urlbar_searchmode Integer Yes
scalar_parent_browser_ui_interaction_preferences_pane_home_sum Record No
scalar_parent_urlbar_picked_autofill_sum Record No
scalar_parent_urlbar_picked_autofill_about_sum Record No
scalar_parent_urlbar_picked_autofill_adaptive_sum Record No
scalar_parent_urlbar_picked_autofill_origin_sum Record No
scalar_parent_urlbar_picked_autofill_other_sum Record No
scalar_parent_urlbar_picked_autofill_preloaded_sum Record No
scalar_parent_urlbar_picked_autofill_url_sum Record No
scalar_parent_urlbar_picked_bookmark_sum Record No
scalar_parent_urlbar_picked_dynamic_sum Record No
scalar_parent_urlbar_picked_extension_sum Record No
scalar_parent_urlbar_picked_formhistory_sum Record No
scalar_parent_urlbar_picked_history_sum Record No
scalar_parent_urlbar_picked_keyword_sum Record No
scalar_parent_urlbar_picked_remotetab_sum Record No
scalar_parent_urlbar_picked_searchengine_sum Record No
scalar_parent_urlbar_picked_searchsuggestion_sum Record No
scalar_parent_urlbar_picked_switchtab_sum Record No
scalar_parent_urlbar_picked_tabtosearch_sum Record No
scalar_parent_urlbar_picked_tip_sum Record No
scalar_parent_urlbar_picked_topsite_sum Record No
scalar_parent_urlbar_picked_unknown_sum Record No
scalar_parent_urlbar_picked_visiturl_sum Record No
default_private_search_engine String Yes
default_private_search_engine_data_load_path String Yes
default_private_search_engine_data_name String Yes
default_private_search_engine_data_origin String Yes
default_private_search_engine_data_submission_url String Yes
search_counts Record No
user_pref_browser_search_region String Yes
search_with_ads Record No
ad_clicks Record No
search_content_urlbar_sum Record No
search_content_urlbar_handoff_sum Record No
search_content_urlbar_searchmode_sum Record No
search_content_contextmenu_sum Record No
search_content_about_home_sum Record No
search_content_about_newtab_sum Record No
search_content_searchbar_sum Record No
search_content_system_sum Record No
search_content_webextension_sum Record No
search_content_tabhistory_sum Record No
search_content_reload_sum Record No
search_content_unknown_sum Record No
search_withads_urlbar_sum Record No
search_withads_urlbar_handoff_sum Record No
search_withads_urlbar_searchmode_sum Record No
search_withads_contextmenu_sum Record No
search_withads_about_home_sum Record No
search_withads_about_newtab_sum Record No
search_withads_searchbar_sum Record No
search_withads_system_sum Record No
search_withads_webextension_sum Record No
search_withads_tabhistory_sum Record No
search_withads_reload_sum Record No
search_withads_unknown_sum Record No
search_adclicks_urlbar_sum Record No
search_adclicks_urlbar_handoff_sum Record No
search_adclicks_urlbar_searchmode_sum Record No
search_adclicks_contextmenu_sum Record No
search_adclicks_about_home_sum Record No
search_adclicks_about_newtab_sum Record No
search_adclicks_searchbar_sum Record No
search_adclicks_system_sum Record No
search_adclicks_webextension_sum Record No
search_adclicks_tabhistory_sum Record No
search_adclicks_reload_sum Record No
search_adclicks_unknown_sum Record No
update_background Boolean Yes
user_pref_browser_search_suggest_enabled String Yes
user_pref_browser_widget_in_navbar String Yes
user_pref_browser_urlbar_suggest_searches String Yes
user_pref_browser_urlbar_show_search_suggestions_first String Yes
user_pref_browser_urlbar_suggest_quicksuggest String Yes
user_pref_browser_urlbar_suggest_quicksuggest_sponsored String Yes
user_pref_browser_urlbar_quicksuggest_onboarding_dialog_choice String Yes
scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum Integer Yes
user_pref_browser_newtabpage_enabled String Yes
user_pref_app_shield_optoutstudies_enabled String Yes
contextual_services_quicksuggest_click_sum Record No
contextual_services_quicksuggest_impression_sum Record No
contextual_services_quicksuggest_help_sum Record No
contextual_services_topsites_click_sum Record No
contextual_services_topsites_impression_sum Record No
user_pref_browser_urlbar_suggest_quicksuggest_nonsponsored String Yes
user_pref_browser_urlbar_quicksuggest_data_collection_enabled String Yes
scalar_a11y_hcm_foreground Integer Yes
scalar_a11y_hcm_background Integer Yes
a11y_theme Record No
contextual_services_quicksuggest_help_nonsponsored_bestmatch_sum Record No
contextual_services_quicksuggest_help_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_block_nonsponsored_sum Record No
contextual_services_quicksuggest_block_sponsored_sum Record No
contextual_services_quicksuggest_block_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_block_nonsponsored_bestmatch_sum Record No
contextual_services_quicksuggest_click_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_click_nonsponsored_bestmatch_sum Record No
contextual_services_quicksuggest_impression_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_impression_nonsponsored_bestmatch_sum Record No
user_pref_browser_urlbar_suggest_bestmatch String Yes
scalar_parent_browser_ui_interaction_textrecognition_error_sum Integer Yes
text_recognition_interaction_timing_sum Integer Yes
text_recognition_interaction_timing_count_sum Integer Yes
scalar_parent_browser_ui_interaction_content_context_sum Record No
text_recognition_api_performance_sum Integer Yes
text_recognition_api_performance_count_sum Integer Yes
text_recognition_text_length_sum Integer Yes
text_recognition_text_length_count_sum Integer Yes
scalar_parent_os_environment_launched_via_taskbar_private Boolean Yes
dom_parentprocess_private_window_used Boolean Yes
os_environment_is_taskbar_pinned_any Boolean Yes
os_environment_is_taskbar_pinned_private_any Boolean Yes
os_environment_is_taskbar_pinned_private Boolean Yes
bookmark_migrations_quantity_chrome Integer Yes
bookmark_migrations_quantity_edge Integer Yes
bookmark_migrations_quantity_safari Integer Yes
bookmark_migrations_quantity_all Integer Yes
history_migrations_quantity_chrome Integer Yes
history_migrations_quantity_edge Integer Yes
history_migrations_quantity_safari Integer Yes
history_migrations_quantity_all Integer Yes
logins_migrations_quantity_chrome Integer Yes
logins_migrations_quantity_edge Integer Yes
logins_migrations_quantity_safari Integer Yes
logins_migrations_quantity_all Integer Yes
search_count_urlbar_persisted Integer Yes
search_content_urlbar_persisted_sum Record No
search_withads_urlbar_persisted_sum Record No
search_adclicks_urlbar_persisted_sum Record No
media_play_time_ms_audio_sum Integer Yes
media_play_time_ms_video_sum Integer Yes
contextual_services_quicksuggest_block_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_block_weather_sum Record No
contextual_services_quicksuggest_click_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_click_nonsponsored_sum Record No
contextual_services_quicksuggest_click_sponsored_sum Record No
contextual_services_quicksuggest_click_weather_sum Record No
contextual_services_quicksuggest_help_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_help_nonsponsored_sum Record No
contextual_services_quicksuggest_help_sponsored_sum Record No
contextual_services_quicksuggest_help_weather_sum Record No
contextual_services_quicksuggest_impression_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_impression_nonsponsored_sum Record No
contextual_services_quicksuggest_impression_sponsored_sum Record No
contextual_services_quicksuggest_impression_weather_sum Record No
places_searchbar_cumulative_searches_sum Integer Yes
places_searchbar_cumulative_filter_count_sum Integer Yes
scalar_parent_sidebar_opened_sum Record No
scalar_parent_sidebar_search_sum Record No
scalar_parent_sidebar_link_sum Record No
places_previousday_visits_mean Float Yes
places_library_cumulative_bookmark_searches_sum Integer Yes
places_library_cumulative_history_searches_sum Integer Yes
places_bookmarks_searchbar_cumulative_searches_sum Integer Yes
scalar_parent_library_link_sum Record No
scalar_parent_library_opened_sum Record No
scalar_parent_library_search_sum Record No
startup_profile_selection_reason_first String Yes
first_document_id String Yes
partner_id String Yes
distribution_version String Yes
distributor String Yes
distributor_channel String Yes
env_build_platform_version String Yes
env_build_xpcom_abi String Yes
geo_db_version String Yes
apple_model_id String Yes
max_subsession_counter Integer Yes
min_subsession_counter Integer Yes
startup_profile_selection_first_ping_only String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_first_seen_v1

Source Directory | View Definition | Metadata File


clients_first_seen_28_days_later

Clients First Seen 28 Days Later

telemetry.clients_first_seen_28_days_later

Please provide a description for the query

Schema
Column Description Type Nullable
client_id String Yes
sample_id Integer Yes
first_seen_date Date Yes
submission_date Date Yes
country_code String Yes
channel String Yes
build_id String Yes
os String Yes
os_version Numeric Yes
distribution_id String Yes
attribution_source String Yes
attribution_ua String Yes
attribution_medium String Yes
attribution_campaign String Yes
attribution_content String Yes
attribution_experiment String Yes
attribution_dltoken String Yes
attribution_dlsource String Yes
activated Whether the profile sent a main ping in at least 5 of their first 7 days. Boolean Yes
returned_second_day Whether the profile sent a main ping on any day after their first day during their first 28 days. Boolean Yes
qualified_second_day Whether the profile qualified as DAU on any day after their first day during their first 28 days. Boolean Yes
retained_week4 Whether the profile sent a main ping on any day in their 4th week. Boolean Yes
qualified_week4 Whether the profile qualified as DAU on any day in their 4th week. Boolean Yes
days_seen_bits Integer Yes
days_visited_1_uri_bits Integer Yes
days_interacted_bits Integer Yes
startup_profile_selection_reason How the profile was selected during startup, as reported by the first ping received. String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_first_seen_28_days_later_v1

Source Directory | View Definition | Metadata File


clients_histogram_aggregates

Clients Histogram Aggregates

telemetry.clients_histogram_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_histogram_aggregates_v1

Source Directory | View Definition | Metadata File


clients_last_seen

Clients Last Seen

telemetry.clients_last_seen

Captures history of activity of each client in 28 day windows for each submission date.

There will be one row per client per submission_date. A given client will stop appearing for new dates if they do not send a main ping for 28 days.

Generally, this is a direct product of clients_daily and serves to make certain query patterns more efficient by eliminating the need for self-joins that would otherwise be needed to consider windows of activity. As an exception, it pulls in first_seen_date and second_seen_date over all time from clients_first_seen since first_seen_date is highly valuable for providing a stable definition of when a profile was created.

See the Working with Bit Patterns in Clients Last Seen article on docs.telemetry.mozilla.org for more detailed notes on usage.

Clustering fields: normalized_channel, sample_id

See also: clients_daily, clients_first_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_last_seen_v1

Source Directory | View Definition | Metadata File


clients_last_seen_v1

Clients Last Seen V1

telemetry.clients_last_seen_v1

Please provide a description for the query

Schema
Column Description Type Nullable
is_regular_user_v3 Boolean Yes
is_new_or_resurrected_v3 Boolean Yes
is_weekday_regular_v1 Boolean Yes
is_allweek_regular_v1 Boolean Yes
is_core_active_v1 Boolean Yes
activity_segments_v1 String Yes
new_profile_7_day_activated_v1 Boolean Yes
new_profile_14_day_activated_v1 Boolean Yes
new_profile_21_day_activated_v1 Boolean Yes
first_run_date Date Yes
days_since_first_seen Integer Yes
days_since_second_seen Integer Yes
days_since_seen Integer Yes
days_since_visited_1_uri Integer Yes
days_since_visited_5_uri Integer Yes
days_since_visited_10_uri Integer Yes
days_since_had_8_active_ticks Integer Yes
days_since_opened_dev_tools Integer Yes
days_since_created_profile Integer Yes
days_since_interacted Integer Yes
days_since_qualified_use_v1 Integer Yes
days_since_visited_1_uri_normal_mode Integer Yes
days_since_visited_1_uri_private_mode Integer Yes
submission_date Date Yes
first_seen_date Date Yes
second_seen_date Date Yes
days_seen_bits Integer Yes
days_visited_1_uri_bits Integer Yes
days_visited_5_uri_bits Integer Yes
days_visited_10_uri_bits Integer Yes
days_had_8_active_ticks_bits Integer Yes
days_opened_dev_tools_bits Integer Yes
days_interacted_bits Integer Yes
days_visited_1_uri_normal_mode_bits Integer Yes
days_visited_1_uri_private_mode_bits Integer Yes
days_created_profile_bits Integer Yes
days_seen_in_experiment Record No
client_id String Yes
aborts_content_sum Integer Yes
aborts_gmplugin_sum Integer Yes
aborts_plugin_sum Integer Yes
active_addons_count_mean Float Yes
active_addons Record No
active_hours_sum Float Yes
addon_compatibility_check_enabled Boolean Yes
app_build_id String Yes
app_display_version String Yes
app_name String Yes
app_version String Yes
attribution Record Yes
blocklist_enabled Boolean Yes
channel String Yes
client_clock_skew_mean Float Yes
client_submission_latency_mean Float Yes
cpu_cores Integer Yes
cpu_count Integer Yes
cpu_family Integer Yes
cpu_l2_cache_kb Integer Yes
cpu_l3_cache_kb Integer Yes
cpu_model Integer Yes
cpu_speed_mhz Integer Yes
cpu_stepping Integer Yes
cpu_vendor String Yes
crashes_detected_content_sum Integer Yes
crashes_detected_gmplugin_sum Integer Yes
crashes_detected_plugin_sum Integer Yes
crash_submit_attempt_content_sum Integer Yes
crash_submit_attempt_main_sum Integer Yes
crash_submit_attempt_plugin_sum Integer Yes
crash_submit_success_content_sum Integer Yes
crash_submit_success_main_sum Integer Yes
crash_submit_success_plugin_sum Integer Yes
default_search_engine String Yes
default_search_engine_data_load_path String Yes
default_search_engine_data_name String Yes
default_search_engine_data_origin String Yes
default_search_engine_data_submission_url String Yes
devtools_toolbox_opened_count_sum Integer Yes
distribution_id String Yes
e10s_enabled Boolean Yes
env_build_arch String Yes
env_build_id String Yes
env_build_version String Yes
environment_settings_intl_accept_languages String No
environment_settings_intl_app_locales String No
environment_settings_intl_available_locales String No
environment_settings_intl_requested_locales String No
environment_settings_intl_system_locales String No
environment_settings_intl_regional_prefs_locales String No
experiments Record No
first_paint_mean Float Yes
flash_version String Yes
country String Yes
city String Yes
geo_subdivision1 String Yes
geo_subdivision2 String Yes
isp_name String Yes
isp_organization String Yes
gfx_features_advanced_layers_status String Yes
gfx_features_d2d_status String Yes
gfx_features_d3d11_status String Yes
gfx_features_gpu_process_status String Yes
histogram_parent_devtools_aboutdebugging_opened_count_sum Integer Yes
histogram_parent_devtools_animationinspector_opened_count_sum Integer Yes
histogram_parent_devtools_browserconsole_opened_count_sum Integer Yes
histogram_parent_devtools_canvasdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_computedview_opened_count_sum Integer Yes
histogram_parent_devtools_custom_opened_count_sum Integer Yes
histogram_parent_devtools_dom_opened_count_sum Integer Yes
histogram_parent_devtools_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_fontinspector_opened_count_sum Integer Yes
histogram_parent_devtools_inspector_opened_count_sum Integer Yes
histogram_parent_devtools_jsbrowserdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_jsdebugger_opened_count_sum Integer Yes
histogram_parent_devtools_jsprofiler_opened_count_sum Integer Yes
histogram_parent_devtools_layoutview_opened_count_sum Integer Yes
histogram_parent_devtools_memory_opened_count_sum Integer Yes
histogram_parent_devtools_menu_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_netmonitor_opened_count_sum Integer Yes
histogram_parent_devtools_options_opened_count_sum Integer Yes
histogram_parent_devtools_paintflashing_opened_count_sum Integer Yes
histogram_parent_devtools_picker_eyedropper_opened_count_sum Integer Yes
histogram_parent_devtools_responsive_opened_count_sum Integer Yes
histogram_parent_devtools_ruleview_opened_count_sum Integer Yes
histogram_parent_devtools_scratchpad_opened_count_sum Integer Yes
histogram_parent_devtools_scratchpad_window_opened_count_sum Integer Yes
histogram_parent_devtools_shadereditor_opened_count_sum Integer Yes
histogram_parent_devtools_storage_opened_count_sum Integer Yes
histogram_parent_devtools_styleeditor_opened_count_sum Integer Yes
histogram_parent_devtools_webaudioeditor_opened_count_sum Integer Yes
histogram_parent_devtools_webconsole_opened_count_sum Integer Yes
histogram_parent_devtools_webide_opened_count_sum Integer Yes
install_year Integer Yes
is_default_browser Boolean Yes
is_wow64 Boolean Yes
locale String Yes
memory_mb Integer Yes
normalized_channel String Yes
normalized_os_version String Yes
os String Yes
os_service_pack_major Integer Yes
os_service_pack_minor Integer Yes
os_version String Yes
pings_aggregated_by_this_row Integer Yes
places_bookmarks_count_mean Float Yes
places_pages_count_mean Float Yes
plugin_hangs_sum Integer Yes
plugins_infobar_allow_sum Integer Yes
plugins_infobar_block_sum Integer Yes
plugins_infobar_shown_sum Integer Yes
plugins_notification_shown_sum Integer Yes
previous_build_id String Yes
profile_age_in_days Integer Yes
profile_creation_date String Yes
push_api_notify_sum Integer Yes
sample_id Integer Yes
sandbox_effective_content_process_level Integer Yes
scalar_combined_webrtc_nicer_stun_retransmits_sum Integer Yes
scalar_combined_webrtc_nicer_turn_401s_sum Integer Yes
scalar_combined_webrtc_nicer_turn_403s_sum Integer Yes
scalar_combined_webrtc_nicer_turn_438s_sum Integer Yes
scalar_content_navigator_storage_estimate_count_sum Integer Yes
scalar_content_navigator_storage_persist_count_sum Integer Yes
scalar_parent_aushelper_websense_reg_version String Yes
scalar_parent_browser_engagement_max_concurrent_tab_count_max Integer Yes
scalar_parent_browser_engagement_max_concurrent_window_count_max Integer Yes
scalar_parent_browser_engagement_tab_open_event_count_sum Integer Yes
scalar_parent_browser_engagement_total_uri_count_sum Integer Yes
scalar_parent_browser_engagement_unfiltered_uri_count_sum Integer Yes
scalar_parent_browser_engagement_unique_domains_count_max Integer Yes
scalar_parent_browser_engagement_unique_domains_count_mean Float Yes
scalar_parent_browser_engagement_window_open_event_count_sum Integer Yes
scalar_parent_devtools_accessibility_node_inspected_count_sum Integer Yes
scalar_parent_devtools_accessibility_opened_count_sum Integer Yes
scalar_parent_devtools_accessibility_picker_used_count_sum Integer Yes
scalar_parent_devtools_accessibility_select_accessible_for_node_sum Record No
scalar_parent_devtools_accessibility_service_enabled_count_sum Integer Yes
scalar_parent_devtools_copy_full_css_selector_opened_sum Integer Yes
scalar_parent_devtools_copy_unique_css_selector_opened_sum Integer Yes
scalar_parent_devtools_toolbar_eyedropper_opened_sum Integer Yes
scalar_parent_navigator_storage_estimate_count_sum Integer Yes
scalar_parent_navigator_storage_persist_count_sum Integer Yes
scalar_parent_storage_sync_api_usage_extensions_using_sum Integer Yes
search_cohort String Yes
search_count_abouthome Integer Yes
search_count_contextmenu Integer Yes
search_count_newtab Integer Yes
search_count_searchbar Integer Yes
search_count_system Integer Yes
search_count_urlbar Integer Yes
search_count_all Integer Yes
search_count_tagged_sap Integer Yes
search_count_tagged_follow_on Integer Yes
search_count_organic Integer Yes
search_count_urlbar_handoff Integer Yes
session_restored_mean Float Yes
sessions_started_on_this_day Integer Yes
shutdown_kill_sum Integer Yes
subsession_hours_sum Numeric Yes
ssl_handshake_result_failure_sum Integer Yes
ssl_handshake_result_success_sum Integer Yes
sync_configured Boolean Yes
sync_count_desktop_mean Float Yes
sync_count_mobile_mean Float Yes
sync_count_desktop_sum Integer Yes
sync_count_mobile_sum Integer Yes
telemetry_enabled Boolean Yes
timezone_offset Integer Yes
update_auto_download Boolean Yes
update_channel String Yes
update_enabled Boolean Yes
vendor String Yes
web_notification_shown_sum Integer Yes
windows_build_number Integer Yes
windows_ubr Integer Yes
fxa_configured Boolean Yes
trackers_blocked_sum Integer Yes
submission_timestamp_min Timestamp Yes
ad_clicks_count_all Integer Yes
search_with_ads_count_all Integer Yes
scalar_parent_urlbar_impression_autofill_about_sum Integer Yes
scalar_parent_urlbar_impression_autofill_adaptive_sum Integer Yes
scalar_parent_urlbar_impression_autofill_origin_sum Integer Yes
scalar_parent_urlbar_impression_autofill_other_sum Integer Yes
scalar_parent_urlbar_impression_autofill_preloaded_sum Integer Yes
scalar_parent_urlbar_impression_autofill_url_sum Integer Yes
scalar_parent_telemetry_event_counts_sum Record No
scalar_content_telemetry_event_counts_sum Record No
scalar_parent_urlbar_searchmode_bookmarkmenu_sum Record No
scalar_parent_urlbar_searchmode_handoff_sum Record No
scalar_parent_urlbar_searchmode_keywordoffer_sum Record No
scalar_parent_urlbar_searchmode_oneoff_sum Record No
scalar_parent_urlbar_searchmode_other_sum Record No
scalar_parent_urlbar_searchmode_shortcut_sum Record No
scalar_parent_urlbar_searchmode_tabmenu_sum Record No
scalar_parent_urlbar_searchmode_tabtosearch_sum Record No
scalar_parent_urlbar_searchmode_tabtosearch_onboard_sum Record No
scalar_parent_urlbar_searchmode_topsites_newtab_sum Record No
scalar_parent_urlbar_searchmode_topsites_urlbar_sum Record No
scalar_parent_urlbar_searchmode_touchbar_sum Record No
scalar_parent_urlbar_searchmode_typed_sum Record No
scalar_parent_os_environment_is_taskbar_pinned Boolean Yes
scalar_parent_os_environment_launched_via_desktop Boolean Yes
scalar_parent_os_environment_launched_via_start_menu Boolean Yes
scalar_parent_os_environment_launched_via_taskbar Boolean Yes
scalar_parent_os_environment_launched_via_other_shortcut Boolean Yes
scalar_parent_os_environment_launched_via_other Boolean Yes
search_count_webextension Integer Yes
search_count_alias Integer Yes
search_count_urlbar_searchmode Integer Yes
scalar_parent_browser_ui_interaction_preferences_pane_home_sum Record No
scalar_parent_urlbar_picked_autofill_sum Record No
scalar_parent_urlbar_picked_autofill_about_sum Record No
scalar_parent_urlbar_picked_autofill_adaptive_sum Record No
scalar_parent_urlbar_picked_autofill_origin_sum Record No
scalar_parent_urlbar_picked_autofill_other_sum Record No
scalar_parent_urlbar_picked_autofill_preloaded_sum Record No
scalar_parent_urlbar_picked_autofill_url_sum Record No
scalar_parent_urlbar_picked_bookmark_sum Record No
scalar_parent_urlbar_picked_dynamic_sum Record No
scalar_parent_urlbar_picked_extension_sum Record No
scalar_parent_urlbar_picked_formhistory_sum Record No
scalar_parent_urlbar_picked_history_sum Record No
scalar_parent_urlbar_picked_keyword_sum Record No
scalar_parent_urlbar_picked_remotetab_sum Record No
scalar_parent_urlbar_picked_searchengine_sum Record No
scalar_parent_urlbar_picked_searchsuggestion_sum Record No
scalar_parent_urlbar_picked_switchtab_sum Record No
scalar_parent_urlbar_picked_tabtosearch_sum Record No
scalar_parent_urlbar_picked_tip_sum Record No
scalar_parent_urlbar_picked_topsite_sum Record No
scalar_parent_urlbar_picked_unknown_sum Record No
scalar_parent_urlbar_picked_visiturl_sum Record No
default_private_search_engine String Yes
default_private_search_engine_data_load_path String Yes
default_private_search_engine_data_name String Yes
default_private_search_engine_data_origin String Yes
default_private_search_engine_data_submission_url String Yes
search_counts Record No
user_pref_browser_search_region String Yes
search_with_ads Record No
ad_clicks Record No
search_content_urlbar_sum Record No
search_content_urlbar_handoff_sum Record No
search_content_urlbar_searchmode_sum Record No
search_content_contextmenu_sum Record No
search_content_about_home_sum Record No
search_content_about_newtab_sum Record No
search_content_searchbar_sum Record No
search_content_system_sum Record No
search_content_webextension_sum Record No
search_content_tabhistory_sum Record No
search_content_reload_sum Record No
search_content_unknown_sum Record No
search_withads_urlbar_sum Record No
search_withads_urlbar_handoff_sum Record No
search_withads_urlbar_searchmode_sum Record No
search_withads_contextmenu_sum Record No
search_withads_about_home_sum Record No
search_withads_about_newtab_sum Record No
search_withads_searchbar_sum Record No
search_withads_system_sum Record No
search_withads_webextension_sum Record No
search_withads_tabhistory_sum Record No
search_withads_reload_sum Record No
search_withads_unknown_sum Record No
search_adclicks_urlbar_sum Record No
search_adclicks_urlbar_handoff_sum Record No
search_adclicks_urlbar_searchmode_sum Record No
search_adclicks_contextmenu_sum Record No
search_adclicks_about_home_sum Record No
search_adclicks_about_newtab_sum Record No
search_adclicks_searchbar_sum Record No
search_adclicks_system_sum Record No
search_adclicks_webextension_sum Record No
search_adclicks_tabhistory_sum Record No
search_adclicks_reload_sum Record No
search_adclicks_unknown_sum Record No
update_background Boolean Yes
user_pref_browser_search_suggest_enabled String Yes
user_pref_browser_widget_in_navbar String Yes
user_pref_browser_urlbar_suggest_searches String Yes
user_pref_browser_urlbar_show_search_suggestions_first String Yes
user_pref_browser_urlbar_suggest_quicksuggest String Yes
user_pref_browser_urlbar_suggest_quicksuggest_sponsored String Yes
user_pref_browser_urlbar_quicksuggest_onboarding_dialog_choice String Yes
scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum Integer Yes
user_pref_browser_newtabpage_enabled String Yes
user_pref_app_shield_optoutstudies_enabled String Yes
contextual_services_quicksuggest_click_sum Record No
contextual_services_quicksuggest_impression_sum Record No
contextual_services_quicksuggest_help_sum Record No
contextual_services_topsites_click_sum Record No
contextual_services_topsites_impression_sum Record No
user_pref_browser_urlbar_suggest_quicksuggest_nonsponsored String Yes
user_pref_browser_urlbar_quicksuggest_data_collection_enabled String Yes
scalar_a11y_hcm_foreground Integer Yes
scalar_a11y_hcm_background Integer Yes
a11y_theme Record No
contextual_services_quicksuggest_help_nonsponsored_bestmatch_sum Record No
contextual_services_quicksuggest_help_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_block_nonsponsored_sum Record No
contextual_services_quicksuggest_block_sponsored_sum Record No
contextual_services_quicksuggest_block_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_block_nonsponsored_bestmatch_sum Record No
contextual_services_quicksuggest_click_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_click_nonsponsored_bestmatch_sum Record No
contextual_services_quicksuggest_impression_sponsored_bestmatch_sum Record No
contextual_services_quicksuggest_impression_nonsponsored_bestmatch_sum Record No
user_pref_browser_urlbar_suggest_bestmatch String Yes
scalar_parent_browser_ui_interaction_textrecognition_error_sum Integer Yes
text_recognition_interaction_timing_sum Integer Yes
text_recognition_interaction_timing_count_sum Integer Yes
scalar_parent_browser_ui_interaction_content_context_sum Record No
text_recognition_api_performance_sum Integer Yes
text_recognition_api_performance_count_sum Integer Yes
text_recognition_text_length_sum Integer Yes
text_recognition_text_length_count_sum Integer Yes
scalar_parent_os_environment_launched_via_taskbar_private Boolean Yes
dom_parentprocess_private_window_used Boolean Yes
os_environment_is_taskbar_pinned_any Boolean Yes
os_environment_is_taskbar_pinned_private_any Boolean Yes
os_environment_is_taskbar_pinned_private Boolean Yes
bookmark_migrations_quantity_chrome Integer Yes
bookmark_migrations_quantity_edge Integer Yes
bookmark_migrations_quantity_safari Integer Yes
bookmark_migrations_quantity_all Integer Yes
history_migrations_quantity_chrome Integer Yes
history_migrations_quantity_edge Integer Yes
history_migrations_quantity_safari Integer Yes
history_migrations_quantity_all Integer Yes
logins_migrations_quantity_chrome Integer Yes
logins_migrations_quantity_edge Integer Yes
logins_migrations_quantity_safari Integer Yes
logins_migrations_quantity_all Integer Yes
search_count_urlbar_persisted Integer Yes
search_content_urlbar_persisted_sum Record No
search_withads_urlbar_persisted_sum Record No
search_adclicks_urlbar_persisted_sum Record No
media_play_time_ms_audio_sum Integer Yes
media_play_time_ms_video_sum Integer Yes
contextual_services_quicksuggest_block_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_block_weather_sum Record No
contextual_services_quicksuggest_click_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_click_nonsponsored_sum Record No
contextual_services_quicksuggest_click_sponsored_sum Record No
contextual_services_quicksuggest_click_weather_sum Record No
contextual_services_quicksuggest_help_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_help_nonsponsored_sum Record No
contextual_services_quicksuggest_help_sponsored_sum Record No
contextual_services_quicksuggest_help_weather_sum Record No
contextual_services_quicksuggest_impression_dynamic_wikipedia_sum Record No
contextual_services_quicksuggest_impression_nonsponsored_sum Record No
contextual_services_quicksuggest_impression_sponsored_sum Record No
contextual_services_quicksuggest_impression_weather_sum Record No
places_searchbar_cumulative_searches_sum Integer Yes
places_searchbar_cumulative_filter_count_sum Integer Yes
scalar_parent_sidebar_opened_sum Record No
scalar_parent_sidebar_search_sum Record No
scalar_parent_sidebar_link_sum Record No
places_previousday_visits_mean Float Yes
places_library_cumulative_bookmark_searches_sum Integer Yes
places_library_cumulative_history_searches_sum Integer Yes
places_bookmarks_searchbar_cumulative_searches_sum Integer Yes
scalar_parent_library_link_sum Record No
scalar_parent_library_opened_sum Record No
scalar_parent_library_search_sum Record No
startup_profile_selection_reason_first String Yes
first_document_id String Yes
partner_id String Yes
distribution_version String Yes
distributor String Yes
distributor_channel String Yes
env_build_platform_version String Yes
env_build_xpcom_abi String Yes
geo_db_version String Yes
apple_model_id String Yes
max_subsession_counter Integer Yes
min_subsession_counter Integer Yes
startup_profile_selection_first_ping_only String Yes
_sample_id_string String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_last_seen_v1

Source Directory | View Definition | Metadata File


clients_probe_processes

Clients Probe Processes

telemetry.clients_probe_processes

Please provide a description for the query

Schema
Column Description Type Nullable
metric String Yes
os String Yes
channel String Yes
processes String No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived client_probe_counts_v1

Source Directory | View Definition | Metadata File


clients_scalar_aggregates

Clients Scalar Aggregates

telemetry.clients_scalar_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_scalar_aggregates_v1

Source Directory | View Definition | Metadata File


cohort_daily_statistics

Cohort Daily Statistics

telemetry.cohort_daily_statistics

Please provide a description for the query

Schema
Column Description Type Nullable
cohort_date Date Yes
activity_date Date Yes
activity_segment String Yes
app_version String Yes
attribution_campaign String Yes
attribution_content String Yes
attribution_experiment String Yes
attribution_medium String Yes
attribution_source String Yes
attribution_variation String Yes
city String Yes
country String Yes
device_model String Yes
distribution_id String Yes
is_default_browser Boolean Yes
locale String Yes
normalized_app_name String Yes
normalized_channel String Yes
normalized_os String Yes
normalized_os_version String Yes
os_version_major Integer Yes
os_version_minor Integer Yes
num_clients_in_cohort Integer Yes
num_clients_active_on_day Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived cohort_daily_statistics_v1

Source Directory | View Definition | Metadata File


core

Core

telemetry.core

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable core_v10
moz-fx-data-shared-prod telemetry_stable core_v2
moz-fx-data-shared-prod telemetry_stable core_v3
moz-fx-data-shared-prod telemetry_stable core_v4
moz-fx-data-shared-prod telemetry_stable core_v5
moz-fx-data-shared-prod telemetry_stable core_v6
moz-fx-data-shared-prod telemetry_stable core_v7
moz-fx-data-shared-prod telemetry_stable core_v8
moz-fx-data-shared-prod telemetry_stable core_v9

Source Directory | View Definition | Metadata File


core_clients_daily

Core Clients Daily

telemetry.core_clients_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
profile_date Date Yes
sessions Integer Yes
durations Integer Yes
flash_usage Integer Yes
app_name String Yes
os String Yes
country String Yes
city String Yes
app_build_id String Yes
normalized_channel String Yes
locale String Yes
osversion String Yes
device String Yes
arch String Yes
default_search String Yes
distribution_id String Yes
campaign String Yes
campaign_id String Yes
default_browser Boolean Yes
show_tracker_stats_share Boolean Yes
metadata_app_version String Yes
bug_1501329_affected Boolean Yes
first_seen_date Date Yes
is_new_profile Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry core_clients_daily_v1

Source Directory | View Definition | Metadata File


core_clients_daily_v1

Core Clients Daily V1

telemetry.core_clients_daily_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
profile_date Date Yes
sessions Integer Yes
durations Integer Yes
flash_usage Integer Yes
app_name String Yes
os String Yes
country String Yes
city String Yes
app_build_id String Yes
normalized_channel String Yes
locale String Yes
osversion String Yes
device String Yes
arch String Yes
default_search String Yes
distribution_id String Yes
campaign String Yes
campaign_id String Yes
default_browser Boolean Yes
show_tracker_stats_share Boolean Yes
metadata_app_version String Yes
bug_1501329_affected Boolean Yes
first_seen_date Date Yes
is_new_profile Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived core_clients_daily_v1

Source Directory | View Definition | Metadata File


core_clients_last_seen

Core Clients Last Seen

telemetry.core_clients_last_seen

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry core_clients_last_seen_v1

Source Directory | View Definition | Metadata File


core_clients_last_seen_v1

Core Clients Last Seen V1

telemetry.core_clients_last_seen_v1

Please provide a description for the query

Schema
Column Description Type Nullable
date_last_seen Date Yes
days_since_seen Integer Yes
days_since_created_profile Integer Yes
submission_date Date Yes
days_seen_bits Integer Yes
days_created_profile_bits Integer Yes
client_id String Yes
profile_date Date Yes
sessions Integer Yes
durations Integer Yes
flash_usage Integer Yes
app_name String Yes
os String Yes
country String Yes
city String Yes
app_build_id String Yes
normalized_channel String Yes
locale String Yes
osversion String Yes
device String Yes
arch String Yes
default_search String Yes
distribution_id String Yes
campaign String Yes
campaign_id String Yes
default_browser Boolean Yes
show_tracker_stats_share Boolean Yes
metadata_app_version String Yes
bug_1501329_affected Boolean Yes
first_seen_date Date Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived core_clients_last_seen_v1

Source Directory | View Definition | Metadata File


crash

Historical Pings for telemetry/crash

telemetry.crash

A historical view of pings sent for the telemetry/crash document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
client_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable crash_v4

Source Directory | View Definition | Metadata File


crash_aggregates

Crash Aggregates

telemetry.crash_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry crash_aggregates_v1

Source Directory | View Definition | Metadata File


crash_aggregates_v1

Crash Aggregates V1

telemetry.crash_aggregates_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crash_aggregates_v1

Source Directory | View Definition | Metadata File


crash_summary

Crash Summary

telemetry.crash_summary

Please provide a description for the query

Schema
Column Description Type Nullable
client_id String Yes
normalized_channel String Yes
build_version String Yes
build_id String Yes
channel String Yes
crash_time String Yes
application String Yes
os_name String Yes
os_version String Yes
architecture String Yes
country String Yes
experiment_id String Yes
experiment_branch String Yes
experiments Record No
e10s_enabled Boolean Yes
gfx_compositor String Yes
profile_created Integer Yes
payload Record Yes
submission_date Date Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry crash_summary_v2

Source Directory | View Definition | Metadata File


crash_summary_v1

Crash Summary V1

telemetry.crash_summary_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crash_summary_v1

Source Directory | View Definition | Metadata File


crash_summary_v2

Crash Summary V2

telemetry.crash_summary_v2

Please provide a description for the query

Schema
Column Description Type Nullable
client_id String Yes
normalized_channel String Yes
build_version String Yes
build_id String Yes
channel String Yes
crash_time String Yes
application String Yes
os_name String Yes
os_version String Yes
architecture String Yes
country String Yes
experiment_id String Yes
experiment_branch String Yes
experiments Record No
e10s_enabled Boolean Yes
gfx_compositor String Yes
profile_created Integer Yes
payload Record Yes
submission_date Date Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crash_summary_v2

Source Directory | View Definition | Metadata File


crashes_daily

Crashes Daily

telemetry.crashes_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
application_name String Yes
build_id String Yes
channel String Yes
os String Yes
os_version String Yes
country_code String Yes
main_crash_count Integer Yes
content_crash_count Integer Yes
gpu_crash_count Integer Yes
rdd_crash_count Integer Yes
socket_crash_count Integer Yes
utility_crash_count Integer Yes
vr_crash_count Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crashes_daily_v1

Source Directory | View Definition | Metadata File


deletion

Historical Pings for telemetry/deletion

telemetry.deletion

A historical view of pings sent for the telemetry/deletion document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable deletion_v4

Source Directory | View Definition | Metadata File


deletion_request

Historical Pings for telemetry/deletion-request

telemetry.deletion_request

A historical view of pings sent for the telemetry/deletion-request document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
payload Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable deletion_request_v4

Source Directory | View Definition | Metadata File


deployment_checker

Historical Pings for telemetry/deployment-checker

telemetry.deployment_checker

A historical view of pings sent for the telemetry/deployment-checker document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable deployment_checker_v4

Source Directory | View Definition | Metadata File


desktop_acquisition_funnel

Desktop Acquisition Funnel

telemetry.desktop_acquisition_funnel

Please provide a description for the query

Schema
Column Description Type Nullable
first_seen_date Date Yes
country_code String Yes
channel String Yes
os String Yes
os_version Numeric Yes
distribution_id String Yes
attribution_ua String Yes
attribution_source String Yes
attribution_medium String Yes
attribution_campaign String Yes
attribution_content String Yes
attribution_experiment String Yes
attribution_dlsource String Yes
startup_profile_selection_reason String Yes
cohort Integer Yes
activated Integer Yes
returned_second_day Integer Yes
qualified_second_day Integer Yes
retained_week4 Integer Yes
qualified_week4 Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_first_seen_28_days_later_v1

Source Directory | View Definition | Metadata File


desktop_retention_1_week

Desktop 1-Week Retention

telemetry.desktop_retention_1_week

Among profiles that were active at least once in the week starting on the specified day (days 0 through 6), whether each profile is active during the following week (days 7 through 13). This based on https://docs.telemetry.mozilla.org/cookbooks/retention.html#1-week-retention for the usage criterion "Any Firefox Activity" on Firefox (Desktop)

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_last_seen

Source Directory | View Definition | Metadata File


devtools_panel_usage

Devtools Panel Usage

telemetry.devtools_panel_usage

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
tool String Yes
dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived devtools_panel_usage_v1

Source Directory | View Definition | Metadata File


disable_sha1rollout

Historical Pings for telemetry/disable-sha1rollout

telemetry.disable_sha1rollout

A historical view of pings sent for the telemetry/disable-sha1rollout document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable disable_sha1rollout_v4

Source Directory | View Definition | Metadata File


dnssec_study_v1

Historical Pings for telemetry/dnssec-study-v1

telemetry.dnssec_study_v1

A historical view of pings sent for the telemetry/dnssec-study-v1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable dnssec_study_v1_v4

Source Directory | View Definition | Metadata File


downgrade

Historical Pings for telemetry/downgrade

telemetry.downgrade

A historical view of pings sent for the telemetry/downgrade document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable downgrade_v4

Source Directory | View Definition | Metadata File


eng_workflow_build_parquet

Eng Workflow Build Parquet

telemetry.eng_workflow_build_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry eng_workflow_build_parquet_v1

Source Directory | View Definition | Metadata File


eng_workflow_build_parquet_v1

Eng Workflow Build Parquet V1

telemetry.eng_workflow_build_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod eng_workflow build

Source Directory | View Definition | Metadata File


eng_workflow_hgpush_parquet

Eng Workflow Hgpush Parquet

telemetry.eng_workflow_hgpush_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived eng_workflow_hgpush_parquet_v1

Source Directory | View Definition | Metadata File


eng_workflow_hgpush_parquet_v1

Eng Workflow Hgpush Parquet V1

telemetry.eng_workflow_hgpush_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived eng_workflow_hgpush_parquet_v1

Source Directory | View Definition | Metadata File


event

Historical Pings for telemetry/event

telemetry.event

A historical view of pings sent for the telemetry/event document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable event_v4

Source Directory | View Definition | Metadata File


event_types

Event Types

telemetry.event_types

Please provide a description for the query

Schema
Column Description Type Nullable
category String Yes
event String Yes
first_timestamp Timestamp Yes
numeric_index Integer Yes
index String Yes
event_properties Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived event_types_v1

Source Directory | View Definition | Metadata File


events

Events

telemetry.events

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
doc_type String Yes
document_id String Yes
client_id String Yes
normalized_channel String Yes
country String Yes
locale String Yes
app_name String Yes
app_version String Yes
os String Yes
os_version String Yes
timestamp Timestamp Yes
sample_id Integer Yes
event_timestamp Integer Yes
event_category String Yes
event_method String Yes
event_object String Yes
event_string_value String Yes
event_map_values Record No
experiments Record No
event_process String Yes
subsession_id String Yes
session_start_time Timestamp Yes
session_id String Yes
build_id String Yes
browser_version_info Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry events_v1

Source Directory | View Definition | Metadata File


events_1pct

Events 1pct

telemetry.events_1pct

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
doc_type String Yes
document_id String Yes
client_id String Yes
normalized_channel String Yes
country String Yes
locale String Yes
app_name String Yes
app_version String Yes
os String Yes
os_version String Yes
timestamp Timestamp Yes
sample_id Integer Yes
event_timestamp Integer Yes
event_category String Yes
event_method String Yes
event_object String Yes
event_string_value String Yes
event_map_values Record No
experiments Record No
event_process String Yes
subsession_id String Yes
session_start_time Timestamp Yes
session_id String Yes
build_id String Yes
browser_version_info Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived events_1pct_v1

Source Directory | View Definition | Metadata File


events_daily

Events Daily

telemetry.events_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
events String Yes
build_id String Yes
build_architecture String Yes
profile_creation_date Float Yes
is_default_browser Boolean Yes
attribution_source String Yes
app_version String Yes
locale String Yes
distribution_id String Yes
attribution_ua String Yes
display_version String Yes
city String Yes
country String Yes
subdivision1 String Yes
channel String Yes
os String Yes
os_version String Yes
experiments Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived events_daily_v1

Source Directory | View Definition | Metadata File


events_v1

Events V1

telemetry.events_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
doc_type String Yes
document_id String Yes
client_id String Yes
normalized_channel String Yes
country String Yes
locale String Yes
app_name String Yes
app_version String Yes
os String Yes
os_version String Yes
timestamp Timestamp Yes
sample_id Integer Yes
event_timestamp Integer Yes
event_category String Yes
event_method String Yes
event_object String Yes
event_string_value String Yes
event_map_values Record No
experiments Record No
event_process String Yes
subsession_id String Yes
session_start_time Timestamp Yes
session_id String Yes
build_id String Yes
browser_version_info Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived event_events_v1
moz-fx-data-shared-prod telemetry_derived events_v1
moz-fx-data-shared-prod telemetry_derived main_events_v1

Source Directory | View Definition | Metadata File


experiment_cumulative_ad_clicks

Experiment Cumulative Ad Clicks

telemetry.experiment_cumulative_ad_clicks

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_cumulative_ad_clicks_v1

Source Directory | View Definition | Metadata File


experiment_cumulative_search_count

Experiment Cumulative Search Count

telemetry.experiment_cumulative_search_count

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_cumulative_search_count_v1

Source Directory | View Definition | Metadata File


experiment_cumulative_search_with_ads_count

Experiment Cumulative Search With Ads Count

telemetry.experiment_cumulative_search_with_ads_count

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_cumulative_search_with_ads_count_v1

Source Directory | View Definition | Metadata File


experiment_enrollment_cumulative_population_estimate

Experiment Enrollment Cumulative Population Estimate

telemetry.experiment_enrollment_cumulative_population_estimate

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_cumulative_population_estimate_v1

Source Directory | View Definition | Metadata File


experiment_enrollment_daily_active_population

Experiment Enrollment Daily Active Population

telemetry.experiment_enrollment_daily_active_population

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_daily_active_population_v1

Source Directory | View Definition | Metadata File


experiment_enrollment_other_events_overall

Experiment Enrollment Other Events Overall

telemetry.experiment_enrollment_other_events_overall

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
event String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_other_events_overall_v1

Source Directory | View Definition | Metadata File


experiment_enrollment_overall

Experiment Enrollment Overall

telemetry.experiment_enrollment_overall

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_overall_v1

Source Directory | View Definition | Metadata File


experiment_error_aggregates

Experiment Error Aggregates

telemetry.experiment_error_aggregates

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_error_aggregates_v1

Source Directory | View Definition | Metadata File


experiment_error_aggregates_v1

Experiment Error Aggregates V1

telemetry.experiment_error_aggregates_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_error_aggregates_v1

Source Directory | View Definition | Metadata File


experiment_unenrollment_overall

Experiment Unenrollment Overall

telemetry.experiment_unenrollment_overall

Please provide a description for the query

Schema
Column Description Type Nullable
time Timestamp Yes
experiment String Yes
branch String Yes
value Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_unenrollment_overall_v1

Source Directory | View Definition | Metadata File


experiments

Experiments

telemetry.experiments

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
submission_date Date Yes
document_id String Yes
client_id String Yes
channel String Yes
normalized_channel String Yes
normalized_os_version String Yes
country String Yes
city String Yes
geo_subdivision1 String Yes
geo_subdivision2 String Yes
os String Yes
os_version String Yes
os_service_pack_major Integer Yes
os_service_pack_minor Integer Yes
windows_build_number Integer Yes
windows_ubr Integer Yes
install_year Integer Yes
is_wow64 Boolean Yes
memory_mb Integer Yes
cpu_count Integer Yes
cpu_cores Integer Yes
cpu_vendor String Yes
cpu_family Integer Yes
cpu_model Integer Yes
cpu_stepping Integer Yes
cpu_l2_cache_kb Integer Yes
cpu_l3_cache_kb Integer Yes
cpu_speed_mhz Integer Yes
gfx_features_d3d11_status String Yes
gfx_features_d2d_status String Yes
gfx_features_gpu_process_status String Yes
gfx_features_advanced_layers_status String Yes
apple_model_id String Yes
antivirus String No
antispyware String No
firewall String No
profile_creation_date Integer Yes
profile_reset_date Integer Yes
previous_build_id String Yes
session_id String Yes
subsession_id String Yes
previous_session_id String Yes
previous_subsession_id String Yes
session_start_date String Yes
subsession_start_date String Yes
session_length Integer Yes
subsession_length Integer Yes
subsession_counter Integer Yes
profile_subsession_counter Integer Yes
creation_date String Yes
distribution_id String Yes
sync_configured Boolean Yes
sync_count_desktop Integer Yes
sync_count_mobile Integer Yes
app_build_id String Yes
app_display_version String Yes
app_name String Yes
app_version String Yes
timestamp Integer Yes
env_build_id String Yes
env_build_version String Yes
env_build_arch String Yes
e10s_enabled Boolean Yes
e10s_multi_processes Integer Yes
locale String Yes
update_channel String Yes
update_enabled Boolean Yes
update_auto_download Boolean Yes
attribution Record Yes
sandbox_effective_content_process_level Integer Yes
reason String Yes
timezone_offset Integer Yes
plugin_hangs Integer Yes
aborts_plugin Integer Yes
aborts_content Integer Yes
aborts_gmplugin Integer Yes
crashes_detected_plugin Integer Yes
crashes_detected_gmplugin Integer Yes
crash_submit_attempt_main Integer Yes
crash_submit_attempt_content Integer Yes
crash_submit_attempt_plugin Integer Yes
crash_submit_success_main Integer Yes
crash_submit_success_content Integer Yes
crash_submit_success_plugin Integer Yes
shutdown_kill Integer Yes
active_addons_count Integer Yes
flash_version String Yes
vendor String Yes
is_default_browser Boolean Yes
default_search_engine_data_name String Yes
default_search_engine_data_load_path String Yes
default_search_engine_data_origin String Yes
default_search_engine_data_submission_url String Yes
default_search_engine String Yes
devtools_toolbox_opened_count Integer Yes
client_submission_date String Yes
client_clock_skew Integer Yes
client_submission_latency Integer Yes
places_bookmarks_count Integer Yes
places_pages_count Integer Yes
push_api_notify Integer Yes
popup_notification_stats Record No
search_counts Record No
active_addons Record No
disabled_addons_ids String No
active_theme Record Yes
blocklist_enabled Boolean Yes
addon_compatibility_check_enabled Boolean Yes
telemetry_enabled Boolean Yes
events Record No
ssl_handshake_result_success Integer Yes
ssl_handshake_result_failure Integer Yes
ssl_handshake_result Record No
active_ticks Integer Yes
main Integer Yes
first_paint Integer Yes
session_restored Integer Yes
total_time Integer Yes
plugins_notification_shown Integer Yes
experiments Record No
search_cohort String Yes
gfx_compositor String Yes
quantum_ready Boolean Yes
gc_max_pause_ms_main_above_150 Integer Yes
gc_max_pause_ms_main_above_250 Integer Yes
gc_max_pause_ms_main_above_2500 Integer Yes
gc_max_pause_ms_content_above_150 Integer Yes
gc_max_pause_ms_content_above_250 Integer Yes
gc_max_pause_ms_content_above_2500 Integer Yes
cycle_collector_max_pause_main_above_150 Integer Yes
cycle_collector_max_pause_main_above_250 Integer Yes
cycle_collector_max_pause_main_above_2500 Integer Yes
cycle_collector_max_pause_content_above_150 Integer Yes
cycle_collector_max_pause_content_above_250 Integer Yes
cycle_collector_max_pause_content_above_2500 Integer Yes
input_event_response_coalesced_ms_main_above_150 Integer Yes
input_event_response_coalesced_ms_main_above_250 Integer Yes
input_event_response_coalesced_ms_main_above_2500 Integer Yes
input_event_response_coalesced_ms_content_above_150 Integer Yes
input_event_response_coalesced_ms_content_above_250 Integer Yes
input_event_response_coalesced_ms_content_above_2500 Integer Yes
ghost_windows_main_above_1 Integer Yes
ghost_windows_content_above_1 Integer Yes
user_pref_dom_ipc_plugins_sandbox_level_flash Integer Yes
user_pref_dom_ipc_processcount Integer Yes
user_pref_extensions_legacy_enabled Boolean Yes
user_pref_browser_search_widget_innavbar Boolean Yes
user_pref_general_config_filename String Yes
scalar_content_browser_usage_plugin_instantiated Integer Yes
scalar_content_gfx_omtp_paint_wait_ratio Integer Yes
scalar_content_gfx_small_paint_phase_weight Record No
scalar_content_images_webp_content_frequency Record No
scalar_content_images_webp_content_observed Boolean Yes
scalar_content_images_webp_probe_observed Boolean Yes
scalar_content_mathml_doc_count Integer Yes
scalar_content_media_autoplay_would_be_allowed_count Integer Yes
scalar_content_media_autoplay_would_not_be_allowed_count Integer Yes
scalar_content_media_page_count Integer Yes
scalar_content_media_page_had_media_count Integer Yes
scalar_content_media_page_had_play_revoked_count Integer Yes
scalar_content_sw_alternative_body_used_count Integer Yes
scalar_content_sw_synthesized_res_count Integer Yes
scalar_content_telemetry_accumulate_unknown_histogram_keys Record No
scalar_content_telemetry_discarded_accumulations Integer Yes
scalar_content_telemetry_discarded_child_events Integer Yes
scalar_content_telemetry_discarded_keyed_accumulations Integer Yes
scalar_content_telemetry_discarded_keyed_scalar_actions Integer Yes
scalar_content_telemetry_discarded_scalar_actions Integer Yes
scalar_content_telemetry_event_counts Record No
scalar_content_webrtc_nicer_turn_401s Integer Yes
scalar_content_webrtc_nicer_turn_403s Integer Yes
scalar_content_webrtc_nicer_turn_438s Integer Yes
scalar_content_webrtc_sdp_parser_diff Record No
scalar_gpu_telemetry_accumulate_unknown_histogram_keys Record No
scalar_gpu_telemetry_discarded_accumulations Integer Yes
scalar_gpu_telemetry_discarded_child_events Integer Yes
scalar_gpu_telemetry_discarded_keyed_accumulations Integer Yes
scalar_gpu_telemetry_discarded_keyed_scalar_actions Integer Yes
scalar_gpu_telemetry_discarded_scalar_actions Integer Yes
scalar_gpu_telemetry_event_counts Record No
scalar_parent_a11y_indicator_acted_on Boolean Yes
scalar_parent_a11y_instantiators String Yes
scalar_parent_browser_engagement_active_ticks Integer Yes
scalar_parent_browser_engagement_max_concurrent_tab_count Integer Yes
scalar_parent_browser_engagement_max_concurrent_window_count Integer Yes
scalar_parent_browser_engagement_navigation_about_home Record No
scalar_parent_browser_engagement_navigation_about_newtab Record No
scalar_parent_browser_engagement_navigation_contextmenu Record No
scalar_parent_browser_engagement_navigation_searchbar Record No
scalar_parent_browser_engagement_navigation_urlbar Record No
scalar_parent_browser_engagement_restored_pinned_tabs_count Integer Yes
scalar_parent_browser_engagement_tab_open_event_count Integer Yes
scalar_parent_browser_engagement_total_uri_count Integer Yes
scalar_parent_browser_engagement_unfiltered_uri_count Integer Yes
scalar_parent_browser_engagement_unique_domains_count Integer Yes
scalar_parent_browser_engagement_window_open_event_count Integer Yes
scalar_parent_browser_errors_collected_count_by_filename Record No
scalar_parent_browser_timings_last_shutdown Integer Yes
scalar_parent_devtools_accessibility_node_inspected_count Integer Yes
scalar_parent_devtools_accessibility_opened_count Integer Yes
scalar_parent_devtools_accessibility_picker_used_count Integer Yes
scalar_parent_devtools_accessibility_select_accessible_for_node Record No
scalar_parent_devtools_accessibility_service_enabled_count Integer Yes
scalar_parent_devtools_copy_full_css_selector_opened Integer Yes
scalar_parent_devtools_copy_unique_css_selector_opened Integer Yes
scalar_parent_devtools_copy_xpath_opened Integer Yes
scalar_parent_devtools_current_theme Record No
scalar_parent_devtools_grid_gridinspector_opened Integer Yes
scalar_parent_devtools_grid_showgridareasoverlay_checked Integer Yes
scalar_parent_devtools_grid_showgridlinenumbers_checked Integer Yes
scalar_parent_devtools_grid_showinfinitelines_checked Integer Yes
scalar_parent_devtools_inspector_three_pane_enabled Record No
scalar_parent_devtools_responsive_open_trigger Record No
scalar_parent_devtools_responsive_toolbox_opened_first Integer Yes
scalar_parent_devtools_rules_gridinspector_opened Integer Yes
scalar_parent_devtools_shadowdom_reveal_link_clicked Boolean Yes
scalar_parent_devtools_shadowdom_shadow_root_displayed Boolean Yes
scalar_parent_devtools_shadowdom_shadow_root_expanded Boolean Yes
scalar_parent_devtools_tool_registered Record No
scalar_parent_devtools_toolbar_eyedropper_opened Integer Yes
scalar_parent_devtools_toolbox_tabs_reordered Record No
scalar_parent_dom_contentprocess_buildid_mismatch Integer Yes
scalar_parent_extensions_updates_rdf Record No
scalar_parent_formautofill_addresses_fill_type_autofill Integer Yes
scalar_parent_formautofill_addresses_fill_type_autofill_update Integer Yes
scalar_parent_formautofill_addresses_fill_type_manual Integer Yes
scalar_parent_formautofill_availability Boolean Yes
scalar_parent_formautofill_creditcards_fill_type_autofill Integer Yes
scalar_parent_formautofill_creditcards_fill_type_manual Integer Yes
scalar_parent_gfx_advanced_layers_failure_id Record No
scalar_parent_images_webp_content_frequency Record No
scalar_parent_images_webp_content_observed Boolean Yes
scalar_parent_images_webp_probe_observed Boolean Yes
scalar_parent_media_page_count Integer Yes
scalar_parent_preferences_browser_home_page_change Record No
scalar_parent_preferences_browser_home_page_count Record No
scalar_parent_preferences_search_query Record No
scalar_parent_preferences_use_bookmark Record No
scalar_parent_preferences_use_current_page Record No
scalar_parent_sandbox_no_job Record No
scalar_parent_screenshots_copy Integer Yes
scalar_parent_screenshots_download Integer Yes
scalar_parent_security_client_cert Record No
scalar_parent_security_pkcs11_modules_loaded Record No
scalar_parent_security_webauthn_used Record No
scalar_parent_services_sync_sync_login_state_transitions Record No
scalar_parent_storage_sync_api_usage_items_stored Record No
scalar_parent_storage_sync_api_usage_storage_consumed Record No
scalar_parent_sw_alternative_body_used_count Integer Yes
scalar_parent_sw_synthesized_res_count Integer Yes
scalar_parent_telemetry_accumulate_clamped_values Record No
scalar_parent_telemetry_accumulate_unknown_histogram_keys Record No
scalar_parent_telemetry_data_upload_optin Boolean Yes
scalar_parent_telemetry_event_counts Record No
scalar_parent_timestamps_first_paint Integer Yes
scalar_parent_webrtc_nicer_turn_401s Integer Yes
scalar_parent_webrtc_nicer_turn_403s Integer Yes
scalar_parent_webrtc_nicer_turn_438s Integer Yes
scalar_parent_widget_ime_name_on_linux Record No
scalar_parent_widget_ime_name_on_mac Record No
scalar_parent_widget_ime_name_on_windows Record No
histogram_content_cert_validation_success_by_ca Record No
histogram_content_cycle_collector_max_pause Record No
histogram_content_devtools_toolbox_time_active_seconds Record No
histogram_content_fx_new_window_ms Record No
histogram_content_fx_searchbar_selected_result_method Record No
histogram_content_fx_session_restore_restore_window_ms Record No
histogram_content_fx_session_restore_startup_init_session_ms Record No
histogram_content_fx_session_restore_startup_onload_initial_window_ms Record No
histogram_content_fx_tab_close_time_anim_ms Record No
histogram_content_fx_tab_switch_update_ms Record No
histogram_content_fx_urlbar_selected_result_index Record No
histogram_content_fx_urlbar_selected_result_index_by_type Record No
histogram_content_fx_urlbar_selected_result_method Record No
histogram_content_fx_urlbar_selected_result_type Record No
histogram_content_gc_animation_ms Record No
histogram_content_gc_max_pause_ms_2 Record No
histogram_content_ghost_windows Record No
histogram_content_gpu_process_initialization_time_ms Record No
histogram_content_gpu_process_launch_time_ms_2 Record No
histogram_content_http_channel_disposition Record No
histogram_content_http_pageload_is_ssl Record No
histogram_content_http_transaction_is_ssl Record No
histogram_content_input_event_response_coalesced_ms Record No
histogram_content_ipc_read_main_thread_latency_ms Record No
histogram_content_memory_heap_allocated Record No
histogram_content_memory_resident_fast Record No
histogram_content_memory_unique Record No
histogram_content_memory_vsize Record No
histogram_content_memory_vsize_max_contiguous Record No
histogram_content_network_cache_metadata_first_read_time_ms Record No
histogram_content_network_cache_v2_hit_time_ms Record No
histogram_content_network_cache_v2_miss_time_ms Record No
histogram_content_places_autocomplete_6_first_results_time_ms Record No
histogram_content_plugin_shutdown_ms Record No
histogram_content_search_reset_result Record No
histogram_content_search_service_init_ms Record No
histogram_content_ssl_handshake_result Record No
histogram_content_ssl_handshake_version Record No
histogram_content_ssl_tls12_intolerance_reason_pre Record No
histogram_content_ssl_tls13_intolerance_reason_pre Record No
histogram_content_time_to_dom_complete_ms Record No
histogram_content_time_to_dom_content_loaded_end_ms Record No
histogram_content_time_to_dom_content_loaded_start_ms Record No
histogram_content_time_to_dom_interactive_ms Record No
histogram_content_time_to_dom_loading_ms Record No
histogram_content_time_to_first_click_ms Record No
histogram_content_time_to_first_interaction_ms Record No
histogram_content_time_to_first_key_input_ms Record No
histogram_content_time_to_first_mouse_move_ms Record No
histogram_content_time_to_first_scroll_ms Record No
histogram_content_time_to_load_event_end_ms Record No
histogram_content_time_to_load_event_start_ms Record No
histogram_content_time_to_non_blank_paint_ms Record No
histogram_content_time_to_response_start_ms Record No
histogram_content_tracking_protection_enabled Record No
histogram_content_uptake_remote_content_result_1 Record No
histogram_content_webext_content_script_injection_ms Record No
histogram_content_webext_storage_local_get_ms Record No
histogram_content_webext_storage_local_set_ms Record No
histogram_content_webvr_time_spent_viewing_in_2d Record No
histogram_content_webvr_users_view_in Record No
histogram_gpu_gpu_process_initialization_time_ms Record No
histogram_gpu_ipc_read_main_thread_latency_ms Record No
histogram_gpu_uptake_remote_content_result_1 Record No
histogram_gpu_webvr_time_spent_viewing_in_oculus Record No
histogram_gpu_webvr_time_spent_viewing_in_openvr Record No
histogram_gpu_webvr_users_view_in Record No
histogram_parent_a11y_consumers Record No
histogram_parent_a11y_instantiated_flag Record No
histogram_parent_cert_validation_success_by_ca Record No
histogram_parent_cycle_collector_max_pause Record No
histogram_parent_devtools_entry_point Record No
histogram_parent_devtools_toolbox_time_active_seconds Record No
histogram_parent_fx_new_window_ms Record No
histogram_parent_fx_searchbar_selected_result_method Record No
histogram_parent_fx_session_restore_restore_window_ms Record No
histogram_parent_fx_session_restore_startup_init_session_ms Record No
histogram_parent_fx_session_restore_startup_onload_initial_window_ms Record No
histogram_parent_fx_tab_close_time_anim_ms Record No
histogram_parent_fx_tab_switch_total_e10s_ms Record No
histogram_parent_fx_tab_switch_update_ms Record No
histogram_parent_fx_urlbar_selected_result_index Record No
histogram_parent_fx_urlbar_selected_result_index_by_type Record No
histogram_parent_fx_urlbar_selected_result_method Record No
histogram_parent_fx_urlbar_selected_result_type Record No
histogram_parent_gc_animation_ms Record No
histogram_parent_gc_max_pause_ms_2 Record No
histogram_parent_ghost_windows Record No
histogram_parent_gpu_process_initialization_time_ms Record No
histogram_parent_gpu_process_launch_time_ms_2 Record No
histogram_parent_http_channel_disposition Record No
histogram_parent_http_pageload_is_ssl Record No
histogram_parent_http_transaction_is_ssl Record No
histogram_parent_input_event_response_coalesced_ms Record No
histogram_parent_ipc_read_main_thread_latency_ms Record No
histogram_parent_memory_distribution_among_content Record No
histogram_parent_memory_heap_allocated Record No
histogram_parent_memory_resident_fast Record No
histogram_parent_memory_total Record No
histogram_parent_memory_unique Record No
histogram_parent_memory_vsize Record No
histogram_parent_memory_vsize_max_contiguous Record No
histogram_parent_network_cache_metadata_first_read_time_ms Record No
histogram_parent_network_cache_v2_hit_time_ms Record No
histogram_parent_network_cache_v2_miss_time_ms Record No
histogram_parent_places_autocomplete_6_first_results_time_ms Record No
histogram_parent_plugin_shutdown_ms Record No
histogram_parent_search_reset_result Record No
histogram_parent_search_service_init_ms Record No
histogram_parent_ssl_handshake_result Record No
histogram_parent_ssl_handshake_version Record No
histogram_parent_ssl_tls12_intolerance_reason_pre Record No
histogram_parent_ssl_tls13_intolerance_reason_pre Record No
histogram_parent_time_to_first_click_ms Record No
histogram_parent_time_to_first_interaction_ms Record No
histogram_parent_time_to_first_key_input_ms Record No
histogram_parent_time_to_first_mouse_move_ms Record No
histogram_parent_time_to_first_scroll_ms Record No
histogram_parent_time_to_non_blank_paint_ms Record No
histogram_parent_time_to_response_start_ms Record No
histogram_parent_touch_enabled_device Record No
histogram_parent_tracking_protection_enabled Record No
histogram_parent_uptake_remote_content_result_1 Record No
histogram_parent_webext_background_page_load_ms Record No
histogram_parent_webext_browseraction_popup_open_ms Record No
histogram_parent_webext_browseraction_popup_preload_result_count Record No
histogram_parent_webext_content_script_injection_ms Record No
histogram_parent_webext_extension_startup_ms Record No
histogram_parent_webext_pageaction_popup_open_ms Record No
histogram_parent_webext_storage_local_get_ms Record No
histogram_parent_webext_storage_local_set_ms Record No
histogram_parent_webvr_time_spent_viewing_in_2d Record No
histogram_parent_webvr_time_spent_viewing_in_oculus Record No
histogram_parent_webvr_time_spent_viewing_in_openvr Record No
histogram_parent_webvr_users_view_in Record No
boolean_addon_scalars Record No
keyed_boolean_addon_scalars Record No
string_addon_scalars Record No
keyed_string_addon_scalars Record No
uint_addon_scalars Record No
keyed_uint_addon_scalars Record No
sample_id Integer Yes
experiment_branch String Yes
experiment_id String Yes
histogram_parent_devtools_about_devtools_opened_key Record No
scalar_content_media_blocked_no_metadata Integer Yes
histogram_parent_devtools_menu_eyedropper_opened_count Integer Yes
histogram_parent_devtools_fonteditor_n_fonts_rendered Record No
histogram_parent_devtools_layoutview_opened_count Integer Yes
histogram_parent_devtools_animationinspector_opened_count Integer Yes
histogram_parent_devtools_browserconsole_opened_count Integer Yes
histogram_parent_devtools_jsprofiler_opened_count Integer Yes
histogram_parent_devtools_responsive_opened_count Integer Yes
histogram_parent_devtools_dom_opened_count Integer Yes
histogram_parent_devtools_computedview_opened_count Integer Yes
scalar_content_media_blocked_no_metadata_endup_no_audio_track Integer Yes
histogram_parent_devtools_scratchpad_opened_count Integer Yes
histogram_parent_devtools_jsdebugger_opened_count Integer Yes
histogram_parent_devtools_fonteditor_font_type_displayed Record No
histogram_parent_devtools_picker_eyedropper_opened_count Integer Yes
histogram_parent_devtools_about_devtools_opened_reason Record No
histogram_parent_devtools_eyedropper_opened_count Integer Yes
histogram_parent_devtools_storage_opened_count Integer Yes
histogram_parent_devtools_webide_opened_count Integer Yes
histogram_parent_devtools_custom_opened_count Integer Yes
histogram_parent_devtools_ruleview_opened_count Integer Yes
histogram_parent_devtools_memory_opened_count Integer Yes
histogram_parent_devtools_styleeditor_opened_count Integer Yes
histogram_parent_devtools_netmonitor_opened_count Integer Yes
scalar_content_media_allowed_autoplay_no_audio_track_count Integer Yes
histogram_parent_devtools_webconsole_opened_count Integer Yes
histogram_parent_devtools_inspector_opened_count Integer Yes
histogram_parent_devtools_scratchpad_window_opened_count Integer Yes
histogram_parent_devtools_aboutdebugging_opened_count Integer Yes
histogram_parent_devtools_fonteditor_n_font_axes Record No
histogram_parent_devtools_paintflashing_opened_count Integer Yes
histogram_parent_devtools_options_opened_count Integer Yes
histogram_parent_devtools_fontinspector_opened_count Integer Yes
histogram_parent_devtools_jsbrowserdebugger_opened_count Integer Yes
histogram_parent_devtools_accessibility_picker_time_active_seconds Record No
histogram_parent_devtools_accessibility_time_active_seconds Record No
histogram_content_devtools_accessibility_service_time_active_seconds Record No
histogram_content_devtools_accessibility_time_active_seconds Record No
histogram_parent_devtools_accessibility_service_time_active_seconds Record No
histogram_content_devtools_accessibility_picker_time_active_seconds Record No
blank_window_shown Integer Yes
histogram_content_content_paint_time Record No
histogram_parent_content_paint_time Record No
scalar_parent_browser_engagement_navigation_webextension Record No
scalar_parent_dom_parentprocess_private_window_used Boolean Yes
histogram_gpu_composite_time Record No
histogram_parent_pwmgr_login_page_safety Record No
histogram_content_checkerboard_severity Record No
histogram_gpu_content_frame_time Record No
histogram_parent_pwmgr_manage_visibility_toggled Record No
histogram_parent_pwmgr_form_autofill_result Record No
histogram_parent_pwmgr_login_last_used_days Record No
histogram_gpu_checkerboard_severity Record No
histogram_parent_pwmgr_manage_deleted Integer Yes
histogram_parent_pwmgr_manage_copied_password Integer Yes
histogram_content_pwmgr_login_page_safety Record No
histogram_parent_composite_time Record No
histogram_parent_pwmgr_num_saved_passwords Record No
histogram_parent_content_frame_time Record No
histogram_parent_geolocation_request_granted Record No
histogram_content_composite_time Record No
histogram_parent_pwmgr_blocklist_num_sites Record No
histogram_content_geolocation_request_granted Record No
histogram_content_pwmgr_form_autofill_result Record No
histogram_parent_pwmgr_manage_copied_username Integer Yes
histogram_parent_pwmgr_prompt_update_action Record No
histogram_parent_pwmgr_num_passwords_per_hostname Record No
histogram_parent_pwmgr_saving_enabled Record No
histogram_parent_pwmgr_prompt_remember_action Record No
histogram_parent_checkerboard_severity Record No
histogram_parent_pwmgr_manage_opened Record No
scalar_parent_contentblocking_enabled Boolean Yes
scalar_parent_contentblocking_exceptions Integer Yes
scalar_parent_contentblocking_fastblock_enabled Boolean Yes
scalar_parent_resistfingerprinting_content_window_size Record No
histogram_parent_number_of_profiles Integer Yes
scalar_parent_telemetry_keyed_scalars_exceed_limit Record No
histogram_content_memory_unique_content_startup Record No
gfx_features_webrender_status String Yes
histogram_content_sandbox_rejected_syscalls Record No
gfx_features_wrqualified_status String Yes
histogram_parent_sandbox_rejected_syscalls Record No
user_pref_gfx_webrender_all_qualified Boolean Yes
scalar_parent_update_binarytransparencyresult Record No
histogram_parent_fx_page_load_ms_2 Record No
histogram_content_fx_page_load_ms_2 Record No
scalar_parent_devtools_markup_gridinspector_opened Integer Yes
scalar_parent_devtools_markup_flexboxhighlighter_opened Integer Yes
scalar_parent_devtools_layout_flexboxhighlighter_opened Integer Yes
scalar_parent_devtools_rules_flexboxhighlighter_opened Integer Yes
scalar_parent_devtools_accessibility_accessible_context_menu_item_activated Record No
scalar_parent_devtools_changesview_opened_count Integer Yes
scalar_parent_devtools_accessibility_accessible_context_menu_opened Integer Yes
scalar_parent_browser_search_ad_clicks Record No
scalar_parent_browser_search_with_ads Record No
scalar_content_encoding_override_used Boolean Yes
scalar_parent_idb_failure_fileinfo_error Integer Yes
scalar_parent_media_autoplay_default_blocked Boolean Yes
scalar_parent_startup_profile_selection_reason String Yes
scalar_parent_timestamps_about_home_topsites_first_paint Integer Yes
environment_settings_intl_accept_languages String No
environment_settings_intl_app_locales String No
environment_settings_intl_regional_prefs_locales String No
environment_settings_intl_system_locales String No
environment_settings_intl_requested_locales String No
environment_settings_intl_available_locales String No
scalar_parent_security_intermediate_preloading_num_preloaded Integer Yes
scalar_parent_security_intermediate_preloading_num_pending Integer Yes
scalar_parent_contentblocking_fingerprinting_blocking_enabled Boolean Yes
scalar_parent_contentblocking_cryptomining_blocking_enabled Boolean Yes
plugins_notification_shown_false Integer Yes
scalar_parent_contentblocking_category Integer Yes
scalar_parent_devtools_changesview_copy_rule Integer Yes
scalar_content_script_preloader_mainthread_recompile Integer Yes
scalar_parent_script_preloader_mainthread_recompile Integer Yes
scalar_parent_devtools_changesview_copy_all_changes Integer Yes
scalar_parent_normandy_recipe_freshness Record No
scalar_parent_devtools_inspector_element_picker_used Integer Yes
scalar_content_dom_event_confluence_load_count Record No
scalar_parent_browser_engagement_max_concurrent_tab_pinned_count Integer Yes
scalar_parent_browser_engagement_tab_pinned_event_count Integer Yes
scalar_parent_dom_contentprocess_os_priority_change_considered Integer Yes
scalar_parent_dom_contentprocess_os_priority_lowered Integer Yes
scalar_parent_dom_contentprocess_os_priority_raised Integer Yes
scalar_parent_networking_data_transferred Record No
scalar_content_webrtc_peerconnection_datachannel_max_life_used Integer Yes
scalar_content_webrtc_peerconnection_datachannel_created Integer Yes
scalar_parent_update_bitshresult Record No
scalar_parent_a11y_theme Record No
histogram_parent_dns_lookup_time Record No
histogram_parent_dns_failed_lookup_time Record No
scalar_parent_update_startup_downloads_bits_complete_bytes Integer Yes
scalar_parent_update_session_from_app_version String Yes
scalar_parent_update_session_mar_partial_size_bytes Integer Yes
scalar_parent_update_startup_intervals_apply_partial Integer Yes
scalar_parent_update_startup_downloads_internal_partial_seconds Integer Yes
scalar_parent_update_startup_downloads_internal_partial_bytes Integer Yes
scalar_parent_update_startup_mar_partial_size_bytes Integer Yes
scalar_parent_update_session_intervals_stage_complete Integer Yes
scalar_parent_update_startup_intervals_check Integer Yes
scalar_parent_update_session_downloads_internal_complete_seconds Integer Yes
scalar_parent_update_startup_downloads_bits_partial_seconds Integer Yes
scalar_parent_update_session_intervals_download_internal_partial Integer Yes
scalar_parent_update_session_intervals_check Integer Yes
scalar_parent_update_startup_intervals_download_bits_complete Integer Yes
scalar_parent_update_startup_intervals_download_internal_complete Integer Yes
scalar_parent_update_session_downloads_bits_partial_bytes Integer Yes
scalar_parent_update_startup_downloads_internal_complete_seconds Integer Yes
scalar_parent_update_startup_intervals_download_bits_partial Integer Yes
scalar_parent_update_startup_intervals_stage_complete Integer Yes
scalar_parent_update_startup_intervals_apply_complete Integer Yes
scalar_parent_update_startup_intervals_stage_partial Integer Yes
scalar_parent_update_session_intervals_download_internal_complete Integer Yes
scalar_parent_update_session_downloads_bits_partial_seconds Integer Yes
scalar_parent_update_startup_intervals_download_internal_partial Integer Yes
scalar_parent_update_session_downloads_internal_complete_bytes Integer Yes
scalar_parent_update_session_intervals_apply_partial Integer Yes
scalar_parent_update_session_downloads_internal_partial_seconds Integer Yes
scalar_parent_update_session_intervals_download_bits_complete Integer Yes
scalar_parent_update_session_downloads_bits_complete_bytes Integer Yes
scalar_parent_update_session_intervals_apply_complete Integer Yes
scalar_parent_update_session_downloads_internal_partial_bytes Integer Yes
scalar_parent_update_startup_downloads_internal_complete_bytes Integer Yes
scalar_parent_update_session_downloads_bits_complete_seconds Integer Yes
scalar_parent_update_startup_mar_complete_size_bytes Integer Yes
scalar_parent_update_startup_downloads_bits_complete_seconds Integer Yes
scalar_parent_update_startup_downloads_bits_partial_bytes Integer Yes
scalar_parent_update_session_mar_complete_size_bytes Integer Yes
scalar_parent_update_session_intervals_stage_partial Integer Yes
scalar_parent_update_startup_from_app_version String Yes
scalar_parent_update_session_intervals_download_bits_partial Integer Yes
scalar_parent_networking_data_transferred_kb Record No
scalar_parent_startup_is_cold Boolean Yes
user_pref_browser_search_region String Yes
environment_system_gfx_headless Boolean Yes
fxa_configured Boolean Yes
scalar_parent_devtools_accessibility_audit_activated Record No
scalar_parent_networking_data_transferred_v3_kb Record No
scalar_parent_devtools_inspector_node_selection_count Integer Yes
hdd_profile_type String Yes
hdd_binary_type String Yes
hdd_system_type String Yes
histogram_parent_update_status_error_code_partial_stage Record No
histogram_parent_update_status_error_code_complete_startup Record No
histogram_parent_update_state_code_complete_startup Record No
histogram_parent_update_download_code_complete Record No
histogram_parent_update_state_code_partial_startup Record No
histogram_parent_update_download_code_partial Record No
histogram_parent_update_state_code_partial_stage Record No
histogram_parent_update_state_code_complete_stage Record No
histogram_parent_update_status_error_code_partial_startup Record No
histogram_parent_update_status_error_code_complete_stage Record No
histogram_parent_update_bits_result_partial Record No
histogram_parent_update_bits_result_complete Record No
histogram_parent_update_can_use_bits_notify Record No
scalar_parent_devtools_tooltip_shown Record No
scalar_content_dom_event_office_online_load_count Record No
scalar_content_webrtc_video_send_codec_used Record No
scalar_content_webrtc_video_recv_codec_used Record No
scalar_parent_qm_origin_directory_unexpected_filename Record No
histogram_parent_cookie_behavior Record No
scalar_content_pictureinpicture_opened_method Record No
scalar_parent_pictureinpicture_closed_method Record No
user_pref_security_enterprise_roots_enabled Boolean Yes
user_pref_security_enterprise_roots_auto_enabled Boolean Yes
user_pref_security_pki_mitm_detected Boolean Yes
attribution_experiment String Yes
attribution_variation String Yes
user_pref_network_trr_mode Integer Yes
scalar_content_pdf_viewer_fallback_shown Integer Yes
scalar_content_pdf_viewer_print Integer Yes
scalar_content_pdf_viewer_used Integer Yes
scalar_parent_blocklist_lastmodified_rs_addons String Yes
scalar_parent_blocklist_usexml Boolean Yes
scalar_parent_blocklist_lastmodified_xml String Yes
scalar_parent_blocklist_lastmodified_rs_plugins String Yes
scalar_parent_os_environment_is_admin_without_uac Boolean Yes
scalar_parent_devtools_accessibility_simulation_activated Record No
scalar_parent_firststartup_statuscode Integer Yes
scalar_parent_pwmgr_potentially_breached_passwords Integer Yes
scalar_parent_contentblocking_trackers_blocked_count Integer Yes
scalar_parent_browser_searchinit_engines_cache_corrupted Boolean Yes
scalar_parent_update_fix_permissions_attempted Boolean Yes
scalar_parent_firststartup_elapsed Integer Yes
scalar_parent_security_contentblocker_permissions Record No
scalar_parent_a11y_backplate Boolean Yes
experiments_details Record No
scalar_parent_networking_ftp_opened_channels_listings Integer Yes
scalar_parent_networking_ftp_opened_channels_files Integer Yes
default_private_search_engine_data_load_path String Yes
default_private_search_engine_data_submission_url String Yes
default_private_search_engine_data_origin String Yes
default_private_search_engine_data_name String Yes
default_private_search_engine String Yes
histogram_content_memory_distribution_among_content Record No
e10s_cohort String Yes
scalar_parent_browser_session_restore_browser_tabs_restorebutton Integer Yes
histogram_parent_gc_max_pause_ms Record No
scalar_parent_browser_session_restore_browser_startup_page Integer Yes
histogram_content_memory_total Record No
histogram_content_gc_max_pause_ms Record No
experiment_enrollment_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry experiments_v1

Source Directory | View Definition | Metadata File


experiments_aggregates

Experiments Aggregates

telemetry.experiments_aggregates

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
experiment_branch String Yes
subgroup String Yes
n Integer Yes
metric_name String Yes
metric_type String Yes
histogram Record No
statistics Record No
experiment_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry experiments_aggregates_v1

Source Directory | View Definition | Metadata File


experiments_aggregates_v1

Experiments Aggregates V1

telemetry.experiments_aggregates_v1

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
experiment_branch String Yes
subgroup String Yes
n Integer Yes
metric_name String Yes
metric_type String Yes
histogram Record No
statistics Record No
experiment_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiments_aggregates_v1

Source Directory | View Definition | Metadata File


experiments_v1

Experiments V1

telemetry.experiments_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
submission_date Date Yes
document_id String Yes
client_id String Yes
channel String Yes
normalized_channel String Yes
normalized_os_version String Yes
country String Yes
city String Yes
geo_subdivision1 String Yes
geo_subdivision2 String Yes
os String Yes
os_version String Yes
os_service_pack_major Integer Yes
os_service_pack_minor Integer Yes
windows_build_number Integer Yes
windows_ubr Integer Yes
install_year Integer Yes
is_wow64 Boolean Yes
memory_mb Integer Yes
cpu_count Integer Yes
cpu_cores Integer Yes
cpu_vendor String Yes
cpu_family Integer Yes
cpu_model Integer Yes
cpu_stepping Integer Yes
cpu_l2_cache_kb Integer Yes
cpu_l3_cache_kb Integer Yes
cpu_speed_mhz Integer Yes
gfx_features_d3d11_status String Yes
gfx_features_d2d_status String Yes
gfx_features_gpu_process_status String Yes
gfx_features_advanced_layers_status String Yes
apple_model_id String Yes
antivirus String No
antispyware String No
firewall String No
profile_creation_date Integer Yes
profile_reset_date Integer Yes
previous_build_id String Yes
session_id String Yes
subsession_id String Yes
previous_session_id String Yes
previous_subsession_id String Yes
session_start_date String Yes
subsession_start_date String Yes
session_length Integer Yes
subsession_length Integer Yes
subsession_counter Integer Yes
profile_subsession_counter Integer Yes
creation_date String Yes
distribution_id String Yes
sync_configured Boolean Yes
sync_count_desktop Integer Yes
sync_count_mobile Integer Yes
app_build_id String Yes
app_display_version String Yes
app_name String Yes
app_version String Yes
timestamp Integer Yes
env_build_id String Yes
env_build_version String Yes
env_build_arch String Yes
e10s_enabled Boolean Yes
e10s_multi_processes Integer Yes
locale String Yes
update_channel String Yes
update_enabled Boolean Yes
update_auto_download Boolean Yes
attribution Record Yes
sandbox_effective_content_process_level Integer Yes
active_experiment_id String Yes
active_experiment_branch String Yes
reason String Yes
timezone_offset Integer Yes
plugin_hangs Integer Yes
aborts_plugin Integer Yes
aborts_content Integer Yes
aborts_gmplugin Integer Yes
crashes_detected_plugin Integer Yes
crashes_detected_content Integer Yes
crashes_detected_gmplugin Integer Yes
crash_submit_attempt_main Integer Yes
crash_submit_attempt_content Integer Yes
crash_submit_attempt_plugin Integer Yes
crash_submit_success_main Integer Yes
crash_submit_success_content Integer Yes
crash_submit_success_plugin Integer Yes
shutdown_kill Integer Yes
active_addons_count Integer Yes
flash_version String Yes
vendor String Yes
is_default_browser Boolean Yes
default_search_engine_data_name String Yes
default_search_engine_data_load_path String Yes
default_search_engine_data_origin String Yes
default_search_engine_data_submission_url String Yes
default_search_engine String Yes
devtools_toolbox_opened_count Integer Yes
client_submission_date String Yes
client_clock_skew Integer Yes
client_submission_latency Integer Yes
places_bookmarks_count Integer Yes
places_pages_count Integer Yes
push_api_notify Integer Yes
web_notification_shown Integer Yes
popup_notification_stats Record No
search_counts Record No
active_addons Record No
disabled_addons_ids String No
active_theme Record Yes
blocklist_enabled Boolean Yes
addon_compatibility_check_enabled Boolean Yes
telemetry_enabled Boolean Yes
user_prefs Record Yes
events Record No
ssl_handshake_result_success Integer Yes
ssl_handshake_result_failure Integer Yes
ssl_handshake_result Record No
active_ticks Integer Yes
main Integer Yes
first_paint Integer Yes
session_restored Integer Yes
total_time Integer Yes
plugins_notification_shown Integer Yes
plugins_notification_user_action Record Yes
plugins_infobar_shown Integer Yes
plugins_infobar_block Integer Yes
plugins_infobar_allow Integer Yes
plugins_infobar_dismissed Integer Yes
experiments Record No
search_cohort String Yes
gfx_compositor String Yes
quantum_ready Boolean Yes
gc_max_pause_ms_main_above_150 Integer Yes
gc_max_pause_ms_main_above_250 Integer Yes
gc_max_pause_ms_main_above_2500 Integer Yes
gc_max_pause_ms_content_above_150 Integer Yes
gc_max_pause_ms_content_above_250 Integer Yes
gc_max_pause_ms_content_above_2500 Integer Yes
cycle_collector_max_pause_main_above_150 Integer Yes
cycle_collector_max_pause_main_above_250 Integer Yes
cycle_collector_max_pause_main_above_2500 Integer Yes
cycle_collector_max_pause_content_above_150 Integer Yes
cycle_collector_max_pause_content_above_250 Integer Yes
cycle_collector_max_pause_content_above_2500 Integer Yes
input_event_response_coalesced_ms_main_above_150 Integer Yes
input_event_response_coalesced_ms_main_above_250 Integer Yes
input_event_response_coalesced_ms_main_above_2500 Integer Yes
input_event_response_coalesced_ms_content_above_150 Integer Yes
input_event_response_coalesced_ms_content_above_250 Integer Yes
input_event_response_coalesced_ms_content_above_2500 Integer Yes
ghost_windows_main_above_1 Integer Yes
ghost_windows_content_above_1 Integer Yes
user_pref_dom_ipc_plugins_sandbox_level_flash Integer Yes
user_pref_dom_ipc_processcount Integer Yes
user_pref_extensions_allow_non_mpc_extensions Boolean Yes
user_pref_extensions_legacy_enabled Boolean Yes
user_pref_browser_search_widget_innavbar Boolean Yes
user_pref_general_config_filename String Yes
scalar_content_browser_feeds_preview_loaded Integer Yes
scalar_content_browser_usage_graphite Integer Yes
scalar_content_browser_usage_plugin_instantiated Integer Yes
scalar_content_gfx_omtp_paint_wait_ratio Integer Yes
scalar_content_gfx_small_paint_phase_weight Record No
scalar_content_idb_type_persistent_count Integer Yes
scalar_content_idb_type_temporary_count Integer Yes
scalar_content_images_webp_content_frequency Record No
scalar_content_images_webp_content_observed Boolean Yes
scalar_content_images_webp_probe_observed Boolean Yes
scalar_content_mathml_doc_count Integer Yes
scalar_content_media_autoplay_would_be_allowed_count Integer Yes
scalar_content_media_autoplay_would_not_be_allowed_count Integer Yes
scalar_content_media_blocked_autoplay_no_audio_track_count Integer Yes
scalar_content_media_page_count Integer Yes
scalar_content_media_page_had_media_count Integer Yes
scalar_content_media_page_had_play_revoked_count Integer Yes
scalar_content_mediarecorder_recording_count Integer Yes
scalar_content_memoryreporter_max_ghost_windows Integer Yes
scalar_content_navigator_storage_estimate_count Integer Yes
scalar_content_navigator_storage_persist_count Integer Yes
scalar_content_sw_alternative_body_used_count Integer Yes
scalar_content_sw_cors_res_for_so_req_count Integer Yes
scalar_content_sw_synthesized_res_count Integer Yes
scalar_content_telemetry_accumulate_unknown_histogram_keys Record No
scalar_content_telemetry_discarded_accumulations Integer Yes
scalar_content_telemetry_discarded_child_events Integer Yes
scalar_content_telemetry_discarded_keyed_accumulations Integer Yes
scalar_content_telemetry_discarded_keyed_scalar_actions Integer Yes
scalar_content_telemetry_discarded_scalar_actions Integer Yes
scalar_content_telemetry_event_counts Record No
scalar_content_telemetry_profile_directory_scans Integer Yes
scalar_content_webrtc_nicer_stun_retransmits Integer Yes
scalar_content_webrtc_nicer_turn_401s Integer Yes
scalar_content_webrtc_nicer_turn_403s Integer Yes
scalar_content_webrtc_nicer_turn_438s Integer Yes
scalar_content_webrtc_peerconnection_connected Integer Yes
scalar_content_webrtc_peerconnection_legacy_callback_stats_used Integer Yes
scalar_content_webrtc_peerconnection_promise_and_callback_stats_used Integer Yes
scalar_content_webrtc_peerconnection_promise_stats_used Integer Yes
scalar_content_webrtc_sdp_parser_diff Record No
scalar_gpu_browser_usage_graphite Integer Yes
scalar_gpu_telemetry_accumulate_unknown_histogram_keys Record No
scalar_gpu_telemetry_discarded_accumulations Integer Yes
scalar_gpu_telemetry_discarded_child_events Integer Yes
scalar_gpu_telemetry_discarded_keyed_accumulations Integer Yes
scalar_gpu_telemetry_discarded_keyed_scalar_actions Integer Yes
scalar_gpu_telemetry_discarded_scalar_actions Integer Yes
scalar_gpu_telemetry_event_counts Record No
scalar_gpu_telemetry_profile_directory_scans Integer Yes
scalar_parent_a11y_indicator_acted_on Boolean Yes
scalar_parent_a11y_instantiators String Yes
scalar_parent_aushelper_websense_reg_version String Yes
scalar_parent_browser_engagement_active_ticks Integer Yes
scalar_parent_browser_engagement_max_concurrent_tab_count Integer Yes
scalar_parent_browser_engagement_max_concurrent_window_count Integer Yes
scalar_parent_browser_engagement_navigation_about_home Record No
scalar_parent_browser_engagement_navigation_about_newtab Record No
scalar_parent_browser_engagement_navigation_contextmenu Record No
scalar_parent_browser_engagement_navigation_searchbar Record No
scalar_parent_browser_engagement_navigation_urlbar Record No
scalar_parent_browser_engagement_restored_pinned_tabs_count Integer Yes
scalar_parent_browser_engagement_tab_open_event_count Integer Yes
scalar_parent_browser_engagement_total_uri_count Integer Yes
scalar_parent_browser_engagement_unfiltered_uri_count Integer Yes
scalar_parent_browser_engagement_unique_domains_count Integer Yes
scalar_parent_browser_engagement_window_open_event_count Integer Yes
scalar_parent_browser_errors_collected_count Integer Yes
scalar_parent_browser_errors_collected_count_by_filename Record No
scalar_parent_browser_errors_collected_with_stack_count Integer Yes
scalar_parent_browser_errors_reported_failure_count Integer Yes
scalar_parent_browser_errors_reported_success_count Integer Yes
scalar_parent_browser_errors_sample_rate String Yes
scalar_parent_browser_feeds_feed_subscribed Integer Yes
scalar_parent_browser_feeds_livebookmark_count Integer Yes
scalar_parent_browser_feeds_livebookmark_item_opened Integer Yes
scalar_parent_browser_feeds_livebookmark_opened Integer Yes
scalar_parent_browser_feeds_preview_loaded Integer Yes
scalar_parent_browser_session_restore_worker_restart_count Integer Yes
scalar_parent_browser_timings_last_shutdown Integer Yes
scalar_parent_browser_usage_graphite Integer Yes
scalar_parent_browser_usage_plugin_instantiated Integer Yes
scalar_parent_devtools_aboutdevtools_installed Integer Yes
scalar_parent_devtools_aboutdevtools_noinstall_exits Integer Yes
scalar_parent_devtools_aboutdevtools_opened Integer Yes
scalar_parent_devtools_accessibility_node_inspected_count Integer Yes
scalar_parent_devtools_accessibility_opened_count Integer Yes
scalar_parent_devtools_accessibility_picker_used_count Integer Yes
scalar_parent_devtools_accessibility_select_accessible_for_node Record No
scalar_parent_devtools_accessibility_service_enabled_count Integer Yes
scalar_parent_devtools_application_opened_count Integer Yes
scalar_parent_devtools_copy_full_css_selector_opened Integer Yes
scalar_parent_devtools_copy_unique_css_selector_opened Integer Yes
scalar_parent_devtools_copy_xpath_opened Integer Yes
scalar_parent_devtools_current_theme Record No
scalar_parent_devtools_grid_gridinspector_opened Integer Yes
scalar_parent_devtools_grid_showgridareasoverlay_checked Integer Yes
scalar_parent_devtools_grid_showgridlinenumbers_checked Integer Yes
scalar_parent_devtools_grid_showinfinitelines_checked Integer Yes
scalar_parent_devtools_inspector_three_pane_enabled Record No
scalar_parent_devtools_onboarding_is_devtools_user Boolean Yes
scalar_parent_devtools_responsive_open_trigger Record No
scalar_parent_devtools_responsive_toolbox_opened_first Integer Yes
scalar_parent_devtools_rules_gridinspector_opened Integer Yes
scalar_parent_devtools_shadowdom_reveal_link_clicked Boolean Yes
scalar_parent_devtools_shadowdom_shadow_root_displayed Boolean Yes
scalar_parent_devtools_shadowdom_shadow_root_expanded Boolean Yes
scalar_parent_devtools_tool_registered Record No
scalar_parent_devtools_toolbar_eyedropper_opened Integer Yes
scalar_parent_devtools_toolbox_tabs_reordered Record No
scalar_parent_dom_contentprocess_buildid_mismatch Integer Yes
scalar_parent_dom_contentprocess_troubled_due_to_memory Integer Yes
scalar_parent_extensions_updates_rdf Record No
scalar_parent_formautofill_addresses_fill_type_autofill Integer Yes
scalar_parent_formautofill_addresses_fill_type_autofill_update Integer Yes
scalar_parent_formautofill_addresses_fill_type_manual Integer Yes
scalar_parent_formautofill_availability Boolean Yes
scalar_parent_formautofill_creditcards_fill_type_autofill Integer Yes
scalar_parent_formautofill_creditcards_fill_type_autofill_modified Integer Yes
scalar_parent_formautofill_creditcards_fill_type_manual Integer Yes
scalar_parent_gfx_advanced_layers_failure_id Record No
scalar_parent_idb_type_persistent_count Integer Yes
scalar_parent_idb_type_temporary_count Integer Yes
scalar_parent_images_webp_content_frequency Record No
scalar_parent_images_webp_content_observed Boolean Yes
scalar_parent_images_webp_probe_observed Boolean Yes
scalar_parent_media_autoplay_would_be_allowed_count Integer Yes
scalar_parent_media_autoplay_would_not_be_allowed_count Integer Yes
scalar_parent_media_blocked_autoplay_no_audio_track_count Integer Yes
scalar_parent_media_page_count Integer Yes
scalar_parent_media_page_had_media_count Integer Yes
scalar_parent_media_page_had_play_revoked_count Integer Yes
scalar_parent_mediarecorder_recording_count Integer Yes
scalar_parent_navigator_storage_estimate_count Integer Yes
scalar_parent_navigator_storage_persist_count Integer Yes
scalar_parent_preferences_browser_home_page_change Record No
scalar_parent_preferences_browser_home_page_count Record No
scalar_parent_preferences_created_new_user_prefs_file Boolean Yes
scalar_parent_preferences_prefs_file_was_invalid Boolean Yes
scalar_parent_preferences_prevent_accessibility_services Boolean Yes
scalar_parent_preferences_read_user_js Boolean Yes
scalar_parent_preferences_search_query Record No
scalar_parent_preferences_use_bookmark Record No
scalar_parent_preferences_use_current_page Record No
scalar_parent_sandbox_no_job Record No
scalar_parent_screenshots_copy Integer Yes
scalar_parent_screenshots_download Integer Yes
scalar_parent_screenshots_upload Integer Yes
scalar_parent_security_client_cert Record No
scalar_parent_security_pkcs11_modules_loaded Record No
scalar_parent_security_webauthn_used Record No
scalar_parent_services_sync_sync_login_state_transitions Record No
scalar_parent_storage_sync_api_usage_extensions_using Integer Yes
scalar_parent_storage_sync_api_usage_items_stored Record No
scalar_parent_storage_sync_api_usage_storage_consumed Record No
scalar_parent_sw_alternative_body_used_count Integer Yes
scalar_parent_sw_cors_res_for_so_req_count Integer Yes
scalar_parent_sw_synthesized_res_count Integer Yes
scalar_parent_telemetry_accumulate_clamped_values Record No
scalar_parent_telemetry_accumulate_unknown_histogram_keys Record No
scalar_parent_telemetry_data_upload_optin Boolean Yes
scalar_parent_telemetry_event_counts Record No
scalar_parent_telemetry_os_shutting_down Boolean Yes
scalar_parent_telemetry_pending_operations_highwatermark_reached Integer Yes
scalar_parent_telemetry_persistence_timer_hit_count Integer Yes
scalar_parent_telemetry_profile_directory_scan_date Integer Yes
scalar_parent_telemetry_profile_directory_scans Integer Yes
scalar_parent_timestamps_first_paint Integer Yes
scalar_parent_webrtc_nicer_stun_retransmits Integer Yes
scalar_parent_webrtc_nicer_turn_401s Integer Yes
scalar_parent_webrtc_nicer_turn_403s Integer Yes
scalar_parent_webrtc_nicer_turn_438s Integer Yes
scalar_parent_webrtc_peerconnection_connected Integer Yes
scalar_parent_webrtc_peerconnection_legacy_callback_stats_used Integer Yes
scalar_parent_webrtc_peerconnection_promise_and_callback_stats_used Integer Yes
scalar_parent_webrtc_peerconnection_promise_stats_used Integer Yes
scalar_parent_widget_ime_name_on_linux Record No
scalar_parent_widget_ime_name_on_mac Record No
scalar_parent_widget_ime_name_on_windows Record No
histogram_content_cert_validation_success_by_ca Record No
histogram_content_cycle_collector_max_pause Record No
histogram_content_devtools_toolbox_time_active_seconds Record No
histogram_content_fx_new_window_ms Record No
histogram_content_fx_searchbar_selected_result_method Record No
histogram_content_fx_session_restore_restore_window_ms Record No
histogram_content_fx_session_restore_startup_init_session_ms Record No
histogram_content_fx_session_restore_startup_onload_initial_window_ms Record No
histogram_content_fx_tab_close_time_anim_ms Record No
histogram_content_fx_tab_switch_update_ms Record No
histogram_content_fx_urlbar_selected_result_index Record No
histogram_content_fx_urlbar_selected_result_index_by_type Record No
histogram_content_fx_urlbar_selected_result_method Record No
histogram_content_fx_urlbar_selected_result_type Record No
histogram_content_gc_animation_ms Record No
histogram_content_gc_max_pause_ms_2 Record No
histogram_content_ghost_windows Record No
histogram_content_gpu_process_initialization_time_ms Record No
histogram_content_gpu_process_launch_time_ms_2 Record No
histogram_content_http_channel_disposition Record No
histogram_content_http_pageload_is_ssl Record No
histogram_content_http_transaction_is_ssl Record No
histogram_content_input_event_response_coalesced_ms Record No
histogram_content_ipc_read_main_thread_latency_ms Record No
histogram_content_memory_heap_allocated Record No
histogram_content_memory_resident_fast Record No
histogram_content_memory_unique Record No
histogram_content_memory_vsize Record No
histogram_content_memory_vsize_max_contiguous Record No
histogram_content_network_cache_metadata_first_read_time_ms Record No
histogram_content_network_cache_v2_hit_time_ms Record No
histogram_content_network_cache_v2_miss_time_ms Record No
histogram_content_places_autocomplete_6_first_results_time_ms Record No
histogram_content_plugin_shutdown_ms Record No
histogram_content_search_reset_result Record No
histogram_content_search_service_init_ms Record No
histogram_content_ssl_handshake_result Record No
histogram_content_ssl_handshake_version Record No
histogram_content_ssl_tls12_intolerance_reason_pre Record No
histogram_content_ssl_tls13_intolerance_reason_pre Record No
histogram_content_time_to_dom_complete_ms Record No
histogram_content_time_to_dom_content_loaded_end_ms Record No
histogram_content_time_to_dom_content_loaded_start_ms Record No
histogram_content_time_to_dom_interactive_ms Record No
histogram_content_time_to_dom_loading_ms Record No
histogram_content_time_to_first_click_ms Record No
histogram_content_time_to_first_interaction_ms Record No
histogram_content_time_to_first_key_input_ms Record No
histogram_content_time_to_first_mouse_move_ms Record No
histogram_content_time_to_first_scroll_ms Record No
histogram_content_time_to_load_event_end_ms Record No
histogram_content_time_to_load_event_start_ms Record No
histogram_content_time_to_non_blank_paint_ms Record No
histogram_content_time_to_response_start_ms Record No
histogram_content_tracking_protection_enabled Record No
histogram_content_uptake_remote_content_result_1 Record No
histogram_content_webext_content_script_injection_ms Record No
histogram_content_webext_storage_local_get_ms Record No
histogram_content_webext_storage_local_set_ms Record No
histogram_content_webvr_time_spent_viewing_in_2d Record No
histogram_content_webvr_users_view_in Record No
histogram_gpu_gpu_process_initialization_time_ms Record No
histogram_gpu_ipc_read_main_thread_latency_ms Record No
histogram_gpu_uptake_remote_content_result_1 Record No
histogram_gpu_webvr_time_spent_viewing_in_oculus Record No
histogram_gpu_webvr_time_spent_viewing_in_openvr Record No
histogram_gpu_webvr_users_view_in Record No
histogram_parent_a11y_consumers Record No
histogram_parent_a11y_instantiated_flag Record No
histogram_parent_cert_validation_success_by_ca Record No
histogram_parent_cycle_collector_max_pause Record No
histogram_parent_devtools_entry_point Record No
histogram_parent_devtools_toolbox_time_active_seconds Record No
histogram_parent_fx_new_window_ms Record No
histogram_parent_fx_searchbar_selected_result_method Record No
histogram_parent_fx_session_restore_restore_window_ms Record No
histogram_parent_fx_session_restore_startup_init_session_ms Record No
histogram_parent_fx_session_restore_startup_onload_initial_window_ms Record No
histogram_parent_fx_tab_close_time_anim_ms Record No
histogram_parent_fx_tab_switch_total_e10s_ms Record No
histogram_parent_fx_tab_switch_update_ms Record No
histogram_parent_fx_urlbar_selected_result_index Record No
histogram_parent_fx_urlbar_selected_result_index_by_type Record No
histogram_parent_fx_urlbar_selected_result_method Record No
histogram_parent_fx_urlbar_selected_result_type Record No
histogram_parent_gc_animation_ms Record No
histogram_parent_gc_max_pause_ms_2 Record No
histogram_parent_ghost_windows Record No
histogram_parent_gpu_process_initialization_time_ms Record No
histogram_parent_gpu_process_launch_time_ms_2 Record No
histogram_parent_http_channel_disposition Record No
histogram_parent_http_pageload_is_ssl Record No
histogram_parent_http_transaction_is_ssl Record No
histogram_parent_input_event_response_coalesced_ms Record No
histogram_parent_ipc_read_main_thread_latency_ms Record No
histogram_parent_memory_distribution_among_content Record No
histogram_parent_memory_heap_allocated Record No
histogram_parent_memory_resident_fast Record No
histogram_parent_memory_total Record No
histogram_parent_memory_unique Record No
histogram_parent_memory_vsize Record No
histogram_parent_memory_vsize_max_contiguous Record No
histogram_parent_network_cache_metadata_first_read_time_ms Record No
histogram_parent_network_cache_v2_hit_time_ms Record No
histogram_parent_network_cache_v2_miss_time_ms Record No
histogram_parent_places_autocomplete_6_first_results_time_ms Record No
histogram_parent_plugin_shutdown_ms Record No
histogram_parent_search_reset_result Record No
histogram_parent_search_service_init_ms Record No
histogram_parent_ssl_handshake_result Record No
histogram_parent_ssl_handshake_version Record No
histogram_parent_ssl_tls12_intolerance_reason_pre Record No
histogram_parent_ssl_tls13_intolerance_reason_pre Record No
histogram_parent_time_to_first_click_ms Record No
histogram_parent_time_to_first_interaction_ms Record No
histogram_parent_time_to_first_key_input_ms Record No
histogram_parent_time_to_first_mouse_move_ms Record No
histogram_parent_time_to_first_scroll_ms Record No
histogram_parent_time_to_non_blank_paint_ms Record No
histogram_parent_time_to_response_start_ms Record No
histogram_parent_touch_enabled_device Record No
histogram_parent_tracking_protection_enabled Record No
histogram_parent_uptake_remote_content_result_1 Record No
histogram_parent_webext_background_page_load_ms Record No
histogram_parent_webext_browseraction_popup_open_ms Record No
histogram_parent_webext_browseraction_popup_preload_result_count Record No
histogram_parent_webext_content_script_injection_ms Record No
histogram_parent_webext_extension_startup_ms Record No
histogram_parent_webext_pageaction_popup_open_ms Record No
histogram_parent_webext_storage_local_get_ms Record No
histogram_parent_webext_storage_local_set_ms Record No
histogram_parent_webvr_time_spent_viewing_in_2d Record No
histogram_parent_webvr_time_spent_viewing_in_oculus Record No
histogram_parent_webvr_time_spent_viewing_in_openvr Record No
histogram_parent_webvr_users_view_in Record No
boolean_addon_scalars Record No
keyed_boolean_addon_scalars Record No
string_addon_scalars Record No
keyed_string_addon_scalars Record No
uint_addon_scalars Record No
keyed_uint_addon_scalars Record No
sample_id Integer Yes
experiment_branch String Yes
experiment_id String Yes
histogram_content_devtools_storage_opened_count Integer Yes
histogram_parent_devtools_about_devtools_opened_key Record No
scalar_content_media_blocked_no_metadata Integer Yes
histogram_parent_devtools_menu_eyedropper_opened_count Integer Yes
histogram_parent_devtools_fonteditor_n_fonts_rendered Record No
histogram_parent_devtools_layoutview_opened_count Integer Yes
histogram_content_devtools_webide_opened_count Integer Yes
histogram_content_devtools_canvasdebugger_opened_count Integer Yes
histogram_parent_devtools_animationinspector_opened_count Integer Yes
histogram_content_devtools_custom_opened_count Integer Yes
histogram_parent_devtools_browserconsole_opened_count Integer Yes
histogram_parent_devtools_jsprofiler_opened_count Integer Yes
histogram_content_devtools_webaudioeditor_opened_count Integer Yes
histogram_parent_devtools_responsive_opened_count Integer Yes
histogram_parent_devtools_dom_opened_count Integer Yes
histogram_parent_devtools_computedview_opened_count Integer Yes
histogram_content_devtools_layoutview_opened_count Integer Yes
scalar_parent_media_blocked_no_metadata_endup_no_audio_track Integer Yes
histogram_content_devtools_menu_eyedropper_opened_count Integer Yes
histogram_content_devtools_aboutdebugging_opened_count Integer Yes
histogram_parent_devtools_developertoolbar_opened_count Integer Yes
scalar_content_media_blocked_no_metadata_endup_no_audio_track Integer Yes
histogram_parent_devtools_canvasdebugger_opened_count Integer Yes
histogram_parent_devtools_scratchpad_opened_count Integer Yes
scalar_parent_media_blocked_no_metadata Integer Yes
histogram_parent_devtools_jsdebugger_opened_count Integer Yes
histogram_parent_devtools_fonteditor_font_type_displayed Record No
histogram_parent_devtools_picker_eyedropper_opened_count Integer Yes
histogram_content_devtools_scratchpad_window_opened_count Integer Yes
histogram_parent_devtools_about_devtools_opened_reason Record No
histogram_content_devtools_ruleview_opened_count Integer Yes
histogram_content_devtools_jsprofiler_opened_count Integer Yes
histogram_parent_devtools_eyedropper_opened_count Integer Yes
histogram_content_devtools_styleeditor_opened_count Integer Yes
histogram_content_devtools_picker_eyedropper_opened_count Integer Yes
histogram_content_devtools_webconsole_opened_count Integer Yes
histogram_content_devtools_animationinspector_opened_count Integer Yes
histogram_content_devtools_fontinspector_opened_count Integer Yes
histogram_content_devtools_shadereditor_opened_count Integer Yes
histogram_content_devtools_jsbrowserdebugger_opened_count Integer Yes
histogram_content_devtools_netmonitor_opened_count Integer Yes
histogram_parent_devtools_storage_opened_count Integer Yes
histogram_parent_devtools_webide_opened_count Integer Yes
histogram_content_devtools_eyedropper_opened_count Integer Yes
histogram_content_devtools_computedview_opened_count Integer Yes
histogram_content_devtools_inspector_opened_count Integer Yes
histogram_parent_devtools_custom_opened_count Integer Yes
histogram_parent_devtools_ruleview_opened_count Integer Yes
histogram_content_devtools_responsive_opened_count Integer Yes
histogram_parent_devtools_memory_opened_count Integer Yes
histogram_parent_devtools_styleeditor_opened_count Integer Yes
histogram_content_devtools_memory_opened_count Integer Yes
histogram_content_devtools_paintflashing_opened_count Integer Yes
histogram_parent_devtools_shadereditor_opened_count Integer Yes
histogram_parent_devtools_netmonitor_opened_count Integer Yes
histogram_content_devtools_dom_opened_count Integer Yes
histogram_content_devtools_browserconsole_opened_count Integer Yes
scalar_content_media_allowed_autoplay_no_audio_track_count Integer Yes
histogram_parent_devtools_webconsole_opened_count Integer Yes
histogram_content_devtools_jsdebugger_opened_count Integer Yes
histogram_parent_devtools_inspector_opened_count Integer Yes
histogram_parent_devtools_scratchpad_window_opened_count Integer Yes
histogram_content_devtools_developertoolbar_opened_count Integer Yes
histogram_parent_devtools_aboutdebugging_opened_count Integer Yes
scalar_parent_media_allowed_autoplay_no_audio_track_count Integer Yes
histogram_content_devtools_scratchpad_opened_count Integer Yes
histogram_parent_devtools_fonteditor_n_font_axes Record No
histogram_parent_devtools_webaudioeditor_opened_count Integer Yes
histogram_parent_devtools_paintflashing_opened_count Integer Yes
histogram_parent_devtools_options_opened_count Integer Yes
histogram_parent_devtools_fontinspector_opened_count Integer Yes
histogram_content_devtools_options_opened_count Integer Yes
histogram_parent_devtools_jsbrowserdebugger_opened_count Integer Yes
histogram_parent_devtools_accessibility_picker_time_active_seconds Record No
histogram_parent_devtools_accessibility_time_active_seconds Record No
histogram_content_devtools_accessibility_service_time_active_seconds Record No
histogram_content_devtools_accessibility_time_active_seconds Record No
histogram_parent_devtools_accessibility_service_time_active_seconds Record No
histogram_content_devtools_accessibility_picker_time_active_seconds Record No
blank_window_shown Integer Yes
histogram_content_content_paint_time Record No
histogram_parent_content_paint_time Record No
scalar_parent_browser_engagement_navigation_webextension Record No
scalar_parent_dom_parentprocess_private_window_used Boolean Yes
histogram_gpu_composite_time Record No
histogram_parent_pwmgr_login_page_safety Record No
histogram_content_checkerboard_severity Record No
histogram_gpu_content_frame_time Record No
histogram_parent_pwmgr_manage_visibility_toggled Record No
histogram_parent_pwmgr_form_autofill_result Record No
histogram_parent_pwmgr_login_last_used_days Record No
histogram_gpu_checkerboard_severity Record No
histogram_parent_pwmgr_manage_deleted Integer Yes
histogram_parent_pwmgr_manage_copied_password Integer Yes
histogram_content_pwmgr_login_page_safety Record No
histogram_content_pwmgr_manage_deleted Integer Yes
histogram_parent_composite_time Record No
histogram_parent_pwmgr_num_saved_passwords Record No
histogram_content_pwmgr_manage_copied_password Integer Yes
histogram_parent_content_frame_time Record No
histogram_parent_geolocation_request_granted Record No
histogram_content_composite_time Record No
histogram_parent_pwmgr_blocklist_num_sites Record No
histogram_content_geolocation_request_granted Record No
histogram_content_pwmgr_manage_copied_username Integer Yes
histogram_content_pwmgr_form_autofill_result Record No
histogram_parent_pwmgr_manage_copied_username Integer Yes
histogram_parent_pwmgr_prompt_update_action Record No
histogram_parent_pwmgr_num_passwords_per_hostname Record No
histogram_parent_pwmgr_saving_enabled Record No
histogram_parent_pwmgr_prompt_remember_action Record No
histogram_parent_checkerboard_severity Record No
histogram_parent_pwmgr_manage_opened Record No
scalar_parent_contentblocking_enabled Boolean Yes
scalar_parent_contentblocking_exceptions Integer Yes
scalar_parent_contentblocking_fastblock_enabled Boolean Yes
scalar_parent_resistfingerprinting_content_window_size Record No
user_pref_marionette_enabled Boolean Yes
scalar_parent_identity_fxaccounts_missed_commands_fetched Integer Yes
scalar_parent_devtools_webreplay_reload_recording Integer Yes
scalar_parent_devtools_webreplay_stop_recording Integer Yes
scalar_parent_devtools_webreplay_load_recording Integer Yes
scalar_parent_devtools_webreplay_new_recording Integer Yes
scalar_parent_devtools_webreplay_save_recording Integer Yes
histogram_parent_number_of_profiles Integer Yes
histogram_content_number_of_profiles Integer Yes
scalar_parent_telemetry_keyed_scalars_exceed_limit Record No
histogram_content_memory_unique_content_startup Record No
gfx_features_webrender_status String Yes
histogram_content_sandbox_rejected_syscalls Record No
gfx_features_wrqualified_status String Yes
histogram_parent_sandbox_rejected_syscalls Record No
user_pref_gfx_webrender_all_qualified Boolean Yes
user_pref_privacy_fuzzyfox_enabled Boolean Yes
scalar_parent_update_binarytransparencyresult Record No
histogram_parent_fx_page_load_ms_2 Record No
histogram_content_fx_page_load_ms_2 Record No
scalar_parent_devtools_markup_gridinspector_opened Integer Yes
scalar_parent_devtools_markup_flexboxhighlighter_opened Integer Yes
scalar_parent_devtools_layout_flexboxhighlighter_opened Integer Yes
scalar_parent_devtools_rules_flexboxhighlighter_opened Integer Yes
scalar_parent_devtools_accessibility_accessible_context_menu_item_activated Record No
scalar_parent_devtools_changesview_opened_count Integer Yes
scalar_parent_devtools_accessibility_accessible_context_menu_opened Integer Yes
scalar_parent_browser_search_ad_clicks Record No
scalar_parent_browser_search_with_ads Record No
scalar_parent_encoding_override_used Boolean Yes
scalar_content_encoding_override_used Boolean Yes
scalar_parent_telemetry_about_telemetry_pageload Integer Yes
scalar_parent_idb_failure_fileinfo_error Integer Yes
scalar_content_media_autoplay_default_blocked Boolean Yes
scalar_parent_media_autoplay_default_blocked Boolean Yes
scalar_parent_devtools_changesview_contextmenu Integer Yes
scalar_parent_devtools_changesview_contextmenu_copy Integer Yes
scalar_parent_devtools_changesview_copy Integer Yes
scalar_parent_gfx_hdr_windows_display_colorspace_bitfield Integer Yes
scalar_parent_startup_profile_selection_reason String Yes
scalar_parent_timestamps_about_home_topsites_first_paint Integer Yes
environment_settings_intl_accept_languages String No
environment_settings_intl_app_locales String No
environment_settings_intl_regional_prefs_locales String No
environment_settings_intl_system_locales String No
environment_settings_intl_requested_locales String No
environment_settings_intl_available_locales String No
scalar_parent_security_intermediate_preloading_num_preloaded Integer Yes
scalar_content_telemetry_process_creation_timestamp_inconsistent Integer Yes
scalar_parent_security_intermediate_preloading_num_pending Integer Yes
scalar_parent_telemetry_process_creation_timestamp_inconsistent Integer Yes
scalar_parent_contentblocking_fingerprinting_blocking_enabled Boolean Yes
scalar_parent_contentblocking_cryptomining_blocking_enabled Boolean Yes
plugins_notification_shown_false Integer Yes
scalar_parent_contentblocking_category Integer Yes
scalar_parent_devtools_changesview_copy_rule Integer Yes
user_pref_browser_launcherprocess_enabled Boolean Yes
scalar_parent_devtools_changesview_contextmenu_copy_declaration Integer Yes
scalar_content_script_preloader_mainthread_recompile Integer Yes
scalar_parent_script_preloader_mainthread_recompile Integer Yes
scalar_parent_devtools_changesview_copy_all_changes Integer Yes
scalar_parent_devtools_changesview_contextmenu_copy_rule Integer Yes
scalar_parent_normandy_recipe_freshness Record No
scalar_parent_devtools_inspector_element_picker_used Integer Yes
scalar_content_dom_event_confluence_load_count Record No
scalar_parent_browser_engagement_max_concurrent_tab_pinned_count Integer Yes
scalar_parent_browser_engagement_tab_pinned_event_count Integer Yes
scalar_parent_dom_contentprocess_os_priority_change_considered Integer Yes
scalar_parent_dom_contentprocess_os_priority_lowered Integer Yes
scalar_parent_dom_contentprocess_os_priority_raised Integer Yes
scalar_parent_networking_data_transferred Record No
scalar_parent_webrtc_peerconnection_datachannel_max_life_used Integer Yes
scalar_parent_webrtc_peerconnection_datachannel_max_retx_and_life_used Integer Yes
scalar_content_webrtc_peerconnection_datachannel_max_retx_and_life_used Integer Yes
scalar_content_webrtc_peerconnection_datachannel_max_retx_used Integer Yes
scalar_parent_webrtc_peerconnection_datachannel_created Integer Yes
scalar_content_webrtc_peerconnection_datachannel_max_life_used Integer Yes
scalar_content_webrtc_peerconnection_datachannel_created Integer Yes
scalar_parent_webrtc_peerconnection_datachannel_max_retx_used Integer Yes
scalar_parent_update_bitshresult Record No
scalar_parent_a11y_theme Record No
histogram_parent_dns_lookup_time Record No
histogram_parent_dns_failed_lookup_time Record No
scalar_parent_update_startup_downloads_bits_complete_bytes Integer Yes
scalar_parent_update_session_from_app_version String Yes
scalar_parent_update_session_mar_partial_size_bytes Integer Yes
scalar_parent_networking_http_connections_captive_portal Integer Yes
scalar_parent_update_startup_intervals_apply_partial Integer Yes
scalar_parent_networking_http_transactions_captive_portal Integer Yes
scalar_parent_update_startup_downloads_internal_partial_seconds Integer Yes
scalar_parent_update_startup_downloads_internal_partial_bytes Integer Yes
scalar_parent_update_startup_mar_partial_size_bytes Integer Yes
scalar_parent_update_session_intervals_stage_complete Integer Yes
scalar_parent_update_startup_intervals_check Integer Yes
scalar_parent_update_session_downloads_internal_complete_seconds Integer Yes
scalar_parent_update_startup_downloads_bits_partial_seconds Integer Yes
scalar_parent_update_session_intervals_download_internal_partial Integer Yes
scalar_parent_update_session_intervals_check Integer Yes
scalar_parent_update_startup_intervals_download_bits_complete Integer Yes
scalar_parent_update_startup_intervals_download_internal_complete Integer Yes
scalar_parent_update_session_downloads_bits_partial_bytes Integer Yes
scalar_parent_update_startup_downloads_internal_complete_seconds Integer Yes
scalar_parent_update_startup_intervals_download_bits_partial Integer Yes
scalar_parent_update_startup_intervals_stage_complete Integer Yes
scalar_parent_update_startup_intervals_apply_complete Integer Yes
scalar_parent_update_startup_intervals_stage_partial Integer Yes
scalar_parent_update_session_intervals_download_internal_complete Integer Yes
scalar_parent_update_session_downloads_bits_partial_seconds Integer Yes
scalar_parent_update_startup_intervals_download_internal_partial Integer Yes
scalar_parent_update_session_downloads_internal_complete_bytes Integer Yes
scalar_parent_update_session_intervals_apply_partial Integer Yes
scalar_parent_update_session_downloads_internal_partial_seconds Integer Yes
scalar_parent_update_session_intervals_download_bits_complete Integer Yes
scalar_parent_update_session_downloads_bits_complete_bytes Integer Yes
scalar_parent_networking_data_transferred_captive_portal Integer Yes
scalar_parent_update_session_intervals_apply_complete Integer Yes
scalar_parent_update_session_downloads_internal_partial_bytes Integer Yes
scalar_parent_update_startup_downloads_internal_complete_bytes Integer Yes
scalar_parent_update_session_downloads_bits_complete_seconds Integer Yes
scalar_parent_update_startup_mar_complete_size_bytes Integer Yes
scalar_parent_update_startup_downloads_bits_complete_seconds Integer Yes
scalar_parent_update_startup_downloads_bits_partial_bytes Integer Yes
scalar_parent_update_session_mar_complete_size_bytes Integer Yes
scalar_parent_update_session_intervals_stage_partial Integer Yes
scalar_parent_update_startup_from_app_version String Yes
scalar_parent_update_session_intervals_download_bits_partial Integer Yes
scalar_parent_corroborate_omnijar_corrupted Boolean Yes
scalar_parent_corroborate_system_addons_corrupted Boolean Yes
scalar_parent_networking_data_transferred_kb Record No
scalar_parent_telemetry_ecosystem_old_send_time String Yes
scalar_parent_telemetry_ecosystem_new_send_time String Yes
scalar_parent_startup_is_cold Boolean Yes
user_pref_browser_search_region String Yes
environment_system_gfx_headless Boolean Yes
fxa_configured Boolean Yes
scalar_parent_devtools_accessibility_audit_activated Record No
scalar_parent_networking_data_transferred_v3_kb Record No
scalar_parent_devtools_inspector_node_selection_count Integer Yes
hdd_profile_type String Yes
hdd_binary_type String Yes
hdd_system_type String Yes
histogram_parent_update_status_error_code_partial_stage Record No
histogram_parent_update_status_error_code_complete_startup Record No
histogram_parent_update_state_code_complete_startup Record No
histogram_parent_update_download_code_complete Record No
histogram_parent_update_state_code_partial_startup Record No
histogram_parent_update_download_code_partial Record No
histogram_parent_update_state_code_partial_stage Record No
histogram_parent_update_state_code_complete_stage Record No
histogram_parent_update_status_error_code_partial_startup Record No
histogram_parent_update_status_error_code_complete_stage Record No
histogram_parent_update_bits_result_partial Record No
histogram_parent_update_bits_result_complete Record No
histogram_parent_update_can_use_bits_notify Record No
scalar_parent_devtools_tooltip_shown Record No
scalar_content_dom_event_office_online_load_count Record No
scalar_content_webrtc_video_send_codec_used Record No
scalar_content_webrtc_video_recv_codec_used Record No
scalar_parent_qm_origin_directory_unexpected_filename Record No
histogram_parent_cookie_behavior Record No
scalar_content_pictureinpicture_opened_method Record No
scalar_parent_pictureinpicture_closed_method Record No
user_pref_security_enterprise_roots_enabled Boolean Yes
user_pref_security_enterprise_roots_auto_enabled Boolean Yes
user_pref_security_pki_mitm_detected Boolean Yes
attribution_experiment String Yes
attribution_variation String Yes
user_pref_network_trr_mode Integer Yes
scalar_content_pdf_viewer_fallback_shown Integer Yes
scalar_content_pdf_viewer_print Integer Yes
scalar_parent_pdf_viewer_fallback_shown Integer Yes
scalar_parent_pdf_viewer_used Integer Yes
scalar_parent_pdf_viewer_print Integer Yes
scalar_content_pdf_viewer_used Integer Yes
scalar_parent_blocklist_lastmodified_rs_addons String Yes
scalar_parent_blocklist_usexml Boolean Yes
scalar_parent_blocklist_lastmodified_xml String Yes
scalar_parent_blocklist_lastmodified_rs_plugins String Yes
scalar_parent_os_environment_is_admin_without_uac Boolean Yes
scalar_parent_devtools_accessibility_simulation_activated Record No
scalar_parent_firststartup_statuscode Integer Yes
scalar_parent_pwmgr_potentially_breached_passwords Integer Yes
scalar_parent_contentblocking_trackers_blocked_count Integer Yes
scalar_parent_webrtc_hostnameobfuscation_disabled_succeeded Integer Yes
scalar_parent_webrtc_hostnameobfuscation_enabled_succeeded Integer Yes
scalar_parent_webrtc_hostnameobfuscation_disabled_failed Integer Yes
scalar_content_webrtc_hostnameobfuscation_disabled_failed Integer Yes
scalar_content_webrtc_hostnameobfuscation_enabled_failed Integer Yes
scalar_content_webrtc_hostnameobfuscation_enabled_succeeded Integer Yes
scalar_parent_webrtc_hostnameobfuscation_enabled_failed Integer Yes
scalar_content_webrtc_hostnameobfuscation_disabled_succeeded Integer Yes
scalar_parent_browser_searchinit_engines_cache_corrupted Boolean Yes
scalar_parent_update_fix_permissions_attempted Boolean Yes
scalar_parent_firststartup_elapsed Integer Yes
scalar_parent_security_contentblocker_permissions Record No
scalar_parent_a11y_backplate Boolean Yes
scalar_parent_security_tls_delegated_credentials_txn Integer Yes
experiments_details Record No
scalar_parent_networking_ftp_opened_channels_listings Integer Yes
scalar_parent_networking_ftp_opened_channels_files Integer Yes
default_private_search_engine_data_load_path String Yes
default_private_search_engine_data_submission_url String Yes
default_private_search_engine_data_origin String Yes
default_private_search_engine_data_name String Yes
default_private_search_engine String Yes
scalar_parent_datasanitization_privacy_clearonshutdown_history Boolean Yes
scalar_parent_datasanitization_privacy_clearonshutdown_cookies Boolean Yes
scalar_parent_datasanitization_privacy_sanitize_sanitizeonshutdown Boolean Yes
scalar_parent_datasanitization_session_permission_exceptions Integer Yes
scalar_parent_datasanitization_privacy_clearonshutdown_openwindows Boolean Yes
scalar_parent_datasanitization_privacy_clearonshutdown_formdata Boolean Yes
scalar_parent_datasanitization_privacy_clearonshutdown_cache Boolean Yes
scalar_parent_datasanitization_privacy_clearonshutdown_sitesettings Boolean Yes
scalar_parent_datasanitization_privacy_clearonshutdown_sessions Boolean Yes
scalar_parent_datasanitization_privacy_clearonshutdown_downloads Boolean Yes
scalar_parent_datasanitization_network_cookie_lifetimepolicy Integer Yes
scalar_parent_datasanitization_privacy_clearonshutdown_offlineapps Boolean Yes
push_api_notification_received Integer Yes
loop_activity_counter Record Yes
scalar_parent_browser_session_restore_tabbar_restore_clicked Boolean Yes
scalar_parent_services_sync_fxa_verification_method String Yes
histogram_content_memory_distribution_among_content Record No
scalar_parent_browser_session_restore_number_of_win Integer Yes
scalar_parent_browser_session_restore_tabbar_restore_available Boolean Yes
e10s_cohort String Yes
scalar_parent_browser_session_restore_browser_tabs_restorebutton Integer Yes
histogram_parent_gc_max_pause_ms Record No
scalar_parent_browser_session_restore_number_of_tabs Integer Yes
scalar_parent_browser_session_restore_browser_startup_page Integer Yes
histogram_content_memory_total Record No
histogram_content_gc_max_pause_ms Record No
experiment_enrollment_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiments_v0
moz-fx-data-shared-prod telemetry_derived experiments_v1

Source Directory | View Definition | Metadata File


feature_usage

Feature Usage

telemetry.feature_usage

Please provide a description for the query

Schema
Column Description Type Nullable
client_id String Yes
submission_date Date Yes
activity_segments_v1 String Yes
is_allweek_regular_v1 Boolean Yes
is_weekday_regular_v1 Boolean Yes
is_core_active_v1 Boolean Yes
days_since_first_seen Integer Yes
days_since_seen Integer Yes
new_profile_7_day_activated_v1 Boolean Yes
new_profile_14_day_activated_v1 Boolean Yes
new_profile_21_day_activated_v1 Boolean Yes
first_seen_date Date Yes
days_since_created_profile Integer Yes
profile_creation_date String Yes
country String Yes
scalar_parent_os_environment_is_taskbar_pinned Boolean Yes
scalar_parent_os_environment_launched_via_desktop Boolean Yes
scalar_parent_os_environment_launched_via_other Boolean Yes
scalar_parent_os_environment_launched_via_taskbar Boolean Yes
scalar_parent_os_environment_launched_via_start_menu Boolean Yes
scalar_parent_os_environment_launched_via_other_shortcut Boolean Yes
os String Yes
normalized_os_version String Yes
app_version String Yes
attributed Boolean Yes
is_default_browser Boolean Yes
sync_count_desktop_mean Float Yes
sync_count_mobile_mean Float Yes
active_hours_sum Float Yes
scalar_parent_browser_engagement_total_uri_count_sum Numeric Yes
ad_clicks_count_all Integer Yes
scalar_parent_browser_engagement_tab_open_event_count_sum Integer Yes
scalar_parent_browser_engagement_window_open_event_count_sum Integer Yes
scalar_parent_browser_engagement_unique_domains_count_max Integer Yes
scalar_parent_browser_engagement_unique_domains_count_mean Float Yes
scalar_parent_browser_engagement_max_concurrent_tab_count_max Integer Yes
scalar_parent_browser_engagement_max_concurrent_window_count_max Integer Yes
search_count_abouthome Integer Yes
search_count_all Integer Yes
search_count_contextmenu Integer Yes
search_count_newtab Integer Yes
search_count_organic Integer Yes
search_count_searchbar Integer Yes
search_count_system Integer Yes
search_count_tagged_follow_on Integer Yes
search_count_tagged_sap Integer Yes
search_count_urlbar Integer Yes
search_with_ads_count_all Integer Yes
subsample_id Integer Yes
is_headless Boolean Yes
video_play_time_ms Integer Yes
video_encrypted_play_time_ms Integer Yes
pdf_viewer_time_to_view_ms_content Integer Yes
pip_window_open_duration Integer Yes
video_play_time_ms_count Integer Yes
video_encrypted_play_time_ms_count Integer Yes
pdf_viewer_time_to_view_ms_content_count Integer Yes
pip_window_open_duration_count Integer Yes
pdf_viewer_doc_size_kb Integer Yes
pdf_viewer_doc_size_kb_content Integer Yes
pdf_viewer_doc_size_kb_count Integer Yes
pdf_viewer_doc_size_kb_content_count Integer Yes
sync_signed_in Boolean Yes
ccards_saved Boolean Yes
pbm_used Boolean Yes
unique_sidebars_accessed_count Integer Yes
sidebars_accessed_total Integer Yes
unique_history_urlbar_indices_picked_count Integer Yes
history_urlbar_picked_total Integer Yes
unique_remotetab_indices_picked_count Integer Yes
remotetab_picked_total Integer Yes
uris_from_newtab Integer Yes
uris_from_searchbar Integer Yes
uris_from_urlbar Integer Yes
nav_history_urlbar Integer Yes
nav_autocomplete_urlbar Integer Yes
nav_visiturl_urlbar Integer Yes
nav_searchsuggestion_urlbar Integer Yes
nav_topsite_urlbar Integer Yes
num_passwords_saved Integer Yes
unique_preferences_accessed_count Integer Yes
preferences_accessed_total Integer Yes
unique_bookmarks_bar_accessed_count Integer Yes
bookmarks_bar_accessed_total Integer Yes
unique_keyboard_shortcut_count Integer Yes
keyboard_shortcut_total Integer Yes
pip_count Integer Yes
viewed_protection_report_count Integer Yes
etp_toggle_off Integer Yes
etp_toggle_on Integer Yes
protections_popup Integer Yes
ccard_filled Integer Yes
ccard_saved Integer Yes
installed_extension Integer Yes
installed_theme Integer Yes
installed_l10n Integer Yes
used_stored_pw Integer Yes
password_filled Integer Yes
password_saved Integer Yes
pwmgr_opened Integer Yes
pwmgr_copy_or_show_info Integer Yes
pwmgr_interacted_breach Integer Yes
generated_password Integer Yes
fxa_connect Integer Yes
normandy_enrolled Integer Yes
downloads Integer Yes
pdf_downloads Integer Yes
image_downloads Integer Yes
media_downloads Integer Yes
msoffice_downloads Integer Yes
newtab_click Integer Yes
bookmark_added_from_newtab Integer Yes
saved_to_pocket_from_newtab Integer Yes
newtab_prefs_opened Integer Yes
activitystream_reported_3rdparty_abouthome Boolean Yes
activitystream_reported_3rdparty_aboutnewtab Boolean Yes
activitystream_reported_3rdparty_both Boolean Yes
activitystream_topsite_clicks Integer Yes
activitystream_highlight_clicks Integer Yes
activitystream_pocket_clicks Integer Yes
activitystream_reported_newtab_search_off Boolean Yes
activitystream_reported_topsites_off Boolean Yes
activitystream_reported_pocket_off Boolean Yes
activitystream_reported_highlights_off Boolean Yes
activitystream_reported_sponsored_topsites_off Boolean Yes
activitystream_sessions_abouthome Integer Yes
activitystream_sessions_newtab Integer Yes
activitystream_sessions_both Integer Yes
num_addblockers Integer Yes
has_notes_extension Boolean Yes
has_facebook_container_extension Boolean Yes
has_multiaccount_container_extension Boolean Yes
has_private_relay_extension Boolean Yes
newtabpage_disabled Boolean Yes
num_topsites_new_tab_impressions_sponsored Integer Yes
num_new_tab_topsites_clicks_sponsored Integer Yes
activitystream_sponsored_pocket_clicks Integer Yes
activitystream_sponsored_topsite_clicks Integer Yes
activitystream_organic_pocket_clicks Integer Yes
activitystream_organic_topsite_clicks Integer Yes
activitystream_reported_sponsored_topstories_off Boolean Yes
search_count_urlbar_handoff Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived feature_usage_v2

Source Directory | View Definition | Metadata File


fenix_clients_last_seen

Fenix Clients Last Seen

telemetry.fenix_clients_last_seen

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_fenix_nightly baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_fennec_aurora baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox_beta baseline_clients_last_seen

Source Directory | View Definition | Metadata File


fenix_events_v1

Fenix Events V1

telemetry.fenix_events_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix_stable events_v1

Source Directory | View Definition | Metadata File


fennec_ios_events_v1

Fennec Ios Events V1

telemetry.fennec_ios_events_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry mobile_event

Source Directory | View Definition | Metadata File


firefox_accounts_exact_mau28_by_dimensions

Firefox Accounts Exact Mau28 By Dimensions

telemetry.firefox_accounts_exact_mau28_by_dimensions

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
id_bucket Integer Yes
country String Yes
seen_in_tier1_country_mau Integer Yes
country_code String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_accounts_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_accounts_exact_mau28_by_dimensions_v1

Firefox Accounts Exact Mau28 By Dimensions V1

telemetry.firefox_accounts_exact_mau28_by_dimensions_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
id_bucket Integer Yes
country String Yes
seen_in_tier1_country_mau Integer Yes
country_code String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_accounts_derived exact_mau28_v1
moz-fx-data-shared-prod static country_names_v1

Source Directory | View Definition | Metadata File


firefox_accounts_exact_mau28_v1

Firefox Accounts Exact Mau28 V1

telemetry.firefox_accounts_exact_mau28_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_accounts_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_desktop_exact_mau28

Firefox Desktop Exact Mau28

telemetry.firefox_desktop_exact_mau28

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
tier1_wau Integer Yes
tier1_dau Integer Yes
visited_5_uri_mau Integer Yes
visited_5_uri_wau Integer Yes
visited_5_uri_dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_desktop_exact_mau28_v1

Source Directory | View Definition | Metadata File


firefox_desktop_exact_mau28_by_client_count_dimensions

Firefox Desktop Exact Mau28 By Client Count Dimensions

telemetry.firefox_desktop_exact_mau28_by_client_count_dimensions

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
visited_5_uri_mau Integer Yes
visited_5_uri_wau Integer Yes
visited_5_uri_dau Integer Yes
dev_tools_mau Integer Yes
dev_tools_wau Integer Yes
dev_tools_dau Integer Yes
app_name String Yes
app_version String Yes
country String Yes
locale String Yes
normalized_channel String Yes
os String Yes
os_version String Yes
distribution_id String Yes
country_name String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_desktop_exact_mau28_by_client_count_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_desktop_exact_mau28_by_dimensions

Firefox Desktop Exact Mau28 By Dimensions

telemetry.firefox_desktop_exact_mau28_by_dimensions

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
visited_5_uri_mau Integer Yes
visited_5_uri_wau Integer Yes
visited_5_uri_dau Integer Yes
id_bucket Integer Yes
source String Yes
medium String Yes
campaign String Yes
content String Yes
country String Yes
country_name String Yes
distribution_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_desktop_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_desktop_exact_mau28_by_dimensions_v1

Firefox Desktop Exact Mau28 By Dimensions V1

telemetry.firefox_desktop_exact_mau28_by_dimensions_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
visited_5_uri_mau Integer Yes
visited_5_uri_wau Integer Yes
visited_5_uri_dau Integer Yes
id_bucket Integer Yes
source String Yes
medium String Yes
campaign String Yes
content String Yes
country String Yes
country_name String Yes
distribution_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_desktop_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_desktop_exact_mau28_v1

Firefox Desktop Exact Mau28 V1

telemetry.firefox_desktop_exact_mau28_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
tier1_wau Integer Yes
tier1_dau Integer Yes
visited_5_uri_mau Integer Yes
visited_5_uri_wau Integer Yes
visited_5_uri_dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod static firefox_desktop_imputed_mau28_v1
moz-fx-data-shared-prod telemetry_derived firefox_desktop_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_desktop_usage_2021

Firefox Desktop Usage 2021

telemetry.firefox_desktop_usage_2021

Stable source for 2021 KPI data on Firefox desktop usage, including cumulative days of use (cdou) and new profiles, broken out by dimensions. Contains data back to 2017 for year-over-year comparisons.

New profile counts are determined using the first_seen_date approach where we consider a profile new on the day it first sends a main ping.

Queries should generally be SUM of the cdou, new_profiles, dau, wau, or mau fields, grouped by any dimensions you want to compare or filtered to only your target population.

Example query to see CDOU and new profiles over time for the Windows population:

SELECT
  submission_date,
  os,
  SUM(cdou) AS cdou,
  SUM(new_profiles) AS new_profiles
FROM mozdata.telemetry.firefox_desktop_usage_2021
WHERE os = 'Windows'
GROUP BY submission_date
ORDER BY submission_date

Note that some amount of the upstream data in clients_last_seen will be deleted over time in response to user-initiated deletion requests, but the aggregates in this view (which are no longer client-level) will remain stable. Expect to see slightly higher results from this table compared to queries on client-level tables. The underlying table was initially created on 2021-02-19.

Schema
Column Description Type Nullable
cdou Integer Yes
cumulative_new_profiles Integer Yes
attributed Boolean Yes
submission_date Date Yes
dau Integer Yes
mau Integer Yes
wau Integer Yes
new_profiles Integer Yes
submission_year Integer Yes
id_bucket Integer Yes
activity_segment String Yes
os String Yes
channel String Yes
source String Yes
medium String Yes
campaign String Yes
content String Yes
country String Yes
distribution_id String Yes
country_name String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_desktop_usage_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_day_2_7_activation

Firefox Nondesktop Day 2 7 Activation

telemetry.firefox_nondesktop_day_2_7_activation

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_nondesktop_day_2_7_activation_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28

Firefox Nondesktop Exact Mau28

telemetry.firefox_nondesktop_exact_mau28

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
tier1_wau Integer Yes
tier1_dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28_by_client_count_dimensions

Firefox Nondesktop Exact Mau28 By Client Count Dimensions

telemetry.firefox_nondesktop_exact_mau28_by_client_count_dimensions

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
app_name String Yes
app_version String Yes
arch String Yes
normalized_channel String Yes
default_search String Yes
distribution_id String Yes
country String Yes
locale String Yes
os String Yes
osversion String Yes
country_name String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_nondesktop_exact_mau28_by_client_count_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28_by_dimensions

Firefox Nondesktop Exact Mau28 By Dimensions

telemetry.firefox_nondesktop_exact_mau28_by_dimensions

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
id_bucket Integer Yes
product String Yes
normalized_channel String Yes
campaign String Yes
country String Yes
distribution_id String Yes
new_profiles Integer Yes
country_name String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28_by_dimensions_v1

Firefox Nondesktop Exact Mau28 By Dimensions V1

telemetry.firefox_nondesktop_exact_mau28_by_dimensions_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
id_bucket Integer Yes
product String Yes
normalized_channel String Yes
campaign String Yes
country String Yes
distribution_id String Yes
new_profiles Integer Yes
country_name String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod static country_codes_v1
moz-fx-data-shared-prod telemetry_derived firefox_nondesktop_exact_mau28_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28_by_product

Firefox Nondesktop Exact Mau28 By Product

telemetry.firefox_nondesktop_exact_mau28_by_product

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
product String Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
tier1_wau Integer Yes
tier1_dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_product_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28_by_product_v1

Firefox Nondesktop Exact Mau28 By Product V1

telemetry.firefox_nondesktop_exact_mau28_by_product_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
product String Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
tier1_wau Integer Yes
tier1_dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


firefox_nondesktop_exact_mau28_v1

Firefox Nondesktop Exact Mau28 V1

telemetry.firefox_nondesktop_exact_mau28_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
mau Integer Yes
wau Integer Yes
dau Integer Yes
tier1_mau Integer Yes
tier1_wau Integer Yes
tier1_dau Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_dimensions_v1

Source Directory | View Definition | Metadata File


first_shutdown

Historical Pings for telemetry/first-shutdown

telemetry.first_shutdown

A historical view of pings sent for the telemetry/first-shutdown document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable first_shutdown_v5

Source Directory | View Definition | Metadata File


first_shutdown_summary

First Shutdown Summary

telemetry.first_shutdown_summary

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived first_shutdown_summary_v4

Source Directory | View Definition | Metadata File


first_shutdown_summary_v4

First Shutdown Summary V4

telemetry.first_shutdown_summary_v4

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived first_shutdown_summary_v4

Source Directory | View Definition | Metadata File


first_shutdown_use_counter

Historical Pings for telemetry/first-shutdown-use-counter

telemetry.first_shutdown_use_counter

A historical view of pings sent for the telemetry/first-shutdown-use-counter document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_id String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable first_shutdown_use_counter_v4

Source Directory | View Definition | Metadata File


flash_shield_study

Historical Pings for telemetry/flash-shield-study

telemetry.flash_shield_study

A historical view of pings sent for the telemetry/flash-shield-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable flash_shield_study_v4

Source Directory | View Definition | Metadata File


focus_event

Focus Event

telemetry.focus_event

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable focus_event_v1

Source Directory | View Definition | Metadata File


fog_decision_support_percentiles

Fog Decision Support Percentiles

telemetry.fog_decision_support_percentiles

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
ping String Yes
channel String Yes
metric_name String Yes
percentiles Integer No
mean Float Yes
std_dev Float Yes
median Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived fog_decision_support_percentiles_v1

Source Directory | View Definition | Metadata File


frecency_update

Historical Pings for telemetry/frecency-update

telemetry.frecency_update

A historical view of pings sent for the telemetry/frecency-update document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_id String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable frecency_update_v4

Source Directory | View Definition | Metadata File


ftu

Historical Pings for telemetry/ftu

telemetry.ftu

A historical view of pings sent for the telemetry/ftu document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable ftu_v3

Source Directory | View Definition | Metadata File


health

Health

telemetry.health

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable health_v4

Source Directory | View Definition | Metadata File


heartbeat

Historical Pings for telemetry/heartbeat

telemetry.heartbeat

A historical view of pings sent for the telemetry/heartbeat document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
engagement_type String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
environment Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable heartbeat_v4

Source Directory | View Definition | Metadata File


install

Install

telemetry.install

View based on firefox_installer.install table. The attribution column in that table is a URL encoded string. This view extracts the fields in the attribution column into STRUCT< campaign STRING, content STRING, dlsource STRING, dltoken STRING, experiment STRING, medium STRING, source STRING, ua STRING, variation STRING

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_installer install

Source Directory | View Definition | Metadata File


installation

Historical Pings for telemetry/installation

telemetry.installation

A historical view of pings sent for the telemetry/installation document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
adgroup Adjust AdGroup String Yes
app_name String Yes
arch device architecture String Yes
campaign Adjust campaign String Yes
channel String Yes
client_id telemetry client_id String Yes
created String Yes
creative Adjust creative String Yes
device_id hashed Google Ad ID String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
locale application locale, such as 'en-US' String Yes
manufacturer Build.MANUFACTURER String Yes
metadata Record Yes
model Build.MODEL String Yes
network Adjust network String Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
os String Yes
osversion String Yes
profile_date Number of days since the epoch that the profile was created Integer Yes
reason String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
seq 0-indexed sequence number Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
tz timezone offset in minutes from UTC Integer Yes
v Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable installation_v1

Source Directory | View Definition | Metadata File


latest_versions

Latest Versions

telemetry.latest_versions

Please provide a description for the query

Schema
Column Description Type Nullable
channel String Yes
latest_version Numeric Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived latest_versions_v2

Source Directory | View Definition | Metadata File


lockwise_mobile_events

Lockwise Mobile Events

telemetry.lockwise_mobile_events

Please provide a description for the query

Schema
Column Description Type Nullable
os String Yes
client_id String Yes
submission_date_s3 Date Yes
submission_timestamp Timestamp Yes
device String Yes
app_build_id String Yes
timestamp Integer Yes
category String Yes
method String Yes
object String Yes
value String Yes
extra Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry lockwise_mobile_events_v1

Source Directory | View Definition | Metadata File


lockwise_mobile_events_v1

Lockwise Mobile Events V1

telemetry.lockwise_mobile_events_v1

Please provide a description for the query

Schema
Column Description Type Nullable
os String Yes
client_id String Yes
submission_date_s3 Date Yes
submission_timestamp Timestamp Yes
device String Yes
app_build_id String Yes
timestamp Integer Yes
category String Yes
method String Yes
object String Yes
value String Yes
extra Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_focus_event_parquet_v1
moz-fx-data-shared-prod telemetry telemetry_mobile_event_parquet_v2

Source Directory | View Definition | Metadata File


main

Historical Pings for telemetry/main

telemetry.main

A historical view of pings sent for the telemetry/main document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable main_v5

Source Directory | View Definition | Metadata File


main_1pct

Main 1 percent

telemetry.main_1pct

A materialized 1 percent sample of main pings without use counters intended as a performance optimization for exploratory queries. It contains only the most recent six months of data.

Queries on this table are logically equivalent to queries on top of main_v5 with a filter on sample_id = 0, but this table has a few advantages. First, query estimates will be much more accurate; estimates of bytes scanned can't take into account clustering, so we sometimes see valid queries get rejected by Redash due to appearing expensive when they really aren't. Second, simple queries should complete much more quickly on this table compared to main_v5; for simple queries on a very wide table like this, the execution time appears to be dominated by BQ simply scanning metadata for all the blocks it might need to touch. Because this table contains only 1% of main ping data, it is likely to have many fewer blocks to scan through.

An extra-experimental feature here is the addition of subsample_id, an additional clustering field that allows for queries to efficiently filter down to a 0.01% sample. Like sample_id, it ranges from 0 to 99.

Clustering fields: normalized_channel, sample_id, subsample_id

See also: main_nightly

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry main_remainder_1pct

Source Directory | View Definition | Metadata File


main_nightly

Main Nightly

telemetry.main_nightly

A materialized subset of main pings intended as a performance optimization for exploratory queries. It contains only the most recent six months of data for the nightly channel of Firefox.

Queries on this table are logically equivalent to queries on top of main_v5 with a filter on normalized_channel = 'nightly', but this table has a few advantages. First, query estimates will be much more accurate; estimates of bytes scanned can't take into account clustering, so we sometimes see valid queries get rejected by Redash due to appearing expensive when they really aren't. Second, simple queries should complete much more quickly on this table compared to main_v5; for simple queries on a very wide table like this, the execution time appears to be dominated by BQ simply scanning metadata for all the blocks it might need to touch. Because this table contains only a fraction of main ping data, it is likely to have many fewer blocks to scan through.

Clustering fields: normalized_channel, sample_id

See also: main_nightly

Schema
Column Description Type Nullable
additional_properties String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name String Yes
normalized_channel String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_nightly_v1

Source Directory | View Definition | Metadata File


main_remainder_1pct

Main Remainder 1 percent

telemetry.main_remainder_1pct

A materialized 1 percent sample of main pings without use counter data intended as a performance optimization for exploratory queries. It contains only the most recent six months of data.

Queries on this table are logically equivalent to queries on top of main_v5 with a filter on sample_id = 0, but this table has a few advantages. First, query estimates will be much more accurate; estimates of bytes scanned can't take into account clustering, so we sometimes see valid queries get rejected by Redash due to appearing expensive when they really aren't. Second, simple queries should complete much more quickly on this table compared to main_v5; for simple queries on a very wide table like this, the execution time appears to be dominated by BQ simply scanning metadata for all the blocks it might need to touch. Because this table contains only 1% of main ping data, it is likely to have many fewer blocks to scan through.

An extra-experimental feature here is the addition of subsample_id, an additional clustering field that allows for queries to efficiently filter down to a 0.01% sample. Like sample_id, it ranges from 0 to 99.

Clustering fields: normalized_channel, sample_id, subsample_id

See also: main_nightly

Schema
Column Description Type Nullable
subsample_id Integer Yes
additional_properties String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name String Yes
normalized_channel String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_remainder_1pct_v1

Source Directory | View Definition | Metadata File


main_summary

Main Summary

telemetry.main_summary

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry main_summary_v4

Source Directory | View Definition | Metadata File


main_summary_v3

Main Summary V3

telemetry.main_summary_v3

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_summary_v3

Source Directory | View Definition | Metadata File


main_summary_v4

Main Summary V4

telemetry.main_summary_v4

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_summary_v4

Source Directory | View Definition | Metadata File


main_use_counter

Historical Pings for telemetry/main-use-counter

telemetry.main_use_counter

A historical view of pings sent for the telemetry/main-use-counter document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_id String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable main_use_counter_v4

Source Directory | View Definition | Metadata File


main_use_counter_1pct

Main Use Counter 1 percent

telemetry.main_use_counter_1pct

A materialized 1 percent sample of main pings use counter data intended as a performance optimization for exploratory queries. It contains only the most recent six months of data.

Queries on this table are logically equivalent to queries on top of main_use_counter_v4 with a filter on sample_id = 0, but this table has a few advantages. First, query estimates will be much more accurate; estimates of bytes scanned can't take into account clustering, so we sometimes see valid queries get rejected by Redash due to appearing expensive when they really aren't. Second, simple queries should complete much more quickly on this table compared to main_use_counter_v4; for simple queries on a very wide table like this, the execution time appears to be dominated by BQ simply scanning metadata for all the blocks it might need to touch. Because this table contains only 1% of main ping data, it is likely to have many fewer blocks to scan through.

An extra-experimental feature here is the addition of subsample_id, an additional clustering field that allows for queries to efficiently filter down to a 0.01% sample. Like sample_id, it ranges from 0 to 99.

Clustering fields: normalized_channel, sample_id, subsample_id

See also: main_nightly

Schema
Column Description Type Nullable
subsample_id Integer Yes
additional_properties String Yes
client_id String Yes
document_id String Yes
metadata Record Yes
normalized_app_name String Yes
normalized_channel String Yes
normalized_country_code String Yes
normalized_os String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Integer Yes
submission_timestamp Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_use_counter_1pct_v1

Source Directory | View Definition | Metadata File


malware_addon_states

Historical Pings for telemetry/malware-addon-states

telemetry.malware_addon_states

A historical view of pings sent for the telemetry/malware-addon-states document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable malware_addon_states_v4

Source Directory | View Definition | Metadata File


mobile_event

Mobile Event

telemetry.mobile_event

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable mobile_event_v1

Source Directory | View Definition | Metadata File


mobile_metrics

Historical Pings for telemetry/mobile-metrics

telemetry.mobile_metrics

A historical view of pings sent for the telemetry/mobile-metrics document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
arch String Yes
client_id String Yes
created_date String Yes
created_timestamp Integer Yes
device String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
experiments Record No
locale String Yes
metadata Record Yes
metrics Record No
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
os String Yes
osversion String Yes
profile_date Integer Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
seq Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
tz Integer Yes
v Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable mobile_metrics_v1

Source Directory | View Definition | Metadata File


mobile_usage_2021

Mobile Usage 2021

telemetry.mobile_usage_2021

Stable source for 2021 KPI data on mobile usage, including cumulative days of use (cdou) broken out by dimensions. Contains data back to 2017 for year-over-year comparisons.

Queries should generally be SUM of the cdou, dau, wau, or mau fields, grouped by any dimensions you want to compare or filtered to only your target population.

Example query to see CDOU over time for Firefox for iOS:

SELECT
  submission_date,
  SUM(cdou) AS cdou
FROM mozdata.telemetry.mobile_usage_2021
WHERE app_name = 'firefox_ios'
GROUP BY submission_date
ORDER BY submission_date

Note that some amount of the upstream data in nondesktop_clients_last_seen will be deleted over time in response to user-initiated deletion requests, but the aggregates in this view (which are no longer client-level) will remain stable. Expect to see slightly higher results from this table compared to queries on client-level tables.

Schema
Column Description Type Nullable
submission_date Date Yes
cdou Integer Yes
wau Integer Yes
mau Integer Yes
dau Integer Yes
id_bucket Integer Yes
app_name String Yes
canonical_app_name String Yes
channel String Yes
os String Yes
campaign String Yes
country String Yes
country_name String Yes
distribution_id String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod static country_codes_v1
moz-fx-data-shared-prod telemetry_derived mobile_usage_v1

Source Directory | View Definition | Metadata File


modules

Historical Pings for telemetry/modules

telemetry.modules

A historical view of pings sent for the telemetry/modules document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable modules_v4

Source Directory | View Definition | Metadata File


new_profile

Historical Pings for telemetry/new-profile

telemetry.new_profile

A historical view of pings sent for the telemetry/new-profile document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable new_profile_v4

Source Directory | View Definition | Metadata File


newtab_interactions

Newtab Interactions

telemetry.newtab_interactions

Please provide a description for the query

Schema
Column Description Type Nullable
newtab_visit_id String Yes
client_id String Yes
submission_date Date Yes
search_access_point String Yes
experiments Record No
default_private_search_engine String Yes
default_search_engine String Yes
os String Yes
os_version String Yes
country_code String Yes
channel String Yes
browser_version String Yes
browser_name String Yes
newtab_open_source String Yes
newtab_visit_started_at Integer Yes
newtab_visit_ended_at Integer Yes
topsite_clicks Integer Yes
sponsored_topsite_clicks Integer Yes
topsite_impressions Integer Yes
sponsored_topsite_impressions Integer Yes
searches Integer Yes
tagged_search_ad_clicks Integer Yes
tagged_search_ad_impressions Integer Yes
follow_on_search_ad_clicks Integer Yes
follow_on_search_ad_impressions Integer Yes
tagged_follow_on_search_ad_clicks Integer Yes
tagged_follow_on_search_ad_impressions Integer Yes
pocket_story_position Integer Yes
pocket_enabled Boolean Yes
pocket_impressions Integer Yes
sponsored_pocket_impressions Integer Yes
organic_pocket_impressions Integer Yes
pocket_clicks Integer Yes
sponsored_pocket_clicks Integer Yes
organic_pocket_clicks Integer Yes
pocket_saves Integer Yes
sponsored_pocket_saves Integer Yes
organic_pocket_saves Integer Yes
pocket_is_signed_in Boolean Yes
pocket_sponsored_stories_enabled Boolean Yes
topsites_enabled Boolean Yes
newtab_homepage_category String Yes
newtab_newtab_category String Yes
newtab_search_enabled Boolean Yes
legacy_telemetry_client_id String Yes
is_new_profile Boolean Yes
activity_segment String Yes
topsites_rows Integer Yes
organic_topsite_clicks Integer Yes
organic_topsite_impressions Integer Yes
search_engine String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived newtab_interactions_v1

Source Directory | View Definition | Metadata File


newtab_visits

Newtab Visits

telemetry.newtab_visits

Visits on the newtab page, one row per visit per-day (identified by the visit id).

Schema
Column Description Type Nullable
legacy_telemetry_client_id String Yes
newtab_visit_id String Yes
submission_date Date Yes
client_id String Yes
normalized_os String Yes
normalized_os_version String Yes
country_code String Yes
channel String Yes
browser_version String Yes
browser_name String Yes
default_search_engine String Yes
default_private_search_engine String Yes
pocket_is_signed_in Boolean Yes
pocket_enabled Boolean Yes
pocket_sponsored_stories_enabled Boolean Yes
topsites_enabled Boolean Yes
newtab_homepage_category String Yes
newtab_newtab_category String Yes
newtab_search_enabled Boolean Yes
topsites_rows Integer Yes
newtab_blocked_sponsors String No
experiments Record No
newtab_visit_started_at Integer Yes
newtab_visit_ended_at Integer Yes
newtab_open_source String Yes
had_non_impression_engagement Boolean Yes
search_interactions Record No
topsite_tile_interactions Record No
pocket_interactions Record No
is_new_profile Boolean Yes
activity_segment String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived newtab_visits_v1

Source Directory | View Definition | Metadata File


nondesktop_clients_last_seen

Nondesktop Clients Last Seen

telemetry.nondesktop_clients_last_seen

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry nondesktop_clients_last_seen_v1

Source Directory | View Definition | Metadata File


nondesktop_clients_last_seen_v1

Nondesktop Clients Last Seen V1

telemetry.nondesktop_clients_last_seen_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_lockbox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_focus baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_focus baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_klar baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_lockbox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_klar baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_reference_browser baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_tv_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_vrbrowser baseline_clients_last_seen
moz-fx-data-shared-prod telemetry core_clients_last_seen
moz-fx-data-shared-prod telemetry fenix_clients_last_seen

Source Directory | View Definition | Metadata File


normandy_login_study

Historical Pings for telemetry/normandy-login-study

telemetry.normandy_login_study

A historical view of pings sent for the telemetry/normandy-login-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable normandy_login_study_v4

Source Directory | View Definition | Metadata File


optout

Historical Pings for telemetry/optout

telemetry.optout

A historical view of pings sent for the telemetry/optout document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable optout_v4

Source Directory | View Definition | Metadata File


outofdate_notifications_system_addon

Historical Pings for telemetry/outofdate-notifications-system-addon

telemetry.outofdate_notifications_system_addon

A historical view of pings sent for the telemetry/outofdate-notifications-system-addon document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable outofdate_notifications_system_addon_v4

Source Directory | View Definition | Metadata File


pioneer_study

Historical Pings for telemetry/pioneer-study

telemetry.pioneer_study

A historical view of pings sent for the telemetry/pioneer-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload pioneer-study - Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type doc_type, restated String Yes
version Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable pioneer_study_v4

Source Directory | View Definition | Metadata File


pre_account

Historical Pings for telemetry/pre-account

telemetry.pre_account

A historical view of pings sent for the telemetry/pre-account document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable pre_account_v4

Source Directory | View Definition | Metadata File


prio

Historical Pings for telemetry/prio

telemetry.prio

A historical view of pings sent for the telemetry/prio document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable prio_v4

Source Directory | View Definition | Metadata File


regrets_reporter_update

Historical Pings for telemetry/regrets-reporter-update

telemetry.regrets_reporter_update

A historical view of pings sent for the telemetry/regrets-reporter-update document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable regrets_reporter_update_v4

Source Directory | View Definition | Metadata File


releases

Releases

telemetry.releases

Firefox release information imported from https://product-details.mozilla.org/1.0/firefox.json

For more context, see https://wiki.mozilla.org/Release_Management/Product_details

Schema
Column Description Type Nullable
build_number Integer Yes
category String Yes
date Date Yes
description String Yes
is_security_driven Boolean Yes
product String Yes
version String Yes
major_version Numeric Yes
minor_version Numeric Yes
patch_version Numeric Yes
beta_version Numeric Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived releases_v1

Source Directory | View Definition | Metadata File


releases_latest

Releases Latest

telemetry.releases_latest

This is built on top of telemetry.releases and aims to provide an entry on each day for on each day for the major release channels ("release", "beta", "esr") along with the latest Firefox version released on that day or earlier for those channels.

Firefox release information imported from https://product-details.mozilla.org/1.0/firefox.json

For more context, see https://wiki.mozilla.org/Release_Management/Product_details

Schema
Column Description Type Nullable
date Date Yes
product String Yes
category String Yes
channel String Yes
build_number Integer Yes
release_date Date Yes
version String Yes
major_version Numeric Yes
minor_version Numeric Yes
patch_version Numeric Yes
beta_version Numeric Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry releases

Source Directory | View Definition | Metadata File


rocket_android_events_v1

Rocket Android Events V1

telemetry.rocket_android_events_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry focus_event

Source Directory | View Definition | Metadata File


rolling_cohorts

Rolling Cohorts

telemetry.rolling_cohorts

Please provide a description for the query

Schema
Column Description Type Nullable
client_id String Yes
cohort_date Date Yes
activity_segment String Yes
app_version String Yes
attribution_campaign String Yes
attribution_content String Yes
attribution_experiment String Yes
attribution_medium String Yes
attribution_source String Yes
attribution_variation String Yes
city String Yes
country String Yes
device_model String Yes
distribution_id String Yes
is_default_browser Boolean Yes
locale String Yes
normalized_app_name String Yes
normalized_channel String Yes
normalized_os String Yes
normalized_os_version String Yes
os_version_major Integer Yes
os_version_minor Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived rolling_cohorts_v1

Source Directory | View Definition | Metadata File


saved_session

Historical Pings for telemetry/saved-session

telemetry.saved_session

A historical view of pings sent for the telemetry/saved-session document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable saved_session_v5

Source Directory | View Definition | Metadata File


saved_session_use_counter

Historical Pings for telemetry/saved-session-use-counter

telemetry.saved_session_use_counter

A historical view of pings sent for the telemetry/saved-session-use-counter document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_id String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable saved_session_use_counter_v4

Source Directory | View Definition | Metadata File


searchvol

Historical Pings for telemetry/searchvol

telemetry.searchvol

A historical view of pings sent for the telemetry/searchvol document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable searchvol_v4

Source Directory | View Definition | Metadata File


searchvolextra

Historical Pings for telemetry/searchvolextra

telemetry.searchvolextra

A historical view of pings sent for the telemetry/searchvolextra document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable searchvolextra_v4

Source Directory | View Definition | Metadata File


shield_icq_v1

Historical Pings for telemetry/shield-icq-v1

telemetry.shield_icq_v1

A historical view of pings sent for the telemetry/shield-icq-v1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_icq_v1_v4

Source Directory | View Definition | Metadata File


shield_study

Historical Pings for telemetry/shield-study

telemetry.shield_study

A historical view of pings sent for the telemetry/shield-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_study_v4

Source Directory | View Definition | Metadata File


shield_study_addon

Historical Pings for telemetry/shield-study-addon

telemetry.shield_study_addon

A historical view of pings sent for the telemetry/shield-study-addon document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_study_addon_v4

Source Directory | View Definition | Metadata File


shield_study_error

Historical Pings for telemetry/shield-study-error

telemetry.shield_study_error

A historical view of pings sent for the telemetry/shield-study-error document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_study_error_v4

Source Directory | View Definition | Metadata File


simpleprophet_forecasts

Simpleprophet Forecasts

telemetry.simpleprophet_forecasts

Please provide a description for the query

Schema
Column Description Type Nullable
asofdate Date Yes
datasource String Yes
date Date Yes
type String Yes
value Float Yes
low90 Float Yes
high90 Float Yes
p10 Float Yes
p20 Float Yes
p30 Float Yes
p40 Float Yes
p50 Float Yes
p60 Float Yes
p70 Float Yes
p80 Float Yes
p90 Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived simpleprophet_forecasts_desktop_v1
moz-fx-data-shared-prod telemetry_derived simpleprophet_forecasts_fxa_v1
moz-fx-data-shared-prod telemetry_derived simpleprophet_forecasts_mobile_v1

Source Directory | View Definition | Metadata File


smoot_usage_day_0

Smoot Usage Day 0

telemetry.smoot_usage_day_0

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
usage String Yes
dau Integer Yes
wau Integer Yes
mau Integer Yes
active_days_in_week Integer Yes
id_bucket Integer Yes
app_name String Yes
app_version String Yes
country String Yes
locale String Yes
os String Yes
os_version String Yes
channel String Yes
attributed Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived smoot_usage_desktop_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_fxa_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_new_profiles_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_nondesktop_v2

Source Directory | View Definition | Metadata File


smoot_usage_day_13

Smoot Usage Day 13

telemetry.smoot_usage_day_13

Please provide a description for the query

Schema
Column Description Type Nullable
date Date Yes
usage String Yes
new_profiles Integer Yes
active_in_week_0 Integer Yes
active_in_week_1 Integer Yes
active_in_weeks_0_and_1 Integer Yes
new_profile_active_in_week_0 Integer Yes
new_profile_active_in_week_1 Integer Yes
new_profile_active_in_weeks_0_and_1 Integer Yes
id_bucket Integer Yes
app_name String Yes
app_version String Yes
country String Yes
locale String Yes
os String Yes
os_version String Yes
channel String Yes
attributed Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived smoot_usage_desktop_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_fxa_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_nondesktop_v2

Source Directory | View Definition | Metadata File


socorro_crash

Socorro Crash

telemetry.socorro_crash

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry socorro_crash_v2

Source Directory | View Definition | Metadata File


socorro_crash_v2

Socorro Crash V2

telemetry.socorro_crash_v2

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived socorro_crash_v2

Source Directory | View Definition | Metadata File


Sponsored Tiles Ad Request Fill

telemetry.sponsored_tiles_ad_request_fill

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
country String Yes
device String Yes
form_factor String Yes
normalized_os String Yes
adm_request_sum Integer Yes
adm_empty_response_sum Integer Yes
adm_response_tiles_min Integer Yes
adm_response_rate Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived contile_filter_adm_empty_response
moz-fx-data-shared-prod telemetry_derived contile_tiles_adm_request
moz-fx-data-shared-prod telemetry_derived contile_tiles_adm_response_tiles_count

Source Directory | View Definition | Metadata File


Sponsored Tiles Clients Daily

telemetry.sponsored_tiles_clients_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
device String Yes
client_id String Yes
browser_version_info Record Yes
country String Yes
locale String Yes
normalized_channel String Yes
normalized_os String Yes
is_new_profile Boolean Yes
sample_id Integer Yes
experiments Record No
sponsored_tiles_click_count Integer Yes
sponsored_tiles_impression_count Integer Yes
sponsored_tiles_dismissal_count Integer Yes
sponsored_tiles_disable_count Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived sponsored_tiles_clients_daily_v1

Source Directory | View Definition | Metadata File


ssl_ratios

Ssl Ratios

telemetry.ssl_ratios

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
os String Yes
country String Yes
reporting_ratio Float Yes
normalized_pageloads Float Yes
ratio Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry ssl_ratios_v1

Source Directory | View Definition | Metadata File


ssl_ratios_v1

Ssl Ratios V1

telemetry.ssl_ratios_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
os String Yes
country String Yes
reporting_ratio Float Yes
normalized_pageloads Float Yes
ratio Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived ssl_ratios_v1

Source Directory | View Definition | Metadata File


suggest_clients_daily

Suggest Clients Daily

telemetry.suggest_clients_daily

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
block_nonsponsored_count Integer Yes
block_sponsored_count Integer Yes
block_nonsponsored_bestmatch_count Integer Yes
block_sponsored_bestmatch_count Integer Yes
click_nonsponsored_count Integer Yes
click_sponsored_count Integer Yes
click_nonsponsored_bestmatch_count Integer Yes
click_sponsored_bestmatch_count Integer Yes
help_nonsponsored_count Integer Yes
help_sponsored_count Integer Yes
help_nonsponsored_bestmatch_count Integer Yes
help_sponsored_bestmatch_count Integer Yes
impression_nonsponsored_count Integer Yes
impression_sponsored_count Integer Yes
impression_nonsponsored_bestmatch_count Integer Yes
impression_sponsored_bestmatch_count Integer Yes
user_pref_data_collection_enabled Boolean Yes
user_pref_sponsored_suggestions_enabled Boolean Yes
user_pref_firefox_suggest_enabled Boolean Yes
browser_version_info Record Yes
experiments Record No
locale String Yes
normalized_channel String Yes
normalized_os_version String Yes
sample_id Integer Yes
country String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived suggest_clients_daily_v1

Source Directory | View Definition | Metadata File


sync

Sync

telemetry.sync

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable sync_v4

Source Directory | View Definition | Metadata File


system_addon_deployment_diagnostics

Historical Pings for telemetry/system-addon-deployment-diagnostics

telemetry.system_addon_deployment_diagnostics

A historical view of pings sent for the telemetry/system-addon-deployment-diagnostics document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable system_addon_deployment_diagnostics_v4

Source Directory | View Definition | Metadata File


telemetry_anonymous_parquet

Telemetry Anonymous Parquet

telemetry.telemetry_anonymous_parquet

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
metadata Record Yes
application Record Yes
creation_date String Yes
id String Yes
payload Record Yes
type String Yes
version Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_anonymous_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_anonymous_parquet_v1

Telemetry Anonymous Parquet V1

telemetry.telemetry_anonymous_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry anonymous

Source Directory | View Definition | Metadata File


telemetry_core_parquet

Telemetry Core Parquet

telemetry.telemetry_core_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_core_parquet_v3

Source Directory | View Definition | Metadata File


telemetry_core_parquet_v3

Telemetry Core Parquet V3

telemetry.telemetry_core_parquet_v3

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry core

Source Directory | View Definition | Metadata File


telemetry_downgrade_parquet

Telemetry Downgrade Parquet

telemetry.telemetry_downgrade_parquet

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
id String Yes
creation_date String Yes
application Record Yes
client_id String Yes
version Float Yes
payload Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_downgrade_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_downgrade_parquet_v1

Telemetry Downgrade Parquet V1

telemetry.telemetry_downgrade_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry downgrade

Source Directory | View Definition | Metadata File


telemetry_focus_event_parquet

Telemetry Focus Event Parquet

telemetry.telemetry_focus_event_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_focus_event_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_focus_event_parquet_v1

Telemetry Focus Event Parquet V1

telemetry.telemetry_focus_event_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry focus_event

Source Directory | View Definition | Metadata File


telemetry_heartbeat_parquet

Telemetry Heartbeat Parquet

telemetry.telemetry_heartbeat_parquet

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
type String Yes
id String Yes
creation_date String Yes
version Float Yes
client_id String Yes
application Record Yes
payload Record Yes
metadata Record Yes
engagement_type String Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_heartbeat_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_heartbeat_parquet_v1

Telemetry Heartbeat Parquet V1

telemetry.telemetry_heartbeat_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry heartbeat

Source Directory | View Definition | Metadata File


telemetry_ip_privacy

Telemetry Ip Privacy

telemetry.telemetry_ip_privacy

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_ip_privacy_v2

Source Directory | View Definition | Metadata File


telemetry_ip_privacy_parquet

Telemetry Ip Privacy Parquet

telemetry.telemetry_ip_privacy_parquet

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
timestamp Integer Yes
fields Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_ip_privacy_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_ip_privacy_parquet_v1

Telemetry Ip Privacy Parquet V1

telemetry.telemetry_ip_privacy_parquet_v1

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date_s3 Date Yes
submission_date Date Yes
timestamp Integer Yes
fields Record Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_ip_privacy_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_mobile_event_parquet

Telemetry Mobile Event Parquet

telemetry.telemetry_mobile_event_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_mobile_event_parquet_v2

Source Directory | View Definition | Metadata File


telemetry_mobile_event_parquet_v2

Telemetry Mobile Event Parquet V2

telemetry.telemetry_mobile_event_parquet_v2

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry mobile_event

Source Directory | View Definition | Metadata File


telemetry_new_profile_parquet

Telemetry New Profile Parquet

telemetry.telemetry_new_profile_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_new_profile_parquet_v2

Source Directory | View Definition | Metadata File


telemetry_new_profile_parquet_v2

Telemetry New Profile Parquet V2

telemetry.telemetry_new_profile_parquet_v2

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_new_profile_parquet_v2

Source Directory | View Definition | Metadata File


telemetry_shield_study_parquet

Telemetry Shield Study Parquet

telemetry.telemetry_shield_study_parquet

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_shield_study_parquet_v1

Source Directory | View Definition | Metadata File


telemetry_shield_study_parquet_v1

Telemetry Shield Study Parquet V1

telemetry.telemetry_shield_study_parquet_v1

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_shield_study_parquet_v1

Source Directory | View Definition | Metadata File


testpilot

Historical Pings for telemetry/testpilot

telemetry.testpilot

A historical view of pings sent for the telemetry/testpilot document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable testpilot_v4

Source Directory | View Definition | Metadata File


testpilottest

Historical Pings for telemetry/testpilottest

telemetry.testpilottest

A historical view of pings sent for the telemetry/testpilottest document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable testpilottest_v4

Source Directory | View Definition | Metadata File


third_party_modules

Historical Pings for telemetry/third-party-modules

telemetry.third_party_modules

A historical view of pings sent for the telemetry/third-party-modules document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
application Record Yes
client_id String Yes
creation_date String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
environment Record Yes
id String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
payload Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
type String Yes
version Float Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable third_party_modules_v4

Source Directory | View Definition | Metadata File


tls13_middlebox_alt_server_hello_1

Historical Pings for telemetry/tls13-middlebox-alt-server-hello-1

telemetry.tls13_middlebox_alt_server_hello_1

A historical view of pings sent for the telemetry/tls13-middlebox-alt-server-hello-1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_alt_server_hello_1_v4

Source Directory | View Definition | Metadata File


tls13_middlebox_beta

Historical Pings for telemetry/tls13-middlebox-beta

telemetry.tls13_middlebox_beta

A historical view of pings sent for the telemetry/tls13-middlebox-beta document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_beta_v4

Source Directory | View Definition | Metadata File


tls13_middlebox_draft22

Historical Pings for telemetry/tls13-middlebox-draft22

telemetry.tls13_middlebox_draft22

A historical view of pings sent for the telemetry/tls13-middlebox-draft22 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_draft22_v4

Source Directory | View Definition | Metadata File


tls13_middlebox_ghack

Historical Pings for telemetry/tls13-middlebox-ghack

telemetry.tls13_middlebox_ghack

A historical view of pings sent for the telemetry/tls13-middlebox-ghack document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_ghack_v4

Source Directory | View Definition | Metadata File


tls13_middlebox_repetition

Historical Pings for telemetry/tls13-middlebox-repetition

telemetry.tls13_middlebox_repetition

A historical view of pings sent for the telemetry/tls13-middlebox-repetition document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
document_id The document ID specified in the URI when the client sent this message String Yes
metadata Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_repetition_v4