GA4 Product Analytics Table

ga4_product_analytics_table

The GA4 Product Analytics Table aggregates product-level engagement and revenue data from GA4, based on user interactions like views, add-to-carts, checkouts, and purchases. Querying this table enables product-focused analysis of performance trends, helping you understand how users interact with individual items and which products drive the most revenue.

📘
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 purchase event occurred, 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 purchase event occurred. 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`.
Item ID	`item_id`	string	The unique identifier for the product, as reported by GA4. Typically maps to the product or variant SKU. Example values: `57404707913`, `sku123`

Measures

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

Title	ID	Type	Description
Gross Item Revenue	`gross_item_revenue`	numeric	The total revenue from items only, before any discounts, tax, shipping, or refunds. Gross Item Revenue = Item Price x Item Quantity
Item Revenue	`item_revenue`	numeric	The total revenue from items only, before tax and shipping (but after refunds). Item Revenue = Item Price x Item Quantity - Refunds
Items Added to Cart	`items_added_to_cart`	numeric	The number of items added to a cart. Each unit counts separately.
Items Checked Out	`items_checked_out`	numeric	The number of items in the cart when the checkout process was initiated. Each unit counts separately.
Items Purchased	`items_purchased`	numeric	The number of items included in purchase events. Each unit counts separately.
Items Viewed	`items_viewed`	numeric	The number of items that the customer viewed.

Updated about 2 months ago