Google Analytics Aggregated connector reference

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Google Analytics Aggregated from the Previews page. See Manage Azure Databricks previews.

The managed Google Analytics Aggregated connector in Lakeflow Connect supports 60 source tables in the default schema: 59 prebuilt report tables and a custom_report table. All tables sync incrementally. The cursor field is date for day-aggregated tables, yearWeek for weekly_events_report, and the dimension set in cursor_dimension for custom_report.

Supported source tables

The Google Analytics Aggregated connector supports the following source tables, all under the default source schema. Each table runs a Google Analytics 4 (GA4) report through the Google Analytics Data API and groups the results by a fixed set of dimensions. The prebuilt tables are organized by GA4 report category:

For definitions of each dimension and metric, see API Dimensions & Metrics in the Google documentation.

To ingest raw, event-level GA4 data exported to BigQuery instead of aggregated reports, use the Google Analytics Raw Data connector.

User activity tables

Active-user counts over rolling 1-day, 7-day, and 28-day windows.

Source table Dimensions Metrics Primary key Sync mode Cursor field
daily_active_users date active1DayUsers property_id, date Incremental date
weekly_active_users date active7DayUsers property_id, date Incremental date
four_weekly_active_users date active28DayUsers property_id, date Incremental date

Core report tables

Users, sessions, and page views for the property, broken down by device, location, page, and traffic source.

Source table Dimensions Metrics Primary key Sync mode Cursor field
website_overview date totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate property_id, date Incremental date
devices date, deviceCategory, operatingSystem, browser totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate property_id, date, deviceCategory, operatingSystem, browser Incremental date
locations region, country, city, date totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate property_id, region, country, city, date Incremental date
pages date, hostName, pagePathPlusQueryString screenPageViews, bounceRate property_id, date, hostName, pagePathPlusQueryString Incremental date
traffic_sources date, sessionSource, sessionMedium totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate property_id, date, sessionSource, sessionMedium Incremental date

User acquisition tables

Users broken down by the source, medium, campaign, platform, and Google Ads attributes that first acquired them.

Source table Dimensions Metrics Primary key Sync mode Cursor field
user_acquisition_first_user_medium_report date, firstUserMedium newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserMedium Incremental date
user_acquisition_first_user_source_report date, firstUserSource newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserSource Incremental date
user_acquisition_first_user_source_medium_report date, firstUserSource, firstUserMedium newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserSource, firstUserMedium Incremental date
user_acquisition_first_user_source_platform_report date, firstUserSourcePlatform newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserSourcePlatform Incremental date
user_acquisition_first_user_campaign_report date, firstUserCampaignName newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserCampaignName Incremental date
user_acquisition_first_user_google_ads_ad_network_type_report date, firstUserGoogleAdsAdNetworkType newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserGoogleAdsAdNetworkType Incremental date
user_acquisition_first_user_google_ads_ad_group_name_report date, firstUserGoogleAdsAdGroupName newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration property_id, date, firstUserGoogleAdsAdGroupName Incremental date

Traffic acquisition tables

Sessions broken down by the session source, medium, campaign, platform, and default channel group.

Source table Dimensions Metrics Primary key Sync mode Cursor field
traffic_acquisition_session_source_medium_report date, sessionSource, sessionMedium totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, sessionSource, sessionMedium Incremental date
traffic_acquisition_session_medium_report date, sessionMedium totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, sessionMedium Incremental date
traffic_acquisition_session_source_report date, sessionSource totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, sessionSource Incremental date
traffic_acquisition_session_campaign_report date, sessionCampaignName totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, sessionCampaignName Incremental date
traffic_acquisition_session_default_channel_grouping_report date, sessionDefaultChannelGrouping totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, sessionDefaultChannelGrouping Incremental date
traffic_acquisition_session_source_platform_report date, sessionSourcePlatform totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, sessionSourcePlatform Incremental date

Engagement tables

Events, key events, page and screen views, and content groups.

