Firefox Ios
Views on data from firefox_ios
baseline
App-specific view for Glean ping "baseline"
firefox_ios.baseline
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.baseline).
It is used by Looker.
| 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 | baseline |
Source Directory | View Definition | Metadata File
baseline_clients_daily
firefox_ios.baseline_clients_daily
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
firefox_ios.baseline_clients_first_seen
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
firefox_ios.baseline_clients_last_seen
Source Directory | View Definition | Metadata File
clients_last_seen_joined
firefox_ios.clients_last_seen_joined
| 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 | |
| uri_count | Integer | Yes | |
| is_default_browser | Boolean | Yes | |
| isp | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | clients_last_seen_joined_v1 |
Source Directory | View Definition | Metadata File
deletion_request
App-specific view for Glean ping "deletion-request"
firefox_ios.deletion_request
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.deletion_request).
It is used by Looker.
| 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 | deletion_request |
Source Directory | View Definition | Metadata File
events
App-specific view for Glean ping "events"
firefox_ios.events
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.events).
It is used by Looker.
| 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 | events |
Source Directory | View Definition | Metadata File
events_unnested
firefox_ios.events_unnested
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | events |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | events |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | events |
Source Directory | View Definition | Metadata File
first_session
App-specific view for Glean ping "first-session"
firefox_ios.first_session
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.first_session).
It is used by Looker.
| 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 | first_session |
Source Directory | View Definition | Metadata File
metrics
App-specific view for Glean ping "metrics"
firefox_ios.metrics
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.metrics).
It is used by Looker.
| 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 | metrics |
Source Directory | View Definition | Metadata File
metrics_clients_daily
firefox_ios.metrics_clients_daily
| 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 | |
| uri_count | Integer | Yes | |
| is_default_browser | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | metrics_clients_daily_v1 |
Source Directory | View Definition | Metadata File
metrics_clients_last_seen
firefox_ios.metrics_clients_last_seen
| 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 | |
| uri_count | Integer | Yes | |
| is_default_browser | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | metrics_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
temp_bookmarks_sync
App-specific view for Glean ping "temp-bookmarks-sync"
firefox_ios.temp_bookmarks_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_bookmarks_sync).
It is used by Looker.
| 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 | temp_bookmarks_sync |
Source Directory | View Definition | Metadata File
temp_clients_sync
App-specific view for Glean ping "temp-clients-sync"
firefox_ios.temp_clients_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_clients_sync).
It is used by Looker.
| 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 | temp_clients_sync |
Source Directory | View Definition | Metadata File
temp_history_sync
App-specific view for Glean ping "temp-history-sync"
firefox_ios.temp_history_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_history_sync).
It is used by Looker.
| 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 | temp_history_sync |
Source Directory | View Definition | Metadata File
temp_logins_sync
App-specific view for Glean ping "temp-logins-sync"
firefox_ios.temp_logins_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_logins_sync).
It is used by Looker.
| 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 | temp_logins_sync |
Source Directory | View Definition | Metadata File
temp_rust_tabs_sync
App-specific view for Glean ping "temp-rust-tabs-sync"
firefox_ios.temp_rust_tabs_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_rust_tabs_sync).
It is used by Looker.
| 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 | temp_rust_tabs_sync |
Source Directory | View Definition | Metadata File
temp_sync
App-specific view for Glean ping "temp-sync"
firefox_ios.temp_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_sync).
It is used by Looker.
| 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 | temp_sync |
Source Directory | View Definition | Metadata File
temp_tabs_sync
App-specific view for Glean ping "temp-tabs-sync"
firefox_ios.temp_tabs_sync
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.temp_tabs_sync).
It is used by Looker.
| 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 | temp_tabs_sync |
Source Directory | View Definition | Metadata File
topsites_impression
App-specific view for Glean ping "topsites-impression"
firefox_ios.topsites_impression
This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Firefox for iOS" (moz-fx-data-shared-prod.org_mozilla_ios_firefox.topsites_impression).
It is used by Looker.
| 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 | topsites_impression |
Source Directory | View Definition | Metadata File