jetstream/recommend-bookmark-toolbar-early-day.toml (19 lines of code) (raw):
[metrics]
weekly = ['bookmarks_bar_pinned_on', 'bookmarks_bar_pinned_off', 'bookmarks_bar_bookmark_added', 'bookmarks_bar_bookmark_opened']
overall = ['bookmarks_bar_pinned_on', 'bookmarks_bar_pinned_off', 'bookmarks_bar_bookmark_added', 'bookmarks_bar_bookmark_opened']
[metrics.bookmarks_bar_pinned_on]
select_expression = '''CAST(COALESCE(SUM(CASE WHEN(SELECT CAST(COUNT(t) AS BOOL) FROM UNNEST(payload.processes.parent.keyed_scalars.browser_ui_toolbar_widgets) t WHERE t.key LIKE r'bookmarks-bar\_pinned\_on' AND t.value) THEN 1 ELSE 0 END),0) > 0 AS INT)'''
data_source = 'main'
[metrics.bookmarks_bar_pinned_off]
select_expression = '''CAST(COALESCE(SUM(CASE WHEN(SELECT CAST(COUNT(t) AS BOOL) FROM UNNEST(payload.processes.parent.keyed_scalars.browser_ui_toolbar_widgets) t WHERE t.key LIKE r'bookmarks-bar\_pinned\_off' AND t.value) THEN 1 ELSE 0 END),0) > 0 AS INT)'''
data_source = 'main'
[metrics.bookmarks_bar_bookmark_added]
select_expression = "CAST(COALESCE(SUM(payload.processes.parent.scalars.browser_engagement_bookmarks_toolbar_bookmark_added), 0) > 0 AS INT)"
data_source = 'main'
[metrics.bookmarks_bar_bookmark_opened]
select_expression = "CAST(COALESCE(SUM(payload.processes.parent.scalars.browser_engagement_bookmarks_toolbar_bookmark_opened), 0) > 0 AS INT)"
data_source = 'main'
[metrics.bookmarks_bar_pinned_on.statistics.binomial]
[metrics.bookmarks_bar_pinned_off.statistics.binomial]
[metrics.bookmarks_bar_bookmark_added.statistics.binomial]
[metrics.bookmarks_bar_bookmark_opened.statistics.binomial]