Sample Queries for the GA4 BigQuery Export
Use these ready-made sample queries to begin querying and building reports from your GA4 BigQuery export data.
-
Create a GA4 Country Report in BigQuery
Generate a geo country report showing users, sessions and engagement metrics for each country. [Read now]
-
Create a GA4 Hourly Traffic Report in BigQuery
Calculate a view of hourly users and sessions on your website for a specific day. [Read now]
-
Create a GA4 Page Performance Report in BigQuery
Generate a list of the top 10 most viewed pages on your site, counting views, users and views per user. [Read now]
-
Calculating Session Metrics
Session metrics can be used to help measure user engagement and behaviours on your digital platforms. [Read now]
-
Calculating User Metrics
User metrics provide valuable insights into your user base and their interactions with your website or app. [Read now]