This repository has been archived by the owner on Jan 26, 2023. It is now read-only.
/
multi-stage-aboutwelcome-set-default-as-first-screen-v2.toml
132 lines (95 loc) · 3.32 KB
/
multi-stage-aboutwelcome-set-default-as-first-screen-v2.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
130
131
132
[experiment]
segments = ["attributed", "non_attributed"]
reference_branch = "msw_default"
start_date = "2021-02-16"
end_date = "2021-03-23"
## data sources
[data_sources]
## data source: item imports from imports histogram
[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"
## data source: themes
[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"
## 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"
[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
## metrics
[metrics]
overall = ['days_of_use', 'unenroll', 'is_default', 'imported_from_any_browser', 'set_theme']
weekly = ['days_of_use', 'unenroll', 'is_default', 'imported_from_any_browser', 'set_theme']
[metrics.unenroll.statistics.binomial]
[metrics.days_of_use.statistics.bootstrap_mean]
## 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]
## set to default
[metrics.is_default]
select_expression = "COALESCE(MAX(is_default_browser), false)"
data_source = "clients_daily"
friendly_name = "Set to Default"
description = "Fraction of clients reported FF is set as default at least once in period."
bigger_is_better = true
[metrics.is_default.statistics.binomial]
## set to default
[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]