Skip to content

Fenix

Data related to Fenix (Firefox for Android)

Source Directory

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.

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_fenix activation
moz-fx-data-shared-prod org_mozilla_fenix_nightly activation
moz-fx-data-shared-prod org_mozilla_fennec_aurora activation
moz-fx-data-shared-prod org_mozilla_firefox activation
moz-fx-data-shared-prod org_mozilla_firefox_beta activation

Source Directory | View Definition | Metadata File


active_users_aggregates

Active Users Aggregates

fenix.active_users_aggregates

Please provide a description for the query

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

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_fenix addresses_sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly addresses_sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora addresses_sync
moz-fx-data-shared-prod org_mozilla_firefox addresses_sync
moz-fx-data-shared-prod org_mozilla_firefox_beta addresses_sync

Source Directory | View Definition | Metadata File


attributable_clients

Attributable Clients

fenix.attributable_clients

Please provide a description for the query

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

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

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_fenix baseline
moz-fx-data-shared-prod org_mozilla_fenix_nightly baseline
moz-fx-data-shared-prod org_mozilla_fennec_aurora baseline
moz-fx-data-shared-prod org_mozilla_firefox baseline
moz-fx-data-shared-prod org_mozilla_firefox_beta baseline

Source Directory | View Definition | Metadata File


baseline_clients_daily

Baseline Clients Daily

fenix.baseline_clients_daily

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_fenix_nightly baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_fennec_aurora baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_firefox baseline_clients_daily
moz-fx-data-shared-prod org_mozilla_firefox_beta baseline_clients_daily

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

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_fenix_nightly baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_fennec_aurora baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_firefox baseline_clients_first_seen
moz-fx-data-shared-prod org_mozilla_firefox_beta baseline_clients_first_seen

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

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_fenix_nightly baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_fennec_aurora baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox_beta baseline_clients_last_seen

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.

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_fenix bookmarks_sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly bookmarks_sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora bookmarks_sync
moz-fx-data-shared-prod org_mozilla_firefox bookmarks_sync
moz-fx-data-shared-prod org_mozilla_firefox_beta bookmarks_sync

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.

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_fenix broken_site_report
moz-fx-data-shared-prod org_mozilla_fenix_nightly broken_site_report
moz-fx-data-shared-prod org_mozilla_fennec_aurora broken_site_report
moz-fx-data-shared-prod org_mozilla_firefox broken_site_report
moz-fx-data-shared-prod org_mozilla_firefox_beta broken_site_report

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.

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 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.

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

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

Schema
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod fenix_derived clients_yearly_v1

Source Directory | View Definition | Metadata File


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.

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_fenix cookie_banner_report_site
moz-fx-data-shared-prod org_mozilla_fenix_nightly cookie_banner_report_site
moz-fx-data-shared-prod org_mozilla_fennec_aurora cookie_banner_report_site
moz-fx-data-shared-prod org_mozilla_firefox cookie_banner_report_site
moz-fx-data-shared-prod org_mozilla_firefox_beta cookie_banner_report_site

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.

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_fenix crash
moz-fx-data-shared-prod org_mozilla_fenix_nightly crash
moz-fx-data-shared-prod org_mozilla_fennec_aurora crash
moz-fx-data-shared-prod org_mozilla_firefox crash
moz-fx-data-shared-prod org_mozilla_firefox_beta crash

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.

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_fenix creditcards_sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly creditcards_sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora creditcards_sync
moz-fx-data-shared-prod org_mozilla_firefox creditcards_sync
moz-fx-data-shared-prod org_mozilla_firefox_beta creditcards_sync

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.

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_fenix deletion_request
moz-fx-data-shared-prod org_mozilla_fenix_nightly deletion_request
moz-fx-data-shared-prod org_mozilla_fennec_aurora deletion_request
moz-fx-data-shared-prod org_mozilla_firefox deletion_request
moz-fx-data-shared-prod org_mozilla_firefox_beta deletion_request

Source Directory | View Definition | Metadata File


event_types

Event Types

fenix.event_types

Please provide a description for the query

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

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_fenix events
moz-fx-data-shared-prod org_mozilla_fenix_nightly events
moz-fx-data-shared-prod org_mozilla_fennec_aurora events
moz-fx-data-shared-prod org_mozilla_firefox events
moz-fx-data-shared-prod org_mozilla_firefox_beta events

Source Directory | View Definition | Metadata File


events_daily

Events Daily

fenix.events_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
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
Referenced Tables
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

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix events
moz-fx-data-shared-prod org_mozilla_fenix_nightly events
moz-fx-data-shared-prod org_mozilla_fennec_aurora events
moz-fx-data-shared-prod org_mozilla_firefox events
moz-fx-data-shared-prod org_mozilla_firefox_beta events

Source Directory | View Definition | Metadata File


firefox_android_clients

Firefox Android Clients

fenix.firefox_android_clients

