Markdown file
new_user_count.md
The number of unique users who triggered a first_visit or first_open event.
SUM(is_new_user)
-- where is_new_user is MAX(IF(event_name IN ('first_visit', 'first_open'), 1, 0)) grouped by user_pseudo_id