Google Analytics 4

Follow our setup guide to connect your Google Analytics 4 connector with QUANTI:

Pre-built tables and definition

---

Prerequisites

Before connecting Google Analytics 4 to QUANTI, ensure you have:

• Google Account: A valid Google account with access to Google Analytics 4

• GA4 Property Access: At least Viewer access to the GA4 property(ies) you want to connect

• Active GA4 Property: Your property must have active data collection to retrieve insights

---

Setup Instructions

1

Authorize Google Connection

• Click on Connect to Google

• You will be redirected to Google's authorization page

• Log in with your Google account credentials

• Review and accept the requested permissions

• Click Allow to grant QUANTI access to your Google Analytics 4 data

2

Connector Information

• Connector Name: Define a unique name for your connector

• Dataset ID: Specify the BigQuery dataset ID where tables will be created

  • The dataset will be created automatically if it doesn't exist

• Click Next

3

Configure Connector

• Connector Name: Enter a unique name for this connector

• Dataset ID: Define the BigQuery dataset ID where data will be stored (must not exist yet, will be created automatically)

• Click Next

4

Select Accounts & Properties

• You'll see a list of your accessible GA4 accounts and properties

• Select the account(s) and property(ies) you want to connect to QUANTI

• You can select multiple properties to track data from different sources

• Click Next

5

Select Pre-built Tables or Create Custom Queries

• Review the available pre-built tables (see section below for details)

• All tables are selected by default - you can deselect tables you don't need

• Pre-built tables provide standard GA4 reports ready to use

• Custom queries: You can also create your own queries by selecting specific dimensions and metrics (refer to the "Custom Query" section below)

• Recommended: Keep all pre-built tables enabled for complete analytics coverage

• Click Next

6

Finish Setup

• Define a sync period and a lookback window

• Click Save

• For the first sync, you have the following options:

  • Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button

  • Launch a historical data recovery by choosing your desired dates in the historical data tab

  • Launch a manual sync immediately by clicking the Sync now button

• Wait for the sync to complete

• Navigate to your data warehouse to verify that tables are populated

• Check the connector dashboard for sync status and any potential errors

---

Pre-built Tables

Dimension Tables (Configuration & History)

• accounts: List of accessible Google Analytics 4 accounts with basic information and settings

• conversion_events: List of conversion events configured in GA4 with counting methods

• custom_dimensions: List of custom dimensions configured in GA4 with their scope and parameter names

• google_ads_links: List of Google Ads links configured in GA4 properties

• properties: List of GA4 properties with their configuration settings

Metric Tables (Reports & Analytics)

Attribution & Campaign Performance

• data_driven_key_events_report: Key events attributed to marketing campaigns with data-driven attribution model

• data_driven_transaction_ids: Transaction-level data with data-driven attribution to campaigns

• session_acquisition_report: Session metrics by acquisition source, medium, and campaign

• first_user_acquisition_report: New user metrics by first acquisition source and campaign

Traffic & Source Analysis

• daily_global_report: Daily aggregated statistics across all traffic sources (overview)

• daily_source_medium_report: Daily statistics by source/medium combination

• daily_source_medium_campaign_report: Daily statistics by source/medium/campaign combination

Content & Engagement

• events_report: Event-level metrics showing user interactions and key events

• pages_path_report: Page-level metrics by URL path

• pages_screen_name_report: Page/screen metrics by title and name

• unified_screen_class_report: Screen class metrics for mobile apps and web pages

E-commerce

• ecommerce_item_report: Product-level metrics including views, cart additions, and purchases

• ecommerce_purchase_item_report: Purchase transaction details by item and transaction ID

Technology & Devices

• tech_device_report: User metrics by device category, model, and operating system

• tech_browser_report: User metrics by browser type

---

Pre-built tables and definition

---

Custom Query

To create custom queries, you need to select dimensions and metrics. To help you in this step, we recommend using the GA4 Dimensions & Metrics Explorer tool.

GA4 Dimensions & Metrics Explorer Tool

How to Build Custom Queries

1

Select Dimensions

Choose up to 9 dimensions that define how your data will be grouped (e.g., source, medium, campaign, deviceCategory).

2

Select Metrics

Choose the metrics you want to measure (e.g., sessions, totalUsers, conversions, totalRevenue).

3

Name Your Query

Give your custom query a descriptive name.

4

Validate

QUANTI will validate your query against GA4 API limits and compatibility rules.

---

Notes

• Data Refresh: Google Analytics 4 data is typically updated once per day

• Historical Limitations: GA4 API has limitations on historical data retrieval. Some metrics may only be available from the property creation date

• Sampling: For large datasets, GA4 may apply sampling. QUANTI automatically manages sampling thresholds

• API Rate Limits: Google enforces rate limits on API requests. QUANTI automatically manages these limits to ensure reliable data extraction

• Data Processing Time: GA4 data can take 24-48 hours to be fully processed after collection

• Custom Dimensions: Custom dimensions must be created in GA4 before they can be used in QUANTI queries

---

Limits

• Custom Query Dimensions: The Google Analytics 4 API limits custom queries to 9 dimensions maximum, so choose them carefully

• API Quota: Google Analytics 4 API has daily quotas. QUANTI automatically manages these quotas across syncs

• Date Range: Historical data availability depends on your GA4 property retention settings (default: 14 months for standard properties)

---

Troubleshooting

Connection Issues

• Verify that your Google account has proper access to the GA4 property

• Ensure you've granted all required permissions during authorization

• Check that the GA4 property is active and collecting data

• Verify that API access is enabled for your GA4 property

Missing Data

• Some metrics may not be available for all dimension combinations

• Historical data older than your retention period will not be available

• Data processing can take 24-48 hours - recent data may be incomplete

• Custom dimensions must be configured in GA4 before syncing

Sync Errors

• API Quota Exceeded: Wait for quota reset (24 hours) or reduce sync frequency

• Invalid Dimension/Metric Combination: Some dimensions and metrics cannot be used together - consult GA4 documentation

• Sampling Applied: For very large date ranges, GA4 may apply sampling - consider splitting into smaller date ranges

Need Help?

Contact QUANTI support at [email protected] or consult our comprehensive documentation at https://docs.quanti.io