org-mozilla-ios-firefox
User-facing views related to document namespace org-mozilla-ios-firefox; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/org-mozilla-ios-firefox
addresses_sync
Historical Pings for org-mozilla-ios-firefox/addresses-sync
org_mozilla_ios_firefox.addresses_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/addresses-sync
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 | org_mozilla_ios_firefox_stable | addresses_sync_v1 |
Source Directory | View Definition | Metadata File
baseline
Historical Pings for org-mozilla-ios-firefox/baseline
org_mozilla_ios_firefox.baseline
A historical view of pings sent for the
org-mozilla-ios-firefox/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 | org_mozilla_ios_firefox_stable | baseline_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
org_mozilla_ios_firefox.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 | org_mozilla_ios_firefox_derived | baseline_clients_daily_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
Baseline Clients First Seen
org_mozilla_ios_firefox.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 | org_mozilla_ios_firefox_derived | baseline_clients_daily_v1 |
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
Baseline Clients Last Seen
org_mozilla_ios_firefox.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 | org_mozilla_ios_firefox_derived | baseline_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
bookmarks_sync
Historical Pings for org-mozilla-ios-firefox/bookmarks-sync
org_mozilla_ios_firefox.bookmarks_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/bookmarks-sync
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 | org_mozilla_ios_firefox_stable | bookmarks_sync_v1 |
Source Directory | View Definition | Metadata File
creditcards_sync
Historical Pings for org-mozilla-ios-firefox/creditcards-sync
org_mozilla_ios_firefox.creditcards_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/creditcards-sync
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 | org_mozilla_ios_firefox_stable | creditcards_sync_v1 |
Source Directory | View Definition | Metadata File
deletion_request
Historical Pings for org-mozilla-ios-firefox/deletion-request
org_mozilla_ios_firefox.deletion_request
A historical view of pings sent for the
org-mozilla-ios-firefox/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 | org_mozilla_ios_firefox_stable | deletion_request_v1 |
Source Directory | View Definition | Metadata File
events
Historical Pings for org-mozilla-ios-firefox/events
org_mozilla_ios_firefox.events
A historical view of pings sent for the
org-mozilla-ios-firefox/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 | org_mozilla_ios_firefox_stable | events_v1 |
Source Directory | View Definition | Metadata File
first_session
Historical Pings for org-mozilla-ios-firefox/first-session
org_mozilla_ios_firefox.first_session
A historical view of pings sent for the
org-mozilla-ios-firefox/first-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
| 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 | org_mozilla_ios_firefox_stable | first_session_v1 |
Source Directory | View Definition | Metadata File
history_sync
Historical Pings for org-mozilla-ios-firefox/history-sync
org_mozilla_ios_firefox.history_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/history-sync
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 | org_mozilla_ios_firefox_stable | history_sync_v1 |
Source Directory | View Definition | Metadata File
logins_sync
Historical Pings for org-mozilla-ios-firefox/logins-sync
org_mozilla_ios_firefox.logins_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/logins-sync
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 | org_mozilla_ios_firefox_stable | logins_sync_v1 |
Source Directory | View Definition | Metadata File
metrics
Historical Pings for org-mozilla-ios-firefox/metrics
org_mozilla_ios_firefox.metrics
A historical view of pings sent for the
org-mozilla-ios-firefox/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 | org_mozilla_ios_firefox_stable | metrics_v1 |
Source Directory | View Definition | Metadata File
review_checker_clients
Review Checker Clients
org_mozilla_ios_firefox.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 | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| shopping_product_page_visits | Integer | Yes | |
| experiments | Record | No | |
| is_opt_in | Integer | Yes | |
| is_opt_out | Integer | Yes | |
| sap | Integer | Yes | |
| ad_click | Integer | Yes | |
| active_hours_sum | Float | Yes | |
| is_onboarded | Integer | Yes | |
| is_nimbus_disabled | Integer | Yes | |
| is_fx_dau | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_firefox_derived | review_checker_clients_v1 |
Source Directory | View Definition | Metadata File
review_checker_events
Review Checker Events
org_mozilla_ios_firefox.review_checker_events
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| os | String | Yes | |
| os_version | String | Yes | |
| is_address_bar_feature_callout_displayed | Integer | Yes | |
| is_address_bar_icon_clicked | Integer | Yes | |
| is_address_bar_icon_displayed | Integer | Yes | |
| is_surface_analyze_reviews_none_available_clicked | Integer | Yes | |
| is_surface_closed | Integer | Yes | |
| is_surface_displayed | Integer | Yes | |
| is_surface_settings_expand_clicked | Integer | Yes | |
| is_surface_learn_more_clicked | Integer | Yes | |
| is_surface_no_review_reliability_available | Integer | Yes | |
| is_surface_onboarding_displayed | Integer | Yes | |
| is_surface_opt_in_accepted | Integer | Yes | |
| is_surface_reactivated_button_clicked | Integer | Yes | |
| is_surface_reanalyze_clicked | Integer | Yes | |
| is_surface_powered_by_fakespot_link_clicked | Integer | Yes | |
| is_surface_show_more_reviews_button_clicked | Integer | Yes | |
| is_surface_show_privacy_policy_clicked | Integer | Yes | |
| is_surface_show_quality_explainer_url_clicked | Integer | Yes | |
| is_surface_show_terms_clicked | Integer | Yes | |
| is_surface_stale_analysis_shown | Integer | Yes | |
| is_engaged_with_sidebar | Integer | Yes | |
| experiments | Record | No | |
| normalized_channel | String | Yes | |
| normalized_country_code | String | Yes | |
| sample_id | Integer | Yes | |
| app_version | Numeric | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_firefox_derived | review_checker_events_v1 |
Source Directory | View Definition | Metadata File
sync
Historical Pings for org-mozilla-ios-firefox/sync
org_mozilla_ios_firefox.sync
A historical view of pings sent for the
org-mozilla-ios-firefox/sync
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 | org_mozilla_ios_firefox_stable | sync_v1 |
Source Directory | View Definition | Metadata File
tabs_sync
Historical Pings for org-mozilla-ios-firefox/tabs-sync
org_mozilla_ios_firefox.tabs_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/tabs-sync
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 | org_mozilla_ios_firefox_stable | tabs_sync_v1 |
Source Directory | View Definition | Metadata File
temp_baseline
Historical Pings for org-mozilla-ios-firefox/temp-baseline
org_mozilla_ios_firefox.temp_baseline
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-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 | org_mozilla_ios_firefox_stable | temp_baseline_v1 |
Source Directory | View Definition | Metadata File
temp_bookmarks_sync
Historical Pings for org-mozilla-ios-firefox/temp-bookmarks-sync
org_mozilla_ios_firefox.temp_bookmarks_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-bookmarks-sync
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 | org_mozilla_ios_firefox_stable | temp_bookmarks_sync_v1 |
Source Directory | View Definition | Metadata File
temp_clients_sync
Historical Pings for org-mozilla-ios-firefox/temp-clients-sync
org_mozilla_ios_firefox.temp_clients_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-clients-sync
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 | org_mozilla_ios_firefox_stable | temp_clients_sync_v1 |
Source Directory | View Definition | Metadata File
temp_credit_cards_sync
Historical Pings for org-mozilla-ios-firefox/temp-credit-cards-sync
org_mozilla_ios_firefox.temp_credit_cards_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-credit-cards-sync
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 | org_mozilla_ios_firefox_stable | temp_credit_cards_sync_v1 |
Source Directory | View Definition | Metadata File
temp_history_sync
Historical Pings for org-mozilla-ios-firefox/temp-history-sync
org_mozilla_ios_firefox.temp_history_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-history-sync
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 | org_mozilla_ios_firefox_stable | temp_history_sync_v1 |
Source Directory | View Definition | Metadata File
temp_logins_sync
Historical Pings for org-mozilla-ios-firefox/temp-logins-sync
org_mozilla_ios_firefox.temp_logins_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-logins-sync
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 | org_mozilla_ios_firefox_stable | temp_logins_sync_v1 |
Source Directory | View Definition | Metadata File
temp_rust_tabs_sync
Historical Pings for org-mozilla-ios-firefox/temp-rust-tabs-sync
org_mozilla_ios_firefox.temp_rust_tabs_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-rust-tabs-sync
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 | org_mozilla_ios_firefox_stable | temp_rust_tabs_sync_v1 |
Source Directory | View Definition | Metadata File
temp_sync
Historical Pings for org-mozilla-ios-firefox/temp-sync
org_mozilla_ios_firefox.temp_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-sync
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 | org_mozilla_ios_firefox_stable | temp_sync_v1 |
Source Directory | View Definition | Metadata File
temp_tabs_sync
Historical Pings for org-mozilla-ios-firefox/temp-tabs-sync
org_mozilla_ios_firefox.temp_tabs_sync
A historical view of pings sent for the
org-mozilla-ios-firefox/temp-tabs-sync
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 | org_mozilla_ios_firefox_stable | temp_tabs_sync_v1 |
Source Directory | View Definition | Metadata File
topsites_impression
Historical Pings for org-mozilla-ios-firefox/topsites-impression
org_mozilla_ios_firefox.topsites_impression
A historical view of pings sent for the
org-mozilla-ios-firefox/topsites-impression
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 | org_mozilla_ios_firefox_stable | topsites_impression_v1 |
Source Directory | View Definition | Metadata File
unified_metrics_v1
unified metrics
org_mozilla_ios_firefox.unified_metrics_v1
Union of legacy metrics and glean metrics
- Owners:
Source Directory | Metadata File