GA4 Web Analytics Table

ga4_web_analytics_table

The GA4 Web Analytics table tracks GA4-sourced on-site activity (sessions, add-to-carts, purchases, revenue) aggregated by landing page, device, browser, and geography. One row per dimension combination per day.

📋
Table Guide
What You Can Answer With This Table

How much GA4 session traffic do we get by landing page, device, or country? — group by landing_page, device, or country with sessions

What are our GA4-reported purchases and revenue? — use orders_quantity, order_revenue

What's our add-to-cart rate per day? — use add_to_cart_percent

Which browsers and devices drive the most GA4 traffic? — group by browser or device

Before You Query

Required field: event_date

Data comes from your connected GA4 property. Without a GA4 connection, this table is empty.

GA4 defines a session as beginning with a session_start event and ending after 30 minutes of inactivity. Counts may differ from your sales platform and from Triple Whale's own Web Analytics table due to differing session definitions. Learn more

Revenue figures reflect GA4's reporting (including subscriptions, minus refunds), not Triple Whale's Pixel-based attribution.

When to Use a Different Table

Need Triple Whale Pixel-based web analytics (Pixel-tracked sessions) → Web Analytics table. Web Analytics uses Triple Whale Pixel; this table uses GA4 — numbers will differ.

Need acquisition-channel breakdown (Organic Search, Paid Social, etc.) → GA4 Sessions Agg table. GA4 Web Analytics breaks down by on-page context; GA4 Sessions Agg breaks down by traffic source.

Need product-level GA4 performance (item views, revenue per item) → GA4 Product Analytics table.

View the full Triple Whale Data Ontology →

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. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
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`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`

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 15 days ago