Source table Dimensions Metrics Primary key Sync mode Cursor field
events_report date, eventName eventCount, totalUsers, eventCountPerUser, totalRevenue property_id, date, eventName Incremental date
weekly_events_report yearWeek, eventName eventCount, totalUsers, eventCountPerUser, totalRevenue property_id, yearWeek, eventName Incremental yearWeek
conversions_report date, eventName keyEvents, totalUsers, totalRevenue property_id, date, eventName Incremental date
pages_title_and_screen_class_report date, unifiedScreenClass screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, unifiedScreenClass Incremental date
pages_path_report date, pagePath screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, pagePath Incremental date
pages_title_and_screen_name_report date, unifiedScreenName screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, unifiedScreenName Incremental date
content_group_report date, contentGroup screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration property_id, date, contentGroup Incremental date

Monetization tables

Ecommerce item purchases and publisher ad performance.

Source table Dimensions Metrics Primary key Sync mode Cursor field
ecommerce_purchases_item_name_report date, itemName cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemName Incremental date
ecommerce_purchases_item_id_report date, itemId cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemId Incremental date
ecommerce_purchases_item_category_report_combined date, itemCategory, itemCategory2, itemCategory3, itemCategory4, itemCategory5 cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemCategory, itemCategory2, itemCategory3, itemCategory4, itemCategory5 Incremental date
ecommerce_purchases_item_category_report date, itemCategory cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemCategory Incremental date
ecommerce_purchases_item_category_2_report date, itemCategory2 cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemCategory2 Incremental date
ecommerce_purchases_item_category_3_report date, itemCategory3 cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemCategory3 Incremental date
ecommerce_purchases_item_category_4_report date, itemCategory4 cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemCategory4 Incremental date
ecommerce_purchases_item_category_5_report date, itemCategory5 cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemCategory5 Incremental date
ecommerce_purchases_item_brand_report date, itemBrand cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed property_id, date, itemBrand Incremental date
publisher_ads_ad_unit_report date, adUnitName publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue property_id, date, adUnitName Incremental date
publisher_ads_page_path_report date, pagePath publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue property_id, date, pagePath Incremental date
publisher_ads_ad_format_report date, adFormat publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue property_id, date, adFormat Incremental date
publisher_ads_ad_source_report date, adSourceName publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue property_id, date, adSourceName Incremental date

Demographics tables

Users broken down by location, language, age, gender, and interests.

Source table Dimensions Metrics Primary key Sync mode Cursor field
demographic_country_report date, country totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, country Incremental date
demographic_region_report date, region totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, region Incremental date
demographic_city_report date, city totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, city Incremental date
demographic_language_report date, language totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, language Incremental date
demographic_age_report date, userAgeBracket totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, userAgeBracket Incremental date
demographic_gender_report date, userGender totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, userGender Incremental date
demographic_interest_report date, brandingInterest totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue property_id, date, brandingInterest Incremental date

Tech tables

Users broken down by browser, device, platform, operating system, app version, and screen resolution.

Source table Dimensions Metrics Primary key Sync mode Cursor field
tech_browser_report date, browser totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, browser Incremental date
tech_device_category_report date, deviceCategory totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, deviceCategory Incremental date
tech_device_model_report date, deviceModel totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, deviceModel Incremental date
tech_screen_resolution_report date, screenResolution totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, screenResolution Incremental date
tech_app_version_report date, appVersion totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, appVersion Incremental date
tech_platform_report date, platform totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, platform Incremental date
tech_platform_device_category_report date, platform, deviceCategory totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, platform, deviceCategory Incremental date
tech_operating_system_report date, operatingSystem totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, operatingSystem Incremental date
tech_os_with_version_report date, operatingSystemWithVersion totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, operatingSystemWithVersion Incremental date
tech_os_version_report date, operatingSystemVersion totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue property_id, date, operatingSystemVersion Incremental date

Audiences tables

Users and sessions broken down by audience.

Source table Dimensions Metrics Primary key Sync mode Cursor field
audiences_report date, audienceName activeUsers, averageSessionDuration, newUsers, screenPageViewsPerSession, sessions, totalRevenue property_id, date, audienceName Incremental date

Custom report table

The custom_report table runs a report with the dimensions and metrics that you specify in its connector options. See Custom reports.

Source table Dimensions Metrics Primary key Sync mode Cursor field
custom_report The values of dimensions, plus cursor_dimension The values of metrics property_id, plus the values of dimensions and cursor_dimension Incremental The value of cursor_dimension

Connector options

Set these options in your pipeline definition. See examples.

Option Type Scope Required Applies to Description
start_date String Pipeline No All tables Earliest date to ingest data from, in yyyy-MM-dd format. Defaults to 60 days before the first sync.
property_ids Array of strings Table Yes All tables except custom_report The numeric IDs of the GA4 properties to ingest, for example '["123456789"]'. The connector ingests the table one time for each property and writes the property ID to the property_id column.
lookback_window_in_days Integer Table No All tables Number of days before the last synced cursor value that each incremental sync re-requests. Defaults to 12.
property_id String Table Yes custom_report only The numeric ID of the GA4 property to run the custom report against.
dimensions Array of strings Table Yes custom_report only The API names of the GA4 dimensions to group the report by, for example '["country", "deviceCategory"]'.
metrics Array of strings Table Yes custom_report only The API names of the GA4 metrics to include in the report, for example '["sessions", "totalUsers"]'.
cursor_dimension String Table Yes custom_report only The date dimension that sets the report's aggregation level and drives incremental syncs. One of date, yearWeek, yearMonth, or year. See Aggregation level.

To find a property ID, see Property ID in the Google documentation.

Custom reports

Use the custom_report table to ingest a combination of dimensions and metrics that the prebuilt tables don't cover. Each custom_report object in a pipeline runs one report against one GA4 property.

The connector requests the dimensions in dimensions, plus the dimension in cursor_dimension if dimensions doesn't already include it. Use the API names listed in API Dimensions & Metrics, including custom dimensions and metrics defined on the property. The dimensions and metrics must be compatible with each other in GA4. To check a combination, see Method: properties.checkCompatibility in the Google documentation.

To ingest more than one custom report, add a custom_report object for each report, each with a different destination_table. See Ingest a custom report.

Aggregation level

The cursor_dimension option sets the time period that the custom report aggregates metrics over. It also sets the cursor field for incremental syncs.

cursor_dimension Aggregation level Example value
date Day 20260115
yearWeek GA4 week 202603
yearMonth Calendar month 202601
year Calendar year 2026

For week, month, and year aggregation, each request covers whole periods. The connector requests the current, incomplete period again in later syncs, so its metrics update after the period ends. For the definition of each dimension, see API Dimensions & Metrics.

Destination table schemas

Every destination table includes the following columns that the connector adds:

  • property_id (STRING): The GA4 property ID that the row came from.
  • ingestion_timestamp (TIMESTAMP): The time that the connector ingested the row.

Dimension values in date columns use the YYYYMMDD format, and dimension values in yearWeek columns use the YYYYWW format. The connector requests rows whose metrics are all zero, so these rows also appear in the destination tables.

daily_active_users

Dimensions: date

Metrics: active1DayUsers

Primary key: property_id, date

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
active1DayUsers BIGINT
ingestion_timestamp TIMESTAMP

weekly_active_users

Dimensions: date

Metrics: active7DayUsers

Primary key: property_id, date

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
active7DayUsers BIGINT
ingestion_timestamp TIMESTAMP

four_weekly_active_users

Dimensions: date

Metrics: active28DayUsers

Primary key: property_id, date

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
active28DayUsers BIGINT
ingestion_timestamp TIMESTAMP

website_overview

Dimensions: date

Metrics: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

Primary key: property_id, date

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
totalUsers BIGINT
newUsers BIGINT
sessions BIGINT
sessionsPerUser DOUBLE
averageSessionDuration DOUBLE
screenPageViews BIGINT
screenPageViewsPerSession DOUBLE
bounceRate DOUBLE
ingestion_timestamp TIMESTAMP

devices

Dimensions: date, deviceCategory, operatingSystem, browser

Metrics: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

Primary key: property_id, date, deviceCategory, operatingSystem, browser

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
deviceCategory STRING
operatingSystem STRING
browser STRING
totalUsers BIGINT
newUsers BIGINT
sessions BIGINT
sessionsPerUser DOUBLE
averageSessionDuration DOUBLE
screenPageViews BIGINT
screenPageViewsPerSession DOUBLE
bounceRate DOUBLE
ingestion_timestamp TIMESTAMP

locations

Dimensions: region, country, city, date

Metrics: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

Primary key: property_id, region, country, city, date

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
region STRING
country STRING
city STRING
date STRING
totalUsers BIGINT
newUsers BIGINT
sessions BIGINT
sessionsPerUser DOUBLE
averageSessionDuration DOUBLE
screenPageViews BIGINT
screenPageViewsPerSession DOUBLE
bounceRate DOUBLE
ingestion_timestamp TIMESTAMP

pages

Dimensions: date, hostName, pagePathPlusQueryString

Metrics: screenPageViews, bounceRate

Primary key: property_id, date, hostName, pagePathPlusQueryString

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
hostName STRING
pagePathPlusQueryString STRING
screenPageViews BIGINT
bounceRate DOUBLE
ingestion_timestamp TIMESTAMP

traffic_sources

Dimensions: date, sessionSource, sessionMedium

Metrics: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

Primary key: property_id, date, sessionSource, sessionMedium

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionSource STRING
sessionMedium STRING
totalUsers BIGINT
newUsers BIGINT
sessions BIGINT
sessionsPerUser DOUBLE
averageSessionDuration DOUBLE
screenPageViews BIGINT
screenPageViewsPerSession DOUBLE
bounceRate DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_medium_report

Dimensions: date, firstUserMedium

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserMedium

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserMedium STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_source_report

Dimensions: date, firstUserSource

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserSource

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserSource STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_source_medium_report

Dimensions: date, firstUserSource, firstUserMedium

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserSource, firstUserMedium

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserSource STRING
firstUserMedium STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_source_platform_report

Dimensions: date, firstUserSourcePlatform

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserSourcePlatform

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserSourcePlatform STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_campaign_report

Dimensions: date, firstUserCampaignName

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserCampaignName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserCampaignName STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_google_ads_ad_network_type_report

Dimensions: date, firstUserGoogleAdsAdNetworkType

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserGoogleAdsAdNetworkType

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserGoogleAdsAdNetworkType STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

user_acquisition_first_user_google_ads_ad_group_name_report

Dimensions: date, firstUserGoogleAdsAdGroupName

Metrics: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserGoogleAdsAdGroupName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
firstUserGoogleAdsAdGroupName STRING
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
totalUsers BIGINT
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

traffic_acquisition_session_source_medium_report

Dimensions: date, sessionSource, sessionMedium

Metrics: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionSource, sessionMedium

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionSource STRING
sessionMedium STRING
totalUsers BIGINT
sessions BIGINT
engagedSessions BIGINT
eventsPerSession DOUBLE
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

traffic_acquisition_session_medium_report

Dimensions: date, sessionMedium

Metrics: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionMedium

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionMedium STRING
totalUsers BIGINT
sessions BIGINT
engagedSessions BIGINT
eventsPerSession DOUBLE
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

traffic_acquisition_session_source_report

Dimensions: date, sessionSource

Metrics: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionSource

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionSource STRING
totalUsers BIGINT
sessions BIGINT
engagedSessions BIGINT
eventsPerSession DOUBLE
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

traffic_acquisition_session_campaign_report

Dimensions: date, sessionCampaignName

Metrics: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionCampaignName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionCampaignName STRING
totalUsers BIGINT
sessions BIGINT
engagedSessions BIGINT
eventsPerSession DOUBLE
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

traffic_acquisition_session_default_channel_grouping_report

Dimensions: date, sessionDefaultChannelGrouping

Metrics: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionDefaultChannelGrouping

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionDefaultChannelGrouping STRING
totalUsers BIGINT
sessions BIGINT
engagedSessions BIGINT
eventsPerSession DOUBLE
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

traffic_acquisition_session_source_platform_report

Dimensions: date, sessionSourcePlatform

Metrics: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionSourcePlatform

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
sessionSourcePlatform STRING
totalUsers BIGINT
sessions BIGINT
engagedSessions BIGINT
eventsPerSession DOUBLE
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

events_report

Dimensions: date, eventName

Metrics: eventCount, totalUsers, eventCountPerUser, totalRevenue

Primary key: property_id, date, eventName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
eventName STRING
eventCount BIGINT
totalUsers BIGINT
eventCountPerUser DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

weekly_events_report

Dimensions: yearWeek, eventName

Metrics: eventCount, totalUsers, eventCountPerUser, totalRevenue

Primary key: property_id, yearWeek, eventName

Sync mode: Incremental

Cursor field: yearWeek

Field Data type
property_id STRING
yearWeek STRING
eventName STRING
eventCount BIGINT
totalUsers BIGINT
eventCountPerUser DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

conversions_report

Dimensions: date, eventName

Metrics: keyEvents, totalUsers, totalRevenue

Primary key: property_id, date, eventName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
eventName STRING
keyEvents DOUBLE
totalUsers BIGINT
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

pages_title_and_screen_class_report

Dimensions: date, unifiedScreenClass

Metrics: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, unifiedScreenClass

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
unifiedScreenClass STRING
screenPageViews BIGINT
totalUsers BIGINT
newUsers BIGINT
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

pages_path_report

Dimensions: date, pagePath

Metrics: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, pagePath

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
pagePath STRING
screenPageViews BIGINT
totalUsers BIGINT
newUsers BIGINT
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

pages_title_and_screen_name_report

Dimensions: date, unifiedScreenName

Metrics: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, unifiedScreenName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
unifiedScreenName STRING
screenPageViews BIGINT
totalUsers BIGINT
newUsers BIGINT
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

content_group_report

Dimensions: date, contentGroup

Metrics: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, contentGroup

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
contentGroup STRING
screenPageViews BIGINT
totalUsers BIGINT
newUsers BIGINT
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
userEngagementDuration DOUBLE
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_name_report

Dimensions: date, itemName

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemName STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_id_report

Dimensions: date, itemId

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemId

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemId STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_category_report_combined

Dimensions: date, itemCategory, itemCategory2, itemCategory3, itemCategory4, itemCategory5

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory, itemCategory2, itemCategory3, itemCategory4, itemCategory5

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemCategory STRING
itemCategory2 STRING
itemCategory3 STRING
itemCategory4 STRING
itemCategory5 STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_category_report

Dimensions: date, itemCategory

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemCategory STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_category_2_report

Dimensions: date, itemCategory2

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory2

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemCategory2 STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_category_3_report

Dimensions: date, itemCategory3

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory3

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemCategory3 STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_category_4_report

Dimensions: date, itemCategory4

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory4

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemCategory4 STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_category_5_report

Dimensions: date, itemCategory5

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory5

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemCategory5 STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

ecommerce_purchases_item_brand_report

Dimensions: date, itemBrand

Metrics: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemBrand

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
itemBrand STRING
cartToViewRate DOUBLE
purchaseToViewRate DOUBLE
itemsPurchased BIGINT
itemRevenue DOUBLE
itemsAddedToCart BIGINT
itemsViewed BIGINT
ingestion_timestamp TIMESTAMP

publisher_ads_ad_unit_report

Dimensions: date, adUnitName

Metrics: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, adUnitName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
adUnitName STRING
publisherAdImpressions BIGINT
adUnitExposure DOUBLE
publisherAdClicks BIGINT
totalAdRevenue DOUBLE
ingestion_timestamp TIMESTAMP

publisher_ads_page_path_report

Dimensions: date, pagePath

Metrics: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, pagePath

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
pagePath STRING
publisherAdImpressions BIGINT
adUnitExposure DOUBLE
publisherAdClicks BIGINT
totalAdRevenue DOUBLE
ingestion_timestamp TIMESTAMP

publisher_ads_ad_format_report

Dimensions: date, adFormat

