Skip to main content

Google Analytics 4 (GA4) API Connector

Updated today
Google Analytics 4 (GA4) Logo ...

Summary

This connector imports and models data from Google Analytics 4 (GA4) properties using the GA4 API. It collects session-level, event-level, channel, and geographic data with support for GA-defined metrics and custom engagement tracking.

  • Source: google_analytics_data

  • Connection Label: Bright Analytics

  • Import Type: Scheduled daily job with 3-day lookback

  • Supports: Segmentation by source/medium/campaign, device, geography, and channel groupings

  • Includes: Engagement metrics (sessions, users, events), conversion tracking, and derived KPIs

For more information on this integration, please follow link here.


Connection

Key

Description

Required

Type

ga_property_ids

Comma‑separated GA4 property IDs

Text

google_client_secret

Google OAuth Client Secret (hidden)

Hidden

google_client_id

Google OAuth Client ID (hidden)

Hidden


Job Configuration

Field

Value

Job Label

GA4 Import

Feed

google_analytics_data

Status

2 (Active)

Lookback

3 days

First Run Hour

6 AM

Poll Frequency

Every 24 hours

Update Mode

append

Lookback Window

0


Targets

Each target represents a table with incoming data. All require the ga_property_ids input (comma-separated GA4 Property IDs).

Table Name

Description

Date Column

googleanalytics4_data_sessions

GA - Session Data

bright_custom_date

googleanalytics4_data_sessions_channel

GA - Sessions Channel Data

bright_custom_date

googleanalytics4_data_sessions_country

GA - Sessions Country Data

bright_custom_date

googleanalytics4_data_event

GA4 - Event Data

bright_custom_date


Dimensions

Name

Result Fields

Medium [GA4]

googleanalytics4_data_sessions.sessionMedium, googleanalytics4_data_event.medium

Campaign [GA4]

googleanalytics4_data_sessions.sessionCampaignName, googleanalytics4_data_event.campaignName

Source [GA4]

googleanalytics4_data_sessions.sessionSource

Default Channel Grouping

googleanalytics4_data_sessions.sessionDefaultChannelGrouping, googleanalytics4_data_sessions_channel.sessionDefaultChannelGrouping

Device [GA4]

googleanalytics4_data_sessions.deviceCategory, googleanalytics4_data_event.deviceCategory

Country [GA4]

googleanalytics4_data_sessions_country.country, googleanalytics4_data_event.country

Event Name [GA4]

googleanalytics4_data_event.eventName


Base Metrics

Name

Formulae

Round

Page Views [GA4]

SUM(screenPageViews) from sessions, sessions_channel, sessions_country

0

Sessions [GA4]

SUM(sessions) from all: sessions, sessions_channel, sessions_country, event

0

Users [GA4]

SUM(totalUsers) from sessions, sessions_channel, sessions_country

0

New Users [GA4]

SUM(newUsers) from sessions, sessions_channel, sessions_country

0

Engagements [GA4]

SUM(engagedSessions) from sessions, sessions_channel, sessions_country

0

Total Session Duration

SUM(userEngagementDuration) from sessions, sessions_channel, sessions_country

0

Conversions [GA4]

SUM(conversions) from googleanalytics4_data_event

0


Composite Metrics

Name

Formula

Format

Avg Session Duration [GA4]

{Total Session Duration [GA4]} / {Sessions [GA4]}

2 decimals, %

Page Views per Session [GA4]

{Page Views [GA4]} / {Sessions [GA4]}

2 decimals, %


Joins

  • Datasource Joins: None configured


Example Use Cases

  • Measure user engagement across device types and countries

  • Analyze session traffic by source/medium/campaign

  • Report marketing performance using session-level and event-based metrics

  • Track conversions and define KPIs like engagement rate or average session duration

Did this answer your question?