Follow me on LinkedIn - AI, GA4, BigQuery

You can track the values of the GA4 Geolocations metrics in BigQuery via the Geolocation fields:


Use the following SQL (automatically generated via a text prompt in ChatGPT) to track the total number of unique users by geo locations in BigQuery: