The GA4 Sessions Agg table aggregates GA4-sourced session metrics (users, sessions, page views, revenue) by traffic source and channel group. One row per source/channel combination per day.

📋
Table Guide
What You Can Answer With This Table

How many users, sessions, and new users are we getting? — use total_users, new_users, active_users, sessions

Which channels drive the most sessions? — group by session_default_channel_group or session_source with sessions

Which first-touch channels bring in new users? — group by first_user_primary_channel_group with new_users

What's our GA4-reported revenue by channel? — group by session_default_channel_group with total_revenue

How deep does engagement go per channel? — group by session_default_channel_group with screen_page_views

Before You Query

Required field: event_date

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

first_user_ dimensions reflect the user's first-ever session (acquisition). session_ dimensions reflect this specific session (current behavior). Use the right one based on the question you're asking.

total_revenue includes purchases, subscriptions, in-app transactions, and ad revenue — broader than order_revenue on the GA4 Web Analytics table.

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 due to differing session definitions. Learn more

When to Use a Different Table

Need Triple Whale Pixel-based traffic and acquisition (channel-level metrics from Pixel data) → Web Analytics table or Sessions table. Those use Triple Whale Pixel; this table uses GA4.

Need on-page context (landing pages, devices, browsers, countries for GA4 sessions) → GA4 Web Analytics table. GA4 Sessions Agg breaks down by traffic source; GA4 Web Analytics breaks down by on-page context.

Need product-level GA4 performance → 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`.
First User Primary Channel Group	`first_user_primary_channel_group`	string	The Primary Channel Group attributed to the user's first session. Example values: `Organic Search`, `Affiliates`, `SMS`, `Cross-network`, `Paid Other`
Session Default Channel Group	`session_default_channel_group`	string	The Default Channel Group assigned to the session. Example values: `Organic Search`, `Referral`, `Direct`, `Paid Social`, `Unassigned`
Session Source	`session_source`	string	The raw traffic source that initiated the session, derived from UTM parameters or the referring domain. Example values: `facebook`, `klaviyo-email-flow`, `awin`
Session Source / Medium	`session_source_medium`	string	A combined representation of the session's traffic source and medium, used by GA4 to assign the session to a channel group. Example values: `facebook / cpc`, `klaviyo-email-flow / email`, `awin / affiliate`

Measures

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

Title	ID	Type	Description
Active Users	`active_users`	numeric	The number of distinct users who had at least one engaged session during the selected time range. GA4 defines an engaged session as one that lasted at least 10 seconds, had a conversion event, or had 2 or more screen/page views.
New Users	`new_users`	numeric	The number of users who interacted with your site or app for the first time.
Promotion Views	`promotion_views`	numeric	The number of times users viewed on-site or in-app promotions, such as banners or product carousels.
Screen / Page Views	`screen_page_views`	numeric	The total number of page views (for web) and screen views (for app) that occurred 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.
Total Revenue	`total_revenue`	numeric	The total revenue (after refunds) from purchases, in-app transactions, subscriptions and ads, during sessions in the selected time range. Total Revenue = Purchases + In-App Purchases + Subscriptions + Ad Revenue - Refunds
Total Users	`total_users`	numeric	The number of distinct users who initiated at least one session during the selected time range, including both new and returning users.