The Google Analytics 360 (GA360) integration with Google BigQuery produces one partitioned table for each day’s worth of data. Before long, this results in having hundreds of tables in your dataset. Looking through this list, it can be difficult to spot whether a day’s table is missing. A missing table usually indicates that the data transfer from GA360 did not happen or failed. This could be due to a number of reasons:
- Someone temporarily disabled the GA360 to Google BigQuery integration
- The billing account attached to your Google BigQuery project had an expired credit card
- Permissions to the datasets may have been altered
If you would like to check whether all dates within a particular range are accounted for, here is a handy SQL query for you.
It will generate a table with each date starting from one year ago to the current date. It then joins this to the dates extracted from existing GA360 table names. Finally, the missing table names are ordered to appear at the top. Any null values in the ‘ga_name_day’ field refer to calendar dates missing in your dataset.
If you see any null values, it means you have missing daily tables in your dataset. If the missing tables are not from the distant past, you can contact the Google Analytics 360 support team to request a backfill of the missing tables.