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