Connecting these two solutions allows you to visually build segments in GrowthLoop, and sync them to a BigQuery table. To get started, you'll need an audience in GrowthLoop, a BigQuery data warehouse with a dataset, a BigQuery service account, and a BigQuery JSON key.
Step 1
In BigQuery, do a quick search for the Service Accounts settings page. Click + Create Service Account.
Step 2
Enter an Account Name and Account Description that will help your teams identify this account later. Make a note of the Account Name.
Step 3
Give your account Editor access to BigQuery.
Step 4
Return to the Service Accounts page and click your new service account in the list.
Step 5
Select the Keys tab and click Create new key. Select JSON and click Create. Save the file somewhere you can find it later.
Step 6
Go to Destinations in the GrowthLoop platform.
Step 7
Search for and select BigQuery.
Step 8
Configure the Destination based on your needs. Enter the Dataset you want to use. Copy and paste the JSON file into the Credentials field. Choose the Columns to export.
Step 9
Click Create to connect the accounts. You can verify the connection by checking the Destinations page in GrowthLoop.