Firefox Desktop
Data related to messaging_system.
active_users_aggregates
Active Users Aggregates
firefox_desktop.active_users_aggregates
Please provide a description for the query
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | active_users_aggregates_v1 |
Source Directory | View Definition | Metadata File
baseline
Historical Pings for firefox-desktop/baseline
firefox_desktop.baseline
A historical view of pings sent for the
firefox-desktop/baseline
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | baseline_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
firefox_desktop.baseline_clients_daily
A daily aggregate of baseline pings per client_id.
Clustering fields: normalized_channel, sample_id
See also: baseline_clients_last_seen
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| first_run_date | Date | Yes | |
| durations | Integer | Yes | |
| days_seen_session_start_bits | Integer | Yes | |
| days_seen_session_end_bits | Integer | Yes | |
| normalized_channel | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| android_sdk_version | String | Yes | |
| locale | String | Yes | |
| city | String | Yes | |
| country | String | Yes | |
| app_build | String | Yes | |
| app_channel | String | Yes | |
| app_display_version | String | Yes | |
| architecture | String | Yes | |
| device_manufacturer | String | Yes | |
| device_model | String | Yes | |
| telemetry_sdk_build | String | Yes | |
| first_seen_date | Date | Yes | |
| is_new_profile | Boolean | Yes | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | baseline_clients_daily_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
Baseline Clients First Seen
firefox_desktop.baseline_clients_first_seen
Captures the earliest server date that we observe a particular client in the
baseline table. A client may have a first_seen_date that is earlier than the
epoch of the baseline table; this is the result of a migration from a legacy
data collection system. These clients are therefore not captured in this
table.
Clustering fields: sample_id
See also: baseline_clients_daily and baseline_clients_last_seen.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| first_run_date | Date | Yes | |
| durations | Integer | Yes | |
| days_seen_session_start_bits | Integer | Yes | |
| days_seen_session_end_bits | Integer | Yes | |
| normalized_channel | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| android_sdk_version | String | Yes | |
| locale | String | Yes | |
| city | String | Yes | |
| country | String | Yes | |
| app_build | String | Yes | |
| app_channel | String | Yes | |
| app_display_version | String | Yes | |
| architecture | String | Yes | |
| device_manufacturer | String | Yes | |
| device_model | String | Yes | |
| telemetry_sdk_build | String | Yes | |
| first_seen_date | Date | Yes | |
| is_new_profile | Boolean | Yes | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | baseline_clients_daily_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
Baseline Clients Last Seen
firefox_desktop.baseline_clients_last_seen
Captures activity history of each client in 28-day windows for each submission date based on baseline pings.
Clustering fields: normalized_channel, sample_id
See also: baseline_clients_daily
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| days_since_seen | Integer | Yes | |
| days_since_created_profile | Integer | Yes | |
| days_since_seen_session_start | Integer | Yes | |
| days_since_seen_session_end | Integer | Yes | |
| days_seen_bits | Integer | Yes | |
| days_created_profile_bits | Integer | Yes | |
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| first_run_date | Date | Yes | |
| durations | Integer | Yes | |
| days_seen_session_start_bits | Integer | Yes | |
| days_seen_session_end_bits | Integer | Yes | |
| normalized_channel | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| android_sdk_version | String | Yes | |
| locale | String | Yes | |
| city | String | Yes | |
| country | String | Yes | |
| app_build | String | Yes | |
| app_channel | String | Yes | |
| app_display_version | String | Yes | |
| architecture | String | Yes | |
| device_manufacturer | String | Yes | |
| device_model | String | Yes | |
| telemetry_sdk_build | String | Yes | |
| first_seen_date | Date | Yes | |
| is_new_profile | Boolean | Yes | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | baseline_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
broken_site_report
Historical Pings for firefox-desktop/broken-site-report
firefox_desktop.broken_site_report
A historical view of pings sent for the
firefox-desktop/broken-site-report
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | broken_site_report_v1 |
Source Directory | View Definition | Metadata File
clients_last_seen_joined
Clients Last Seen Joined
firefox_desktop.clients_last_seen_joined
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| normalized_channel | String | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| days_since_seen | Integer | Yes | |
| days_since_created_profile | Integer | Yes | |
| days_since_seen_session_start | Integer | Yes | |
| days_since_seen_session_end | Integer | Yes | |
| days_seen_bits | Integer | Yes | |
| days_created_profile_bits | Integer | Yes | |
| first_run_date | Date | Yes | |
| durations | Integer | Yes | |
| days_seen_session_start_bits | Integer | Yes | |
| days_seen_session_end_bits | Integer | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| android_sdk_version | String | Yes | |
| locale | String | Yes | |
| city | String | Yes | |
| country | String | Yes | |
| app_build | String | Yes | |
| app_channel | String | Yes | |
| app_display_version | String | Yes | |
| architecture | String | Yes | |
| device_manufacturer | String | Yes | |
| device_model | String | Yes | |
| telemetry_sdk_build | String | Yes | |
| first_seen_date | Date | Yes | |
| is_new_profile | Boolean | Yes | |
| n_metrics_ping | Integer | Yes | |
| days_sent_metrics_ping_bits | Integer | Yes | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | clients_last_seen_joined_v1 |
Source Directory | View Definition | Metadata File
crash
Historical Pings for firefox-desktop/crash
firefox_desktop.crash
A historical view of pings sent for the
firefox-desktop/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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | crash_v1 |
Source Directory | View Definition | Metadata File
deletion_request
Historical Pings for firefox-desktop/deletion-request
firefox_desktop.deletion_request
A historical view of pings sent for the
firefox-desktop/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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | deletion_request_v1 |
Source Directory | View Definition | Metadata File
events
Historical Pings for firefox-desktop/events
firefox_desktop.events
A historical view of pings sent for the
firefox-desktop/events
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | events_v1 |
Source Directory | View Definition | Metadata File
events_unnested
Events Unnested
firefox_desktop.events_unnested
Please provide a description for the query
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop | events |
Source Directory | View Definition | Metadata File
first_startup
Historical Pings for firefox-desktop/first-startup
firefox_desktop.first_startup
A historical view of pings sent for the
firefox-desktop/first-startup
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | first_startup_v1 |
Source Directory | View Definition | Metadata File
fog_validation
Historical Pings for firefox-desktop/fog-validation
firefox_desktop.fog_validation
A historical view of pings sent for the
firefox-desktop/fog-validation
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | fog_validation_v1 |
Source Directory | View Definition | Metadata File
messaging_system
Historical Pings for firefox-desktop/messaging-system
firefox_desktop.messaging_system
A historical view of pings sent for the
firefox-desktop/messaging-system
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | messaging_system_v1 |
Source Directory | View Definition | Metadata File
metrics
Historical Pings for firefox-desktop/metrics
firefox_desktop.metrics
A historical view of pings sent for the
firefox-desktop/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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | metrics_v1 |
Source Directory | View Definition | Metadata File
metrics_clients_daily
Metrics Clients Daily
firefox_desktop.metrics_clients_daily
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| normalized_channel | String | Yes | |
| n_metrics_ping | Integer | Yes | |
| days_sent_metrics_ping_bits | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | metrics_clients_daily_v1 |
Source Directory | View Definition | Metadata File
metrics_clients_last_seen
Metrics Clients Last Seen
firefox_desktop.metrics_clients_last_seen
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| normalized_channel | String | Yes | |
| n_metrics_ping | Integer | Yes | |
| days_sent_metrics_ping_bits | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | metrics_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
new_metric_capture_emulation
Historical Pings for firefox-desktop/new-metric-capture-emulation
firefox_desktop.new_metric_capture_emulation
A historical view of pings sent for the
firefox-desktop/new-metric-capture-emulation
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | new_metric_capture_emulation_v1 |
Source Directory | View Definition | Metadata File
newtab
Historical Pings for firefox-desktop/newtab
firefox_desktop.newtab
A historical view of pings sent for the
firefox-desktop/newtab
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | newtab_v1 |
Source Directory | View Definition | Metadata File
onboarding
Onboarding
firefox_desktop.onboarding
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_timestamp | Time when the ingestion edge server accepted this message | Timestamp | Yes |
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| addon_version | String | Yes | |
| client_id | String | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| event | String | Yes | |
| event_context | A string that describes the context about this event | String | Yes |
| event_page | The event_context's page. Almost always "about:welcome". | String | Yes |
| event_reason | The event_context's reason. Likely something like "welcome-window-closed" or "app-shut-down". | String | Yes |
| event_source | The event_context's source. Likely something like "primary_button". | String | Yes |
| locale | String | Yes | |
| message_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 | |
| release_channel | String | Yes | |
| sample_id | Integer | Yes | |
| version | String | Yes | |
| browser_session_id | A mirror of the browser sessionId, as defined in https://github.com/mozilla-services/mozilla-pipeline-schemas/blob/main/schemas/telemetry/main/main.4.schema.json | String | Yes |
| experiments | Record | No | |
| attribution | Record | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | onboarding_v2 |
Source Directory | View Definition | Metadata File
pageload
Historical Pings for firefox-desktop/pageload
firefox_desktop.pageload
A historical view of pings sent for the
firefox-desktop/pageload
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | pageload_v1 |
Source Directory | View Definition | Metadata File
pocket_button
Historical Pings for firefox-desktop/pocket-button
firefox_desktop.pocket_button
A historical view of pings sent for the
firefox-desktop/pocket-button
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | pocket_button_v1 |
Source Directory | View Definition | Metadata File
pseudo_main
Historical Pings for firefox-desktop/pseudo-main
firefox_desktop.pseudo_main
A historical view of pings sent for the
firefox-desktop/pseudo-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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | pseudo_main_v1 |
Source Directory | View Definition | Metadata File
quick_suggest
Historical Pings for firefox-desktop/quick-suggest
firefox_desktop.quick_suggest
A historical view of pings sent for the
firefox-desktop/quick-suggest
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
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | quick_suggest_v1 |
Source Directory | View Definition | Metadata File
review_checker_clients
Review Checker Clients
firefox_desktop.review_checker_clients
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| normalized_channel | String | Yes | |
| normalized_country_code | String | Yes | |
| legacy_client_id | String | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| shopping_product_page_visits | Integer | Yes | |
| is_opt_in | Integer | Yes | |
| is_opt_out | Integer | Yes | |
| sap | Integer | Yes | |
| ad_click | Integer | Yes | |
| active_hours_sum | Float | Yes | |
| is_fx_dau | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | review_checker_clients_v1 |
Source Directory | View Definition | Metadata File
review_checker_events
Review Checker Events
firefox_desktop.review_checker_events
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| is_exposed_event | Integer | Yes | |
| is_opt_in_event | Integer | Yes | |
| is_surface_displayed | Integer | Yes | |
| is_engaged_with_sidebar | Integer | Yes | |
| experiments | Record | No | |
| normalized_channel | String | Yes | |
| normalized_country_code | String | Yes | |
| sample_id | Integer | Yes | |
| os_version | Numeric | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | review_checker_events_v1 |
Source Directory | View Definition | Metadata File
review_checker_microsurvey
Review Checker Microsurvey
firefox_desktop.review_checker_microsurvey
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| normalized_channel | String | Yes | |
| country_code | String | Yes | |
| os_version | Numeric | Yes | |
| submission_date | Date | Yes | |
| message_id | String | Yes | |
| event | String | Yes | |
| event_page | String | Yes | |
| event_reason | String | Yes | |
| event_source | String | Yes | |
| new_user | Integer | Yes | |
| existing_user | Integer | Yes | |
| coded_question | String | Yes | |
| coded_answers | String | Yes | |
| experiments | Record | No |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | review_checker_microsurvey_v1 |
Source Directory | View Definition | Metadata File
serp_events
Serp Events
firefox_desktop.serp_events
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| impression_id | String | Yes | |
| submission_date | Date | Yes | |
| glean_client_id | String | Yes | |
| legacy_telemetry_client_id | String | Yes | |
| event_timestamp | Integer | Yes | |
| normalized_channel | String | Yes | |
| normalized_country_code | String | Yes | |
| os | String | Yes | |
| browser_version_info | Record | Yes | |
| sample_id | Integer | Yes | |
| is_shopping_page | Boolean | Yes | |
| search_engine | String | Yes | |
| sap_source | String | Yes | |
| is_tagged | Boolean | Yes | |
| is_engaged | Boolean | Yes | |
| abandon_reason | String | Yes | |
| ping_seq | Integer | Yes | |
| experiments | Record | No | |
| has_ads_loaded | Boolean | Yes | |
| component | String | Yes | |
| is_ad_component | Boolean | Yes | |
| num_clicks | Integer | Yes | |
| num_expands | Integer | Yes | |
| num_submits | Integer | Yes | |
| num_ads_loaded_reported | Integer | Yes | |
| num_ads_visible_reported | Integer | Yes | |
| num_ads_hidden_reported | Integer | Yes | |
| ad_blocker_inferred | Boolean | Yes | |
| num_ads_showing | Integer | Yes | |
| num_ads_notshowing | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | serp_events_v1 |
Source Directory | View Definition | Metadata File
snippets
Snippets
firefox_desktop.snippets
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_timestamp | Time when the ingestion edge server accepted this message | Timestamp | Yes |
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| addon_version | String | Yes | |
| client_id | String | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| event | An event identifier | String | Yes |
| event_context | A string that describes the context about this event | String | Yes |
| locale | String | Yes | |
| message_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 | |
| release_channel | String | Yes | |
| sample_id | Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 | Integer | Yes |
| version | String | Yes | |
| experiments | Record | No | |
| source | A string describing the source of this event | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | snippets_v2 |
Source Directory | View Definition | Metadata File
spoc
Historical Pings for firefox-desktop/spoc
firefox_desktop.spoc
A historical view of pings sent for the
firefox-desktop/spoc
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | spoc_v1 |
Source Directory | View Definition | Metadata File
top_sites
Historical Pings for firefox-desktop/top-sites
firefox_desktop.top_sites
A historical view of pings sent for the
firefox-desktop/top-sites
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
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | top_sites_v1 |
Source Directory | View Definition | Metadata File
urlbar_events
Urlbar Events
firefox_desktop.urlbar_events
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| glean_client_id | String | Yes | |
| legacy_telemetry_client_id | String | Yes | |
| sample_id | Integer | Yes | |
| event_name | Name of the 'urlbar' event represented by this row- 'engagement' or 'abandonment' | String | Yes |
| event_timestamp | Glean event timestamp | Integer | Yes |
| event_id | Row identifier UUID. When unnesting the results column, use 'COUNT(DISTINCT event_id)' to count events. | String | Yes |
| experiments | Record | No | |
| seq | ping_info.seq from the events ping. Use together with event_timestamp for event sequencing. | Integer | Yes |
| normalized_channel | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_engine | Normalized default search engine | String | Yes |
| pref_data_collection | Has the user opted into Firefox Suggest data collection, aka Suggest Online. | Boolean | Yes |
| pref_sponsored_suggestions | Are Firefox Suggest sponsored suggestions enabled | Boolean | Yes |
| pref_fx_suggestions | Is Firefox Suggest enabled (nonsponsored suggestions) | Boolean | Yes |
| engagement_type | How the user selected the result. Eg. 'click', 'enter'. | String | Yes |
| interaction | How the user started the search action. Eg. 'typed', 'pasted'. | String | Yes |
| num_chars_typed | Length of the query string typed by the user | Integer | Yes |
| num_total_results | Number of results displayed | Integer | Yes |
| selected_position | Rank of the selected result, starting from 1, if any. | Integer | Yes |
| selected_result | Raw type identifier for the selected result, if any. Eg. 'search_suggest', 'bookmark'. | String | Yes |
| results | Array listing info about each result displayed. | Record | No |
| product_selected_result | Product type identifier for the selected result, if any. Eg. 'wikipedia_enhanced', 'default_partner_search_suggestion'. | String | Yes |
| event_action | Action taken by the user which generated the event- 'engaged', 'abandoned', or 'annoyance'. | String | Yes |
| is_terminal | Did the event action cause the search session to end? Filter on 'is_terminal = TRUE' to count unique search sessions. | Boolean | Yes |
| engaged_result_type | Raw type identifier for the selected result, if any. | String | Yes |
| product_engaged_result_type | Product type identifier for the selected result, if any. | String | Yes |
| annoyance_signal_type | Annoyance option selected, if any. This uses the value of 'engagement_type' when 'event_action' is annoyance. Eg. 'dismiss', 'help'. | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_derived | urlbar_events_v2 |
Source Directory | View Definition | Metadata File
use_counters
Historical Pings for firefox-desktop/use-counters
firefox_desktop.use_counters
A historical view of pings sent for the
firefox-desktop/use-counters
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
| Column | Description | Type | Nullable |
|---|---|---|---|
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| client_info | Record | Yes | |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | 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 | |
| ping_info | 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_desktop_stable | use_counters_v1 |
Source Directory | View Definition | Metadata File