jetstream/cbhqps-german-hold-back-with-promo.toml

[experiment]

# NOTE: metrics in this experiment make use of the serp_events v1 data source, which is deprecated.
# To rerun analysis, data source definitions need to be updated.

[experiment.exposure_signal]
name = "opened_pbm"
friendly_name = "Opened PBM"
description = "The set of clients that opened PBM"
select_expression = "COALESCE(dom_parentprocess_private_window_used, false)"
data_source = "clients_daily_v6"
window_end = 7

[data_sources]

[data_sources.clients_daily_v6]
from_expression = "moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6"
friendly_name = "Clients Daily"
description = "Clients Daily"

[data_sources.pbm_search_events]
from_expression = """(
    SELECT 
        metrics.uuid.legacy_telemetry_client_id AS client_id,
        DATE(submission_timestamp) AS submission_date,
        ping_info.experiments AS experiments,
        event.name AS event_name,
        event.extra AS event_extra
    FROM `mozdata.firefox_desktop.events`
    CROSS JOIN UNNEST(events) AS event
    WHERE
        event.category = 'serp'
        AND event.name = 'impression'
        AND mozfun.map.get_key(event.extra, 'is_private') IS NOT NULL
)"""
experiments_column_type = "native"
friendly_name = "PBM search events"
description = "Glean events unnested, filtered to PBM search impressions"

[data_sources.pbm_ad_click_events]
# NOTE: from_expression queries the serp_events v1 data source, which is deprecated.
# To rerun analysis, this query must be updated to work against the v2 data source.
from_expression = """(
    SELECT 
      legacy_telemetry_client_id AS client_id,
      submission_date,
      num_ads_showing,
      IF(is_core_ad_component and num_ads_showing > 0, num_clicks, 0) AS num_ad_clicks
    FROM (
        SELECT *,
        COALESCE(
                  component IN (
                    'ad_carousel',
                    'ad_image_row',
                    'ad_link',
                    'ad_sidebar',
                    'ad_sitelink'
                  ),
                  FALSE
                ) AS is_core_ad_component
      FROM `moz-fx-data-shared-prod.firefox_desktop.serp_events` 
      INNER JOIN (
          SELECT
            mozfun.map.get_key(event.extra, 'impression_id') AS impression_id,
          FROM
            `moz-fx-data-shared-prod.firefox_desktop.events`,
            UNNEST(events) AS event
          WHERE
            event.category = 'serp'
            AND mozfun.map.get_key(event.extra, 'is_private') = 'true'
            AND DATE(submission_timestamp) >= '2023-11-27'  
      ) -- impression_ids of private mode ad clicks
      USING (impression_id)
      WHERE submission_date >= '2023-11-27'  
    )
)"""
experiments_column_type = "none"
friendly_name = "PBM ad clicks"
description = "PBM search impressions enriched with ad clicks. One row per PBM SERP impression, with a column containing the number of ad clicks"

[metrics]

weekly = ['pbm_searches','pbm_uri_count', 'pbm_ad_clicks', 'pbm_searches_with_ads', 'pbm_ads_seen']
overall = ['pbm_searches','pbm_uri_count', 'pbm_ad_clicks', 'pbm_searches_with_ads', 'pbm_ads_seen']

[metrics.pbm_searches]
select_expression = "COUNT(*)"
data_source = "pbm_search_events"

[metrics.pbm_searches.statistics.bootstrap_mean]

[metrics.pbm_searches_with_ads]
select_expression = "COUNTIF(num_ads_showing > 0)"
data_source = "pbm_ad_click_events"

[metrics.pbm_searches_with_ads.statistics.bootstrap_mean]

[metrics.pbm_ads_seen]
select_expression = "SUM(num_ads_showing)"
data_source = "pbm_ad_click_events"

[metrics.pbm_ads_seen.statistics.bootstrap_mean]

[metrics.pbm_ad_clicks]
select_expression = "COALESCE(SUM(num_ad_clicks),0)"
data_source = "pbm_ad_click_events"

[metrics.pbm_ad_clicks.statistics.bootstrap_mean]

[metrics.pbm_uri_count]
select_expression = '''(
COALESCE(
    SUM(scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum) - 
    SUM(scalar_parent_browser_engagement_total_uri_count_sum)
    ,0)
)'''
data_source = "clients_daily_v6"

[metrics.pbm_uri_count.statistics.bootstrap_mean]