Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user_events as (SELECT
- uid,
- visitParamExtractString(addJson, 'from')||'_'||visitParamExtractString(addJson, 'ar') as source_a,
- Count(uid) FILTER (WHERE action = 'buy_screen') AS buy_screen,
- Count(uid) FILTER (WHERE action = 'buy_screen_buy_clicked') AS buy_screen_buy_clicked,
- Count(uid) FILTER (WHERE action = 'buy_screen_buy_success') AS buy_screen_buy_success
- FROM stat.funnelTrack ft
- WHERE
- ft.dt >= '2024-12-01'
- AND ft.action in ('buy_screen', 'buy_screen_buy_clicked', 'buy_screen_buy_success', 'buy_screen_details', 'buy_screen_loading_time', 'buy_screen_select_plan')
- GROUP BY 1, 2),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement