Google Analytics Aggregated connector reference

Beta

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 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:

• User activity tables
• Core report tables
• User acquisition tables
• Traffic acquisition tables
• Engagement tables
• Monetization tables
• Demographics tables
• Tech tables
• Audiences tables
• Custom report table

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Permission	Required for
https://www.googleapis.com/auth/analytics.readonly	All tables