The GA4 Sessions Agg Table provides a session-level summary of user activity derived from GA4, aggregating key engagement and acquisition metrics such as active users, sessions, page views, and revenue. Querying this table allows you to explore how users are acquired and how they engage during sessions, using time-based and traffic source dimensions.

📘
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 user time zone when 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 user time zone when 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, based on the GA4 UI-selected primary channel grouping (which may include custom channel groups). 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, using GA4’s built-in channel classification logic based on session source and medium. 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: `postscript-sms-flow`, `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: `postscript-sms-flow / sms`, `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.