jetstream/pdfjs-feature-callout.toml

[experiment]
enrollment_query = """
SELECT
    e.client_id,
    `mozfun.map.get_key`(e.event_map_values, 'branch')
        AS branch,
    MIN(e.submission_date) AS enrollment_date,
    COUNT(e.submission_date) AS num_enrollment_events
FROM
    `moz-fx-data-shared-prod.telemetry.events` e
WHERE
    e.event_category = 'normandy'
    AND e.event_method = 'enroll'
    AND e.submission_date
        BETWEEN '2023-02-23' AND '2023-03-02'
    AND e.event_string_value = 'pdfjs-feature-callout'
    AND sample_id < 10
GROUP BY e.client_id, branch
"""

[experiment.exposure_signal]
description = "filters to clients that opened a PDF at all during the observation period"
name = "opened_pdf"
friendly_name = "Opened PDF"
select_expression = """(
    COALESCE(metrics.counter.pdfjs_used > 0, FALSE)
)"""
data_source = "metrics"
window_start = 0
window_end = 7


[metrics]

weekly = [
    "pdf_engagement",
    "pdf_freetext",
    "pdf_ink", 
    "pdf_print", 
    "pdf_save", 
    "pdf_opening",
    "pdf_opening_legacy"
]

overall = [
    "pdf_engagement",
    "pdf_freetext",
    "pdf_ink", 
    "pdf_print", 
    "pdf_save", 
    "pdf_opening",
    "pdf_opening_legacy"
]

[metrics.pdf_engagement]
select_expression = """(
    (COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "freetext")) > 0, FALSE) OR
    COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "ink")) > 0, FALSE)) AND 
    (COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "print")) > 0, FALSE) OR 
    COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "save")) > 0, FALSE))
)"""
data_source = "metrics"
[metrics.pdf_engagement.statistics.binomial]

[metrics.pdf_freetext]
select_expression = """(
    COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "freetext")) > 0, FALSE)
)"""
data_source = "metrics"
[metrics.pdf_freetext.statistics.binomial]

[metrics.pdf_ink]
select_expression = """(
    COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "ink")) > 0, FALSE)
)"""
data_source = "metrics"
[metrics.pdf_ink.statistics.binomial]

[metrics.pdf_print]
select_expression = """(
    COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "print")) > 0, FALSE)
)"""
data_source = "metrics"
[metrics.pdf_print.statistics.binomial]

[metrics.pdf_save]
select_expression = """(
    COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "save")) > 0, FALSE)
)"""
data_source = "metrics"
[metrics.pdf_save.statistics.binomial]

[metrics.pdf_opening]
select_expression = """(
    COALESCE(SUM(metrics.counter.pdfjs_used) > 0, FALSE)
)"""
data_source = "metrics"
[metrics.pdf_opening.statistics.binomial]

[metrics.pdf_opening_legacy]
select_expression = """(
    COALESCE(SUM(scalar_content_pdf_viewer_used) > 0, FALSE)
)"""
data_source = "main_summary"
[metrics.pdf_opening_legacy.statistics.binomial]


[data_sources]
[data_sources.metrics]
friendly_name = "metrics"
from_expression = """(
    SELECT 
      p.*,
      DATE(p.submission_timestamp) AS submission_date
    FROM `mozdata.firefox_desktop.metrics` p
    )"""
client_id_column = "metrics.uuid.legacy_telemetry_client_id"
experiments_column_type = "none"