Referência do conector do Google analítica Aggregated

info

Beta

Esse recurso está na versão beta. Para usá-lo, um administrador de Workspace deve ativar Lakeflow Connect for Google analítica Aggregated na página Pré-visualizações . Consulte Gerenciar prévias do Databricks.

O conector gerenciado do Google analítica Aggregated no Lakeflow Connect suporta 60 tabelas de origem no esquema default: 59 tabelas de relatório pré-construídas e uma tabela custom_report. Todas as tabelas são sincronizadas incrementalmente. O campo do cursor é date para tabelas agregadas por dia, yearWeek para weekly_events_report e o conjunto de dimensões definido em cursor_dimension para custom_report.

Tabelas de origem suportadas

O conector Google analítica Aggregated é compatível com as seguintes tabelas de origem, todas no esquema de origem default. Cada tabela faz uma execução de um relatório do Google analítica 4 (GA4) por meio da API de dados do Google analítica e agrupa os resultados por um conjunto fixo de dimensões. As tabelas pré-criadas são organizadas por categoria de relatório GA4:

• Tabelas de atividades do usuário
• Tabelas de relatório principais
• Tabelas de aquisição de usuários
• Tabelas de aquisição de tráfego
• Tabelas de engajamento
• Tabelas de monetização
• Tabelas demográficas
• Tabelas técnicas
• Tabelas de públicos-alvo
• Tabela de relatório personalizada

Para definições de cada dimensão e métrica, consulte Dimensões & Métricas de API na documentação do Google.

Para ingerir dados brutos de GA4 em nível de evento exportados para o BigQuery em vez de relatórios agregados, use o conector de dados brutos do Google analítica.

Tabelas de atividade do usuário

Contagens de usuários ativos em janelas rolantes de 1 dia, 7 dias e 28 dias.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas de relatório principais

Usuários, sessões e visualizações de página da propriedade, divididos por dispositivo, local, página e fonte de tráfego.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas de aquisição de usuários

Usuários divididos por atributos de origem, meio, campanha, plataforma e Google Ads que os adquiriram inicialmente.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas de aquisição de tráfego

Sessões divididas por fonte de sessão, meio, campanha, plataforma e grupo de canais default.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas de engajamento

Eventos, eventos key, views de página e tela e grupos de conteúdo.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas de monetização

Compras de itens de ecommerce e desempenho de anúncios do editor.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas demográficas

Usuários detalhados por localização, idioma, idade, gênero e interesses.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas técnicas

Usuários divididos por navegador, dispositivo, plataforma, sistema operacional, versão do aplicativo e resolução de tela.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
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

Tabelas de públicos-alvo

Usuários e sessões divididos por audiência.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
audiences_report	date, audienceName	activeUsers, averageSessionDuration, newUsers, screenPageViewsPerSession, sessions, totalRevenue	property_id, date, audienceName	Incremental	date

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
audiences_report	date, audienceName	activeUsers, averageSessionDuration, newUsers, screenPageViewsPerSession, sessions, totalRevenue	property_id, date, audienceName	Incremental	date

Tabela de relatório personalizada

A tabela custom_report executa um relatório com as dimensões e métricas que você especifica nas opções do seu conector. Veja Relatórios personalizados.

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
custom_report	Os valores de dimensions, mais cursor_dimension	Os valores de metrics	property_id, mais os valores de dimensions e cursor_dimension	Incremental	O valor de cursor_dimension

Tabela de fonte	Dimensões	Métricas	Chave primária	Modo de sincronização	Campo do cursor
custom_report	Os valores de dimensions, mais cursor_dimension	Os valores de metrics	property_id, mais os valores de dimensions e cursor_dimension	Incremental	O valor de cursor_dimension

Opções do conector

Defina estas opções em sua definição de pipeline. Consulte exemplos.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
start_date	String	Pipeline	Não	Todas as tabelas	Data mais antiga a partir da qual ingerir dados, no formato yyyy-MM-dd. O default é 60 dias antes da primeira sincronização.
property_ids	Matriz de strings	Tabela	Sim	Todas as tabelas, exceto custom_report	Os IDs numéricos das propriedades do GA4 para ingerir, por exemplo '["123456789"]'. O conector ingere a tabela uma vez para cada propriedade e grava o ID da propriedade na coluna property_id.
lookback_window_in_days	Integer	Tabela	Não	Todas as tabelas	Número de dias antes do último valor de cursor sincronizado que cada sincronização incremental solicita novamente. default 12.
property_id	String	Tabela	Sim	custom_report apenas	O ID numérico da propriedade GA4 para a execução do relatório personalizado.
dimensions	Matriz de strings	Tabela	Sim	custom_report apenas	Os nomes de API das dimensões do GA4 para agrupar o relatório, por exemplo '["country", "deviceCategory"]'.
metrics	Matriz de strings	Tabela	Sim	custom_report apenas	Os nomes de API das métricas do GA4 a serem incluídas no relatório, por exemplo '["sessions", "totalUsers"]'.
cursor_dimension	String	Tabela	Sim	custom_report apenas	A dimensão de data que define o nível de agregação do relatório e aciona sincronizações incrementais. Um entre date, yearWeek, yearMonth ou year. Veja Nível de agregação.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
start_date	String	Pipeline	Não	Todas as tabelas	Data mais antiga a partir da qual ingerir dados, no formato yyyy-MM-dd. O default é 60 dias antes da primeira sincronização.
property_ids	Matriz de strings	Tabela	Sim	Todas as tabelas, exceto custom_report	Os IDs numéricos das propriedades do GA4 para ingerir, por exemplo '["123456789"]'. O conector ingere a tabela uma vez para cada propriedade e grava o ID da propriedade na coluna property_id.
lookback_window_in_days	Integer	Tabela	Não	Todas as tabelas	Número de dias antes do último valor de cursor sincronizado que cada sincronização incremental solicita novamente. default 12.
property_id	String	Tabela	Sim	custom_report apenas	O ID numérico da propriedade GA4 para a execução do relatório personalizado.
dimensions	Matriz de strings	Tabela	Sim	custom_report apenas	Os nomes de API das dimensões do GA4 para agrupar o relatório, por exemplo '["country", "deviceCategory"]'.
metrics	Matriz de strings	Tabela	Sim	custom_report apenas	Os nomes de API das métricas do GA4 a serem incluídas no relatório, por exemplo '["sessions", "totalUsers"]'.
cursor_dimension	String	Tabela	Sim	custom_report apenas	A dimensão de data que define o nível de agregação do relatório e aciona sincronizações incrementais. Um entre date, yearWeek, yearMonth ou year. Veja Nível de agregação.

Para encontrar um ID de propriedade, consulte ID de propriedade na documentação do Google.

Relatórios personalizados

Use a tabela custom_report para ingerir uma combinação de dimensões e métricas que as tabelas pré-construídas não cobrem. Cada objeto custom_report em um pipeline faz uma execução de um relatório contra uma propriedade GA4.

O conector solicita as dimensões em dimensions, mais a dimensão em cursor_dimension se dimensions ainda não a incluir. Use os nomes da API listados em Dimensões e métricas da API, incluindo dimensões e métricas personalizadas definidas na propriedade. As dimensões e métricas devem ser compatíveis entre si no GA4. Para verificar uma combinação, consulte Método: properties.checkCompatibility na documentação do Google.

Para ingerir mais de um relatório personalizado, adicione um objeto custom_report para cada relatório, cada um com um destination_table diferente. Consulte Ingerir um relatório personalizado.

Nível de agregação

A opção cursor_dimension define o período de tempo durante o qual o relatório personalizado agrega métricas. Ele também define o campo de cursor para sincronizações incrementais.

cursor_dimension	Nível de agregação	Valor de exemplo
date	Dia	20260115
yearWeek	Semana do GA4	202603
yearMonth	Mês civil	202601
year	Ano civil	2026

cursor_dimension	Nível de agregação	Valor de exemplo
date	Dia	20260115
yearWeek	Semana do GA4	202603
yearMonth	Mês civil	202601
year	Ano civil	2026

Para agregação de semana, mês e ano, cada solicitação cobre períodos inteiros. O conector solicita o período atual e incompleto novamente em sincronizações posteriores, de modo que suas métricas são atualizadas após o fim do período. Para a definição de cada dimensão, consulte Dimensões e métricas da API.

Esquemas de tabela de destino

Cada tabela de destino inclui as seguintes colunas que o conector adiciona:

• property_id (STRING): O ID da propriedade GA4 da qual a linha veio.
• ingestion_timestamp (TIMESTAMP): A hora em que o conector ingeriu a linha.

Os valores de dimensão nas colunas date usam o formato YYYYMMDD e os valores de dimensão nas colunas yearWeek usam o formato YYYYWW. O conector solicita linhas cujas métricas são todas zero, portanto, essas linhas também aparecem nas tabelas de destino.

daily_active_users

Dimensões: date

Métricas: active1DayUsers

key primária: property_id, date

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
active1DayUsers	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
active1DayUsers	BIGINT
ingestion_timestamp	TIMESTAMP

weekly_active_users

Dimensões: date

Métricas: active7DayUsers

key primária: property_id, date

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
active7DayUsers	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
active7DayUsers	BIGINT
ingestion_timestamp	TIMESTAMP

four_weekly_active_users

Dimensões: date

Métricas: active28DayUsers

key primária: property_id, date

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
active28DayUsers	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
active28DayUsers	BIGINT
ingestion_timestamp	TIMESTAMP

website_overview

Dimensões: date

Métricas: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

key primária: property_id, date

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
totalUsers	BIGINT
newUsers	BIGINT
sessions	BIGINT
sessionsPerUser	DOUBLE
averageSessionDuration	DOUBLE
screenPageViews	BIGINT
screenPageViewsPerSession	DOUBLE
bounceRate	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, deviceCategory, operatingSystem, browser

Métricas: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

key primária: property_id, date, deviceCategory, operatingSystem, browser

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: region, country, city, date

Métricas: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

key primária: property_id, region, country, city, date

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, hostName, pagePathPlusQueryString

Métricas: screenPageViews, bounceRate

key primária: property_id, date, hostName, pagePathPlusQueryString

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
hostName	STRING
pagePathPlusQueryString	STRING
screenPageViews	BIGINT
bounceRate	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
hostName	STRING
pagePathPlusQueryString	STRING
screenPageViews	BIGINT
bounceRate	DOUBLE
ingestion_timestamp	TIMESTAMP

traffic_sources

Dimensões: date, sessionSource, sessionMedium

Métricas: totalUsers, newUsers, sessions, sessionsPerUser, averageSessionDuration, screenPageViews, screenPageViewsPerSession, bounceRate

key primária: property_id, date, sessionSource, sessionMedium

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserMedium

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserMedium

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserSource

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserSource

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserSource, firstUserMedium

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

key primária: property_id, date, firstUserSource, firstUserMedium

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserSourcePlatform

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserSourcePlatform

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserCampaignName

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserCampaignName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserGoogleAdsAdNetworkType

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserGoogleAdsAdNetworkType

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, firstUserGoogleAdsAdGroupName

Métricas: newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue, totalUsers, userEngagementDuration

Primary key: property_id, date, firstUserGoogleAdsAdGroupName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, sessionSource, sessionMedium

Métricas: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

key primária: property_id, date, sessionSource, sessionMedium

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, sessionMedium

Métricas: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionMedium

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, sessionSource

Métricas: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionSource

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, sessionCampaignName

Métricas: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionCampaignName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, sessionDefaultChannelGrouping

Métricas: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionDefaultChannelGrouping

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, sessionSourcePlatform

Métricas: totalUsers, sessions, engagedSessions, eventsPerSession, engagementRate, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, sessionSourcePlatform

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, eventName

Métricas: eventCount, totalUsers, eventCountPerUser, totalRevenue

Primary key: property_id, date, eventName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
eventName	STRING
eventCount	BIGINT
totalUsers	BIGINT
eventCountPerUser	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
eventName	STRING
eventCount	BIGINT
totalUsers	BIGINT
eventCountPerUser	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

weekly_events_report

Dimensões: yearWeek, eventName

Métricas: eventCount, totalUsers, eventCountPerUser, totalRevenue

Primary key: property_id, yearWeek, eventName

Modo de sincronização: Incremental

Campo do cursor: yearWeek

campo	Tipo de dados
property_id	STRING
yearWeek	STRING
eventName	STRING
eventCount	BIGINT
totalUsers	BIGINT
eventCountPerUser	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
yearWeek	STRING
eventName	STRING
eventCount	BIGINT
totalUsers	BIGINT
eventCountPerUser	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

conversions_report

Dimensões: date, eventName

Métricas: keyEvents, totalUsers, totalRevenue

Primary key: property_id, date, eventName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
eventName	STRING
keyEvents	DOUBLE
totalUsers	BIGINT
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
eventName	STRING
keyEvents	DOUBLE
totalUsers	BIGINT
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

pages_title_and_screen_class_report

Dimensões: date, unifiedScreenClass

Métricas: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, unifiedScreenClass

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
unifiedScreenClass	STRING
screenPageViews	BIGINT
totalUsers	BIGINT
newUsers	BIGINT
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
userEngagementDuration	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, pagePath

Métricas: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, pagePath

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
pagePath	STRING
screenPageViews	BIGINT
totalUsers	BIGINT
newUsers	BIGINT
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
userEngagementDuration	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, unifiedScreenName

Métricas: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, unifiedScreenName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
unifiedScreenName	STRING
screenPageViews	BIGINT
totalUsers	BIGINT
newUsers	BIGINT
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
userEngagementDuration	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, contentGroup

Métricas: screenPageViews, totalUsers, newUsers, eventCount, keyEvents, totalRevenue, userEngagementDuration

Primary key: property_id, date, contentGroup

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
contentGroup	STRING
screenPageViews	BIGINT
totalUsers	BIGINT
newUsers	BIGINT
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
userEngagementDuration	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemName

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemName	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemId

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemId

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemId	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemCategory, itemCategory2, itemCategory3, itemCategory4, itemCategory5

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

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

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, itemCategory

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemCategory	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemCategory2

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory2

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemCategory2	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemCategory3

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory3

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemCategory3	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemCategory4

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory4

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemCategory4	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemCategory5

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemCategory5

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemCategory5	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, itemBrand

Métricas: cartToViewRate, purchaseToViewRate, itemsPurchased, itemRevenue, itemsAddedToCart, itemsViewed

Primary key: property_id, date, itemBrand

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
itemBrand	STRING
cartToViewRate	DOUBLE
purchaseToViewRate	DOUBLE
itemsPurchased	BIGINT
itemRevenue	DOUBLE
itemsAddedToCart	BIGINT
itemsViewed	BIGINT
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, adUnitName

Métricas: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, adUnitName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
adUnitName	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
adUnitName	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

publisher_ads_page_path_report

Dimensões: date, pagePath

Métricas: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, pagePath

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
pagePath	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
pagePath	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

publisher_ads_ad_format_report

Dimensões: date, adFormat

Métricas: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, adFormat

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
adFormat	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
adFormat	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

publisher_ads_ad_source_report

Dimensões: date, adSourceName

Métricas: publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Primary key: property_id, date, adSourceName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
adSourceName	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
adSourceName	STRING
publisherAdImpressions	BIGINT
adUnitExposure	DOUBLE
publisherAdClicks	BIGINT
totalAdRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

demographic_country_report

Dimensões: date, country

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, country

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
country	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, region

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, region

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
region	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, city

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, city

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
city	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, language

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, language

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
language	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, userAgeBracket

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, userAgeBracket

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
userAgeBracket	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, userGender

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, userGender

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
userGender	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, brandingInterest

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, keyEvents, totalRevenue

Primary key: property_id, date, brandingInterest

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
brandingInterest	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, browser

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, browser

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
browser	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, deviceCategory

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, deviceCategory

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
deviceCategory	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, deviceModel

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, deviceModel

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
deviceModel	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, screenResolution

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, screenResolution

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
screenResolution	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, appVersion

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, appVersion

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
appVersion	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, platform

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, platform

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
platform	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, platform, deviceCategory

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

key primária: property_id, date, platform, deviceCategory

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
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

campo	Tipo de dados
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

Dimensões: date, operatingSystem

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, operatingSystem

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
operatingSystem	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, operatingSystemWithVersion

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, operatingSystemWithVersion

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
operatingSystemWithVersion	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, operatingSystemVersion

Métricas: totalUsers, newUsers, engagedSessions, engagementRate, eventCount, keyEvents, totalRevenue

Primary key: property_id, date, operatingSystemVersion

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
operatingSystemVersion	STRING
totalUsers	BIGINT
newUsers	BIGINT
engagedSessions	BIGINT
engagementRate	DOUBLE
eventCount	BIGINT
keyEvents	DOUBLE
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
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

Dimensões: date, audienceName

Métricas: activeUsers, averageSessionDuration, newUsers, screenPageViewsPerSession, sessions, totalRevenue

Primary key: property_id, date, audienceName

Modo de sincronização: Incremental

Campo do cursor: date

campo	Tipo de dados
property_id	STRING
date	STRING
audienceName	STRING
activeUsers	BIGINT
averageSessionDuration	DOUBLE
newUsers	BIGINT
screenPageViewsPerSession	DOUBLE
sessions	BIGINT
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

campo	Tipo de dados
property_id	STRING
date	STRING
audienceName	STRING
activeUsers	BIGINT
averageSessionDuration	DOUBLE
newUsers	BIGINT
screenPageViewsPerSession	DOUBLE
sessions	BIGINT
totalRevenue	DOUBLE
ingestion_timestamp	TIMESTAMP

custom_report

Dimensões: Os valores de dimensions, mais cursor_dimension

Métricas: Os valores de metrics

Chave key: property_id, mais os valores de dimensions e cursor_dimension

Modo de sincronização: Incremental

Campo do cursor: O valor de cursor_dimension

O conector cria o esquema de custom_report a partir dos metadados da propriedade. Cada dimensão é uma coluna STRING. Cada coluna de métrica obtém seu tipo de dados do tipo GA4 da métrica:

Tipo de métrica do GA4	Tipo de dados
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

Tipo de métrica do GA4	Tipo de dados
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

A tabela também inclui as colunas property_id e ingestion_timestamp.

Permissões OAuth necessárias

O conector Agregado do Google analítica solicita o escopo https://www.googleapis.com/auth/analytics.readonly, que concede acesso somente leitura aos dados do Google analítica. A identidade autenticada também deve ter pelo menos a função Visualizador em cada propriedade. Consulte Configurar autenticação no Google Analítica.

Permissão	Obrigatório para
https://www.googleapis.com/auth/analytics.readonly	Todas as tabelas

Permissão	Obrigatório para
https://www.googleapis.com/auth/analytics.readonly	Todas as tabelas