Data Octopus
Contents
Analytics

Google Analytics 4

Data Octopus connects to GA4 through the official Google Analytics API and pulls key e-commerce and traffic data into two tables: product data and overview data.

Integration overview

Data is pulled per GA4 property.

How to connect

To add Google Analytics 4 data to the Data Octopus app, after signing in to the panel:

  1. 1Click the shop you want to add data to.
  2. 2Go to the Sources section.
  3. 3Choose Google Analytics 4.
The Sources section in the Data Octopus app with the Google Analytics 4 tile
The Sources section in the Data Octopus app with the Google Analytics 4 tile

After clicking Google Analytics 4, a panel opens on the right where you enter the Google Analytics property identifier – Property Id.

The Property Id field in the Google Analytics 4 panel
The Property Id field in the Google Analytics 4 panel

To find the property number in Google Analytics 4, open Admin in the bottom-left corner.

The Admin button in the bottom-left corner of Google Analytics 4
The Admin button in the bottom-left corner of Google Analytics 4

Then open settings (1) and, under property settings, click property details (2). The number is in the top-right corner (3). Paste the copied property ID into the form.

Property details in Google Analytics 4 showing the property ID
Property details in Google Analytics 4 showing the property ID

After entering the ID, click Add and confirm access with a Google account that has at least Viewer access to the property.

Google sign-in window when confirming Google Analytics 4 access
Google sign-in window when confirming Google Analytics 4 access

When approving access, tick the checkbox "See and download your Google Analytics data".

The "See and download your Google Analytics data" consent
The "See and download your Google Analytics data" consent
Access setup guide: every source in one place

Resources we pull

Product data
ga4_products

Product-level e-commerce events: view, add to cart, purchase.

Overview data
ga4_overview

Overall traffic, session and conversion statistics.

Schedule and data range

  • Frequency: automatically once a day, overnight, between 00:00 and 03:00.
  • History: on first connection we pull data from up to the last 2 years. If the GA4 property has collected data for less time, a correspondingly shorter range is pulled.

Table 1: product data

  • propertyId: ID of the GA4 property the data comes from.
  • date: the date the row refers to.
  • itemId: unique product identifier.
  • itemName: product name.
  • itemsViewed: number of product views.
  • itemsAddedToCart: number of times the product was added to cart.
  • itemsCheckedOut: number of checkouts.
  • itemsPurchased: number of products purchased.
  • itemRevenue: revenue generated by the product.

Table 2: overview data

  • propertyId: ID of the GA4 property the data comes from.
  • date: the date the row refers 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 cart.
  • checkouts: number of checkouts started (begin_checkout events).
  • itemsPurchased: total number of products purchased.
  • ecommercePurchases: number of all e-commerce transactions (purchase events).
  • purchaseRevenue: total revenue from e-commerce transactions.

What we don't pull

Only these two reports are pulled. Events, traffic sources and audiences are not part of the pull.