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