Pipeline GA4 Tables - Items Table

• Table name: ga4_mrt_items
• Scoping: Item Level (This is only for eCommerce websites).
• Table Contains: Item level dimensions and metrics.
• Each Row Presents: One row per item

When e-commerce actions take place such as purchases or viewing product details, GA4 creates “events”.

Within these eCommerce events, there are specific pieces of information at Item level. This includes information such as item name, category, price and quantity.

Each row of this table represents a different item, and the details associated with it.

Dimensions - Keys

Keys are unique IDs that help track and organise data.

In this table there are identifiers for different sessions, clients and streams which can allow you to dig into specific sessions or clients etc.

Dimensions - Dates

These date fields come in different formats - both timestamp and date.

If you are unsure of which column to use, use date__session_start_dt as this is the partition column. Unsure what a parition column is? Please see here to see the FAQ on this section.

Dimensions - Session Level

These dimensions relate to the source of session traffic i.e how users came to start their session.

Dimensions - Session Information

These dimensions provide boolean (true or false) values depending on whether the session matches certain criteria.

Dimensions - Last Non Direct Click

These dimensions provide information on the session using the Last Non-Direct Click (LNDC) attribution method. This is the GA4 default attribution method.

This method attributes the traffic acquisition to the last channel the user clicked through to the site over the past 90 day period (though this can be customised), excluding direct visits.

Dimension - Traffic Source All Time

These dimensions are provided directly by GA4 and provide information about the traffic source that first acquired the user.

Dimensions - Item Level

These dimensions provide information at the item level which are sent as parameters with an event.

Note: The item level parameters will need to be set up - these are not automatically generated by GA4.

Dimensions - Device

These dimensions provide information about the device which the user used to interact with the site/app.

Dimensions - Landing Page

These dimensions relate to the first Landing Page the user came across, or in other words, the first page that the user came to on the app/ website to start the session.

Dimensions - LNDC

These dimensions relate to the last non direct click (LNDC) attribution method.

Dimensions - Location Information

These dimensions relate to the location of the user session based on the IP address.

Dimensions - Other

This section provides information on other miscellaneous dimensions.

Dimensions - Session Level Traffic Source

These dimensions provide information about the traffic source that started the session.

Dimensions - Paid Dimensions

These dimensions relate to the paid traffic sources and are at session level.

Metrics

This section provides all the metrics which can be combined with the dimensions listed above.