Skip to main content

GA4 Events & Parameters

Specialized features for Google Analytics 4 BigQuery exports.

Only relevant if you use GA4 with BigQuery export.

GA4 Dataset Pattern​

  • Dataset: analytics_NNNNNNNN
  • Daily tables: events_YYYYMMDD
  • Intraday: events_intraday_YYYYMMDD

Querylab.io auto-detects GA4 datasets with a special icon.

Events Tab​

Overview of event types in the table:

Event NameCount%Description
page_view45,23152%User views a page
session_start12,45614%New session begins
purchase2340.3%Transaction completed

Uses free sampling (1000 rows). For exact counts, run a query.

Parameters Tab​

Shows parameters for each event type:

page_view
├── page_location (STRING): "https://..."
├── page_title (STRING): "Home Page"
└── page_referrer (STRING): "https://..."

purchase
├── transaction_id (STRING): "T12345"
├── value (FLOAT): 99.99
└── currency (STRING): "USD"

Extracting Parameters​

GA4 parameters are nested arrays. To extract in SQL:

SELECT
  event_name,
  (SELECT value.string_value FROM UNNEST(event_params)
   WHERE key = 'page_location') AS page_url
FROM `project.analytics_123456789.events_20250110`
WHERE event_name = 'page_view'

Cost Optimization​

  • Filter by _TABLE_SUFFIX: WHERE _TABLE_SUFFIX BETWEEN '20250101' AND '20250110'
  • Filter by event_date or event_name
  • Avoid SELECT * - specify needed columns