Referencemetric
New User Count
The number of unique users who triggered a first_visit or first_open event.
https://developers.google.com/analytics/bigquery/basic-queries
SUM(is_new_user)
-- where is_new_user is MAX(IF(event_name IN ('first_visit', 'first_open'), 1, 0)) grouped by user_pseudo_idCitations
← cited bylinks to →
Cited by
- Events table (Google Analytics BigQuery Export) — Contains Google Analytics event export data from the `ga4_obfuscated_sample_ecommerce` dataset.