jetstream/ios-sent-from-firefox-rollout-increase-to-5.toml

friendly_name = "Sent From Firefox - iOS"
description = "Track tab shares to WhatsApp and overall sharing behavior from enrolled and opted-in users."

[experiment]
enrollment_period = 14

[metrics]
overall = ["total_tab_shares", "whatsapp_share_count", "any_whatsapp_share"]

[metrics.total_tab_shares]
select_expression = """
    COUNTIF(
        JSON_VALUE(event_extra["share_type"]) = 'tab'
        AND JSON_VALUE(event_extra["is_enrolled_in_sent_from_firefox"]) = 'true'
        AND JSON_VALUE(event_extra["is_opted_in_sent_from_firefox"]) = 'true'
    )
"""
data_source = "ios_events"
friendly_name = "Total tab shares (all destinations)"
description = "Total number of tabs shared by enrolled and opted-in users, regardless of destination."
analysis_bases = ["enrollments"]
bigger_is_better = true

[metrics.total_tab_shares.statistics.bootstrap_mean]

[metrics.whatsapp_share_count]
select_expression = """
    COUNTIF(
        JSON_VALUE(event_extra["activity_identifier"]) = 'net.whatsapp.WhatsApp.ShareExtension'
        AND JSON_VALUE(event_extra["share_type"]) = 'tab'
        AND JSON_VALUE(event_extra["is_enrolled_in_sent_from_firefox"]) = 'true'
        AND JSON_VALUE(event_extra["is_opted_in_sent_from_firefox"]) = 'true'
    )
"""
data_source = "ios_events"
friendly_name = "WhatsApp tab share count"
description = "Number of times enrolled and opted-in users shared a tab to WhatsApp."
analysis_bases = ["enrollments"]
bigger_is_better = true

[metrics.whatsapp_share_count.statistics.bootstrap_mean]
[metrics.whatsapp_share_count.statistics.deciles]

[metrics.any_whatsapp_share]
select_expression = """
    CAST(
        COUNTIF(
            JSON_VALUE(event_extra["activity_identifier"]) = 'net.whatsapp.WhatsApp.ShareExtension'
            AND JSON_VALUE(event_extra["share_type"]) = 'tab'
            AND JSON_VALUE(event_extra["is_enrolled_in_sent_from_firefox"]) = 'true'
            AND JSON_VALUE(event_extra["is_opted_in_sent_from_firefox"]) = 'true'
        ) > 0 AS INT64
    )
"""
data_source = "ios_events"
friendly_name = "Any WhatsApp tab share"
description = "Proportion of enrolled and opted-in users who shared at least one tab to WhatsApp."
analysis_bases = ["enrollments"]

[metrics.any_whatsapp_share.statistics.binomial]

[data_sources.ios_events]
from_expression = """
(
  SELECT
    client_id,
    DATE(submission_timestamp) AS submission_date,
    event_extra
  FROM `mozdata.org_mozilla_ios_firefox.events_stream`
  WHERE event = 'share_sheet.shared_to'
    AND event_category = 'share_sheet'
)
"""
experiments_column_type = "none"
analysis_units = ["client_id"]