Firefox desktop

metric-hub

Pre-defined segment data sources for firefox_desktop. These segment data sources are defined in metric-hub

clients_last_seen

Client ID column: client_id

Submission Date column: submission_date

Window Start: 0

Window End: 0

Definition:

mozdata.telemetry.clients_last_seen

---

clients_daily

Client ID column: client_id

Submission Date column: submission_date

Window Start: 0

Window End: 0

Definition:

mozdata.telemetry.clients_daily

---

newtab_interactions

Client ID column: client_id

Submission Date column: submission_date

Window Start: 0

Window End: 0

Definition:

mozdata.telemetry.newtab_interactions

---

newtab

Client ID column: client_id

Submission Date column: submission_date

Window Start: 0

Window End: 0

Definition:

(
    SELECT
        DATE(submission_timestamp) AS submission_date,
        metrics.uuid.legacy_telemetry_client_id AS client_id,
        *
    FROM
        mozdata.firefox_desktop.newtab
)

---