Firefox desktop

metric-hub

Pre-defined dimensions for firefox_desktop. These dimensions are defined in metric-hub

os

Operating System

Normalized Operating System

Data Source: main

Definition:

normalized_os

---

cores_count

Cores Count

Number of CPU cores

Data Source: main

Definition:

environment.system.cpu.cores

---

build

Build ID

Build ID

Data Source: main

Definition:

SAFE.SUBSTR(application.build_id, 0, 8)

---

country

Country

Normalized Country Code

Data Source: main

Definition:

normalized_country_code

---

cohort_retention_day

Retention Day

Days Since Client Was New - Used for N-Day Retention

Data Source: desktop_cohort_daily_retention

Definition:

DATE_DIFF(submission_date, first_seen_date, DAY)

---

cohort_retention_week

Retention Week

Weeks Since Client was New (Even 7 Day Periods Only)

Data Source: desktop_cohort_daily_retention

Definition:

IF(MOD(DATE_DIFF(submission_date, first_seen_date, DAY) + 1, 7) = 0, SAFE_DIVIDE(DATE_DIFF(submission_date, first_seen_date, DAY) + 1, 7), NULL)

---

cohort_retention_month

Retention Month

Months Since Client was New (Even 28 Day Periods Only)

Data Source: desktop_cohort_daily_retention

Definition:

IF(MOD(DATE_DIFF(submission_date, first_seen_date, DAY) + 1, 28) = 0, SAFE_DIVIDE(DATE_DIFF(submission_date, first_seen_date, DAY) + 1, 28), NULL)

---