Advertisement
kirzecy670

Untitled

Dec 16th, 2024
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.59 KB | None | 0 0
  1. user_events as (SELECT
  2.     uid,
  3.     visitParamExtractString(addJson, 'from')||'_'||visitParamExtractString(addJson, 'ar') as source_a,
  4.     Count(uid) FILTER (WHERE action = 'buy_screen') AS buy_screen,
  5.     Count(uid) FILTER (WHERE action = 'buy_screen_buy_clicked') AS buy_screen_buy_clicked,
  6.     Count(uid) FILTER (WHERE action = 'buy_screen_buy_success') AS buy_screen_buy_success
  7. FROM stat.funnelTrack ft
  8. WHERE
  9.     ft.dt >= '2024-12-01'
  10.     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')
  11. GROUP BY 1, 2),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement