Data Octopus integrates with Google Analytics 4 (GA4) by using the official Google Analytics API. This ensures a secure and orderly transfer of key e-commerce and behavioral data. The data is structured into two main tables, which facilitates its subsequent analysis and use.
Data Retrieval Schedule and Scope
Retrieval Frequency
Data is updated automatically once a day at night, within a fixed time window between 00:00 and 03:00.
Historical Scope
When first connecting a GA4 data source, the Data Octopus system retrieves historical data from a maximum of the last 2 years. If your GA4 property has been collecting data for a shorter period, a correspondingly shorter date range will be retrieved.
Data Table Schemas
Data Octopus processes and stores data in two main tables, which allow for comprehensive analysis of e-commerce and general traffic.
Table 1: Product Data
This table is closely related to e-commerce events at the individual product level (e.g., view, add to cart, purchase).
Column Name | Description |
propertyId | ID of the GA4 property from which the data was retrieved. |
date | The date the data row pertains to. |
itemId | Unique product identifier. |
itemName | Product name. |
itemsViewed | Number of product views. |
itemsAddedToCart | Number of times the product was added to the cart. |
itemsCheckedOut | Number of checkouts. |
itemsPurchased | Number of products purchased. |
itemRevenue | Revenue generated by the product. |
Table 2: Overview Data
This table contains general statistics on traffic, sessions, and conversions, providing an overview of the most important metrics.
Column Name | Description |
propertyId | ID of the GA4 property from which the data was retrieved. |
date | The date the data row pertains to. |
sessions | Number of user sessions. |
newUsers | Number of new users. |
totalUsers | Total number of unique users. |
itemsViewed | Total number of product views. |
itemsAddedToCart | Total number of products added to the cart. |
checkouts | Number of initiated checkout processes (begin_checkout events). |
itemsPurchased | Total number of products purchased. |
ecommercePurchases | Number of all e-commerce transactions (purchase events). |
purchaseRevenue | Total revenue generated by e-commerce transactions. |