jetstream/sidebar-button-existing-users-experiment.toml

[experiment]

[metrics]

weekly = [
    "sidebar_engagement",
]

overall = [
    "sidebar_engagement",
]

[metrics.sidebar_engagement]
select_expression = "COALESCE(LOGICAL_OR(sidebar), FALSE)"
data_source = "sidebar_toggle"
friendly_name = "Sidebar Engagement"
description = "Percentage of clients who opened any panel in the sidebar"

[metrics.sidebar_engagement.statistics.binomial]

[data_sources.sidebar_toggle]
from_expression = """(
  SELECT 
    legacy_telemetry_client_id as client_id,
    CAST(submission_timestamp as DATE) as submission_date,
    TRUE as sidebar
  FROM
    `mozdata.firefox_desktop.events_stream`
  WHERE
    event_category IN ('genai.chatbot', 'history', 'synced_tabs', 'bookmarks', 'extension')
    AND event_name = 'sidebar_toggle'
    AND JSON_VALUE(event_extra.opened) = 'true'
  GROUP BY 1, 2, 3
)"""
experiments_column_type = "none"
friendly_name = "Sidebar Open"
description = "Clients who open any sidebar panel"