jetstream/import-bookmarks-copy.toml

[metrics]
weekly = ['imported_bookmarks', 'imported_logins', 'imported_history', 'is_pinned']

overall = ['imported_bookmarks', 'imported_logins', 'imported_history', 'is_pinned']

[segments]

[segments.new_users]
select_expression = """COALESCE(ANY_VALUE(activity_segment_importbookmarks) = 'new_user', FALSE)"""
data_source = 'clients_last_seen_with_activity'
window_start = 0
window_end = 0

[segments.core_users]
select_expression = """COALESCE(ANY_VALUE(activity_segment_importbookmarks) = 'core', FALSE)"""
data_source = 'clients_last_seen_with_activity'
window_start = 0
window_end = 0

[segments.regular_users]
select_expression = """COALESCE(ANY_VALUE(activity_segment_importbookmarks) = 'regular', FALSE)"""
data_source = 'clients_last_seen_with_activity'
window_start = 0
window_end = 0

[segments.casual_users]
select_expression = """COALESCE(ANY_VALUE(activity_segment_importbookmarks) = 'casual', FALSE)"""
data_source = 'clients_last_seen_with_activity'
window_start = 0
window_end = 0

[segments.infrequent_users]
select_expression = """COALESCE(ANY_VALUE(activity_segment_importbookmarks) = 'infrequent', FALSE)"""
data_source = 'clients_last_seen_with_activity'
window_start = 0
window_end = 0

[segments.other_users]
select_expression = """COALESCE(ANY_VALUE(activity_segment_importbookmarks) = 'other', FALSE)"""
data_source = 'clients_last_seen_with_activity'
window_start = 0
window_end = 0

[segments.data_sources]

[segments.data_sources.clients_last_seen_with_activity]
from_expression = """(
     SELECT 
          *,
          CASE WHEN days_since_first_seen < 28 THEN 'new_user' 
               WHEN days_since_first_seen >= 28 AND activity_segments_v1 = 'core_user' THEN 'core' 
               WHEN days_since_first_seen >=28  AND activity_segments_v1 = 'regular_user' THEN 'regular' 
               WHEN days_since_first_seen >= 28 AND activity_segments_v1 = 'casual_user' THEN 'casual' 
               WHEN days_since_first_seen >= 28 AND activity_segments_v1 = 'infrequent_user' THEN 'infrequent'
          ELSE 'other' END AS activity_segment_importbookmarks
     FROM mozdata.telemetry.clients_last_seen
)"""
window_start = 0
window_end = 0


[experiment]
segments = [
     'new_users',
     'core_users',
     'regular_users', 
     'casual_users',
     'infrequent_users'
]