7. Geo

Use the SQL code below and change {{projectId}} and {{datasetName}} to your own.

#Geo object
WITH 
  #Set the date range for the calculation
    dates as 
      ( 
        SELECT
          '20220901' AS date_start,
          '20220930' AS date_end,
      )

SELECT
  CAST(FARM_FINGERPRINT(CONCAT(
    IFNULL(geoNetwork.country,""),
    IFNULL(geoNetwork.region,""),
    IFNULL(geoNetwork.city,""))) as STRING) as geoHash,
  geoNetwork.country,
  geoNetwork.region,
  geoNetwork.city
FROM
  dates as d, `{{projectId}}.{{datasetName}}.ga_sessions_*` 
WHERE 
  _TABLE_SUFFIX BETWEEN d.date_start and d.date_end
GROUP BY 1,2,3,4

You will get the data in the table 'geo' with the schema below: