firefox-desktop-background-update

User-facing views related to document namespace firefox-desktop-background-update; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/firefox-desktop-background-update

Source Directory

background_update

Historical Pings for firefox-desktop-background-update/background-update

firefox_desktop_background_update.background_update

A historical view of pings sent for the firefox-desktop-background-update/background-update document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	background_update_v1

Source Directory | View Definition | Metadata File

baseline

Historical Pings for firefox-desktop-background-update/baseline

firefox_desktop_background_update.baseline

A historical view of pings sent for the firefox-desktop-background-update/baseline document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	baseline_v1

Source Directory | View Definition | Metadata File

baseline_clients_daily

Baseline Clients Daily

firefox_desktop_background_update.baseline_clients_daily

A daily aggregate of baseline pings per client_id.

Clustering fields: normalized_channel, sample_id

baseline_clients_first_seen

Baseline Clients First Seen

firefox_desktop_background_update.baseline_clients_first_seen

Captures the earliest server date that we observe a particular client in the baseline table. A client may have a first_seen_date that is earlier than the epoch of the baseline table; this is the result of a migration from a legacy data collection system. These clients are therefore not captured in this table.

Clustering fields: sample_id

See also: baseline_clients_daily and baseline_clients_last_seen.

Owners:
- ascholtz@mozilla.com

Schema
Column	Type	Nullable
submission_date	Date	Yes
client_id	String	Yes
sample_id	Integer	Yes
first_run_date	Date	Yes
durations	Integer	Yes
days_seen_session_start_bits	Integer	Yes
days_seen_session_end_bits	Integer	Yes
normalized_channel	String	Yes
normalized_os	String	Yes
normalized_os_version	String	Yes
android_sdk_version	String	Yes
locale	String	Yes
city	String	Yes
country	String	Yes
app_build	String	Yes
app_channel	String	Yes
app_display_version	String	Yes
architecture	String	Yes
device_manufacturer	String	Yes
device_model	String	Yes
telemetry_sdk_build	String	Yes
first_seen_date	Date	Yes
is_new_profile	Boolean	Yes
isp	String	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_derived	baseline_clients_daily_v1

Source Directory | View Definition | Metadata File

baseline_clients_last_seen

Baseline Clients Last Seen

firefox_desktop_background_update.baseline_clients_last_seen

Captures activity history of each client in 28-day windows for each submission date based on baseline pings.

Clustering fields: normalized_channel, sample_id

broken_site_report

Historical Pings for firefox-desktop-background-update/broken-site-report

firefox_desktop_background_update.broken_site_report

A historical view of pings sent for the firefox-desktop-background-update/broken-site-report document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	broken_site_report_v1

Source Directory | View Definition | Metadata File

clients_last_seen_joined

Clients Last Seen Joined

firefox_desktop_background_update.clients_last_seen_joined

Please provide a description for the query

Schema
Column	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
isp	String	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_derived	clients_last_seen_joined_v1

Source Directory | View Definition | Metadata File

crash

Historical Pings for firefox-desktop-background-update/crash

firefox_desktop_background_update.crash

A historical view of pings sent for the firefox-desktop-background-update/crash document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	crash_v1

Source Directory | View Definition | Metadata File

deletion_request

Historical Pings for firefox-desktop-background-update/deletion-request

firefox_desktop_background_update.deletion_request

A historical view of pings sent for the firefox-desktop-background-update/deletion-request document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	deletion_request_v1

Source Directory | View Definition | Metadata File

events

Historical Pings for firefox-desktop-background-update/events

firefox_desktop_background_update.events

A historical view of pings sent for the firefox-desktop-background-update/events document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	events_v1

Source Directory | View Definition | Metadata File

events_unnested

Events Unnested

firefox_desktop_background_update.events_unnested

Please provide a description for the query

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update	events

Source Directory | View Definition | Metadata File

fog_validation

Historical Pings for firefox-desktop-background-update/fog-validation

firefox_desktop_background_update.fog_validation

A historical view of pings sent for the firefox-desktop-background-update/fog-validation document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	fog_validation_v1

Source Directory | View Definition | Metadata File

metrics

Historical Pings for firefox-desktop-background-update/metrics

firefox_desktop_background_update.metrics

A historical view of pings sent for the firefox-desktop-background-update/metrics document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	metrics_v1

Source Directory | View Definition | Metadata File

metrics_clients_daily

Metrics Clients Daily

firefox_desktop_background_update.metrics_clients_daily

Please provide a description for the query

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

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_derived	metrics_clients_daily_v1

Source Directory | View Definition | Metadata File

metrics_clients_last_seen

Metrics Clients Last Seen

firefox_desktop_background_update.metrics_clients_last_seen

Please provide a description for the query

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

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_derived	metrics_clients_last_seen_v1

Source Directory | View Definition | Metadata File

pageload

Historical Pings for firefox-desktop-background-update/pageload

firefox_desktop_background_update.pageload

A historical view of pings sent for the firefox-desktop-background-update/pageload document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	pageload_v1

Source Directory | View Definition | Metadata File

use_counters

Historical Pings for firefox-desktop-background-update/use-counters

firefox_desktop_background_update.use_counters

A historical view of pings sent for the firefox-desktop-background-update/use-counters document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column	Description	Type	Nullable
additional_properties	A JSON string containing any payload properties not present in the schema	String	Yes
client_info		Record	Yes
document_id	The document ID specified in the URI when the client sent this message	String	Yes
events		Record	No
metadata		Record	Yes
metrics		Record	Yes
normalized_app_name	Set to "Other" if this message contained an unrecognized app name	String	Yes
normalized_channel	Set to "Other" if this message contained an unrecognized channel name	String	Yes
normalized_country_code	An ISO 3166-1 alpha-2 country code	String	Yes
normalized_os	Set to "Other" if this message contained an unrecognized OS name	String	Yes
normalized_os_version		String	Yes
ping_info		Record	Yes
sample_id	Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99	Integer	Yes
submission_timestamp	Time when the ingestion edge server accepted this message	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	firefox_desktop_background_update_stable	use_counters_v1

Source Directory | View Definition | Metadata File