looker/definitions/fenix.toml

[metrics.feature_usage_dau_v1]
select_expression = "SUM(dau)"
data_source = "feature_usage_metrics_v1"
friendly_name = "Feature Usage DAU"
description = "Daily Active Users associated with feature usage"
owner = "rzhao@mozilla.com"

[metrics.feature_usage_dau_v1.statistics.sum]


[metrics.bookmarks_add_users_v1.statistics.sum]

[metrics.bookmarks_add_v1.statistics.sum]

[metrics.bookmarks_add_users_v1.statistics.ratio]
numerator = "bookmarks_add_users_v1.sum"
denominator = "feature_usage_dau_v1.sum"

[metrics.bookmarks_add_v1.statistics.ratio]
numerator = "bookmarks_add_v1.sum"
denominator = "bookmarks_add_users_v1.sum"

[metrics.bookmarks_delete_users_v1.statistics.sum]

[metrics.bookmarks_delete_v1.statistics.sum]

[metrics.bookmarks_delete_v1.statistics.ratio]
numerator = "bookmarks_delete_v1.sum"
denominator = "bookmarks_delete_users_v1.sum"

[metrics.bookmarks_delete_users_v1.statistics.ratio]
numerator = "bookmarks_delete_users_v1.sum"
denominator = "feature_usage_dau_v1.sum"

[metrics.days_of_use.statistics.average]

[metrics.active_hours.statistics.average]

[metrics.ad_click_organic.statistics.average]


[data_sources.looker_base_fields]
from_expression = """
(
  SELECT
    client_info.client_id AS client_id,
    DATE(submission_timestamp) AS submission_date,
    * EXCEPT(ping_info, metrics, events, additional_properties)
  FROM
    `moz-fx-data-shared-prod`.fenix.baseline
)
"""
friendly_name = "Default Looker Base Fields for Fenix"
description = """
  Default fields used to filter and segment metric definition views in Looker
"""
columns_as_dimensions = true
submission_date_column = "submission_date"
client_id_column = "client_id"

[data_sources.'*'.joins.looker_base_fields]

[data_sources.feature_usage_metrics_v1]
columns_as_dimensions = true
joins = {}

[data_sources.fenix_active_users_aggregates_view]
columns_as_dimensions = true