Please provide a description for the query

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

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_fenix first_session
moz-fx-data-shared-prod org_mozilla_fenix_nightly first_session
moz-fx-data-shared-prod org_mozilla_fennec_aurora first_session
moz-fx-data-shared-prod org_mozilla_firefox first_session
moz-fx-data-shared-prod org_mozilla_firefox_beta first_session

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.

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_fenix fog_validation
moz-fx-data-shared-prod org_mozilla_fenix_nightly fog_validation
moz-fx-data-shared-prod org_mozilla_fennec_aurora fog_validation
moz-fx-data-shared-prod org_mozilla_firefox fog_validation
moz-fx-data-shared-prod org_mozilla_firefox_beta fog_validation

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.

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_fenix font_list
moz-fx-data-shared-prod org_mozilla_fenix_nightly font_list
moz-fx-data-shared-prod org_mozilla_fennec_aurora font_list
moz-fx-data-shared-prod org_mozilla_firefox font_list
moz-fx-data-shared-prod org_mozilla_firefox_beta font_list

Source Directory | View Definition | Metadata File


funnel_retention_clients

Funnel Retention Clients

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

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

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_fenix fx_suggest
moz-fx-data-shared-prod org_mozilla_fenix_nightly fx_suggest
moz-fx-data-shared-prod org_mozilla_fennec_aurora fx_suggest
moz-fx-data-shared-prod org_mozilla_firefox fx_suggest
moz-fx-data-shared-prod org_mozilla_firefox_beta fx_suggest

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

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

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_fenix history_sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly history_sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora history_sync
moz-fx-data-shared-prod org_mozilla_firefox history_sync
moz-fx-data-shared-prod org_mozilla_firefox_beta history_sync

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.

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_fenix installation
moz-fx-data-shared-prod org_mozilla_fenix_nightly installation
moz-fx-data-shared-prod org_mozilla_fennec_aurora installation
moz-fx-data-shared-prod org_mozilla_firefox installation
moz-fx-data-shared-prod org_mozilla_firefox_beta installation

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.

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_fenix logins_sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly logins_sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora logins_sync
moz-fx-data-shared-prod org_mozilla_firefox logins_sync
moz-fx-data-shared-prod org_mozilla_firefox_beta logins_sync

Source Directory | View Definition | Metadata File


ltv_states

Ltv States

fenix.ltv_states

Please provide a description for the query

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

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

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_fenix metrics
moz-fx-data-shared-prod org_mozilla_fenix_nightly metrics
moz-fx-data-shared-prod org_mozilla_fennec_aurora metrics
moz-fx-data-shared-prod org_mozilla_firefox metrics
moz-fx-data-shared-prod org_mozilla_firefox_beta metrics

Source Directory | View Definition | Metadata File


metrics_clients_daily

Metrics Clients Daily

fenix.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 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

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

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

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
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
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix migration
moz-fx-data-shared-prod org_mozilla_fenix_nightly migration
moz-fx-data-shared-prod org_mozilla_fennec_aurora migration
moz-fx-data-shared-prod org_mozilla_firefox migration
moz-fx-data-shared-prod org_mozilla_firefox_beta migration

Source Directory | View Definition | Metadata File


new_profile_activation

New Profile Activation

fenix.new_profile_activation

Please provide a description for the query

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

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_fenix pageload
moz-fx-data-shared-prod org_mozilla_fenix_nightly pageload
moz-fx-data-shared-prod org_mozilla_fennec_aurora pageload
moz-fx-data-shared-prod org_mozilla_firefox pageload
moz-fx-data-shared-prod org_mozilla_firefox_beta pageload

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.

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_fenix spoc
moz-fx-data-shared-prod org_mozilla_fenix_nightly spoc
moz-fx-data-shared-prod org_mozilla_fennec_aurora spoc
moz-fx-data-shared-prod org_mozilla_firefox spoc
moz-fx-data-shared-prod org_mozilla_firefox_beta spoc

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.

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_fenix startup_timeline
moz-fx-data-shared-prod org_mozilla_fenix_nightly startup_timeline
moz-fx-data-shared-prod org_mozilla_fennec_aurora startup_timeline
moz-fx-data-shared-prod org_mozilla_firefox startup_timeline
moz-fx-data-shared-prod org_mozilla_firefox_beta startup_timeline

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.

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_fenix sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora sync
moz-fx-data-shared-prod org_mozilla_firefox sync
moz-fx-data-shared-prod org_mozilla_firefox_beta sync

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.

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_fenix tabs_sync
moz-fx-data-shared-prod org_mozilla_fenix_nightly tabs_sync
moz-fx-data-shared-prod org_mozilla_fennec_aurora tabs_sync
moz-fx-data-shared-prod org_mozilla_firefox tabs_sync
moz-fx-data-shared-prod org_mozilla_firefox_beta tabs_sync

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.

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_fenix use_counters
moz-fx-data-shared-prod org_mozilla_fenix_nightly use_counters
moz-fx-data-shared-prod org_mozilla_fennec_aurora use_counters
moz-fx-data-shared-prod org_mozilla_firefox use_counters
moz-fx-data-shared-prod org_mozilla_firefox_beta use_counters

Source Directory | View Definition | Metadata File