This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

GA4 Bigquery All Data

Posted on 05-02-2024 04:24 AM
MariaJose
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hello,
I linked GA4 with Bigquery and everything went perfectly.

But how can I export data from two months ago? Now I only have it in Bigquery since linking.

Thanks,

0 1 244
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Snoshone07
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi @MariaJose when you link GA4 with BigQuery, the data export begins only from the moment the connection is established. Unfortunately, GA4 does not have a native option to backfill historical data to BigQuery for periods prior to the connection.

That said, here are a few alternatives to retrieve older data:

1. Using the GA4 Data API

If your historical data is still available in the GA4 interface, you can manually extract it using the Google Analytics Data API and then load it into BigQuery.

Steps:

  • Ensure you have the required permissions to access the GA4 Data API.
  • Query the historical data by specifying the desired date ranges.
  • Export the data and load it into BigQuery. You can use tools like Python or Google Apps Script to automate this process.

For more details, check out the official GA4 Data API documentation.

2. Manual Export from the GA4 Interface

If the dataset is manageable in size, you can export it manually from the GA4 platform:

  • Use the GA4 "Explore" section or create custom reports to filter historical data.
  • Export the results as a CSV file.
  • Upload the CSV to BigQuery using the web UI or scripts.

This method is ideal for smaller data volumes but can be time-consuming for larger datasets.

3. Third-Party Tools to help with this transfer

For a simpler and more automated solution, consider using a tool like Windsor.ai. It supports GA4 data extraction and can seamlessly transfer historical data into BigQuery.

Steps with Windsor.ai:

  1. Connect your GA4 account to Windsor.ai.
  2. Set the desired date range, including historical periods.
  3. Choose BigQuery as your destination and let the tool handle the rest.

4. Verify GA4 Data Retention Settings

Ensure your GA4 property’s data retention is set to the maximum allowed period (14 months for standard accounts). If it was configured for a shorter duration, some older data may no longer be accessible.

Hope this helps!