Klar ios

metric-hub

Pre-defined metrics for klar_ios. These metrics are defined in metric-hub

baseline_ping_count

Baseline pings

Counts the number of baseline pings received from each client.

Data Source: baseline

Definition:

COUNT(document_id)

SQL with DataSource

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

---

metric_ping_count

Metrics pings

Counts the number of metrics pings received from each client.

Data Source: metrics

Definition:

COUNT(document_id)

SQL with DataSource

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

---

first_run_date

First run date

The earliest first-run date reported by each client.

Data Source: baseline

Definition:

MIN(client_info.first_run_date)

SQL with DataSource

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

---

active_hours

Active Hours

Total time Firefox was active

Data Source: baseline

Definition:

COALESCE(SUM(metrics.timespan.glean_baseline_duration.value), 0) / 3600.0

SQL with DataSource

SELECT
  COALESCE(SUM(metrics.timespan.glean_baseline_duration.value), 0) / 3600.0
FROM (
  (
    SELECT
        p.*,
        DATE(p.submission_timestamp) AS submission_date
    FROM `moz-fx-data-shared-prod.{dataset}.baseline` p
)
)

---

days_of_use

Days of use

The number of days in an observation window that clients used the browser.

Data Source: baseline

Definition:

COUNT(DISTINCT DATE(submission_timestamp))

SQL with DataSource

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

---

ad_clicks

Ad Clicks

Counts clicks on ads on search engine result pages with a Mozilla partner tag.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('ad_click')}}

SQL with DataSource

SELECT
  COALESCE(SUM(ad_click), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

ad_clicks_organic

Ad Clicks through organic traffic

Counts clicks on ads on search engine result pages that are not tagged with an eligible Mozilla partner code.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('ad_click_organic')}}

SQL with DataSource

SELECT
  COALESCE(SUM(ad_click_organic), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

searches_with_ads_organic

Organic Search With Ads Count

Total number of Organic Search With Ads Counts

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('search_with_ads_organic')}}

SQL with DataSource

SELECT
  COALESCE(SUM(search_with_ads_organic), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

search_count

SAP search count

Number of searches performed through a Search Access Point.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('search_count')}}

SQL with DataSource

SELECT
  COALESCE(SUM(search_count), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

tagged_search_count

Tagged SAP searches

Counts the number of searches a user performed through Firefox's Search Access Points that were submitted with a partner code and were potentially revenue-generating. Learn more in the search data documentation.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('tagged_sap')}}

SQL with DataSource

SELECT
  COALESCE(SUM(tagged_sap), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

tagged_follow_on_search_count

Tagged follow-on searches

Counts the number of follow-on searches with a Mozilla partner tag. These are additional searches that users performed from a search engine results page after executing a tagged search through a SAP. Learn more in the search data documentation.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('tagged_follow_on')}}

SQL with DataSource

SELECT
  COALESCE(SUM(tagged_follow_on), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

organic_search_count

Organic searches

Counts organic searches, which are searches that are not performed through a Firefox SAP and which are not monetizable. Learn more in the search data documentation.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum('organic')}}

SQL with DataSource

SELECT
  COALESCE(SUM(organic), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

searches_with_ads

Search result pages with ads (a.k.a. Ad Impressions) both tagged and organic

Counts search result pages served with advertising. Users may not actually see these ads thanks to e.g. ad-blockers. Learn more in the search analysis documentation.

Data Source: mobile_search_clients_engines_sources_daily

Definition:

{{agg_sum("search_with_ads")}}

SQL with DataSource

SELECT
  COALESCE(SUM(search_with_ads), 0)
FROM (
  (
    SELECT *
    FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
    WHERE normalized_app_name_os = 'Klar iOS'
 )
)

---

engagement_rate_v1

Klar iOS Engagement Rate

The Engagement Rate is calculated as the ratio between DAU and MAU. For each day, we use the single-day DAU number and divide it by the MAU corresponding to the 28-day period ending on that day. For OKR reporting, we then calculate a 28-day moving average of this number. More information is provided on the New Profiles, Retention and Engagement Rate Confluence Page.

Data Source: klar_ios_engagement_view

Definition:

SUM(dau) / SUM(mau)

SQL with DataSource

SELECT
  SUM(dau) / SUM(mau)
FROM (
  (
    SELECT *
     FROM `moz-fx-data-shared-prod.klar_ios.engagement`
    WHERE app_name = "Klar iOS"
)
)

---

retention_rate_v1

Klar iOS Retention Rate

The Retention Rate is calculated as the proportion of clients that are active on the 4th week after the metric date.

Data Source: klar_ios_retention_view

Definition:

SUM(retained_week_4) / SUM(active_metric_date)

SQL with DataSource

SELECT
  SUM(retained_week_4) / SUM(active_metric_date)
FROM (
  (
    SELECT *
     FROM `moz-fx-data-shared-prod.klar_ios.retention`
    WHERE app_name = "Klar iOS"
)
)

---

new_profile_retention_rate_v1

Klar iOS New Proflie Retention Rate

The New Profile Retention Rate is calculated as the proportion of new profiles that are active on the 4th week after the metric date. More information is provided on the New Profiles, Retention and Engagement Rate Confluence Page.

Data Source: klar_ios_retention_view

Definition:

SUM(retained_week_4_new_profiles) / SUM(new_profiles_metric_date)

SQL with DataSource

SELECT
  SUM(retained_week_4_new_profiles) / SUM(new_profiles_metric_date)
FROM (
  (
    SELECT *
     FROM `moz-fx-data-shared-prod.klar_ios.retention`
    WHERE app_name = "Klar iOS"
)
)

---

client_level_daily_active_users_v1

Klar iOS Client-Level DAU

Client-level DAU. The logic is detailed on the Confluence DAU page and is automatically cross-checked, actively monitored, and change controlled. This metric needs to be aggregated by submission_date. If it is not aggregated by submission_date, it is similar to a "days of use" metric, and not DAU.

Data Source: klar_ios_active_users_view

Definition:

COUNTIF(is_dau)

SQL with DataSource

SELECT
  COUNTIF(is_dau)
FROM (
  (
    SELECT *
     FROM `moz-fx-data-shared-prod.klar_ios.active_users`
    WHERE app_name = "Klar iOS"
)
)

---