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

How to transfer all data from Google Analytics 4 to Google BigQuery?

Hello everyone,

 

I have set up and linked my Google Analytics 4 property to Google BigQuery. It does collect data from each day since the start of linking it, but it has not moved any data from before this date over to Google BigQuery. I would like all historical data.

 

Is there a way to do this? Does this happen automatically? Is there a way to manually do this?

Thank you everyone!

Solved Solved
1 2 1,421
1 ACCEPTED SOLUTION

There is an instruction available here: https://www.optimizesmart.com/how-to-backfill-ga4-data-in-bigquery/ Though I have not tested it yet, because it requires billing activation and I am still playing in sandbox.

Another option is third party tools like windsor.ai that can upload historical data but they all are subject to Google API limitations.

View solution in original post

2 REPLIES 2