Skip to content

Firefox iOS

Data related to Firefox for iOS

Source Directory

active_users_aggregates

Active Users Aggregates

firefox_ios.active_users_aggregates

Please provide a description for the query

Referenced Tables
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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_ios_firefox baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta baseline_clients_daily

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

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_ios_firefox baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta baseline_clients_first_seen

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

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta baseline_clients_last_seen

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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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

Referenced Tables
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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec temp_bookmarks_sync
moz-fx-data-shared-prod org_mozilla_ios_firefox temp_bookmarks_sync
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta 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 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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec temp_credit_cards_sync
moz-fx-data-shared-prod org_mozilla_ios_firefox temp_credit_cards_sync
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta temp_credit_cards_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 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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec temp_rust_tabs_sync
moz-fx-data-shared-prod org_mozilla_ios_firefox temp_rust_tabs_sync
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta 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 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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
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.

Schema
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_ios_fennec topsites_impression
moz-fx-data-shared-prod org_mozilla_ios_firefox topsites_impression
moz-fx-data-shared-prod org_mozilla_ios_firefoxbeta topsites_impression

Source Directory | View Definition | Metadata File