[GA4] Set up BigQuery Export

Step 1: Create a Google-APIs-Console project and enable BigQuery

1. Log in to the Google Cloud Console.
2. Create a new Google Cloud Console project or select an existing project.
3. Navigate to the APIs table.
   
   Open the Navigation menu in the top-left corner, click APIs & Services, then click Library.
4. Activate BigQuery.
   
   Under Google Cloud APIs, click BigQuery API. On the following page, click Enable.
5. If prompted, review and agree to the Terms of Service.

Step 2: Prepare your project for BigQuery Export

You can export Google Analytics data to the BigQuery sandbox free of charge (sandbox limits apply).

Learn more about upgrading from the sandbox and BigQuery pricing.

Step 3: Link a Google Analytics 4 property to BigQuery

After you complete the first two steps, you can enable BigQuery Export from Analytics Admin.

1. In Admin, under Product Links, click BigQuery Links.
   Note: The previous link opens to the last Analytics property you accessed. You can change the property using the property selector.

   • You must be an Editor or above at the property level to link an Analytics property to BigQuery.
   • You must also use an email address that has OWNER access to the BigQuery project (view Permissions below for detailed access requirements).
2. Click Link.
3. Click Choose a BigQuery project to display a list of projects for which you have access.
   
   If you have linked Analytics and Firebase (or plan to), consider exporting to the same Cloud project, which will facilitate easier joins with other Firebase data.
4. Select a project from the list, then click Confirm.
5. Select a location for the data. (If your project already has a dataset for the Analytics property, you can't configure this option.)
6. Click Next.
7. Select Configure data streams and events to select which data streams to include with the export and specific events to exclude from the export. You can exclude events by either clicking Add to select from a list of existing events or by clicking Specify event by name to choose existing events by name or to specify event names that have yet to be collected on the property.
8. Click Done.
9. Select Include advertising identifiers for mobile app streams if you want to include advertising identifiers.
10. Select either or both a Daily (once a day) or Streaming (continuous) export of data. For Analytics 360 properties, you may also select Fresh Daily.
11. Click Next.
12. Review your settings, then click Submit.

Permissions

Project getIamPolicy/setIamPolicy rights, Services get/enable rights

To create a BigQuery link the minimal permissions you need are:

• resourcemanager.projects.get
  • To get the project
• resourcemanager.projects.getIamPolicy
  • To get a list of permissions
• resourcemanager.projects.setIamPolicy
  • To check if user has permission to create the link on this project
• serviceusage.services.enable
  • To enable the BigQuery API
• serviceusage.services.get
  • To check if the BigQuery API is enabled

Verify the service account

When you link Analytics and BigQuery, that process creates the following service account:

[email protected]

Verify that the account has been added as a member of the project, and given the role of BigQuery User (roles/bigquery.user).

Change regions

If you choose the wrong region and need to change it after you've created the link:

1. Delete the link to BigQuery (see below).
2. Backup the data to another dataset in BigQuery (move or copy).
3. Delete the original dataset. Take note of the name: you'll need it in the next step.
4. Create a new dataset with the same name as the dataset you just deleted, and select the location for the data.
5. Share the new dataset with [email protected] and give the service account the BigQuery Data Owner role.
6. Copy the backup data into the new dataset.
7. Repeat the procedure above to create a new link to BigQuery.

After changing the location, you'll have a gap in your data: streaming and daily exports of data will not process between deletion of the existing link and creation of the new link.

Delete a link to BigQuery

1. In Admin, under Product Links, click BigQuery Links.
   Note: The previous link opens to the last Analytics property you accessed. You can change the property using the property selector.You must be an Editor or above at the property level to delete a link to BigQuery.
2. Click the row for the link.
3. In the top right, click > Delete.

BigQuery Export limits

Standard GA4 properties have a BigQuery Export limit of 1 million events for Daily (batch) exports. There is no limit on the number of events for Streaming export. If your property consistently exceeds the export limit, the daily BigQuery export will be paused and previous days’ exports will not be reprocessed.

For Analytics 360 properties, the Fresh Daily export contains all data fields and columns understood to be in the daily export, including observed user attribution and Ad Impression data.

Property editors and administrators will receive an email notification each time a property they manage exceeds the daily limit. That notification will indicate when their export will be paused if action is not taken. Additionally, if a standard property significantly exceeds the one-million-event daily limit, Analytics may pause daily exports immediately. If you receive a notification, please leverage the data-filtering options (data-stream export and event-exclusion) to decrease the volume of events exported each day and ensure the daily export continues to operate.

Learn more about the higher limits available with 360 properties.

Data filtering

You can exclude specific data streams and events from your export, either to limit the size of your export or to make sure you're exporting just the events you want in BigQuery.

Exclude data streams and events during linking process

During the linking process, when you select the data streams you want to export, you also have the option to select events to exclude from export. See Step 9 in the linking process.

Add or remove data streams or events after you've configured linking

You can add or remove data streams and add events to or remove events from the exclusion list after you've configured the BigQuery link.

1. In Admin, under Product Links, click BigQuery Links.
   Note: The previous link opens to the last Analytics property you accessed. You can change the property using the property selector.

   • You must be an Editor or above at the property level to add or remove data streams or events.
   • You must also use an email address that has OWNER access to the BigQuery project.
2. Click the row for the project whose link you want to modify.
3. Under Data streams and events, click View data streams and events.
4. Under Data streams to export, you can select additional data streams to export or remove existing data streams from the list.
5. On the Events to exclude list, click Add to select from a list of existing events or click Specify event by name to choose existing events by name or to specify event names that have yet to be collected on the property.
6. To remove an event from the list, click the minus sign at the end of that row.

Pricing and billing

BigQuery charges for usage with two pricing components: storage and query processing. You can review the pricing table and learn about the differences between interactive and batch queries.

You need to have a valid form of payment on file in Cloud in order for the export to proceed. If the export is interrupted due to an invalid payment method, we are not able to re-export data for that time.

You can also export Analytics data to the BigQuery sandbox free of charge but keep in mind that sandbox limits apply.

When you start seeing data

Once the linkage is complete, data should start flowing to your BigQuery project within 24 hours. If you enable daily export, then 1 file will be exported each day that contains the previous day’s data (generally, during early afternoon in the time zone you set for reporting).

For "Normal" and "Large" premium properties, the Fresh Daily export is updated approximately every 60 minutes throughout the day. The Fresh Daily export option is not available for "XL" premium properties.

Reasons for linking failures

Creating the link to BigQuery can fail for either of the following two reasons:

• Your organization policy prohibits export to the United States. If you've chosen the United States as the location of your data, choose a different location.
• Your organization policy prohibits service accounts from the domain you want to export data from. In this case, you would need to modify your organization policy.

Reasons for export failures

Support

For BigQuery issues, like billing, contact Google Cloud Support.

Related resources

BigQuery Export

For information about the export and access to a sample data set, read the BigQuery Export documentation.

BI-vendor integration with BigQuery

• Google Looker Studio
• Tableau
• QlikView
• BIME
• Looker
• Excel