+34649324221 · Today 09:00–14:00 · 15:30–20:00

GA4 BigQuery Backfill: Can You Export Historical Data?

· By the from Analytics teamChat on WhatsApp

The short answer: the export does not go back

No. The GA4 BigQuery export starts on the day you link the property and only sends data from then on. As of October 2026 there is still no option in GA4 to send past events to BigQuery, and Google's help is explicit about the related cases: data that has been exported cannot be re-exported, days missed while the export is paused for going over the limit are not reprocessed, and data from an export interrupted by an invalid payment method cannot be sent again.

So if you linked GA4 to BigQuery in March, your event-level history in BigQuery starts in March. Everything before that exists only inside GA4, in aggregated form, and only for as long as GA4 keeps it.

The only "late" data the export does handle is events that arrive a little after they happen: Google keeps updating each daily table with events that come in up to three days late. That is not a backfill, just a delay.

The GA4 connector in BigQuery Data Transfer Service

There is one official route that does reach into the past, and it is often mistaken for a backfill of the export. The BigQuery Data Transfer Service has a Google Analytics 4 connector. According to the Google Cloud documentation in October 2026:

  • It loads reporting data from the Google Analytics Data API, not events. You get tables such as p_ga4_Events, p_ga4_TrafficAcquisition, p_ga4_LandingPage and p_ga4_PagesAndScreens, with dimensions and metrics already aggregated.
  • It runs daily, with a refresh window of 4 days by default and up to 30.
  • You can run a backfill for earlier dates, as far back as the data retention policy of the source allows.
  • Running the transfer has no cost; normal BigQuery storage and query prices apply.
  • Its limits: totals for distinct users and sessions may not be accurate or match GA4, custom properties are not supported, and a custom report allows one per transfer, with up to 9 dimensions and 10 metrics and no custom dimensions or metrics.
  • It does not work in the BigQuery sandbox, which does not support the Data Transfer Service.

On retention, GA4's own help says its data retention setting affects explorations and funnel reports, not standard aggregated reports. Even so, run a test backfill on your property before promising anyone a start date.

In other words, the connector gives you historical reports in BigQuery. It does not give you historical events: no event_params, no user_pseudo_id and no session IDs to join with your CRM.

Your real options for GA4 historical data

The GA4 connector in Data Transfer Service
Official and free to run. Good for daily trends by channel, page or event since the property started, within the limits above.
The GA4 Data API directly
The same aggregated data, with full control over dimensions and metrics. You write and schedule the code yourself, and the GA4 API quotas apply.
Third-party connectors
ETL tools that load GA4 into BigQuery for a fee. Most read the same Data API, so they bring aggregated reports, not raw events. Check that before paying for one as a backfill.
Downloads from the GA4 interface
CSV or Google Sheets exports of specific reports. Enough for a handful of figures, not for a history.
Universal Analytics
Not an option any more. Google ended access to UA data and its API from the week of 1 July 2024. If you had Analytics 360 with the UA BigQuery export, those tables remain in your own Google Cloud project unless someone deleted them, with a different schema from GA4.

Joining old reports with new events

If you need a continuous history, the practical answer is usually a combination: aggregated tables from the connector or the Data API for the period before the link, and the event export from the link onwards, with a clear date where one ends and the other starts.

Two things to keep in mind:

  • The metrics will not line up perfectly at the join. Users and sessions in GA4 reports are estimates, and the connector documentation itself warns those totals may differ. Use a period where you have both sources to measure the difference, and write it down.
  • Keep the long comparisons at the aggregated level. A year-on-year chart of sessions or key events by channel works across the join. A user-level funnel or a match with CRM leads only works from the day the event export started.

For the event side, see the GA4 export schema and how to count sessions. For comparing channels over time, keep in mind that the connector and the export do not use the same attribution: how attribution models differ.

Why you should turn on the export today

  1. 1
    Link it now
    Even if nobody will query it this quarter. Every day without the export is a day of event-level data you will never have in BigQuery, and linking costs nothing on a standard property.
  2. 2
    Use a project with billing
    In the BigQuery sandbox, tables expire after 60 days, so the history you are trying to build disappears.
  3. 3
    Choose the location carefully
    For example the EU multi-region. Changing it later means deleting the link and recreating the dataset.
  4. 4
    Watch the volume
    Standard properties can export up to 1 million events a day. Stay under it so the export is never paused.
  5. 5
    Extend GA4 retention
    Set event data retention to the longest option your property allows, 14 months on standard properties, so explorations cover the period while the BigQuery history builds up.
  6. 6
    Add the Google Ads transfer
    If you advertise on Google Ads, Google suggests its transfer to look up campaign data for gclids that the export marks as not available.

What it costs to start now

Very little at company-website volumes. BigQuery storage in the EU and US multi-regions costs $0.02 per GiB a month for active data and $0.01 for data not modified in 90 days, with the first 10 GiB each month free, according to the Google Cloud pricing page in October 2026. Google estimates about 600,000 GA4 events per GB, so a site with a few hundred thousand events a month adds well under a gigabyte.

The real cost is queries and the work of turning events into something the business can read. That is what our BigQuery consulting covers, and it is why the daily export limit is worth checking before it becomes a gap.

GA4 BigQuery historical data FAQ

Can I backfill the GA4 BigQuery export?

No. The export only sends events from the day it is linked, and Google does not re-export data or reprocess days missed during a pause.

Is the GA4 connector in Data Transfer Service a backfill of the export?

No. It loads aggregated report data from the GA4 Data API into BigQuery and can backfill earlier dates, but it has no raw events or event parameters.

How far back can I get GA4 report data?

According to the connector documentation, as far back as the source's data retention allows. GA4 says its retention setting does not affect standard aggregated reports, but test it on your property first.

Can I still get Universal Analytics data?

Not from Google. Access to UA data and its API ended from the week of 1 July 2024. Only data you exported before then, to BigQuery or to files, is still available.

If I link GA4 today, when will I see data?

Google says data should start arriving within 24 hours, with each daily table holding the previous day.

GA4 BigQuery exportGA4 export limitExport schema and SQLLooker Studio dashboards

Want to keep what GA4 still has?

Tell us when your property started and what you need to compare. In a 30-minute call we will tell you what can still be brought into BigQuery and how to join it with the export.

Book the 30-minute call
Reviews

What our clients say

★★★★★
«from Analytics consultants have been a great asset to us at H&M. They initially joined us to support our migration to GCP and have since helped various business teams not only migrate their reports, but also restructure their entire BI architecture, while being a front-runner in exploring how AI can be utilized within analytics.»
Bianca A.H&M
★★★★★
«Truly impressed with from analytics data visualization skills! Their professionalism and attention to detail not only met but exceeded my expectations. Working with them was a breeze, thanks to their proactive communication and politeness. Highly recommend!»
Facundo P.Puramedicina
★★★★★
«Thanks to from Analytics, we now have custom dashboards to monitor performance across all team divisions, from marketing and customer success to finance and business development. The customer success dashboard has been a complete game-changer, and our leadership team can now make informed decisions directly from clear visual data. We are forever grateful for from Analytics dashboards!»
Chryso S.Stronde