firefox-suggest-best-match.toml

[experiment]
segments = ['exposed', 'non_exposed']

[segments.data_sources.events_unnested]
from_expression = """(
  SELECT
    *
  FROM
    `moz-fx-data-shared-prod.telemetry.events`
)"""
window_start = 0
window_end = 28 

[segments.exposed]
select_expression = """
  COALESCE(CAST(MAX(
    CASE WHEN event_category = 'normandy'
           AND event_method = 'expose'
           AND event_object = 'nimbus_experiment'
           AND event_string_value = 'firefox-suggest-best-match'
           AND normalized_channel = 'release'
         THEN 1
         ELSE 0
    END
  ) AS BOOL), FALSE)
"""
data_source = "events_unnested"

[segments.non_exposed]
select_expression = """
  COALESCE(  NOT  CAST(MAX(
    CASE WHEN event_category = 'normandy'
           AND event_method = 'expose'
           AND event_object = 'nimbus_experiment'
           AND event_string_value = 'firefox-suggest-best-match'
           AND normalized_channel = 'release'
         THEN 1
         ELSE 0
    END
  ) AS BOOL), FALSE)
"""
data_source = "events_unnested"