Untitled

kirzecy670

Jul 8th, 2025

206

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

PostgreSQL 1.10 KB | None | 0 0

raw download clone embed print report

-- Пользователи с forced group installation
forced_group_installation_users AS (
SELECT uid as uid
FROM stat.funnelTrack
WHERE dt >= '2025-06-16'
AND action = 'forced_group_installation'
AND deviceType = 1
AND appVersion >= 2009141
AND (
visitParamExtractString(addJson, 'experimentId') = 'android_gmd_57483_newApp_v01_ru_experiment'
OR visitParamExtractString(addJson, 'experiment') = 'ios_gmd_57484_newApp_v01_ru_experiment'
)
),
-- Только реальные участники эксперимента (без форсированных)
new_ui_users AS (
SELECT uid
FROM stat.funnelTrack
WHERE dt >= '2025-06-16'
AND action IN (
'android_gmd_57483_newApp_v01_ru_experiment',
'ios_gmd_57484_newApp_v01_ru_experiment'
)
AND deviceType = 1
AND appVersion >= 2009141
AND visitParamExtractString(addJson, 'option') = 'new'
),
AND (ts < '2025-06-16' OR uid IN (SELECT uid FROM new_ui_users))
AND uid NOT IN (SELECT uid FROM forced_group_installation_users)

Add Comment

Please, Sign In to add comment