GA4 Web Analytics Table (BETA)

ga4_web_analytics_table

The GA4 Web Analytics Table captures event-level user interactions from your GA4 property, including sessions, purchases, and engagement signals such as add-to-carts and page views. Querying this table gives you full visibility into individual event activity and conversion behavior, allowing for granular analysis of user actions across time, geography, and device type.

📘
Note
event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Hour	`event_hour`	string	The hour of the day on which the GA4 session started, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: `07`, `16`, `21`
Event Date	`event_date`	date	The date the GA4 session started. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Web Browser	`browser`	string	The web browser of the session where the order originated. Example values: `Chrome`, `Firefox`, `Safari`
Session City	`city`	string	The city of the session where the order originated. Example values: `San Francisco`, `Tel Aviv`, `Kyiv`
Session Country	`country`	string	The country of the session where the order originated. Example values: `United Kingdom`, `New Zealand`, `United Arab Emirates`
Device	`device`	string	The type of device used by the visitor for the session. Example values: `mobile`, `desktop`, `tablet`, `wearable`
Landing Page	`landing_page`	string	The URL path (without query parameters) of the page the visitor landed after clicking on an ad or link, indicating the first page viewed in a session. Example value: `/myshop/collections/green_sweater`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Add To Carts	`add_to_carts`	numeric	The number of Add To Cart events during sessions in the selected time range.
Purchase Revenue	`order_revenue`	numeric	The total revenue (after refunds) from purchases and subscriptions, during sessions in the selected time range. Purchase Revenue = Purchases + Subscriptions - Refunds
Purchases	`orders_quantity`	numeric	The total number of website and app purchases (orders) during sessions in the selected time range.
Sessions	`sessions`	numeric	The total number of sessions that started during the selected date range. GA4 defines a session as beginning with a `session_start` event and ending after 30 minutes of inactivity by default.

Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

Title	ID	Type	Description
Add To Cart Percent	`add_to_cart_percent`	formula	The percentage of add-to-carts out of total sessions. Add To Cart Percent = Number of Add To Carts / Number of Sessions

Title

Type

Description

Add To Cart Percent

add_to_cart_percent

formula

The percentage of add-to-carts out of total sessions.

Add To Cart Percent = Number of Add To Carts / Number of Sessions

Updated 20 days ago