Metrics: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, adFormat

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
adFormat STRING
publisherAdImpressions BIGINT
adUnitExposure DOUBLE
publisherAdClicks BIGINT
totalAdRevenue DOUBLE
ingestion_timestamp TIMESTAMP

publisher_ads_ad_source_report

Dimensions: date, adSourceName

Metrics: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, adSourceName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
adSourceName STRING
publisherAdImpressions BIGINT
adUnitExposure DOUBLE
publisherAdClicks BIGINT
totalAdRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_country_report

Dimensions: date, country

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, country

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
country STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_region_report

Dimensions: date, region

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, region

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
region STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_city_report

Dimensions: date, city

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, city

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
city STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_language_report

Dimensions: date, language

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, language

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
language STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_age_report

Dimensions: date, userAgeBracket

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, userAgeBracket

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
userAgeBracket STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_gender_report

Dimensions: date, userGender

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, userGender

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
userGender STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

demographic_interest_report

Dimensions: date, brandingInterest

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, brandingInterest

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
brandingInterest STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_browser_report

Dimensions: date, browser

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, browser

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
browser STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_device_category_report

Dimensions: date, deviceCategory

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, deviceCategory

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
deviceCategory STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_device_model_report

Dimensions: date, deviceModel

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, deviceModel

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
deviceModel STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_screen_resolution_report

Dimensions: date, screenResolution

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, screenResolution

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
screenResolution STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_app_version_report

Dimensions: date, appVersion

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, appVersion

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
appVersion STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_platform_report

Dimensions: date, platform

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, platform

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
platform STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_platform_device_category_report

Dimensions: date, platform, deviceCategory

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, platform, deviceCategory

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
platform STRING
deviceCategory STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_operating_system_report

Dimensions: date, operatingSystem

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, operatingSystem

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
operatingSystem STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_os_with_version_report

Dimensions: date, operatingSystemWithVersion

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, operatingSystemWithVersion

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
operatingSystemWithVersion STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

tech_os_version_report

Dimensions: date, operatingSystemVersion

Metrics: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, operatingSystemVersion

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
operatingSystemVersion STRING
totalUsers BIGINT
newUsers BIGINT
engagedSessions BIGINT
engagementRate DOUBLE
eventCount BIGINT
keyEvents DOUBLE
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

audiences_report

Dimensions: date, audienceName

Metrics: activeUsers, averageSessionDuration, newUsers, screenPageViewsPerSession, sessions, totalRevenue

Primary key: property_id, date, audienceName

Sync mode: Incremental

Cursor field: date

Field Data type
property_id STRING
date STRING
audienceName STRING
activeUsers BIGINT
averageSessionDuration DOUBLE
newUsers BIGINT
screenPageViewsPerSession DOUBLE
sessions BIGINT
totalRevenue DOUBLE
ingestion_timestamp TIMESTAMP

custom_report

Dimensions: The values of dimensions, plus cursor_dimension

Metrics: The values of metrics

Primary key: property_id, plus the values of dimensions and cursor_dimension

Sync mode: Incremental

Cursor field: The value of cursor_dimension

The connector builds the schema of custom_report from the property's metadata. Each dimension is a STRING column. Each metric column takes its data type from the metric's GA4 type:

GA4 metric type Data type
TYPE_INTEGER BIGINT
TYPE_FLOAT, TYPE_SECONDS, TYPE_MILLISECONDS, TYPE_MINUTES, TYPE_HOURS, TYPE_STANDARD, TYPE_CURRENCY, TYPE_FEET, TYPE_MILES, TYPE_METERS, TYPE_KILOMETERS DOUBLE
METRIC_TYPE_UNSPECIFIED STRING

The table also includes the property_id and ingestion_timestamp columns.

Required OAuth permissions

The Google Analytics Aggregated connector requests the https://www.googleapis.com/auth/analytics.readonly scope, which grants read-only access to Google Analytics data. The authenticated identity must also have at least the Viewer role on each property. See Configure authentication to Google Analytics.

Permission Required for
https://www.googleapis.com/auth/analytics.readonly All tables
  • Last updated on