Firefox iOS
Data related to Firefox for iOS
active_users_aggregates
Active Users Aggregates
firefox_ios.active_users_aggregates
Please provide a description for the query
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | active_users_aggregates_v2 |
Source Directory | View Definition | Metadata File
ad_activation_performance
Ad Activation Performance
firefox_ios.ad_activation_performance
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| date_day | Date | Yes | |
| campaign_id | Integer | Yes | |
| campaign_name | String | Yes | |
| currency | String | Yes | |
| taps | Integer | Yes | |
| new_downloads | Integer | Yes | |
| redownloads | Integer | Yes | |
| total_downloads | Integer | Yes | |
| impressions | Integer | Yes | |
| campaign_spend | Bignumeric | Yes | |
| clients_activated | Integer | Yes | |
| new_profiles | Integer | Yes | |
| campaign_spend_per_activation | Bignumeric | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | apple_ads | campaign_report |
| moz-fx-data-shared-prod | firefox_ios | firefox_ios_clients |
Source Directory | View Definition | Metadata File
addresses_sync
App-specific view for Glean ping "addresses-sync"
firefox_ios.addresses_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.addresses_sync, org_mozilla_ios_firefoxbeta.addresses_sync, org_mozilla_ios_fennec.addresses_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | addresses_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | addresses_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | addresses_sync |
Source Directory | View Definition | Metadata File
app_store_funnel
App Store Funnel
firefox_ios.app_store_funnel
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Partition field, also corresponds to internal execution date of the job. submision_date - 7 days gives us the same date as the date field. | Date | Yes |
| first_seen_date | Date of when the user was first seen. | Date | Yes |
| country | Dimension by which the numeric values are grouped. | String | Yes |
| impressions | Number of Firefox iOS app unique impressions in the Apple Store. | Integer | Yes |
| total_downloads | Total number of downloads of the Firefox iOS app from the Apple Store. | Integer | Yes |
| first_time_downloads | Number of first time downloads of the Firefox iOS app from the Apple Store. | Integer | Yes |
| redownloads | Number of redownloads of the Firefox iOS app from the Apple Store. | Integer | Yes |
| new_profiles | Number of new profiles on the date. | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | app_store_funnel_v1 |
Source Directory | View Definition | Metadata File
attributable_clients
Attributable Clients
firefox_ios.attributable_clients
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Processing date, this indicates which date partiion was used when generating this record. | Date | Yes |
| first_seen_date | Date when we observed the user for the first time. | Date | Yes |
| sample_id | Sample ID to limit query results during an analysis. | Integer | Yes |
| client_id | Unique ID for the client installation. | String | Yes |
| adjust_network | The type of source of a client installation. | String | Yes |
| adjust_adgroup | Structure parameter for the the ad group of a campaign. | String | Yes |
| adjust_campaign | Structure parameter for the campaign name. | String | Yes |
| adjust_creative | Structure parameter for the creative content of a campaign. | String | Yes |
| is_new_profile | Determines if a client is a new profile. | Boolean | Yes |
| searches | The number of search interactions the user had on SERP pages. | Integer | Yes |
| searches_with_ads | The number of SERP pages with ads shown to the user. | Integer | Yes |
| ad_clicks | The number of times a user clicked on an ad on SERP pages. | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | attributable_clients_v1 |
Source Directory | View Definition | Metadata File
baseline
App-specific view for Glean ping "baseline"
firefox_ios.baseline
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.baseline, org_mozilla_ios_firefoxbeta.baseline, org_mozilla_ios_fennec.baseline).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | baseline |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | baseline |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | baseline |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
firefox_ios.baseline_clients_daily
Please provide a description for the query
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
Baseline Clients First Seen
firefox_ios.baseline_clients_first_seen
Please provide a description for the query
Source Directory | View Definition | Metadata File
baseline_clients_last_seen
Baseline Clients Last Seen
firefox_ios.baseline_clients_last_seen
Please provide a description for the query
Source Directory | View Definition | Metadata File
baseline_clients_yearly
Baseline Clients Yearly
firefox_ios.baseline_clients_yearly
Captures activity history of each client in 1-Year 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 | |
| consecutive_days_seen | Integer | Yes | |
| days_seen_in_past_year | Integer | Yes | |
| days_since_active | Integer | Yes | |
| consecutive_days_active | Integer | Yes | |
| days_active_in_past_year | Integer | Yes | |
| days_since_first_seen | Integer | Yes | |
| day_of_week | Integer | Yes | |
| days_seen_bytes | Bytes | Yes | |
| days_active_bytes | Bytes | Yes | |
| normalized_app_id | String | 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_ios_derived | baseline_clients_yearly_v1 |
Source Directory | View Definition | Metadata File
bookmarks_sync
App-specific view for Glean ping "bookmarks-sync"
firefox_ios.bookmarks_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.bookmarks_sync, org_mozilla_ios_firefoxbeta.bookmarks_sync, org_mozilla_ios_fennec.bookmarks_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | bookmarks_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | bookmarks_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | bookmarks_sync |
Source Directory | View Definition | Metadata File
client_adclicks_history
Client Adclicks History
firefox_ios.client_adclicks_history
Client Adclick History. Contains a map of each day in a clients history and the number of adclicks on that day.
For use with LTV.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| client_id | Unique ID for the client installation. | String | Yes |
| sample_id | Sample ID to limit query results during an analysis. | Integer | Yes |
| ad_click_history | History of ad_clicks for a user, by submission_date | Record | No |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | client_adclicks_history_v1 |
Source Directory | View Definition | Metadata File
clients_activation
Clients Activation
firefox_ios.clients_activation
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date when a client activated. | Date | Yes |
| first_seen_date | Date when the app first reported a baseline ping for the client. | Date | Yes |
| client_id | Unique ID for the client installation. | String | Yes |
| sample_id | Sample ID to limit query results during an analysis. | Integer | Yes |
| is_activated | Determines if a client is activated based on the activation metric and a 7 day lag. | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | clients_activation_v1 |
Source Directory | View Definition | Metadata File
clients_last_seen_joined
Clients Last Seen Joined
firefox_ios.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 | |
| uri_count | Integer | Yes | |
| is_default_browser | Boolean | Yes | |
| isp | String | Yes | |
| normalized_app_id | String | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | clients_last_seen_joined_v1 |
Source Directory | View Definition | Metadata File
creditcards_sync
App-specific view for Glean ping "creditcards-sync"
firefox_ios.creditcards_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.creditcards_sync, org_mozilla_ios_firefoxbeta.creditcards_sync, org_mozilla_ios_fennec.creditcards_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | creditcards_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | creditcards_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | creditcards_sync |
Source Directory | View Definition | Metadata File
deletion_request
App-specific view for Glean ping "deletion-request"
firefox_ios.deletion_request
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.deletion_request, org_mozilla_ios_firefoxbeta.deletion_request, org_mozilla_ios_fennec.deletion_request).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | deletion_request |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | deletion_request |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | deletion_request |
Source Directory | View Definition | Metadata File
events
App-specific view for Glean ping "events"
firefox_ios.events
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.events, org_mozilla_ios_firefoxbeta.events, org_mozilla_ios_fennec.events).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| 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
events_unnested
Events Unnested
firefox_ios.events_unnested
Please provide a description for the query
| 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
firefox_ios_clients
Firefox Ios Clients
firefox_ios.firefox_ios_clients
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| client_id | Unique ID for the client installation. | String | Yes |
| sample_id | Sample ID to limit query results during an analysis. | Integer | Yes |
| first_seen_date | Date when the app first reported a baseline ping for the client. | Date | Yes |
| first_reported_country | First reported country for the client installation. | String | Yes |
| first_reported_isp | Name of the first reported isp (Internet Service Provider). | String | Yes |
| channel | Channel where the browser is released. | String | Yes |
| device_manufacturer | Manufacturer of the device where the client is installed. | String | Yes |
| device_model | Model of the device where the client is installed. | String | Yes |
| os_version | Version of the Operating System where the client is originally installed. | String | Yes |
| app_version | App display version for this client installation. | String | Yes |
| is_activated | Determines if a client is activated based on the activation metric and a 7 day lag. | Boolean | Yes |
| submission_timestamp | Timestamp of the ping which contained the adjust information. | Timestamp | Yes |
| adjust_ad_group | Structure parameter for the the ad group of a campaign. | String | Yes |
| adjust_campaign | Structure parameter for the campaign name. | String | Yes |
| adjust_creative | Structure parameter for the creative content of a campaign. | String | Yes |
| adjust_network | The type of source of a client installation. | String | Yes |
| metadata | Additional context around the source of this record. | Record | Yes |
| is_suspicious_device_client | Flag to identify suspicious device users, see bug-1846554 for more info. | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | firefox_ios_clients_v1 |
Source Directory | View Definition | Metadata File
first_session
App-specific view for Glean ping "first-session"
firefox_ios.first_session
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.first_session, org_mozilla_ios_firefoxbeta.first_session, org_mozilla_ios_fennec.first_session).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | first_session |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | first_session |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | first_session |
Source Directory | View Definition | Metadata File
funnel_retention_clients
Funnel Retention Clients
firefox_ios.funnel_retention_clients
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| first_seen_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| first_reported_country | String | Yes | |
| first_reported_isp | String | Yes | |
| adjust_ad_group | String | Yes | |
| adjust_campaign | String | Yes | |
| adjust_creative | String | Yes | |
| adjust_network | String | Yes | |
| retained_week_2 | Boolean | Yes | |
| retained_week_4 | Boolean | Yes | |
| days_seen_in_first_28_days | Integer | Yes | |
| repeat_first_month_user | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | funnel_retention_clients_week_2_v1 |
| moz-fx-data-shared-prod | firefox_ios_derived | funnel_retention_clients_week_4_v1 |
Source Directory | View Definition | Metadata File
funnel_retention_week_4
Funnel Retention Week 4
firefox_ios.funnel_retention_week_4
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Partition field, also corresponds to internal execution date of the job (first_seen_date + 28 days). | Date | Yes |
| first_seen_date | Date of when the client was first seen. | Date | Yes |
| first_reported_country | First reported country for the client installation. | String | Yes |
| first_reported_isp | Name of the first reported isp (Internet Service Provider). | String | Yes |
| adjust_ad_group | Structure parameter for the the ad group of a campaign. | String | Yes |
| adjust_campaign | Structure parameter for the campaign name. | String | Yes |
| adjust_creative | Structure parameter for the creative content of a campaign. | String | Yes |
| adjust_network | The type of source of a client installation. | String | Yes |
| new_profiles | Count of new_profiles for the given grouping. | Integer | Yes |
| repeat_user | Count of clients categorised as "repeat_first_month_user" for the grouping. | Integer | Yes |
| retained_week_4 | Count of clients categorised as "retained_week_4" for the grouping. | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | funnel_retention_week_4_v1 |
Source Directory | View Definition | Metadata File
history_sync
App-specific view for Glean ping "history-sync"
firefox_ios.history_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.history_sync, org_mozilla_ios_firefoxbeta.history_sync, org_mozilla_ios_fennec.history_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | history_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | history_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | history_sync |
Source Directory | View Definition | Metadata File
logins_sync
App-specific view for Glean ping "logins-sync"
firefox_ios.logins_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.logins_sync, org_mozilla_ios_firefoxbeta.logins_sync, org_mozilla_ios_fennec.logins_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | logins_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | logins_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | logins_sync |
Source Directory | View Definition | Metadata File
metrics
App-specific view for Glean ping "metrics"
firefox_ios.metrics
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.metrics, org_mozilla_ios_firefoxbeta.metrics, org_mozilla_ios_fennec.metrics).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | metrics |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | metrics |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | metrics |
Source Directory | View Definition | Metadata File
metrics_clients_daily
Metrics Clients Daily
firefox_ios.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 | |
| 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
Metrics Clients Last Seen
firefox_ios.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 | |
| 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
new_profile_activation
New Profile Activation
firefox_ios.new_profile_activation
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| client_id | Unique ID for the client installation. | String | Yes |
| sample_id | Sample ID to limit query results during an analysis. | Integer | Yes |
| normalized_channel | The channel the application is being distributed on (normalized). This could be release, beta, etc. | String | Yes |
| app_build | The build identifier generated by the CI system (e.g. "1234/A"). If the value was not provided through configuration, this metric gets set to Unknown. | String | Yes |
| app_channel | The channel the application is being distributed on. | String | Yes |
| app_display_version | The user visible version string (e.g. "1.0.3"). If the value was not provided through configuration, this metric gets set to Unknown. | String | Yes |
| device_manufacturer | The manufacturer of the device the application is running on. Not set if the device manufacturer can't be determined (e.g. on Desktop). | String | Yes |
| device_model | The model of the device the application is running on. On Android, this is Build.MODEL, the user-visible marketing name, like "Pixel 2 XL". Not set if the device model can't be determined (e.g. on Desktop). | String | Yes |
| isp | Name of the isp (Internet Service Provider). | String | Yes |
| locale | The locale of the application during initialization (e.g. "es-ES"). If the locale can't be determined on the system, the value is "und", to indicate "undetermined". | String | Yes |
| city | City associated with the client's activity. | String | Yes |
| country | Country associated with the client's activity (2 letter ISO country codes used). | String | Yes |
| first_seen_date | Date when the app first reported a baseline ping for the client. | Date | Yes |
| submission_date | Processing date, this indicates which date partiion was used when generating this record. | Date | Yes |
| new_profile | Determines if a client is a new profile. | Integer | Yes |
| activated | Determines if a client is activated based on the activation metric and a 7 day lag. | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_ios_derived | new_profile_activation_v1 |
Source Directory | View Definition | Metadata File
sync
App-specific view for Glean ping "sync"
firefox_ios.sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.sync, org_mozilla_ios_firefoxbeta.sync, org_mozilla_ios_fennec.sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | sync |
Source Directory | View Definition | Metadata File
tabs_sync
App-specific view for Glean ping "tabs-sync"
firefox_ios.tabs_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.tabs_sync, org_mozilla_ios_firefoxbeta.tabs_sync, org_mozilla_ios_fennec.tabs_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | tabs_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | tabs_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | tabs_sync |
Source Directory | View Definition | Metadata File
temp_baseline
App-specific view for Glean ping "temp-baseline"
firefox_ios.temp_baseline
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_baseline, org_mozilla_ios_firefoxbeta.temp_baseline, org_mozilla_ios_fennec.temp_baseline).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | temp_baseline |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | temp_baseline |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | temp_baseline |
Source Directory | View Definition | Metadata File
temp_bookmarks_sync
App-specific view for Glean ping "temp-bookmarks-sync"
firefox_ios.temp_bookmarks_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_bookmarks_sync, org_mozilla_ios_firefoxbeta.temp_bookmarks_sync, org_mozilla_ios_fennec.temp_bookmarks_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
temp_clients_sync
App-specific view for Glean ping "temp-clients-sync"
firefox_ios.temp_clients_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_clients_sync, org_mozilla_ios_firefoxbeta.temp_clients_sync, org_mozilla_ios_fennec.temp_clients_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | temp_clients_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | temp_clients_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | temp_clients_sync |
Source Directory | View Definition | Metadata File
temp_credit_cards_sync
App-specific view for Glean ping "temp-credit-cards-sync"
firefox_ios.temp_credit_cards_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_credit_cards_sync, org_mozilla_ios_firefoxbeta.temp_credit_cards_sync, org_mozilla_ios_fennec.temp_credit_cards_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
temp_history_sync
App-specific view for Glean ping "temp-history-sync"
firefox_ios.temp_history_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_history_sync, org_mozilla_ios_firefoxbeta.temp_history_sync, org_mozilla_ios_fennec.temp_history_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | temp_history_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | temp_history_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | 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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_logins_sync, org_mozilla_ios_firefoxbeta.temp_logins_sync, org_mozilla_ios_fennec.temp_logins_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | temp_logins_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | temp_logins_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | 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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_rust_tabs_sync, org_mozilla_ios_firefoxbeta.temp_rust_tabs_sync, org_mozilla_ios_fennec.temp_rust_tabs_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File
temp_sync
App-specific view for Glean ping "temp-sync"
firefox_ios.temp_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_sync, org_mozilla_ios_firefoxbeta.temp_sync, org_mozilla_ios_fennec.temp_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | temp_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | temp_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | 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 a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.temp_tabs_sync, org_mozilla_ios_firefoxbeta.temp_tabs_sync, org_mozilla_ios_fennec.temp_tabs_sync).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_ios_fennec | temp_tabs_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefox | temp_tabs_sync |
| moz-fx-data-shared-prod | org_mozilla_ios_firefoxbeta | temp_tabs_sync |
Source Directory | View Definition | Metadata File
topsites_impression
App-specific view for Glean ping "topsites-impression"
firefox_ios.topsites_impression
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for iOS" (org_mozilla_ios_firefox.topsites_impression, org_mozilla_ios_firefoxbeta.topsites_impression, org_mozilla_ios_fennec.topsites_impression).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
Source Directory | View Definition | Metadata File