logo

BigQuery Export

Google Analytics 4 event tracking is only available for projects using the Google BigQuery data warehouse.
Google Analytics 4 event tracking is only available for projects using the Google BigQuery data warehouse.
To use event data from Google Analytics 4 in SegmentStream, you need to first set up a Google Analytics 4 BigQuery export. Please refer to the Google Analytics guide for detailed setup instructions, ensuring that the following requirements are met:
  • Ensure that the data location of the BigQuery dataset used in SegmentStream matches the one configured in GA4.
    • Image without caption
  • Enable the Streaming export type. Additionally, you have the option to enable Daily export.
    • Image without caption
  • Ensure that no events are excluded in your BigQuery Link settings.
    • Image without caption
Once the GA4 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 4 to SegmentStream.

Connecting Google Analytics 4 to SegmentStream

  1. Inside the admin panel navigate to Settings → Events Tracking.
  1. Click + ADD and select the Google Analytics 4 option.
  1. In the drawer that opens authorise your Google account.
  1. Select the account and property 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

Referral exclusion logic

To ensure SegmentStream provides accurate insights, it's crucial that it accurately identifies where each session's traffic is coming from. Properly setting up referral exclusions is key, especially when users move between different domains or subdomains, like during redirects.
Typical scenarios for using referral exclusions are to stop counting traffic from payment gateways, login systems, or other internal processes as external referrals.
SegmentStream uses the settings from your Google Analytics 4 (GA4) property to filter out these unwanted referrals. So, if your GA4 is correctly set up, SegmentStream will automatically apply those same settings. This process helps identify and exclude unwanted referral traffic through the following methods:
  • Identifying when visitors navigate within different parts of your site or its subdomains, preventing these movements from being counted as external visits. If it’s necessary for your business to track subdomain referrals, visit the following link - FAQ.
  • Redirects between websites specified in your GA4 stream's cross-domain measurement function are treated similarly to redirects within the same domain and are excluded from referral tracking. Learn more about setting up cross-domain measurement in Google's documentation here.
  • You can further control unwanted referrals by configuring the unwanted referals list in your GA4 stream settings. Refer to Google's documentation for step-by-step guidance on configuring unwanted referrals here.

BigQuery access issues

If the Google Analytics 4 BigQuery link 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 4 option.
  1. Select the account and property where your data is collected.
  1. Copy the service account email from the Google Analytics 4 connection settings.
Image without caption

Find the BigQuery project to which the Google Analytics 4 property is linked

  1. In your Google Analytics property, go to Admin.
  1. Under Product Links, click BigQuery Links.
  1. You will see the ID and name of the linked project.
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 linked to Google Analytics 4.
    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 4 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 4 tracking setup.
Image without caption

Powered by Notaku