Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT uid,
- ts,
- action,
- sessionNumber,
- addJson,
- JSONExtractInt(addJson, 'timestamp') AS timestamp,
- appVersion
- FROM stat.funnelTrack
- WHERE dt >= '2025-06-01'
- AND uid IN ('uw8bt35x40')
- AND action NOT IN ('default_price_group',
- 'app_theme_change',
- 'install_referrer_init',
- 'sensors',
- 'unlucky',
- 'notification_in_app_switcher',
- 'notifications_sound',
- 'firebase_info',
- 'load_product_prices_start',
- 'install_referrer_response',
- 'REFERRER',
- 'feature_disabled',
- 'load_product_prices_end',
- 'purchase_flow',
- 'appsflyer_attribution',
- 'fst_gmd_55626_quiz_basic',
- 'app_was_rolled',
- 'app_was_closed')
- -- AND action in ('full_register', 'profile_open', 'main_screen_open', 'open_first')
- AND action not like 'fst_gmd_%'
- AND action not like 'growth_gmd_%'
- AND action not like '%buy_screen%'
- ORDER BY uid,
- ts DESC, timestamp DESC
- LIMIT 5000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
