Learn business growth with Google Analytics 4 Forums Google Analytics 4 Retrieving Historical GA4 Data for BigQuery Export

  • Retrieving Historical GA4 Data for BigQuery Export

    Posted by Oliver on 7 October 2022 at 9:05 pm

    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!

    James replied 10 months, 3 weeks ago 3 Members · 2 Replies
  • 2 Replies
  • Isabella

    Member
    1 January 2023 at 3:49 am

    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!

  • James

    Member
    30 April 2023 at 9:43 am

    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.