Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select action, count(*) FROM stat.funnelTrack
- where action = 'block_viewed'
- and dt >= '2025-05-20'
- and appVersion = 2009111
- and ((action = 'block_viewed' and simpleJSONExtractString(addJson, 'block_name') = 'articleCarousel')
- or action in ('articles_block_clicked', 'articleCarousel_link_click', 'feed_card_viewed', 'feed_card_clicked', 'article_viewed'))
- group by 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
