Tracking Google Analytics 4 First Time Users in BigQuery

You can track the values of the GA4 First Time Users metric in BigQuery via the 'user_first_touch_timestamp' field. This field tells when a user first interacted with your website or app.

Use the following SQL (automatically generated via a text prompt in ChatGPT) to track GA4 First Time Users in BigQuery: