-
Retrieving Historical GA4 Data for BigQuery Export
Hey there! Hope you’re doing well. We started a neat setup last Wednesday where we send our GA4 data over to BigQuery once a day. It’s been going pretty well so far. However, I’ve noticed something odd. We only have the data starting from last Wednesday, when we put this new system into place. Our project actually launched back in September this year, and we were wondering if there’s a way for us to pull the older data into BigQuery from GA4, even though we weren’t using BigQuery at the time. It’s definitely available in the reports on analytics.google.com, but we just can’t seem to get it over to BigQuery. Any ideas or advice you have on this would be so helpful!
-
2 Replies
-
Ah, I see! It does seem a bit tricky, doesn’t it? There’s one method I know of to backfill previous data, and that is by utilizing a tool called the Supermetrics Analytics connector. It’s available on the GCP Marketplace. As far as I’m aware, there isn’t another way currently to achieve this. Hope this helps!
-
Unfortunately, Google Analytics 4 (GA4) only exports data to BigQuery from the day that you link them together and going forward. This means it’s not possible to retroactively import old data from GA4 to BigQuery that was collected prior to the linking of these two platforms. Despite this, you can still access and analyze the old data directly in GA4. It’s not the ideal situation I know, but it stands true as of Google’s current policy.
Log in to reply.