jetstream/encourage-use-of-search-bar-on-mobile.toml (27 lines of code) (raw):
[metrics.awesomebar_engagement]
friendly_name = "Awesomebar Engagement"
description = "Number of times a user completed their search session by tapping a search result, or entering a URL or a search term."
select_expression = """
COALESCE(COUNTIF(event_name = 'engagement'), 0)
"""
data_source = "events_filtered"
statistics = { sum = {}, bootstrap_mean = {}, deciles = {} }
[metrics.awesomebar_abandonment]
friendly_name = "Awesomebar Abandonment"
description = "Number of times a user dismissed the awesomebar without completing their search."
select_expression = """
COALESCE(COUNTIF(event_name = 'abandonment'), 0)
"""
data_source = "events_filtered"
statistics = { sum = {}, bootstrap_mean = {}, deciles = {} }
[data_sources]
[data_sources.events_filtered]
from_expression = """(
SELECT *, DATE(submission_timestamp) AS submission_date
FROM `moz-fx-data-shared-prod.firefox_desktop.events_stream`
WHERE event_category IN ('urlbar', 'awesomebar')
)"""
description = "Glean events_stream dataset (events ping unnested to a single row per event) filtered"
friendly_name = "Glean Events Stream Filtered"
experiments_column_type = "none"
client_id_column = "legacy_telemetry_client_id"