Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

GA4 BigQuery Table

I've successfully linked my GA4 360 property with BigQuery, but I'm only seeing a data history of the last 60 days, whereas for my Universal Analytics 360 configuration I have no issue to load a bigger data set/a data set for a longer date period.

Is there a setting I need to adjust?

Schermafbeelding 2021-12-02 141153.png

0 2 596
2 REPLIES 2

Hello,

Data export is free in GA4 so that everyone can use it. You only pay for actual data storage and data querying once you exceed the limits of  use of the Google Cloud free tier [1]. Only after 1 TB of querying per month and 10 GB of storage ,your credit card will be charged.

However, if you are using the  BigQuery sandbox environment without a credit card, there are certain limitations [2], according to which your data tables can expire after 60 days. You can upgrade the sandbox [3] to avoid table expiration and update the table expiration settings so you don't lose any data.

[1] https://cloud.google.com/free

[2] Limitations: https://cloud.google.com/bigquery/docs/sandbox#limits

[3] Upgrade the sandbox: https://cloud.google.com/bigquery/docs/sandbox#upgrading_from_the_sandbox

 

Hi @VincentSaelen 

You can import your data via third party tools. E.g. import your GA 360 data into windsor.ai account and export the GA 360 data into BigQuery.

windsor.ai Google Ads 360.png