Référence du connecteur agrégé Google Analytique

info

Bêta

Cette fonctionnalité est en version Bêta. Pour l’utiliser, un administrateur de Workspace doit activer Lakeflow Connect for Google analytique Aggregated sur la page Aperçus . Consultez Gérer les aperçus Databricks.

Le connecteur managé Google analytique Aggregated dans Lakeflow Connect prend en charge 60 tables sources dans le schéma default : 59 tables de rapport prédéfinies et une table custom_report. Toutes les tables se synchronisent de manière incrémentielle. Le champ de curseur est date pour les tables agrégées par jour, yearWeek pour weekly_events_report, et l’ensemble de dimensions défini dans cursor_dimension pour custom_report.

Tables sources prises en charge

Le connecteur Google Analytique prend en charge les tables sources suivantes, toutes sous le schéma source default. Chaque table exécute un rapport Google analytique 4 (GA4) via l’ API Google analytique Data et regroupe les résultats par un ensemble fixe de dimensions. Les tables préconstruites sont organisées par catégorie de rapport GA4 :

Tables d'activité des utilisateurs
Tables de rapport de base
Tables d'acquisition d'utilisateurs
Tables d'acquisition de trafic
Tables d'engagement
Tables de monétisation
Tables de données démographiques
Tables techniques
Tables d'audiences
Table de rapport personnalisée

Pour les définitions de chaque dimension et mesure, consultez Dimensions et mesures de l'API dans la documentation de Google.

Pour ingérer des données GA4 brutes au niveau de l’événement exportées vers BigQuery au lieu de rapports agrégés, utilisez le connecteur de données brutes Google analytique.

Tables d’activité des utilisateurs

Nombre d’utilisateurs actifs sur des fenêtres glissantes de 1 jour, 7 jours et 28 jours.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`daily_active_users`	`date`	`active1DayUsers`	`property_id`, `date`	Incrémentiel	`date`
`weekly_active_users`	`date`	`active7DayUsers`	`property_id`, `date`	Incrémentiel	`date`
`four_weekly_active_users`	`date`	`active28DayUsers`	`property_id`, `date`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`daily_active_users`	`date`	`active1DayUsers`	`property_id`, `date`	Incrémentiel	`date`
`weekly_active_users`	`date`	`active7DayUsers`	`property_id`, `date`	Incrémentiel	`date`
`four_weekly_active_users`	`date`	`active28DayUsers`	`property_id`, `date`	Incrémentiel	`date`

Tables de rapports principales

Utilisateurs, sessions et pages vues pour la propriété, ventilés par appareil, emplacement, page et source de trafic.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`website_overview`	`date`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `date`	Incrémentiel	`date`
`devices`	`date`, `deviceCategory`, `operatingSystem`, `browser`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `date`, `deviceCategory`, `operatingSystem`, `browser`	Incrémentiel	`date`
`locations`	`region`, `country`, `city`, `date`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `region`, `country`, `city`, `date`	Incrémentiel	`date`
`pages`	`date`, `hostName`, `pagePathPlusQueryString`	`screenPageViews`, `bounceRate`	`property_id`, `date`, `hostName`, `pagePathPlusQueryString`	Incrémentiel	`date`
`traffic_sources`	`date`, `sessionSource`, `sessionMedium`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `date`, `sessionSource`, `sessionMedium`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`website_overview`	`date`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `date`	Incrémentiel	`date`
`devices`	`date`, `deviceCategory`, `operatingSystem`, `browser`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `date`, `deviceCategory`, `operatingSystem`, `browser`	Incrémentiel	`date`
`locations`	`region`, `country`, `city`, `date`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `region`, `country`, `city`, `date`	Incrémentiel	`date`
`pages`	`date`, `hostName`, `pagePathPlusQueryString`	`screenPageViews`, `bounceRate`	`property_id`, `date`, `hostName`, `pagePathPlusQueryString`	Incrémentiel	`date`
`traffic_sources`	`date`, `sessionSource`, `sessionMedium`	`totalUsers`, `newUsers`, `sessions`, `sessionsPerUser`, `averageSessionDuration`, `screenPageViews`, `screenPageViewsPerSession`, `bounceRate`	`property_id`, `date`, `sessionSource`, `sessionMedium`	Incrémentiel	`date`

Tables d'acquisition d'utilisateurs

Utilisateurs ventilés par source, support, campagne, plateforme et attributs Google Ads qui les ont acquis en premier.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`user_acquisition_first_user_medium_report`	`date`, `firstUserMedium`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserMedium`	Incrémentiel	`date`
`user_acquisition_first_user_source_report`	`date`, `firstUserSource`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserSource`	Incrémentiel	`date`
`user_acquisition_first_user_source_medium_report`	`date`, `firstUserSource`, `firstUserMedium`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserSource`, `firstUserMedium`	Incrémentiel	`date`
`user_acquisition_first_user_source_platform_report`	`date`, `firstUserSourcePlatform`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserSourcePlatform`	Incrémentiel	`date`
`user_acquisition_first_user_campaign_report`	`date`, `firstUserCampaignName`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserCampaignName`	Incrémentiel	`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`	Incrémentiel	`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`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`user_acquisition_first_user_medium_report`	`date`, `firstUserMedium`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserMedium`	Incrémentiel	`date`
`user_acquisition_first_user_source_report`	`date`, `firstUserSource`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserSource`	Incrémentiel	`date`
`user_acquisition_first_user_source_medium_report`	`date`, `firstUserSource`, `firstUserMedium`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserSource`, `firstUserMedium`	Incrémentiel	`date`
`user_acquisition_first_user_source_platform_report`	`date`, `firstUserSourcePlatform`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserSourcePlatform`	Incrémentiel	`date`
`user_acquisition_first_user_campaign_report`	`date`, `firstUserCampaignName`	`newUsers`, `engagedSessions`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `totalUsers`, `userEngagementDuration`	`property_id`, `date`, `firstUserCampaignName`	Incrémentiel	`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`	Incrémentiel	`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`	Incrémentiel	`date`

Tables d'acquisition de trafic

Sessions ventilées par source, support, campagne, plateforme et groupe de Canaux de distribution default.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`traffic_acquisition_session_source_medium_report`	`date`, `sessionSource`, `sessionMedium`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionSource`, `sessionMedium`	Incrémentiel	`date`
`traffic_acquisition_session_medium_report`	`date`, `sessionMedium`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionMedium`	Incrémentiel	`date`
`traffic_acquisition_session_source_report`	`date`, `sessionSource`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionSource`	Incrémentiel	`date`
`traffic_acquisition_session_campaign_report`	`date`, `sessionCampaignName`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionCampaignName`	Incrémentiel	`date`
`traffic_acquisition_session_default_channel_grouping_report`	`date`, `sessionDefaultChannelGrouping`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionDefaultChannelGrouping`	Incrémentiel	`date`
`traffic_acquisition_session_source_platform_report`	`date`, `sessionSourcePlatform`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionSourcePlatform`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`traffic_acquisition_session_source_medium_report`	`date`, `sessionSource`, `sessionMedium`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionSource`, `sessionMedium`	Incrémentiel	`date`
`traffic_acquisition_session_medium_report`	`date`, `sessionMedium`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionMedium`	Incrémentiel	`date`
`traffic_acquisition_session_source_report`	`date`, `sessionSource`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionSource`	Incrémentiel	`date`
`traffic_acquisition_session_campaign_report`	`date`, `sessionCampaignName`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionCampaignName`	Incrémentiel	`date`
`traffic_acquisition_session_default_channel_grouping_report`	`date`, `sessionDefaultChannelGrouping`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionDefaultChannelGrouping`	Incrémentiel	`date`
`traffic_acquisition_session_source_platform_report`	`date`, `sessionSourcePlatform`	`totalUsers`, `sessions`, `engagedSessions`, `eventsPerSession`, `engagementRate`, `eventCount`, `keyEvents`, `totalRevenue`, `userEngagementDuration`	`property_id`, `date`, `sessionSourcePlatform`	Incrémentiel	`date`

Tables d'engagement

Événements, événements clés, vues de pages et d'écrans, et groupes de contenu.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`events_report`	`date`, `eventName`	`eventCount`, `totalUsers`, `eventCountPerUser`, `totalRevenue`	`property_id`, `date`, `eventName`	Incrémentiel	`date`
`weekly_events_report`	`yearWeek`, `eventName`	`eventCount`, `totalUsers`, `eventCountPerUser`, `totalRevenue`	`property_id`, `yearWeek`, `eventName`	Incrémentiel	`yearWeek`
`conversions_report`	`date`, `eventName`	`keyEvents`, `totalUsers`, `totalRevenue`	`property_id`, `date`, `eventName`	Incrémentiel	`date`
`pages_title_and_screen_class_report`	`date`, `unifiedScreenClass`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `unifiedScreenClass`	Incrémentiel	`date`
`pages_path_report`	`date`, `pagePath`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `pagePath`	Incrémentiel	`date`
`pages_title_and_screen_name_report`	`date`, `unifiedScreenName`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `unifiedScreenName`	Incrémentiel	`date`
`content_group_report`	`date`, `contentGroup`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `contentGroup`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`events_report`	`date`, `eventName`	`eventCount`, `totalUsers`, `eventCountPerUser`, `totalRevenue`	`property_id`, `date`, `eventName`	Incrémentiel	`date`
`weekly_events_report`	`yearWeek`, `eventName`	`eventCount`, `totalUsers`, `eventCountPerUser`, `totalRevenue`	`property_id`, `yearWeek`, `eventName`	Incrémentiel	`yearWeek`
`conversions_report`	`date`, `eventName`	`keyEvents`, `totalUsers`, `totalRevenue`	`property_id`, `date`, `eventName`	Incrémentiel	`date`
`pages_title_and_screen_class_report`	`date`, `unifiedScreenClass`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `unifiedScreenClass`	Incrémentiel	`date`
`pages_path_report`	`date`, `pagePath`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `pagePath`	Incrémentiel	`date`
`pages_title_and_screen_name_report`	`date`, `unifiedScreenName`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `unifiedScreenName`	Incrémentiel	`date`
`content_group_report`	`date`, `contentGroup`	`screenPageViews`; `totalUsers`; `newUsers`; `eventCount`; `keyEvents`; `totalRevenue`; `userEngagementDuration`	`property_id`, `date`, `contentGroup`	Incrémentiel	`date`

Tables de monétisation

Achats d’articles de e-commerce et performance publicitaire de l’éditeur.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`ecommerce_purchases_item_name_report`	`date`, `itemName`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemName`	Incrémentiel	`date`
`ecommerce_purchases_item_id_report`	`date`, `itemId`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemId`	Incrémentiel	`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`	Incrémentiel	`date`
`ecommerce_purchases_item_category_report`	`date`, `itemCategory`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory`	Incrémentiel	`date`
`ecommerce_purchases_item_category_2_report`	`date`, `itemCategory2`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory2`	Incrémentiel	`date`
`ecommerce_purchases_item_category_3_report`	`date`, `itemCategory3`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory3`	Incrémentiel	`date`
`ecommerce_purchases_item_category_4_report`	`date`, `itemCategory4`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory4`	Incrémentiel	`date`
`ecommerce_purchases_item_category_5_report`	`date`, `itemCategory5`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory5`	Incrémentiel	`date`
`ecommerce_purchases_item_brand_report`	`date`, `itemBrand`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemBrand`	Incrémentiel	`date`
`publisher_ads_ad_unit_report`	`date`, `adUnitName`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `adUnitName`	Incrémentiel	`date`
`publisher_ads_page_path_report`	`date`, `pagePath`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `pagePath`	Incrémentiel	`date`
`publisher_ads_ad_format_report`	`date`, `adFormat`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `adFormat`	Incrémentiel	`date`
`publisher_ads_ad_source_report`	`date`, `adSourceName`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `adSourceName`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`ecommerce_purchases_item_name_report`	`date`, `itemName`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemName`	Incrémentiel	`date`
`ecommerce_purchases_item_id_report`	`date`, `itemId`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemId`	Incrémentiel	`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`	Incrémentiel	`date`
`ecommerce_purchases_item_category_report`	`date`, `itemCategory`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory`	Incrémentiel	`date`
`ecommerce_purchases_item_category_2_report`	`date`, `itemCategory2`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory2`	Incrémentiel	`date`
`ecommerce_purchases_item_category_3_report`	`date`, `itemCategory3`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory3`	Incrémentiel	`date`
`ecommerce_purchases_item_category_4_report`	`date`, `itemCategory4`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory4`	Incrémentiel	`date`
`ecommerce_purchases_item_category_5_report`	`date`, `itemCategory5`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemCategory5`	Incrémentiel	`date`
`ecommerce_purchases_item_brand_report`	`date`, `itemBrand`	`cartToViewRate`, `purchaseToViewRate`, `itemsPurchased`, `itemRevenue`, `itemsAddedToCart`, `itemsViewed`	`property_id`, `date`, `itemBrand`	Incrémentiel	`date`
`publisher_ads_ad_unit_report`	`date`, `adUnitName`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `adUnitName`	Incrémentiel	`date`
`publisher_ads_page_path_report`	`date`, `pagePath`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `pagePath`	Incrémentiel	`date`
`publisher_ads_ad_format_report`	`date`, `adFormat`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `adFormat`	Incrémentiel	`date`
`publisher_ads_ad_source_report`	`date`, `adSourceName`	`publisherAdImpressions`, `adUnitExposure`, `publisherAdClicks`, `totalAdRevenue`	`property_id`, `date`, `adSourceName`	Incrémentiel	`date`

Tables de données démographiques

Utilisateurs ventilés par lieu, langue, âge, genre et intérêts.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`demographic_country_report`	`date`, `country`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `country`	Incrémentiel	`date`
`demographic_region_report`	`date`, `region`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `region`	Incrémentiel	`date`
`demographic_city_report`	`date`, `city`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `city`	Incrémentiel	`date`
`demographic_language_report`	`date`, `language`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `language`	Incrémentiel	`date`
`demographic_age_report`	`date`, `userAgeBracket`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `userAgeBracket`	Incrémentiel	`date`
`demographic_gender_report`	`date`, `userGender`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `userGender`	Incrémentiel	`date`
`demographic_interest_report`	`date`, `brandingInterest`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `brandingInterest`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`demographic_country_report`	`date`, `country`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `country`	Incrémentiel	`date`
`demographic_region_report`	`date`, `region`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `region`	Incrémentiel	`date`
`demographic_city_report`	`date`, `city`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `city`	Incrémentiel	`date`
`demographic_language_report`	`date`, `language`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `language`	Incrémentiel	`date`
`demographic_age_report`	`date`, `userAgeBracket`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `userAgeBracket`	Incrémentiel	`date`
`demographic_gender_report`	`date`, `userGender`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `userGender`	Incrémentiel	`date`
`demographic_interest_report`	`date`, `brandingInterest`	`totalUsers`, `newUsers`, `engagedSessions`, `engagementRate`, `keyEvents`, `totalRevenue`	`property_id`, `date`, `brandingInterest`	Incrémentiel	`date`

Tables Tech

Utilisateurs répartis par navigateur, appareil, plateforme, système d’exploitation, version d’application et résolution d’écran.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`tech_browser_report`	`date`, `browser`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `browser`	Incrémentiel	`date`
`tech_device_category_report`	`date`, `deviceCategory`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `deviceCategory`	Incrémentiel	`date`
`tech_device_model_report`	`date`, `deviceModel`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `deviceModel`	Incrémentiel	`date`
`tech_screen_resolution_report`	`date`, `screenResolution`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `screenResolution`	Incrémentiel	`date`
`tech_app_version_report`	`date`, `appVersion`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `appVersion`	Incrémentiel	`date`
`tech_platform_report`	`date`, `platform`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `platform`	Incrémentiel	`date`
`tech_platform_device_category_report`	`date`, `platform`, `deviceCategory`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `platform`, `deviceCategory`	Incrémentiel	`date`
`tech_operating_system_report`	`date`, `operatingSystem`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `operatingSystem`	Incrémentiel	`date`
`tech_os_with_version_report`	`date`, `operatingSystemWithVersion`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `operatingSystemWithVersion`	Incrémentiel	`date`
`tech_os_version_report`	`date`, `operatingSystemVersion`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `operatingSystemVersion`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`tech_browser_report`	`date`, `browser`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `browser`	Incrémentiel	`date`
`tech_device_category_report`	`date`, `deviceCategory`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `deviceCategory`	Incrémentiel	`date`
`tech_device_model_report`	`date`, `deviceModel`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `deviceModel`	Incrémentiel	`date`
`tech_screen_resolution_report`	`date`, `screenResolution`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `screenResolution`	Incrémentiel	`date`
`tech_app_version_report`	`date`, `appVersion`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `appVersion`	Incrémentiel	`date`
`tech_platform_report`	`date`, `platform`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `platform`	Incrémentiel	`date`
`tech_platform_device_category_report`	`date`, `platform`, `deviceCategory`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `platform`, `deviceCategory`	Incrémentiel	`date`
`tech_operating_system_report`	`date`, `operatingSystem`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `operatingSystem`	Incrémentiel	`date`
`tech_os_with_version_report`	`date`, `operatingSystemWithVersion`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `operatingSystemWithVersion`	Incrémentiel	`date`
`tech_os_version_report`	`date`, `operatingSystemVersion`	`totalUsers`; `newUsers`; `engagedSessions`; `engagementRate`; `eventCount`; `keyEvents`; `totalRevenue`	`property_id`, `date`, `operatingSystemVersion`	Incrémentiel	`date`

Tables des audiences

Utilisateurs et sessions répartis par audience.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`audiences_report`	`date`, `audienceName`	`activeUsers`, `averageSessionDuration`, `newUsers`, `screenPageViewsPerSession`, `sessions`, `totalRevenue`	`property_id`, `date`, `audienceName`	Incrémentiel	`date`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`audiences_report`	`date`, `audienceName`	`activeUsers`, `averageSessionDuration`, `newUsers`, `screenPageViewsPerSession`, `sessions`, `totalRevenue`	`property_id`, `date`, `audienceName`	Incrémentiel	`date`

Table de rapport personnalisée

La table custom_report exécute un rapport avec les dimensions et les mesures que vous spécifiez dans ses options de connecteur. Consultez les rapports personnalisés.

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`custom_report`	Les valeurs de `dimensions`, plus `cursor_dimension`	Les valeurs de `metrics`	`property_id`, plus les valeurs de `dimensions` et `cursor_dimension`	Incrémentiel	La valeur de `cursor_dimension`

Table source	Dimensions	Métriques	Clé primaire	Mode de synchronisation	Champ de curseur
`custom_report`	Les valeurs de `dimensions`, plus `cursor_dimension`	Les valeurs de `metrics`	`property_id`, plus les valeurs de `dimensions` et `cursor_dimension`	Incrémentiel	La valeur de `cursor_dimension`

Options du connecteur

Définissez ces options dans votre définition de pipeline. Voir exemples.

Option	Type	Périmètre	Obligatoire	S'applique à	Description
`start_date`	Chaîne	Pipeline	Non	Toutes les tables	Date la plus ancienne à partir de laquelle ingérer des données, au format `yyyy-MM-dd`. 60 jours avant la première synchronisation default.
`property_ids`	Tableau de chaînes	Table	Oui	Toutes les tables sauf `custom_report`	Les ID numériques des propriétés GA4 à ingérer, par exemple `'["123456789"]'`. Le connecteur ingère la table une seule fois pour chaque propriété et écrit l'ID de la propriété dans la colonne `property_id`.
`lookback_window_in_days`	Entier	Table	Non	Toutes les tables	Nombre de jours précédant la dernière valeur de curseur synchronisée que chaque synchronisation incrémentielle demande à nouveau. La valeur default est `12`.
`property_id`	Chaîne	Table	Oui	`custom_report` uniquement	Identifiant numérique de la propriété GA4 à exécuter par rapport au rapport personnalisé.
`dimensions`	Tableau de chaînes	Table	Oui	`custom_report` uniquement	Les noms d’API des dimensions GA4 pour regrouper le rapport, par exemple `'["country", "deviceCategory"]'`.
`metrics`	Tableau de chaînes	Table	Oui	`custom_report` uniquement	Les noms d’API des métriques GA4 à inclure dans le rapport, par exemple `'["sessions", "totalUsers"]'`.
`cursor_dimension`	Chaîne	Table	Oui	`custom_report` uniquement	Dimension de date qui définit le niveau d’agrégation du rapport et pilote les synchronisations incrémentielles. L’un de `date`, `yearWeek`, `yearMonth` ou `year`. Voir Niveau d’agrégation.

Option	Type	Périmètre	Obligatoire	S'applique à	Description
`start_date`	Chaîne	Pipeline	Non	Toutes les tables	Date la plus ancienne à partir de laquelle ingérer des données, au format `yyyy-MM-dd`. 60 jours avant la première synchronisation default.
`property_ids`	Tableau de chaînes	Table	Oui	Toutes les tables sauf `custom_report`	Les ID numériques des propriétés GA4 à ingérer, par exemple `'["123456789"]'`. Le connecteur ingère la table une seule fois pour chaque propriété et écrit l'ID de la propriété dans la colonne `property_id`.
`lookback_window_in_days`	Entier	Table	Non	Toutes les tables	Nombre de jours précédant la dernière valeur de curseur synchronisée que chaque synchronisation incrémentielle demande à nouveau. La valeur default est `12`.
`property_id`	Chaîne	Table	Oui	`custom_report` uniquement	Identifiant numérique de la propriété GA4 à exécuter par rapport au rapport personnalisé.
`dimensions`	Tableau de chaînes	Table	Oui	`custom_report` uniquement	Les noms d’API des dimensions GA4 pour regrouper le rapport, par exemple `'["country", "deviceCategory"]'`.
`metrics`	Tableau de chaînes	Table	Oui	`custom_report` uniquement	Les noms d’API des métriques GA4 à inclure dans le rapport, par exemple `'["sessions", "totalUsers"]'`.
`cursor_dimension`	Chaîne	Table	Oui	`custom_report` uniquement	Dimension de date qui définit le niveau d’agrégation du rapport et pilote les synchronisations incrémentielles. L’un de `date`, `yearWeek`, `yearMonth` ou `year`. Voir Niveau d’agrégation.

Pour trouver un identifiant de propriété, consultez Identifiant de propriété dans la documentation de Google.

Rapports personnalisés

Utilisez la table custom_report pour ingérer une combinaison de dimensions et de métriques que les tables préconstruites ne couvrent pas. Chaque objet custom_report dans un pipeline exécute un rapport par rapport à une propriété GA4.

Le connecteur demande les dimensions dans dimensions, ainsi que la dimension dans cursor_dimension si dimensions ne l’inclut pas déjà. Utilisez les noms d’API listés dans Dimensions et métriques de l’API, notamment les dimensions personnalisées et les métriques définies sur la propriété. Les dimensions et les métriques doivent être compatibles entre elles dans GA4. Pour vérifier une combinaison, consultez la Méthode : properties.checkCompatibility dans la documentation Google.

Pour ingérer plus d’un rapport personnalisé, ajoutez un objet custom_report pour chaque rapport, chacun avec un destination_table différent. Voir Ingérer un rapport personnalisé.

Niveau d’agrégation

L'option cursor_dimension définit la période sur laquelle le rapport personnalisé agrège les métriques. Il définit également le champ de curseur pour les synchronisations incrémentielles.

`cursor_dimension`	Niveau d'agrégation	Exemple de valeur
`date`	jour	`20260115`
`yearWeek`	Semaine GA4	`202603`
`yearMonth`	Mois civil	`202601`
`year`	Année civile	`2026`

Pour l'agrégation par semaine, mois et année, chaque demande couvre des périodes entières. Le connecteur demande à nouveau la période actuelle incomplète lors des synchronisations ultérieures, de sorte que ses métriques sont mises à jour après la fin de la période. Pour la définition de chaque dimension, consultez les Dimensions et métriques de l’API.

Schémas de table de destination

Chaque table de destination comprend les colonnes suivantes que le connecteur ajoute :

property_id (STRING) : ID de la propriété GA4 dont provient la ligne.
ingestion_timestamp (TIMESTAMP) : heure à laquelle le connecteur a ingéré la ligne.

Les valeurs de dimension dans les colonnes date utilisent le format YYYYMMDD, et les valeurs de dimension dans les colonnes yearWeek utilisent le format YYYYWW. Le connecteur demande des lignes dont les métriques sont toutes égales à zéro, ces lignes apparaissent donc aussi dans les tables de destination.

`daily_active_users`

Dimensions : date

Métriques : active1DayUsers

Clé principale : property_id, date

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`active1DayUsers`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

`weekly_active_users`

Dimensions : date

Métriques : active7DayUsers

Clé principale : property_id, date

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`active7DayUsers`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

`four_weekly_active_users`

Dimensions : date

Métriques : active28DayUsers

Clé principale : property_id, date

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`active28DayUsers`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

`website_overview`

Dimensions : date

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

Clé principale : property_id, date

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`sessions`	`BIGINT`
`sessionsPerUser`	`DOUBLE`
`averageSessionDuration`	`DOUBLE`
`screenPageViews`	`BIGINT`
`screenPageViewsPerSession`	`DOUBLE`
`bounceRate`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, deviceCategory, operatingSystem, browser

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, region, country, city, date

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

Métriques : screenPageViews, bounceRate

Clé principale : property_id, date, hostName, pagePathPlusQueryString

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`hostName`	`STRING`
`pagePathPlusQueryString`	`STRING`
`screenPageViews`	`BIGINT`
`bounceRate`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

`traffic_sources`

Dimensions : date, sessionSource, sessionMedium

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

Clé principale : property_id, date, sessionSource, sessionMedium

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserMedium

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserSource

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserSource, firstUserMedium

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserSourcePlatform

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserCampaignName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserGoogleAdsAdNetworkType

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, firstUserGoogleAdsAdGroupName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, sessionSource, sessionMedium

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, sessionMedium

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, sessionSource

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, sessionCampaignName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, sessionDefaultChannelGrouping

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, sessionSourcePlatform

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

Métriques : eventCount, totalUsers, eventCountPerUser, totalRevenue

Clé principale : property_id, date, eventName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`eventName`	`STRING`
`eventCount`	`BIGINT`
`totalUsers`	`BIGINT`
`eventCountPerUser`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

`weekly_events_report`

Dimensions : yearWeek, eventName

Métriques : eventCount, totalUsers, eventCountPerUser, totalRevenue

Clé principale : property_id, yearWeek, eventName

Mode de synchronisation : Incrémentiel

Champ du curseur : yearWeek

Champ	Type de données
`property_id`	`STRING`
`yearWeek`	`STRING`
`eventName`	`STRING`
`eventCount`	`BIGINT`
`totalUsers`	`BIGINT`
`eventCountPerUser`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

`conversions_report`

Dimensions : date, eventName

Métriques : keyEvents, totalUsers, totalRevenue

Clé principale : property_id, date, eventName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

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

Clé principale : property_id, date, unifiedScreenClass

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`unifiedScreenClass`	`STRING`
`screenPageViews`	`BIGINT`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`userEngagementDuration`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, pagePath

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`pagePath`	`STRING`
`screenPageViews`	`BIGINT`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`userEngagementDuration`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, unifiedScreenName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`unifiedScreenName`	`STRING`
`screenPageViews`	`BIGINT`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`userEngagementDuration`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, contentGroup

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`contentGroup`	`STRING`
`screenPageViews`	`BIGINT`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`userEngagementDuration`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemName`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemId

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemId`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé primaire : property_id, date, itemCategory, itemCategory2, itemCategory3, itemCategory4, itemCategory5

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemCategory

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemCategory`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemCategory2

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemCategory2`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemCategory3

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemCategory3`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemCategory4

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemCategory4`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemCategory5

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemCategory5`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, itemBrand

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`itemBrand`	`STRING`
`cartToViewRate`	`DOUBLE`
`purchaseToViewRate`	`DOUBLE`
`itemsPurchased`	`BIGINT`
`itemRevenue`	`DOUBLE`
`itemsAddedToCart`	`BIGINT`
`itemsViewed`	`BIGINT`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

Métriques : publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Clé principale : property_id, date, adUnitName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

Métriques : publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Clé principale : property_id, date, pagePath

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

Métriques : publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Clé principale : property_id, date, adFormat

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

Métriques : publisherAdImpressions, adUnitExposure, publisherAdClicks, totalAdRevenue

Clé principale : property_id, date, adSourceName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`adSourceName`	`STRING`
`publisherAdImpressions`	`BIGINT`
`adUnitExposure`	`DOUBLE`
`publisherAdClicks`	`BIGINT`
`totalAdRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

`demographic_country_report`

Dimensions : date, country

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

Clé principale : property_id, date, country

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

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

Clé principale : property_id, date, region

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

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

Clé principale : property_id, date, city

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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

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

Clé principale : property_id, date, language

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`language`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, userAgeBracket

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`userAgeBracket`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, userGender

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`userGender`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, brandingInterest

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`brandingInterest`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, browser

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`browser`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, deviceCategory

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`deviceCategory`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, deviceModel

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`deviceModel`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, screenResolution

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`screenResolution`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, appVersion

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`appVersion`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, platform

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`platform`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, platform, deviceCategory

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`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`

Champ	Type de données
`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

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

Clé principale : property_id, date, operatingSystem

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`operatingSystem`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, operatingSystemWithVersion

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`operatingSystemWithVersion`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, operatingSystemVersion

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`operatingSystemVersion`	`STRING`
`totalUsers`	`BIGINT`
`newUsers`	`BIGINT`
`engagedSessions`	`BIGINT`
`engagementRate`	`DOUBLE`
`eventCount`	`BIGINT`
`keyEvents`	`DOUBLE`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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

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

Clé principale : property_id, date, audienceName

Mode de synchronisation : Incrémentiel

Champ du curseur : date

Champ	Type de données
`property_id`	`STRING`
`date`	`STRING`
`audienceName`	`STRING`
`activeUsers`	`BIGINT`
`averageSessionDuration`	`DOUBLE`
`newUsers`	`BIGINT`
`screenPageViewsPerSession`	`DOUBLE`
`sessions`	`BIGINT`
`totalRevenue`	`DOUBLE`
`ingestion_timestamp`	`TIMESTAMP`

Champ	Type de données
`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 : les valeurs de dimensions, plus cursor_dimension

Métriques : les valeurs de metrics

Clé principale : property_id, plus les valeurs de dimensions et cursor_dimension

Mode de synchronisation : Incrémentiel

Champ de curseur : La valeur de cursor_dimension

Le connecteur génère le schéma de custom_report à partir des métadonnées de la propriété. Chaque dimension est une colonne STRING. Chaque colonne de métrique tire son type de données du type GA4 de la métrique :

Type de métrique GA4	Type de données
`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`

Type de métrique GA4	Type de données
`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`

La table inclut également les colonnes property_id et ingestion_timestamp.

Permissions OAuth nécessaires

Le connecteur Agrégé de Google analytique demande l'étendue https://www.googleapis.com/auth/analytics.readonly, qui accorde un accès en lecture seule aux données Google analytique. L'identité authentifiée doit également disposer au moins du rôle Lecteur sur chaque propriété. Voir Configurer l’authentification à Google analytique.

Autorisation	Requis pour
`https://www.googleapis.com/auth/analytics.readonly`	Toutes les tables

Sur cette page

Tables sources prises en charge
Tables d’activité des utilisateurs
Tables de rapports principales
Tables d'acquisition d'utilisateurs
Tables d'acquisition de trafic
Tables d'engagement
Tables de monétisation
Tables de données démographiques
Tables Tech
Tables des audiences
Table de rapport personnalisée
Options du connecteur
Rapports personnalisés
- Niveau d’agrégation
Schémas de table de destination
Permissions OAuth nécessaires

Tables sources prises en charge​

Tables d’activité des utilisateurs​

Tables de rapports principales​

Tables d'acquisition d'utilisateurs​

Tables d'acquisition de trafic​

Tables d'engagement​

Tables de monétisation​

Tables de données démographiques​

Tables Tech​

Tables des audiences​

Table de rapport personnalisée​

Options du connecteur​

Rapports personnalisés​

Niveau d’agrégation​

Schémas de table de destination​

daily_active_users​

weekly_active_users​

four_weekly_active_users​

website_overview​

devices​

locations​

pages​

traffic_sources​

user_acquisition_first_user_medium_report​

user_acquisition_first_user_source_report​

user_acquisition_first_user_source_medium_report​

user_acquisition_first_user_source_platform_report​

user_acquisition_first_user_campaign_report​

user_acquisition_first_user_google_ads_ad_network_type_report​

user_acquisition_first_user_google_ads_ad_group_name_report​

traffic_acquisition_session_source_medium_report​

traffic_acquisition_session_medium_report​

traffic_acquisition_session_source_report​

traffic_acquisition_session_campaign_report​

traffic_acquisition_session_default_channel_grouping_report​

traffic_acquisition_session_source_platform_report​

events_report​

weekly_events_report​

conversions_report​

pages_title_and_screen_class_report​

pages_path_report​

pages_title_and_screen_name_report​

content_group_report​

ecommerce_purchases_item_name_report​

ecommerce_purchases_item_id_report​

ecommerce_purchases_item_category_report_combined​

ecommerce_purchases_item_category_report​

ecommerce_purchases_item_category_2_report​

ecommerce_purchases_item_category_3_report​

ecommerce_purchases_item_category_4_report​

ecommerce_purchases_item_category_5_report​

ecommerce_purchases_item_brand_report​

publisher_ads_ad_unit_report​

publisher_ads_page_path_report​

publisher_ads_ad_format_report​

publisher_ads_ad_source_report​

demographic_country_report​

demographic_region_report​

demographic_city_report​

demographic_language_report​

demographic_age_report​

demographic_gender_report​

demographic_interest_report​

tech_browser_report​

tech_device_category_report​

tech_device_model_report​

tech_screen_resolution_report​

tech_app_version_report​

tech_platform_report​

tech_platform_device_category_report​

tech_operating_system_report​

tech_os_with_version_report​

tech_os_version_report​

audiences_report​

custom_report​

Permissions OAuth nécessaires​

Tables sources prises en charge

Tables d’activité des utilisateurs

Tables de rapports principales

Tables d'acquisition d'utilisateurs

Tables d'acquisition de trafic

Tables d'engagement

Tables de monétisation

Tables de données démographiques

Tables Tech

Tables des audiences

Table de rapport personnalisée

Options du connecteur

Rapports personnalisés

Niveau d’agrégation

Schémas de table de destination

`daily_active_users`

`weekly_active_users`

`four_weekly_active_users`

`website_overview`

`devices`

`locations`

`pages`

`traffic_sources`

`user_acquisition_first_user_medium_report`

`user_acquisition_first_user_source_report`

`user_acquisition_first_user_source_medium_report`

`user_acquisition_first_user_source_platform_report`

`user_acquisition_first_user_campaign_report`

`user_acquisition_first_user_google_ads_ad_network_type_report`

`user_acquisition_first_user_google_ads_ad_group_name_report`

`traffic_acquisition_session_source_medium_report`

`traffic_acquisition_session_medium_report`

`traffic_acquisition_session_source_report`

`traffic_acquisition_session_campaign_report`

`traffic_acquisition_session_default_channel_grouping_report`

`traffic_acquisition_session_source_platform_report`

`events_report`

`weekly_events_report`

`conversions_report`

`pages_title_and_screen_class_report`

`pages_path_report`

`pages_title_and_screen_name_report`

`content_group_report`

`ecommerce_purchases_item_name_report`

`ecommerce_purchases_item_id_report`

`ecommerce_purchases_item_category_report_combined`

`ecommerce_purchases_item_category_report`

`ecommerce_purchases_item_category_2_report`

`ecommerce_purchases_item_category_3_report`

`ecommerce_purchases_item_category_4_report`

`ecommerce_purchases_item_category_5_report`

`ecommerce_purchases_item_brand_report`

`publisher_ads_ad_unit_report`

`publisher_ads_page_path_report`

`publisher_ads_ad_format_report`

`publisher_ads_ad_source_report`

`demographic_country_report`

`demographic_region_report`

`demographic_city_report`

`demographic_language_report`

`demographic_age_report`

`demographic_gender_report`

`demographic_interest_report`

`tech_browser_report`

`tech_device_category_report`

`tech_device_model_report`

`tech_screen_resolution_report`

`tech_app_version_report`

`tech_platform_report`

`tech_platform_device_category_report`

`tech_operating_system_report`

`tech_os_with_version_report`

`tech_os_version_report`

`audiences_report`

`custom_report`

Permissions OAuth nécessaires