Untitled

kirzecy670

Jun 16th, 2025

168

Never

Add comment

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

MySQL 0.84 KB | None | 0 0

raw download clone embed print report

WITH filtered_data AS (
SELECT
uid,
simpleJSONExtractString(addJson, 'details') as details
FROM stat.funnelTrack
WHERE action IN ('feature_disabled', 'feature_deactivated')
AND dt >= '2025-06-01'
AND (
simpleJSONExtractString(addJson, 'experiment') in ('android_gmd_57483_newApp_v01_ru_experiment', 'ios_gmd_57483_newApp_v01_ru_experiment')
OR simpleJSONExtractString(addJson, 'experimentId') in ('android_gmd_57483_newApp_v01_ru_experiment', 'ios_gmd_57483_newApp_v01_ru_experiment')
)
-- AND simpleJSONExtractString(addJson, 'details') = 'first install does not match'
)
SELECT distinct uid
FROM stat.funnelTrack f
JOIN filtered_data d ON f.uid = d.uid
WHERE f.dt >= '2025-06-16'
AND f.action = 'open_first'
and details = 'minimal date open first do not match'

Add Comment

Please, Sign In to add comment