logo

GA360 BigQuery Export

Google Analytics 360 event tracking is only available for projects using the Google BigQuery data warehouse.
Google Analytics 360 event tracking is only available for projects using the Google BigQuery data warehouse.
To use event data from Google Analytics 360 in SegmentStream, you need to first set up a Google Analytics 360 BigQuery export. Please follow this guide before proceeding.
⚠️
Ensure that the data location of the BigQuery dataset used in SegmentStream matches the one configured in GA360.
Once the GA360 BigQuery Export is set up, data should start flowing to your BigQuery project within 24 hours. After that happens, you will be able to connect your Google Analytics 360 to SegmentStream.

Connecting Google Analytics 360 to SegmentStream

  1. Inside the admin panel navigate to Settings → Events Tracking.
  1. Click + ADD and select the Google Analytics 360 option.
  1. In the drawer that opens authorise your Google account.
  1. Select the BigQuery project and dataset where your data is collected.
  1. Click Save.
  1. All event data exported to your BigQuery in the past 45 days will be processed by SegmentStream, and reports will become available. This process might take a couple of hours.
Image without caption

BigQuery access issues

If the Google Analytics 360 BigQuery export is connected to a different project than the one specified in the SegmentStream BigQuery settings, you will need to provide additional permissions before connecting event tracking. Follow these steps for the process.

Get your service account email

  1. In your SegmentStream project, navigate to Settings → Events Tracking.
  1. Click on the Google Analytics 360 option.
  1. Select the BigQuery project and dataset where your data is collected.
  1. Copy the service account email from the Google Analytics 360 connection settings.
Image without caption

Set permissions in your Google Cloud Account

  1. Go to the Google Cloud Platform Console.
  1. Open the console left side menu and click IAM & admin. Select IAM from the list.
    1. Image without caption
  1. Click on the project selection menu in the navigation bar, and select the project where the Google Analytics 360 data is exported.
    1. Image without caption
  1. Click GRANT ACCESS:
    1. Image without caption
  1. Paste the service account email address into New principals field.
  1. Select the BigQuery Data Viewer and BigQuery User roles.
  1. Click Save.
    1. Image without caption

Test connection and save

  1. Return to your SegmentStream project and navigate to the Google Analytics 360 connection.
  1. Click TEST CONNECTION.
  1. If the permissions have been correctly set up the SAVE button should be active, click it to complete your Google Analytics 360 tracking setup.