org_mozilla_firefox_beta

activation

A historical view of pings sent for the org-mozilla-firefox-beta/activation 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/activation

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	activation_v1

Source Directory | Metadata File | View Definition

---

baseline

A historical view of pings sent for the org-mozilla-firefox-beta/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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/baseline

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	baseline_v1

Source Directory | Metadata File | View Definition

---

baseline_clients_daily

A daily aggregate of baseline pings per client_id.

Clustering fields: normalized_channel, sample_id

See also: baseline_clients_last_seen

• Friendly name: Baseline Clients Daily

• Owners:

  • jklukas@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_derived	baseline_clients_daily_v1

Source Directory | Metadata File | View Definition

---

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.

• Friendly name: Baseline Clients First Seen

• Owners:

  • amiyaguchi@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_derived	baseline_clients_daily_v1

Source Directory | Metadata File | View Definition

---

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

See also: baseline_clients_daily

• Friendly name: Baseline Clients Last Seen

• Owners:

  • jklukas@mozilla.com

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_derived	baseline_clients_last_seen_v1

Source Directory | Metadata File | View Definition

---

bookmarks_sync

A historical view of pings sent for the org-mozilla-firefox-beta/bookmarks-sync 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/bookmarks-sync

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	bookmarks_sync_v1

Source Directory | Metadata File | View Definition

---

deletion_request

A historical view of pings sent for the org-mozilla-firefox-beta/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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/deletion-request

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	deletion_request_v1

Source Directory | Metadata File | View Definition

---

events

A historical view of pings sent for the org-mozilla-firefox-beta/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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/events

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	events_v1

Source Directory | Metadata File | View Definition

---

first_session

A historical view of pings sent for the org-mozilla-firefox-beta/first-session 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/first-session

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	first_session_v1

Source Directory | Metadata File | View Definition

---

history_sync

A historical view of pings sent for the org-mozilla-firefox-beta/history-sync 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/history-sync

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	history_sync_v1

Source Directory | Metadata File | View Definition

---

installation

A historical view of pings sent for the org-mozilla-firefox-beta/installation 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/installation

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	installation_v1

Source Directory | Metadata File | View Definition

---

logins_sync

A historical view of pings sent for the org-mozilla-firefox-beta/logins-sync 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/logins-sync

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	logins_sync_v1

Source Directory | Metadata File | View Definition

---

metrics

A historical view of pings sent for the org-mozilla-firefox-beta/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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/metrics

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	metrics_v1

Source Directory | Metadata File | View Definition

---

migration

A historical view of pings sent for the org-mozilla-firefox-beta/migration 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/migration

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	migration_v1

Source Directory | Metadata File | View Definition

---

startup_timeline

A historical view of pings sent for the org-mozilla-firefox-beta/startup-timeline 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/startup-timeline

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	startup_timeline_v1

Source Directory | Metadata File | View Definition

---

sync

A historical view of pings sent for the org-mozilla-firefox-beta/sync 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

• Friendly name: Historical Pings for org-mozilla-firefox-beta/sync

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_beta_stable	sync_v1

Source Directory | Metadata File | View Definition

---