org_mozilla_firefox

activation

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

addresses_sync

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

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_stable	addresses_sync_v1

Source Directory | Metadata File | View Definition

---

baseline

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

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_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_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_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_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/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/bookmarks-sync

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

creditcards_sync

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

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_stable	creditcards_sync_v1

Source Directory | Metadata File | View Definition

---

deletion_request

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

event_types

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_derived	event_types_v1

Source Directory | Metadata File | View Definition

---

events

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

events_daily

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_derived	events_daily_v1

Source Directory | Metadata File | View Definition

---

first_session

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

history_sync

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

installation

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

logins_sync

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

metrics

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

migrated_clients

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_derived	migrated_clients_v1

Source Directory | Metadata File | View Definition

---

migration

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

startup_timeline

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

sync

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

Referenced Tables

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

Source Directory | Metadata File | View Definition

---

tabs_sync

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

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	org_mozilla_firefox_stable	tabs_sync_v1

Source Directory | Metadata File | View Definition

---