Skip to content

Focus android

Pre-defined data sources for focus_android that can be used across all experiments. These data sources are defined in jetstream-config

baseline

Client ID column: client_info.client_id

Submission Date column: None

Definition:
(
    SELECT
        p.*,
        DATE(p.submission_timestamp) AS submission_date
    FROM `moz-fx-data-shared-prod.{dataset}.baseline` p
)

events

Client ID column: client_info.client_id

Submission Date column: None

Definition:
(
    SELECT
        p.* EXCEPT (events),
        DATE(p.submission_timestamp) AS submission_date,
        event
    FROM
        `moz-fx-data-shared-prod.{dataset}.events` p
    CROSS JOIN
        UNNEST(p.events) AS event
)

metrics

Client ID column: client_info.client_id

Submission Date column: None

Definition:
(
    SELECT
        p.*,
        DATE(p.submission_timestamp) AS submission_date
    FROM `moz-fx-data-shared-prod.{dataset}.metrics` p
)