Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tdsmith/926e7ad4004739e0eb7a3fd12318c8b1 to your computer and use it in GitHub Desktop.
Save tdsmith/926e7ad4004739e0eb7a3fd12318c8b1 to your computer and use it in GitHub Desktop.
[experiment]
enrollment_query = """
SELECT
client_id,
mozfun.map.get_key(experiments, "{{experiment.normandy_slug}}").branch AS branch,
MIN(DATE(submission_timestamp)) AS enrollment_date,
COUNT(*) AS num_enrollments
FROM `moz-fx-data-shared-prod`.messaging_system.cfr
WHERE
message_id LIKE "{{experiment.normandy_slug}}:%"
AND DATE(submission_timestamp) BETWEEN "{{experiment.start_date_str}}" AND "{{experiment.last_enrollment_date_str}}"
GROUP BY client_id, branch
"""
[metrics]
weekly = ["ever_default_homepage"]
[metrics.ever_default_homepage]
select_expression = "LOGICAL_OR(mozfun.map.get_key(environment.settings.user_prefs, 'browser.startup.homepage') IS NULL)"
data_source = "main"
[metrics.ever_default_homepage.statistics.binomial]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment