forked from mozilla/jetstream-config
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path1-click-pin-experiment.toml
130 lines (100 loc) · 3.7 KB
/
1-click-pin-experiment.toml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
[experiment]
segments = ["attributed", "non_attributed"]
enrollment_period = 14
end_date = "2021-05-26"
reference_branch = "control"
## Segments
[segments]
[segments.attributed]
select_expression = 'max(attr_source is not null)'
data_source = "npp"
[segments.non_attributed]
select_expression = 'max(attr_source is null)'
data_source = "npp"
## Data Sources
[segments.data_sources.npp]
from_expression = """
(SELECT
DATE(submission_timestamp) AS submission_date,
client_id,
environment.settings.attribution.source AS attr_source
FROM `moz-fx-data-shared-prod.telemetry.new_profile`
WHERE environment.partner.distribution_id IS NULL
AND coalesce(environment.settings.attribution.ua, '') != 'firefox'
)
"""
window_start = -2
window_end = 0
[data_sources.themes]
from_expression = """
(
SELECT
submission_date,
client_id,
experiments,
true as switched_theme
FROM `moz-fx-data-shared-prod.telemetry.events`
WHERE event_category = 'addonsManager'
AND event_method = 'enable'
AND event_object = 'theme'
)
"""
experiments_column_type = "native"
[data_sources.imports]
from_expression = """
(
SELECT
DATE(submission_timestamp) AS submission_date,
client_id,
environment.experiments,
stretch.entity,
kh.key AS browser,
mozfun.hist.extract(kh.value).sum AS items
FROM mozdata.telemetry.main
CROSS JOIN UNNEST([
STRUCT(payload.keyed_histograms.fx_migration_bookmarks_quantity AS histogram, "bookmarks" AS entity),
(payload.keyed_histograms.fx_migration_logins_quantity, "logins"),
(payload.keyed_histograms.fx_migration_history_quantity, "history")
]) AS stretch
CROSS JOIN UNNEST(stretch.histogram) AS kh
)
"""
experiments_column_type = "native"
## Metrics
[metrics]
weekly = ['days_of_use', 'search_count', 'organic_search_count', 'active_hours', 'unenroll',
'set_to_default_rate', 'imported_from_any_browser', 'set_theme', 'taskbar_pin_rate', 'taskbar_launch_rate']
overall = ['days_of_use', 'search_count', 'organic_search_count', 'active_hours', 'unenroll',
'set_to_default_rate', 'imported_from_any_browser', 'set_theme', 'taskbar_pin_rate', 'taskbar_launch_rate']
[metrics.unenroll.statistics.binomial]
## Set to default rate
[metrics.set_to_default_rate]
select_expression = "COALESCE(LOGICAL_OR(is_default_browser), FALSE)"
data_source = 'clients_daily'
[metrics.set_to_default_rate.statistics.binomial]
## Taskbar Pinning rate
[metrics.taskbar_pin_rate]
select_expression = "COALESCE(LOGICAL_OR(scalar_parent_os_environment_is_taskbar_pinned), FALSE)"
data_source = 'clients_daily'
[metrics.taskbar_pin_rate.statistics.binomial]
## Taskbar Launch rate
[metrics.taskbar_launch_rate]
select_expression = "COALESCE(LOGICAL_OR(scalar_parent_os_environment_launched_via_taskbar), FALSE)"
data_source = 'clients_daily'
[metrics.taskbar_launch_rate.statistics.binomial]
## imports, global
[metrics.imported_from_any_browser]
select_expression = "COALESCE(SUM(IF(browser != 'firefox', items, 0)), 0) > 0"
data_source = "imports"
friendly_name = "Importers"
description = "Fraction of clients that imported at least one item from a non-Firefox browser."
bigger_is_better = true
[metrics.imported_from_any_browser.statistics.binomial]
## theme
[metrics.set_theme]
select_expression = "COALESCE(MAX(switched_theme), false)"
data_source = "themes"
friendly_name = "Set to Default"
description = "Fraction of clients reported a theme switch event at least once in period."
bigger_is_better = true
[metrics.set_theme.statistics.binomial]