Fenix
Data related to Fenix (Firefox for Android)
activation
App-specific view for Glean ping "activation"
fenix.activation
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.activation, org_mozilla_firefox_beta.activation, org_mozilla_fenix.activation, org_mozilla_fenix_nightly.activation, org_mozilla_fennec_aurora.activation).
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
active_users_aggregates
Active Users Aggregates
fenix.active_users_aggregates
Please provide a description for the query
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | active_users_aggregates_v2 |
Source Directory | View Definition | Metadata File
addresses_sync
App-specific view for Glean ping "addresses-sync"
fenix.addresses_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.addresses_sync, org_mozilla_firefox_beta.addresses_sync, org_mozilla_fenix.addresses_sync, org_mozilla_fenix_nightly.addresses_sync, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
attributable_clients
Attributable Clients
fenix.attributable_clients
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
submission_date | Date | Yes | |
cohort_date | Date | Yes | |
sample_id | Integer | Yes | |
client_id | String | Yes | |
country | String | Yes | |
adjust_network | String | Yes | |
adjust_adgroup | String | Yes | |
adjust_campaign | String | Yes | |
adjust_creative | String | Yes | |
is_new_profile | Boolean | Yes | |
searches | Integer | Yes | |
searches_with_ads | Integer | Yes | |
ad_clicks | Integer | Yes | |
is_new_install | Boolean | Yes | |
activated | Boolean | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | attributable_clients_v1 |
Source Directory | View Definition | Metadata File
attributable_clients_v2
Attributable Clients V2
fenix.attributable_clients_v2
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
submission_date | Date | Yes | |
cohort_date | Date | Yes | |
first_seen_date | Date | Yes | |
sample_id | Integer | Yes | |
client_id | String | Yes | |
activations_count | Integer | Yes | |
active_day_count | Integer | Yes | |
searches | Integer | Yes | |
searches_with_ads | Integer | Yes | |
ad_clicks | Integer | Yes | |
first_reported_country | String | Yes | |
adjust_network | String | Yes | |
adjust_ad_group | String | Yes | |
adjust_campaign | String | Yes | |
adjust_creative | String | Yes | |
is_new_install | Boolean | Yes | |
is_new_profile | Boolean | Yes | |
is_activated | Boolean | Yes | |
metadata | Record | Yes | |
firefox_android_clients_metadata | Record | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix | firefox_android_clients |
moz-fx-data-shared-prod | fenix | new_profile_activation |
moz-fx-data-shared-prod | fenix_derived | attributable_clients_v2 |
Source Directory | View Definition | Metadata File
baseline
App-specific view for Glean ping "baseline"
fenix.baseline
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.baseline, org_mozilla_firefox_beta.baseline, org_mozilla_fenix.baseline, org_mozilla_fenix_nightly.baseline, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
baseline_clients_daily
Baseline Clients Daily
fenix.baseline_clients_daily
Please provide a description for the query
Source Directory | View Definition | Metadata File
baseline_clients_first_seen
Baseline Clients First Seen
fenix.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
fenix.baseline_clients_last_seen
Please provide a description for the query
Source Directory | View Definition | Metadata File
bookmarks_sync
App-specific view for Glean ping "bookmarks-sync"
fenix.bookmarks_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.bookmarks_sync, org_mozilla_firefox_beta.bookmarks_sync, org_mozilla_fenix.bookmarks_sync, org_mozilla_fenix_nightly.bookmarks_sync, org_mozilla_fennec_aurora.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
broken_site_report
App-specific view for Glean ping "broken-site-report"
fenix.broken_site_report
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.broken_site_report, org_mozilla_firefox_beta.broken_site_report, org_mozilla_fenix.broken_site_report, org_mozilla_fenix_nightly.broken_site_report, org_mozilla_fennec_aurora.broken_site_report).
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
client_adclicks_history
Client Adclicks History
fenix.client_adclicks_history
Contains the full history of ad-clicks for each client.
This should only be used for the LTV project. To calculate LTV for any client, we add together two things - 1. Predicted future Ad Clicks 2. Total historical ad clicks
This table provides 2. The full history of each client's ad_clicks are available as a MAP, keyed by date, where the value is the number of ad clicks.
- 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 | fenix_derived | client_adclicks_history_v1 |
Source Directory | View Definition | Metadata File
client_deduplication
Client Deduplication
fenix.client_deduplication
A view over all client deduplication pings, from all channels.
- Owners:
Column | Description | Type | Nullable |
---|---|---|---|
client_id | String | Yes | |
hashed_ad_id | String | Yes | |
valid_advertising_id | Boolean | Yes | |
submission_date | Date | Yes | |
normalized_app_id | 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_channel | 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_fenix | client_deduplication |
moz-fx-data-shared-prod | org_mozilla_firefox | client_deduplication |
moz-fx-data-shared-prod | org_mozilla_firefox_beta | client_deduplication |
Source Directory | View Definition | Metadata File
clients_last_seen_joined
Clients Last Seen Joined
fenix.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 | fenix_derived | clients_last_seen_joined_v1 |
Source Directory | View Definition | Metadata File
clients_yearly
Clients Yearly
fenix.clients_yearly
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
days_seen_bytes | Bytes | 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 | |
days_since_seen | Integer | Yes | |
consecutive_days_seen | Integer | Yes | |
days_seen_in_past_year | Integer | Yes | |
days_since_first_seen | Integer | Yes | |
day_of_week | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | clients_yearly_v1 |
Source Directory | View Definition | Metadata File
cookie_banner_report_site
App-specific view for Glean ping "cookie-banner-report-site"
fenix.cookie_banner_report_site
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.cookie_banner_report_site, org_mozilla_firefox_beta.cookie_banner_report_site, org_mozilla_fenix.cookie_banner_report_site, org_mozilla_fenix_nightly.cookie_banner_report_site, org_mozilla_fennec_aurora.cookie_banner_report_site).
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
crash
App-specific view for Glean ping "crash"
fenix.crash
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.crash, org_mozilla_firefox_beta.crash, org_mozilla_fenix.crash, org_mozilla_fenix_nightly.crash, org_mozilla_fennec_aurora.crash).
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
creditcards_sync
App-specific view for Glean ping "creditcards-sync"
fenix.creditcards_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.creditcards_sync, org_mozilla_firefox_beta.creditcards_sync, org_mozilla_fenix.creditcards_sync, org_mozilla_fenix_nightly.creditcards_sync, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
deletion_request
App-specific view for Glean ping "deletion-request"
fenix.deletion_request
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.deletion_request, org_mozilla_firefox_beta.deletion_request, org_mozilla_fenix.deletion_request, org_mozilla_fenix_nightly.deletion_request, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
event_types
Event Types
fenix.event_types
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
category | String | Yes | |
event | String | Yes | |
first_timestamp | Timestamp | Yes | |
numeric_index | Integer | Yes | |
index | String | Yes | |
event_properties | Record | No |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | event_types_v1 |
Source Directory | View Definition | Metadata File
events
App-specific view for Glean ping "events"
fenix.events
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.events, org_mozilla_firefox_beta.events, org_mozilla_fenix.events, org_mozilla_fenix_nightly.events, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
events_daily
Events Daily
fenix.events_daily
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
submission_date | Date | Yes | |
client_id | String | Yes | |
sample_id | Integer | Yes | |
events | String | Yes | |
android_sdk_version | 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 | |
first_run_date | String | Yes | |
telemetry_sdk_build | String | Yes | |
locale | String | Yes | |
city | String | Yes | |
country | String | Yes | |
subdivision1 | String | Yes | |
channel | String | Yes | |
os | String | Yes | |
os_version | String | Yes | |
experiments | Record | No |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | events_daily_v1 |
Source Directory | View Definition | Metadata File
events_unnested
Events Unnested
fenix.events_unnested
Please provide a description for the query
Source Directory | View Definition | Metadata File
firefox_android_clients
Firefox Android Clients
fenix.firefox_android_clients
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
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 |
submission_date | Date when the server first received a baseline ping for the client. | Date | Yes |
first_run_date | Date when the browser first ran. | 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 |
locale | Client locale. | String | Yes |
activated | Determines if a client is activated based on the activation metric and a 7 day lag. | Boolean | Yes |
adjust_campaign | Structure parameter for the campaign name. | String | Yes |
adjust_ad_group | Structure parameter for the the ad group of a campaign. | String | Yes |
adjust_creative | Structure parameter for the creative content of a campaign. | String | Yes |
last_reported_adjust_campaign | Last reported campaign name. | String | Yes |
last_reported_adjust_ad_group | Last reported campaign ad group. | String | Yes |
last_reported_adjust_creative | Last reported campaign name. | String | Yes |
last_reported_adjust_network | Last reported client campaign network. | String | Yes |
last_reported_date | Last date client seen. | Date | Yes |
last_reported_channel | Last reported client channel. | String | Yes |
last_reported_country | Last reported client country. | String | Yes |
last_reported_device_model | Last reported client device model. | String | Yes |
last_reported_device_manufacturer | Last reported client device manufacturer. | String | Yes |
last_reported_locale | Last reported client locale. | String | Yes |
metadata | Record | Yes | |
adjust_network | Structure parameter for the network of a campaign. | String | Yes |
install_source | The source of a client installation. | String | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | firefox_android_clients_v1 |
Source Directory | View Definition | Metadata File
first_session
App-specific view for Glean ping "first-session"
fenix.first_session
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.first_session, org_mozilla_firefox_beta.first_session, org_mozilla_fenix.first_session, org_mozilla_fenix_nightly.first_session, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
fog_validation
App-specific view for Glean ping "fog-validation"
fenix.fog_validation
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.fog_validation, org_mozilla_firefox_beta.fog_validation, org_mozilla_fenix.fog_validation, org_mozilla_fenix_nightly.fog_validation, org_mozilla_fennec_aurora.fog_validation).
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
font_list
App-specific view for Glean ping "font-list"
fenix.font_list
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.font_list, org_mozilla_firefox_beta.font_list, org_mozilla_fenix.font_list, org_mozilla_fenix_nightly.font_list, org_mozilla_fennec_aurora.font_list).
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
funnel_retention_clients
Funnel Retention Clients
fenix.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 | |
install_source | 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 | fenix_derived | funnel_retention_clients_week_2_v1 |
moz-fx-data-shared-prod | fenix_derived | funnel_retention_clients_week_4_v1 |
Source Directory | View Definition | Metadata File
funnel_retention_week_4
Funnel Retention Week 4
fenix.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 |
install_source | 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 | fenix_derived | funnel_retention_week_4_v1 |
Source Directory | View Definition | Metadata File
fx_suggest
App-specific view for Glean ping "fx-suggest"
fenix.fx_suggest
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.fx_suggest, org_mozilla_firefox_beta.fx_suggest, org_mozilla_fenix.fx_suggest, org_mozilla_fenix_nightly.fx_suggest, org_mozilla_fennec_aurora.fx_suggest).
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
gplay_installs_by_country
Gplay Installs By Country
fenix.gplay_installs_by_country
A view on Fenix Google Play Install Data by Country
- Owners:
Column | Description | Type | Nullable |
---|---|---|---|
date | Date | Yes | |
channel | String | Yes | |
country_code | String | Yes | |
country_name | String | Yes | |
region_name | String | Yes | |
subregion_name | String | Yes | |
install_count | Integer | Yes | |
uninstall_count | Integer | Yes | |
update_count | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_external | gplay_installs_by_country_v1 |
Source Directory | View Definition | Metadata File
history_sync
App-specific view for Glean ping "history-sync"
fenix.history_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.history_sync, org_mozilla_firefox_beta.history_sync, org_mozilla_fenix.history_sync, org_mozilla_fenix_nightly.history_sync, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
installation
App-specific view for Glean ping "installation"
fenix.installation
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.installation, org_mozilla_firefox_beta.installation, org_mozilla_fenix.installation, org_mozilla_fenix_nightly.installation, org_mozilla_fennec_aurora.installation).
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
logins_sync
App-specific view for Glean ping "logins-sync"
fenix.logins_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.logins_sync, org_mozilla_firefox_beta.logins_sync, org_mozilla_fenix.logins_sync, org_mozilla_fenix_nightly.logins_sync, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
ltv_states
Ltv States
fenix.ltv_states
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
client_id | Client ID; uniquely identifies a client. Joinable with fenix.firefox_android_clients. | String | Yes |
submission_date | Submission date, the date of the data. Also the partition key. | Date | Yes |
markov_states | Record | Yes | |
sample_id | A number, 0-99, that samples by client_id. | Integer | Yes |
first_seen_date | First submission date that this client was seen on. | Date | Yes |
days_since_first_seen | Number of days since this client was first seen. | Integer | Yes |
days_since_seen | Number of days since this client was last seen. For example, if they were seen yesterday, days_since_seen would be 1. | Integer | Yes |
consecutive_days_seen | Number of consecutive days this client has been seen. For example, if they were missing two days ago but present yesterday & today, consecutive_days_seen would be 2. | Integer | Yes |
days_seen_bytes | Days seen over the past year, represented as bytes. | Bytes | Yes |
ad_clicks_on_date | Number of ad clicks by this client on this submission date. | Integer | Yes |
total_historic_ad_clicks | Total historic ad clicks by this client up to this date (inclusive of this date). | Integer | Yes |
first_reported_country | First country reported by this client. | String | Yes |
first_reported_isp | First ISP reported by this client. | String | Yes |
adjust_network | First Adjust Network reported by this client. | String | Yes |
install_source | First install source reported by this client. | String | Yes |
activity_pattern | Integer | Yes | |
active_on_this_date | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | ltv_states_v1 |
Source Directory | View Definition | Metadata File
marketing_attributable_metrics
Marketing Attributable Metrics
fenix.marketing_attributable_metrics
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
submission_date | Date | Yes | |
cohort_date | Date | Yes | |
sample_id | Integer | Yes | |
client_id | String | Yes | |
country | String | Yes | |
adjust_network | String | Yes | |
adjust_adgroup | String | Yes | |
adjust_campaign | String | Yes | |
adjust_creative | String | Yes | |
is_new_profile | Boolean | Yes | |
searches_with_ads | Integer | Yes | |
ad_clicks | Integer | Yes | |
is_new_install | Boolean | Yes | |
activated | Boolean | Yes | |
dau | Integer | Yes | |
new_profiles | Integer | Yes | |
search_count | Integer | Yes | |
new_installs | Integer | Yes | |
activations | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix | attributable_clients |
Source Directory | View Definition | Metadata File
metrics
App-specific view for Glean ping "metrics"
fenix.metrics
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.metrics, org_mozilla_firefox_beta.metrics, org_mozilla_fenix.metrics, org_mozilla_fenix_nightly.metrics, org_mozilla_fennec_aurora.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 |
Source Directory | View Definition | Metadata File
metrics_clients_daily
Metrics Clients Daily
fenix.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 | fenix_derived | metrics_clients_daily_v1 |
Source Directory | View Definition | Metadata File
metrics_clients_last_seen
Metrics Clients Last Seen
fenix.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 | fenix_derived | metrics_clients_last_seen_v1 |
Source Directory | View Definition | Metadata File
migrated_clients
Migrated Clients
fenix.migrated_clients
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
fenix_client_id | String | Yes | |
submission_date | Date | Yes | |
normalized_channel | String | Yes | |
manufacturer | String | Yes | |
country | String | Yes | |
fennec_client_id | String | Yes | |
migration_ping_count | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | org_mozilla_firefox_derived | migrated_clients_v1 |
Source Directory | View Definition | Metadata File
migration
App-specific view for Glean ping "migration"
fenix.migration
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.migration, org_mozilla_firefox_beta.migration, org_mozilla_fenix.migration, org_mozilla_fenix_nightly.migration, org_mozilla_fennec_aurora.migration).
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 |
submission_date | Date | 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
new_profile_activation
New Profile Activation
fenix.new_profile_activation
Please provide a description for the query
Column | Description | Type | Nullable |
---|---|---|---|
client_id | String | Yes | |
sample_id | Integer | Yes | |
normalized_channel | String | Yes | |
app_build | String | Yes | |
app_channel | String | Yes | |
app_display_version | String | Yes | |
device_manufacturer | String | Yes | |
device_model | String | Yes | |
isp | String | Yes | |
locale | String | Yes | |
city | String | Yes | |
country | String | Yes | |
adjust_network | String | Yes | |
adjust_adgroup | String | Yes | |
adjust_campaign | String | Yes | |
adjust_creative | String | Yes | |
first_seen_date | Date | Yes | |
submission_date | Date | Yes | |
new_profile | Integer | Yes | |
activated | Integer | Yes |
Project | Dataset | Table |
---|---|---|
moz-fx-data-shared-prod | fenix_derived | new_profile_activation_v1 |
Source Directory | View Definition | Metadata File
pageload
App-specific view for Glean ping "pageload"
fenix.pageload
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.pageload, org_mozilla_firefox_beta.pageload, org_mozilla_fenix.pageload, org_mozilla_fenix_nightly.pageload, org_mozilla_fennec_aurora.pageload).
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
spoc
App-specific view for Glean ping "spoc"
fenix.spoc
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.spoc, org_mozilla_firefox_beta.spoc, org_mozilla_fenix.spoc, org_mozilla_fenix_nightly.spoc, org_mozilla_fennec_aurora.spoc).
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
startup_timeline
App-specific view for Glean ping "startup-timeline"
fenix.startup_timeline
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.startup_timeline, org_mozilla_firefox_beta.startup_timeline, org_mozilla_fenix.startup_timeline, org_mozilla_fenix_nightly.startup_timeline, org_mozilla_fennec_aurora.startup_timeline).
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
sync
App-specific view for Glean ping "sync"
fenix.sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.sync, org_mozilla_firefox_beta.sync, org_mozilla_fenix.sync, org_mozilla_fenix_nightly.sync, org_mozilla_fennec_aurora.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
tabs_sync
App-specific view for Glean ping "tabs-sync"
fenix.tabs_sync
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.tabs_sync, org_mozilla_firefox_beta.tabs_sync, org_mozilla_fenix.tabs_sync, org_mozilla_fenix_nightly.tabs_sync, org_mozilla_fennec_aurora.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
use_counters
App-specific view for Glean ping "use-counters"
fenix.use_counters
This a view that UNIONs the stable ping tables across all channels of the Glean application "Firefox for Android" (org_mozilla_firefox.use_counters, org_mozilla_firefox_beta.use_counters, org_mozilla_fenix.use_counters, org_mozilla_fenix_nightly.use_counters, org_mozilla_fennec_aurora.use_counters).
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