Advertisement
kirzecy670

Untitled

Feb 7th, 2025
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.60 KB | None | 0 0
  1. SELECT action,
  2.        COUNT(uid) AS events_amount,
  3.        uniqCombined(uid) AS users
  4. FROM stat.funnelTrack
  5. WHERE dt >= '2025-02-01'
  6.   AND dt <= '2025-03-01'
  7.   AND action IN ('article_click',
  8.                  'articles_scroll_right',
  9.                  'read_story_click',
  10.                  'stories_scroll_right',
  11.                  'story_view',
  12.                  'web_enter_email_click',
  13.                  'web_enter_email_start',
  14.                  'web_go_to_bot_click',
  15.                  'web_go_to_bot_clock',
  16.                  'web_help_service_click',
  17.                  'web_share_page_click')
  18. GROUP BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement