{"id":16082,"date":"2024-09-09T09:35:44","date_gmt":"2024-09-09T09:35:44","guid":{"rendered":"https:\/\/datama.io\/?p=16082"},"modified":"2025-03-03T09:36:04","modified_gmt":"2025-03-03T09:36:04","slug":"differences-mise-a-jour-ga4-bigquery","status":"publish","type":"post","link":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/","title":{"rendered":"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Si vous collectez des donn\u00e9es dans GA4<\/strong>, vous utilisez certainement des exports<\/strong> vers BigQuery<\/strong>.

Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu’\u00e0 un moment donn\u00e9, les donn\u00e9es n’\u00e9taient pas exactement les m\u00eames entre les 2 outils.

Chez Datama, nous avons mis en place un sc\u00e9nario pour l’un de nos clients (appel\u00e9 Client A) :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Les donn\u00e9es GA4 sont requ\u00eat\u00e9es dans BigQuery puis connect\u00e9es \u00e0 notre outil Datama Detect, qui d\u00e9clenche automatiquement un email d’anomalie<\/strong> si les donn\u00e9es sont incompl\u00e8tes.<\/p>\n

Depuis quelques semaines, nous avons commenc\u00e9 \u00e0 recevoir ces emails de d\u00e9tection de plus en plus fr\u00e9quemment.<\/p>\n

Apr\u00e8s une premi\u00e8re analyse, nous avons remarqu\u00e9 une divergence<\/strong> entre les tables partitionn\u00e9es et les \u00e9v\u00e9nements intraday & interday.<\/strong><\/p>\n

Nous avons pr\u00e9c\u00e9demment mis en place une requ\u00eate programm\u00e9e (via BigQuery) pour r\u00e9cup\u00e9rer les donn\u00e9es GA4 \u00e0 une heure fixe. Le r\u00e9sultat est une table partitionn\u00e9e en jours.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Rappel: Intraday vs. Interday<\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Notre cas client<\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

En th\u00e9orie, les donn\u00e9es de la table intraday sont cens\u00e9es \u00ab passer \u00bb en interday apr\u00e8s un jour.<\/p>\n

Nous avons donc d\u00e9cid\u00e9 de copier les tableaux deux fois par jour (\u00e0 9 heures et \u00e0 18 heures) pendant une semaine afin d’analyser l’\u00e9volution de la compl\u00e9tion des donn\u00e9es.<\/p>\n

Nous avons s\u00e9lectionn\u00e9 4 \u00e9v\u00e9nements :<\/p>\n

    \n
  • Nombre de sessions<\/li>\n
  • Nombre de transactions<\/li>\n
  • Nombre d’Out of stock (\u00e9v\u00e9nement personnalis\u00e9)<\/li>\n
  • Nombre d’itemViews (\u00e9v\u00e9nement personnalis\u00e9)<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Nos constats<\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Tout d’abord, voyons comment les donn\u00e9es sont compl\u00e9t\u00e9es apr\u00e8s la premi\u00e8re copie (jour+1 AM) :<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t
      \n
    • \n

      Alors que nous aurions pu esp\u00e9rer \u00eatre proches de 100% des donn\u00e9es disponibles, ce n’est pas le cas pour la majorit\u00e9 des \u00e9v\u00e9nements (\u00e0 quelques exceptions pr\u00e8s). La plupart des \u00e9v\u00e9nements ont m\u00eame 5 \u00e0 15% de donn\u00e9es manquantes, ce qui n’est pas n\u00e9gligeable.<\/p>\n<\/li>\n

    • \n

      Pour l’\u00e9v\u00e9nement Transactions, les donn\u00e9es sont d\u00e9j\u00e0 disponibles \u00e0 100% pour 3 dates (22.06 au 24.06), avant m\u00eame le passage de l’intraday \u00e0 l’interday.<\/p>\n<\/li>\n

    • \n

      Les \u00e9v\u00e9nements personnalis\u00e9s (Out of stock, itemViews) ont tendance \u00e0 \u00eatre moins complets \u00e0 des dates \u00e9quivalentes.<\/p>\n<\/li>\n<\/ul>\n

      Avons-nous des donn\u00e9es compl\u00e8tes apr\u00e8s 1 jour ?<\/p>\n

      Si l’on examine la deuxi\u00e8me copie (Jour+1 PM), la r\u00e9ponse est oui<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      Analyse compl\u00e9mentaire & enseignements<\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      Comme indiqu\u00e9 ci-dessous, nous recevions de plus en plus d’e-mails de d\u00e9tection d’anomalies indiquant que nos donn\u00e9es \u00e9taient incompl\u00e8tes.<\/p>\n

      Notre premi\u00e8re r\u00e9action a \u00e9t\u00e9 de retarder de quelques heures notre requ\u00eate programm\u00e9e dans BigQuery.<\/p>\n

      Mais maintenant que nous savons que les donn\u00e9es sont enti\u00e8rement disponibles apr\u00e8s une journ\u00e9e enti\u00e8re, nous devons r\u00e9pondre \u00e0 cette question :<\/p>\n

      Pouvons-nous savoir exactement quand notre table a \u00e9t\u00e9 cr\u00e9\u00e9e dans BigQuery ?<\/strong><\/p>\n

      En fait, cette simple requ\u00eate fournit cette information :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

      \n\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\n\t\t\t\t\tSELECT\r\n  table_name,\r\n  creation_time,\r\n  CAST(creation_time AS DATETIME) AS creation_time\r\nFROM\r\n  `nameofyourdataset.analytics_xxxx.INFORMATION_SCHEMA.TABLES`-- change name of dataset to your own\r\nWHERE\r\n  table_name BETWEEN 'events_202402%' AND 'events_202408%'-- change period to what you need\r\n  AND table_name NOT LIKE '%intraday%'\r\nORDER BY\r\n  table_name ASC;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d50f3a3 elementor-widget elementor-widget-text-editor\" data-id=\"d50f3a3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Nous avons appliqu\u00e9 cette requ\u00eate \u00e0 notre cas et voici ce que nous avons appris :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55b97c5 elementor-widget elementor-widget-image\" data-id=\"55b97c5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"385\" src=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-1024x493.png\" class=\"attachment-large size-large wp-image-16053\" alt=\"\" srcset=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-1024x493.png 1024w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-300x144.png 300w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-768x370.png 768w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-1536x739.png 1536w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation.png 1600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db0d214 elementor-widget elementor-widget-text-editor\" data-id=\"db0d214\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Entre mai et juin, les tables ont commenc\u00e9 \u00e0 \u00eatre cr\u00e9\u00e9es de plus en plus tard. En cons\u00e9quence, notre requ\u00eate programm\u00e9e a commenc\u00e9 \u00e0 interroger les donn\u00e9es \u00ab trop t\u00f4t \u00bb, d\u00e9clenchant des courriels d&rsquo;anomalie.\u00a0<\/p>\n<p>\u00c0 la mi-juillet, nous avons modifi\u00e9 l&rsquo;heure d&rsquo;interrogation de 09h00 \u00e0 12h00, ce qui n&rsquo;a r\u00e9solu que partiellement le probl\u00e8me.\u00a0<\/p>\n<p>En fait, nous pouvons voir ici, par exemple, que le fait de d\u00e9placer la requ\u00eate \u00e0 18 heures nous permettrait d&rsquo;avoir les donn\u00e9es interday compl\u00e9t\u00e9es dans tous les cas.<\/p>\n<p>Pour s&rsquo;assurer qu&rsquo;il ne s&rsquo;agissait pas d&rsquo;un cas isol\u00e9 pour un seul client, nous avons \u00e9tendu la recherche \u00e0 5 autres clients, tous disposant d&rsquo;un compte GA4 360 (contrairement au client A qui dispose d&rsquo;un compte gratuit).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-39f924c elementor-widget elementor-widget-image\" data-id=\"39f924c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"385\" src=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients-1024x493.png\" class=\"attachment-large size-large wp-image-16055\" alt=\"\" srcset=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients-1024x493.png 1024w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients-300x144.png 300w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients-768x370.png 768w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients-1536x739.png 1536w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients.png 1600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee7b9e5 elementor-widget elementor-widget-text-editor\" data-id=\"ee7b9e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Nous pouvons constater que la tendance g\u00e9n\u00e9rale est globalement la m\u00eame.<\/p>\n<p>L&rsquo;heure de la cr\u00e9ation a \u00e9t\u00e9 de plus en plus tardive au cours des trois derniers mois (vers 9 heures du matin en moyenne il y a six mois, aujourd&rsquo;hui apr\u00e8s 10 heures).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95f38ce elementor-widget elementor-widget-image\" data-id=\"95f38ce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"353\" src=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/creation-time-distribution-cumulated-1024x452.png\" class=\"attachment-large size-large wp-image-16057\" alt=\"\" srcset=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/creation-time-distribution-cumulated-1024x452.png 1024w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/creation-time-distribution-cumulated-300x132.png 300w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/creation-time-distribution-cumulated-768x339.png 768w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/creation-time-distribution-cumulated-1536x678.png 1536w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/creation-time-distribution-cumulated.png 1600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a60c722 elementor-widget elementor-widget-text-editor\" data-id=\"a60c722\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>En outre, si l&rsquo;on examine la r\u00e9partition des heures, on constate que :<\/p>\n<ul>\n<li>La plage horaire varie de 3 heures du matin \u00e0 6 heures du soir ! Cela montre \u00e0 quel point GA4 peut \u00eatre impr\u00e9visible.<\/li>\n<li>+Plus de 70 % des tables sont cr\u00e9\u00e9es entre 6 heures et 10 heures du matin, mais le temps de r\u00e9alisation reste tr\u00e8s variable.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00603e9 elementor-widget elementor-widget-text-editor\" data-id=\"00603e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Pour aller plus loin&#8230;<\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f23595 elementor-widget elementor-widget-text-editor\" data-id=\"1f23595\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il convient de noter que ces recherches ont \u00e9t\u00e9 men\u00e9es avec un compte BigQuery gratuit, et que les r\u00e9sultats peuvent diff\u00e9rer avec un compte Premium.\u00a0<\/p>\n<p>Par ailleurs, depuis le 24 avril, GA4 360 prend d\u00e9sormais en charge l&rsquo;exportation BigQuery \u00ab <strong>Fresh daily<\/strong> \u00bb, qui permet aux entreprises de recevoir des mises \u00e0 jour p\u00e9riodiques par lots de l&rsquo;ensemble des donn\u00e9es, termin\u00e9es \u00e0 une heure garantie chaque jour.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-31c6bd3 e-flex e-con-boxed e-con e-parent\" data-id=\"31c6bd3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-27b8904 elementor-widget elementor-widget-image\" data-id=\"27b8904\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"218\" src=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/GA4_fresh_daily.png\" class=\"attachment-large size-large wp-image-16059\" alt=\"\" srcset=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/GA4_fresh_daily.png 708w, https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/GA4_fresh_daily-300x92.png 300w\" sizes=\"(max-width: 708px) 100vw, 708px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1efa655 elementor-widget elementor-widget-text-editor\" data-id=\"1efa655\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Une autre option consiste \u00e9galement \u00e0 d\u00e9clencher un job bas\u00e9 sur la compl\u00e9tion de la table intrady. En d&rsquo;autres termes, il s&rsquo;agit d&rsquo;obtenir les donn\u00e9es de GA4 dans BigQuery d\u00e8s qu&rsquo;elles sont disponibles et que l&rsquo;export est termin\u00e9. C&rsquo;est le principe de Pub-Sub que nous exp\u00e9rimenterons prochainement.\u00a0<\/p>\n<p>Restez connect\u00e9s !<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9ce45c8 e-flex e-con-boxed e-con e-parent\" data-id=\"9ce45c8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu&rsquo;\u00e0 un moment donn\u00e9, les donn\u00e9es n&rsquo;\u00e9taient pas exactement les m\u00eames entre les 2 outils. Chez Datama, nous avons mis en place un sc\u00e9nario pour l&rsquo;un de nos clients (appel\u00e9 Client A) : Les donn\u00e9es [&hellip;]<\/p>\n","protected":false},"author":32,"featured_media":16710,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[139],"tags":[],"class_list":["post-16082","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles-fr"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query - Datama<\/title>\n<meta name=\"description\" content=\"Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu&#039;\u00e0 un moment donn\u00e9, les donn\u00e9es n&#039;\u00e9taient pas exactement les m\u00eames entre les 2 outils. Cet article montre comment les donn\u00e9es \u00e9voluent dans le temps (tables intraday et interday).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query - Datama\" \/>\n<meta property=\"og:description\" content=\"Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu&#039;\u00e0 un moment donn\u00e9, les donn\u00e9es n&#039;\u00e9taient pas exactement les m\u00eames entre les 2 outils. Cet article montre comment les donn\u00e9es \u00e9voluent dans le temps (tables intraday et interday).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\" \/>\n<meta property=\"og:site_name\" content=\"Datama\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-09T09:35:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-03T09:36:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"770\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Cl\u00e9ment Gu\u00e9rin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@datama_solution\" \/>\n<meta name=\"twitter:site\" content=\"@datama_solution\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cl\u00e9ment Gu\u00e9rin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\"},\"author\":{\"name\":\"Cl\u00e9ment Gu\u00e9rin\",\"@id\":\"https:\/\/datama.io\/fr\/#\/schema\/person\/47e25db1d2f94324121b71eff6dea298\"},\"headline\":\"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query\",\"datePublished\":\"2024-09-09T09:35:44+00:00\",\"dateModified\":\"2025-03-03T09:36:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\"},\"wordCount\":886,\"publisher\":{\"@id\":\"https:\/\/datama.io\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png\",\"articleSection\":[\"Articles\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\",\"url\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\",\"name\":\"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query - Datama\",\"isPartOf\":{\"@id\":\"https:\/\/datama.io\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png\",\"datePublished\":\"2024-09-09T09:35:44+00:00\",\"dateModified\":\"2025-03-03T09:36:04+00:00\",\"description\":\"Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu'\u00e0 un moment donn\u00e9, les donn\u00e9es n'\u00e9taient pas exactement les m\u00eames entre les 2 outils. Cet article montre comment les donn\u00e9es \u00e9voluent dans le temps (tables intraday et interday).\",\"breadcrumb\":{\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage\",\"url\":\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png\",\"contentUrl\":\"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png\",\"width\":3440,\"height\":2016},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/datama.io\/fr\/accueil\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datama.io\/fr\/#website\",\"url\":\"https:\/\/datama.io\/fr\/\",\"name\":\"Datama\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/datama.io\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datama.io\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datama.io\/fr\/#organization\",\"name\":\"Datama\",\"url\":\"https:\/\/datama.io\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datama.io\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datama.io\/wp-content\/uploads\/2023\/12\/cropped-Logo-Datama.png\",\"contentUrl\":\"https:\/\/datama.io\/wp-content\/uploads\/2023\/12\/cropped-Logo-Datama.png\",\"width\":400,\"height\":100,\"caption\":\"Datama\"},\"image\":{\"@id\":\"https:\/\/datama.io\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/datama_solution\",\"https:\/\/www.linkedin.com\/company\/datama\/\",\"https:\/\/www.youtube.com\/channel\/UCoxfesECCiubm0XLCXcN3TA\/featured\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datama.io\/fr\/#\/schema\/person\/47e25db1d2f94324121b71eff6dea298\",\"name\":\"Cl\u00e9ment Gu\u00e9rin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query - Datama","description":"Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu'\u00e0 un moment donn\u00e9, les donn\u00e9es n'\u00e9taient pas exactement les m\u00eames entre les 2 outils. Cet article montre comment les donn\u00e9es \u00e9voluent dans le temps (tables intraday et interday).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/","og_locale":"fr_FR","og_type":"article","og_title":"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query - Datama","og_description":"Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu'\u00e0 un moment donn\u00e9, les donn\u00e9es n'\u00e9taient pas exactement les m\u00eames entre les 2 outils. Cet article montre comment les donn\u00e9es \u00e9voluent dans le temps (tables intraday et interday).","og_url":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/","og_site_name":"Datama","article_published_time":"2024-09-09T09:35:44+00:00","article_modified_time":"2025-03-03T09:36:04+00:00","og_image":[{"width":1600,"height":770,"url":"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/interday-time-creation-all-clients.png","type":"image\/png"}],"author":"Cl\u00e9ment Gu\u00e9rin","twitter_card":"summary_large_image","twitter_creator":"@datama_solution","twitter_site":"@datama_solution","twitter_misc":{"\u00c9crit par":"Cl\u00e9ment Gu\u00e9rin","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#article","isPartOf":{"@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/"},"author":{"name":"Cl\u00e9ment Gu\u00e9rin","@id":"https:\/\/datama.io\/fr\/#\/schema\/person\/47e25db1d2f94324121b71eff6dea298"},"headline":"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query","datePublished":"2024-09-09T09:35:44+00:00","dateModified":"2025-03-03T09:36:04+00:00","mainEntityOfPage":{"@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/"},"wordCount":886,"publisher":{"@id":"https:\/\/datama.io\/fr\/#organization"},"image":{"@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png","articleSection":["Articles"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/","url":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/","name":"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query - Datama","isPartOf":{"@id":"https:\/\/datama.io\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage"},"image":{"@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png","datePublished":"2024-09-09T09:35:44+00:00","dateModified":"2025-03-03T09:36:04+00:00","description":"Si vous collectez des donn\u00e9es dans GA4, vous utilisez certainement des exports vers BigQuery. Vous avez donc peut-\u00eatre d\u00e9j\u00e0 remarqu\u00e9 qu'\u00e0 un moment donn\u00e9, les donn\u00e9es n'\u00e9taient pas exactement les m\u00eames entre les 2 outils. Cet article montre comment les donn\u00e9es \u00e9voluent dans le temps (tables intraday et interday).","breadcrumb":{"@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#primaryimage","url":"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png","contentUrl":"https:\/\/datama.io\/wp-content\/uploads\/2024\/09\/Image_Article-Interday.png","width":3440,"height":2016},{"@type":"BreadcrumbList","@id":"https:\/\/datama.io\/fr\/differences-mise-a-jour-ga4-bigquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/datama.io\/fr\/accueil\/"},{"@type":"ListItem","position":2,"name":"Google Analytics 4 : Limitations des donn\u00e9es dans les tables Intraday Big Query"}]},{"@type":"WebSite","@id":"https:\/\/datama.io\/fr\/#website","url":"https:\/\/datama.io\/fr\/","name":"Datama","description":"","publisher":{"@id":"https:\/\/datama.io\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datama.io\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/datama.io\/fr\/#organization","name":"Datama","url":"https:\/\/datama.io\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datama.io\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/datama.io\/wp-content\/uploads\/2023\/12\/cropped-Logo-Datama.png","contentUrl":"https:\/\/datama.io\/wp-content\/uploads\/2023\/12\/cropped-Logo-Datama.png","width":400,"height":100,"caption":"Datama"},"image":{"@id":"https:\/\/datama.io\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/datama_solution","https:\/\/www.linkedin.com\/company\/datama\/","https:\/\/www.youtube.com\/channel\/UCoxfesECCiubm0XLCXcN3TA\/featured"]},{"@type":"Person","@id":"https:\/\/datama.io\/fr\/#\/schema\/person\/47e25db1d2f94324121b71eff6dea298","name":"Cl\u00e9ment Gu\u00e9rin"}]}},"_links":{"self":[{"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/posts\/16082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/comments?post=16082"}],"version-history":[{"count":6,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/posts\/16082\/revisions"}],"predecessor-version":[{"id":16896,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/posts\/16082\/revisions\/16896"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/media\/16710"}],"wp:attachment":[{"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/media?parent=16082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/categories?post=16082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datama.io\/fr\/wp-json\/wp\/v2\/tags?post=16082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}