Connect Google BigQuery to Google Customer Match with LeadsBridge

1. Head over to the left sidebar and click on Google Suite.
2. Click Google Customer Match.
3. You'll be taken to the Google Customer Match section of your account.
4. Click on Add New.
5. You'll be taken to the first step of the bridge creation.

1. Select the Google Ad Account you want to assign the Google Customer Match.
2. Click Next.

1. Pick an existing Custom Audience or choose to create a new one from the drop-down.
2. In case of a new one, enter the name for your Google Customer Match (this will be visible inside your Ad Account).
3. Add some labels to identify your bridge later in LeadsBridge.
4. Click Next.

1. Choose Google BigQuery as source of your contacts.
2. Select to use an existing integration or to create a new one.
3. Click Next.

You may skip the integration part if your integration has been already configured.

Integrate Google BigQuery with LeadsBridge

1. Type in the name you'd like to call your integration to recognize it later.
2. Enter GCP Authentication JSON and Dataset name to connect your Google BigQuery with LeadsBridge.
3. To authenticate in Google BigQuery you need to have the OAuth JSON file for your project with the right roles set. If you don't have this file yet, please follow the official guide below to generate it.
   Once downloaded, open the file, select the whole content and paste it into the "GCP Authentication JSON" field.( OPEN LINK)
4. All the needed data can be found on your Google BigQuery dashboard on the left as shown in the picture below.
   In the "Dataset name" field you have to specify the name of the database you want to use in Google BigQuery.
   In the "Project ID" field you have to specify your Google Cloud Platform project id.
   
   As entity Google BigQuery uses the single record of your database, so select "Record" from the "Manage "Entities as" dropdown.
   
   As segmentation, you will have to select the database table to use, so select "Table" from the "Use Segment as" dropdown.
   
5. Click Next.

Contacts segmentation

1. Select the segment you'd like to use as the source for your contacts.
2. You may also add filter conditions by clicking the Source Filter button:

• Add conditions to filter contacts and tailor specific segments.
• Remember that source data will be processed only when all conditions added are met.

Click Next.

Fields Mapping

Here you can map your Google BigQuery information with your destination fields.

You'll see a field name with the destination integration's logo at the top, this indicates the name of the field on Google Customer Match.

Underneath there's a box where you may add the information you'd like to send.

• Check each of the Google Customer Match fields available and match the data you wish to sync from Google BigQuery.
• Map as many fields as possible to achieve higher performing data matching to people on Google.
• You may also leave blank the box of a field's information you don't want to send through.

Once accomplished your desired outcome, click Next.

Audience Sources

Here you can Edit the source created, Delete it or Add Another Source to combine different sources into your Google Customer Match.

If you'd like to add other source data, please click Add Another Source and repeat the Step 3 to setup your new source.

Once done, click Next and head to the last step.

1. Before proceeding, please check the information recap.
2. Choose if you'd like to run a Simulation or you're ready to go Live.

• Simulation mode provides you with the opportunity to elaborate source data excluding the data sync process. The outcome is a report in order to verify the information processed.
• Live mode process source data and sync information with Google Customer Match as the outcome. Activate this when you're ready to go live.

Click Publish to start syncing your contacts.