Focus ios

metric-hub

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

focus_ios_active_users_aggregates_view

Client ID column: NULL

Submission Date column: submission_date

Definition:

(
    SELECT *
     FROM `moz-fx-data-shared-prod.telemetry.active_users_aggregates`
    WHERE app_name = 'Focus iOS'
)

---

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
)

---

baseline_v2

Client ID column: client_info.client_id

Submission Date column: submission_date

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
)

---

mobile_search_clients_engines_sources_daily

Client ID column: client_id

Submission Date column: submission_date

Definition:

(
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Focus iOS'
 )

---

focus_ios_engagement_view

Client ID column: NULL

Submission Date column: submission_date

Definition:

(
    SELECT *
     FROM `moz-fx-data-shared-prod.focus_ios.engagement`
    WHERE is_mobile
)

---

focus_ios_retention_view

Client ID column: NULL

Submission Date column: metric_date

Definition:

(
    SELECT *
     FROM `moz-fx-data-shared-prod.focus_ios.retention`
    WHERE is_mobile
)

---

focus_ios_active_users_view

Client ID column: client_id

Submission Date column: submission_date

Definition:

(
    SELECT *
     FROM `moz-fx-data-shared-prod.focus_ios.active_users`
    WHERE is_mobile
)

---