Skip to main content

Connect Varify.io with BigQuery

Last updated on Apr 22, 20263 min read
Table of contents

In short​

You can easily link your Varify.io account to your BigQuery project. To do this, go to your tracking settings in Varify.io and connect your Google account with Varify. You can then select your BigQuery project.

Is there already a BigQuery project for GA4?​

To use Varify with BigQuery, you connect a BigQuery project in which the GA4 data is exported. You can either select an existing project or create and connect a new project with the one-click auto setup.

YES, there is already a BQ project linked to GA4

  • Connection to an existing BigQuery GA4 project
  • Connection to a manually set up BigQuery GA4 project

Skip to section

NO there is no BQ project connected to GA4 yet

  • Ideal if no BigQuery GA4 project exists yet
  • Simple one-click setup

Skip to section

Connect existing BigQuery GA4 project​

Link an existing BigQuery project to which Google Analytics data is exported.

Proceed as follows:

  1. Open the tracking setup in Varify.
  2. Scroll to "Use BigQueryData".
  3. Activate the feature with the switch.
  4. Select "Connect existing project".
  5. Select the appropriate BigQuery project under "Project".
  6. If a suitable dataset already exists, the status "found dataset" appears.
  7. Confirm with "Update".
important

In the linked BigQuery project, ensure that in GA4 both the Event Dataas well as User Data is exported daily.

Varify card „Use Bigquery Data“ with „Connect existing project“ selected; the chosen project reports the status „found dataset“
important

Every Varify account user can activate the dataset → It is important that the user of the Google connection has the authorization to add the project.

Create and connect new BigQuery project with one-click auto-setup​

If you do not yet have a BigQuery project for your GA4 data, you can either create a new project Create manually or use the one-click auto setup in Varify to create a project automatically.

1. create project with the one-click auto-setup​

First create a new BigQuery project with one click.

Proceed as follows:

  1. Open the tracking setup in Varify.
  2. Scroll to "Use BigQueryData".
  3. Check the „Use BigQuery Data“ box.
  4. Select "One-click auto-setup".
  5. Click on "Create BigQuery Project"
important

The project is created for the Google account that was connected to the Varify tracking setup.

Varify card „Use Bigquery Data“ with „One-click auto setup“ selected and an arrow pointing at „Create Bigquery Project“

After you have created a new BigQuery project using the one-click auto setup, you will see the project ID highlighted in green. You will need this project ID in a moment.

The project was created in the Google account that is connected to Varify via the tracking setup.

Varify step 1 confirming the created BigQuery project, its ID „varify-team-1-1234567890“ highlighted

Now link the new project to your GA4 property to export the GA4 event and user data to BigQuery.

Follow either the steps in the step-by-step guide or this article: Connect BigQuery Auto-Setup with GA4.

Varify setup with the step-by-step demo video highlighted and the toggle confirming that GA4 is linked with BigQuery

To make the BigQuery Goals available in reporting, confirm and complete the setup in Varify. Proceed as follows:

  1. Confirm in Varify that you have linked the project to GA4 as described above
  2. Click „Finish Setup“
Varify setup card with the toggle „I have followed the steps and linked GA4 with Bigquery“ switched on and the „Finish setup“ button

Add BigQuery Goals to the report​

You can add a BigQuery Goal to your reports just as easily as the GA4 Goals.

This is how you proceed:

  1. Start the experiment and click on the "Results" button.
  2. Click on "Add BigQuery Goal" (This button only appears after a successful connection to the BigQuery project)
  3. Select the event you want to measure, e.g. "Purchases".
  4. In the second drop-down menu, you specify the counting method:
  • CountCounts the triggered events.
  • RevenueCounts the revenue value of the event (relevant for purchase events).
  1. Confirm with the green tick.
Varify test results with the button „Add BigQuery goal“ highlighted next to „Add GA4 goal“

Back to overview

On this page