GA4 Data Not Retained for More Than 60 Days Despite BigQuery Table Expiration Set to 'Never

[dchuguashvili]

Hello,

I've recently linked my Credit Card and upgraded my Google BigQuery settings and set the table expiration to 'never' in hopes of retaining my Google Analytics 4 (GA4) data for more than a year. However, I've observed that GA4 is not retaining data for more than 60 days.

Has anyone else faced a similar issue? How did you resolve it? Is there something I might be overlooking?

Any help would be greatly appreciated.

Thank you.

[lsolatorio]

Hi @dchuguashvili, 

Welcome and thank you for reaching out to the community.

I understand that you are having challenges keeping your data in Google Analytics for more than 60 days. You might need to review the Data Retention value under Data Settings in the Google Analytics interface, set it to 14 months, as described in this document. Anything more than 14 months is only available for 360 users only.

Hope this solves your concern.

[deepakjangir]

If you’re encountering issues with unexpected data expiration in BigQuery, despite having configured the following settings:

1. GA4 retention is configured to 14 months, starting from the export initiation.
2. A billing account is connected to your BigQuery project.
3. The dataset expiration is set to “NEVER”.

Ensure that you also check the expiration settings for individual events within the dataset. Even if the main table’s expiration is set to “NEVER”, each events_ subtable might have an inherited expiration date from previous settings. You will have to go through each dated table and fix it manually.

Thanks,

Deepak Jangir