Setup and Integrations
      Back to home
      1. Help Center
      2. General Resources
      3. Setup and Integrations

      GA4 BigQuery data in Pressboard

      Connect your Google Analytics4 BigQuery and benefit from unrestricted data retrieval without API limitations.

      Prerequisites

      Before proceeding, ensure you have a Google Cloud Platform (GCP) account with access to the BigQuery project containing GA4 data. Refer to GA4 documentation here and here.

      If you'e already exporting raw events from GA4 properties to BigQuery you can consider replacing the Properties already connected in Pressboard Data Sources with a BigQuery connection.

      Granting Pressboard third-party access to your GA4-exported data in BigQuery is done programatically. You will create a service account and generate a private JSON key to input in Settings > Data Sources You can always get in touch with us once you get to this stage. 

       

      image (40)

      Why use BigQuery and not the standard GA4 connection for reporting?
       

      1. Access to raw, unsampled event data 
      2. Highly scalable; unlike, GA4 reports there are no API limitations when querying data. The likelihood of consuming GA's quotas increases with demand which at times can result in delayed data syncs, until quota resets each day.
      3. Create customised report components and dashboards similar to those you may already be using for GA4 reports in Pressboard.   

      Further considerations

      Costs:

      You can export to a free instance of BigQuery (BigQuery sandbox), but exports that exceed the sandbox limits incur charges. Refer to BigQuery pricing for information on costs beyond the free usage limit. 


      Data Governance:

      Remember that you maintain full control over provisioning access to the dataset and can revoke access at any time. Refer to this resource about pre-defined roles.

      Once permissions are granted, we ingest data from the BigQuery table or view that applies only to URLs added to your campaign reports. 

      In short, your BigQuery administrator defines the parameters around what data is exposed in 3rd party applications and the scope of that data is further defined by which URLs are added in your Pressboard account. 

      What else? 

      Reach out to your Customer Success Manager if you’d like to review the setup or if there’s anything else we can clarify.