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 GuideWhat You Can Answer With This Table
- How much GA4 session traffic do we get by landing page, device, or country? — use
sessions,landing_page,device- What are our GA4-reported purchases, revenue, and add-to-cart rates? — use
orders_quantity,order_revenue,add_to_cart_percentBefore 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_startevent 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
- Use Web Analytics table when you need Triple Whale Pixel-based web analytics. The GA4 Web Analytics table is for GA4 web analytics data, so numbers can differ.
- Use GA4 Sessions Agg table when you need GA4 traffic-source or acquisition-channel breakdowns. The GA4 Web Analytics table is for GA4 on-page context such as landing page, device, browser, and country.
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: |
| 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: |
| Session City | city | string | The city of the session where the order originated. Example values: |
| Session Country | country | string | The country of the session. See list of countries. Example values: |
| Device | device | string | The type of device used by the visitor for the session. Example values: |
| 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: |
| 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: |
| 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: |
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 |
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 |
Updated 12 days ago