On this page
- Requirements
- Set up BigQuery as a data source
- BigQuery permissions
- Using VPC Service Controls
- Troubleshoot errors
Requirements
- You must have GCP owner access
on the BQ project and Google Ads admin access to establish an initial connection between your BigQuery table and Search Ads 360.
- Note: The Search Ads 360 admin access can be revoked once the connection is established.
- BigQuery views must be fully authorized and the source of the view cannot include external tables. Learn more about authorized views and external data sources .
Set up BigQuery as a data source
Note: If you have access to a large number of tables or projects, you may experience a delay to download and display your tables. Please allow up to five minutes for a list of tables to become available. If the number of tables or projects is very large, the table list may fail to load.
Apply a use case now
The following sections walk you through a single procedure to link a data source to a use case, such as audience or Floodlight conversion creation. To link the data source only, and apply a use case later, you can refer to Apply a use case later .
Customer Match
Through the “Audience manager” page
- Sign in to your Search Ads 360 account.
- Navigate to a sub-manager account, and then to the Google Ads client account .
- In the page menu, select Shared librarydrop-down,and then select Audience manager.
- Under "Data source", select Connect a new data source, then search and select Google BigQueryfrom the list of products.
- Select Direct connection, then select Continue.
- If you previously linked a data source from the Data manager screen that you want to use, choose Select an existing source.
- Under "Select a data type", choose the data type, then select Continue.
- Select the BigQuery project, dataset, and table that you want to use. An alert appears.
- Select Applyto grant access, then select Next.
- Optional: You can apply filters to define the audience segment that you’ll import. Learn more about using filters .
- To map fields, select the data source fields from the dropdown lists that match the Google fields, then select Continue.
- Optional: Apply transformations to your data.
- Enter a name for this connection.
- Optional: Edit connection details .
- select Done.
- Enter a name for the segment, confirm policy compliance, then select Create.
Offline conversion import
Through the “Conversions” page
- Sign in to your Search Ads 360 account.
- Navigate to a sub-manager account .
- In the page menu, select Conversionsdrop-down, and then select Conversions.
- Select + Create conversion actionunder Goalssection.
- Optional: If you already created a conversion and skipped adding a data source, in the page menu, select Setupdrop-down, select Data manager, then select + Connect Product.
- Select Import.
- Select CRMs, files, or other data sources.
- Select a tracking method.
- Under "Data source", select Connect a new data source.
- If you previously linked a data source from the Data manager screen that you want to use, choose Select an existing source.
- Search and select Google BigQueryfrom the list of products then choose Direct connection.
- Select the check box for the customer data policy to acknowledge that the data was collected and is being shared in compliance with Google's policies, then select Continue.
- Select a conversion goal from the list, then select Set up.
- Select Save and continue.
- Select the BigQuery project, dataset, and table that you want to use. An alert appears.
- Select Applyto grant access, then select Next.
- Optional: You can apply filters to define the conversion events that you’ll import. This is important especially if you have multiple different conversion goals in the file you will be importing. Learn more about using filters .
- To map fields, select the data source fields from the dropdown lists that match the Google fields, then select Continue.
- Optional: Apply transformations to your data.
- Enter a name for this connection.
- Optional: Edit connection details .
- Select Done.
- Select Save and continue.
Apply a use case later
In this type of setup, you complete each part of the connection at different times. This can be useful when you are ready to link a data source, but you are not ready to set up your use case, for example, you aren’t ready to create a customer list.
Example
Consider the following scenario:
- Step 1: Dana is an engineer who manages data for your company. Dana sets up the data source to be used for activation in Search Ads 360. The data source is ready to be associated with a use case.
- Step 2: Mahan is a media specialist who needs to measure audience activation. Mahan creates a customer list and then associates it to the data source that Dana has previously set up, to use that data for Customer Match.
Step 1. Initiate the connection to the data source
Note: It’s recommended that you add an audience segment or conversion goal to a connection that you created. You can either set up an audience segment or conversion goal before you link a data source or you can create an audience segment or conversion goal in the final step of setting up a data source.
Open Setup, select Data manager. Select the connection you just made from “Connected products” and under “Usage”, select + Add audience segmentor + Add conversion action.Set up a data source and create a connection to be associated with a use case later.
- Sign in to your Search Ads 360 account.
- Navigate to a sub-manager account .
- In the page menu, select Setupdrop-down, and then select Data manager.
- Select + Connect Product.
- Under Data source, search and select a data source from the list of products.
- If prompted, select Direct connection.
- Select your use case, read and accept the customer data policy, then select Continue. If you select Audiences, you are prompted to select the data type at this step.
- Enter your data source location and credentials*, then select Next.
- To map fields, select the data source fields from the dropdown lists that match the destination fields.
- Optional: Apply transformations to your data.
- Select Next.
- Enter a name for this connection.
- Optional: Edit connection details .
- Select Finish.
* Use the same credentials and location details for this data source as described in the first part of this article.
Step 2. Complete the connection by applying a use case
- Open the destination you intend to use–for example, begin to create a new customer list or conversion goal using the steps from the previous sections. Return to these steps before completing the data source step.
- Under Data source, choose Select an existing source.
- Select the data source that was initiated in Step 1 from the list of data sources.
- Continue to follow the remaining steps for your use case in the first part of this article. Note that you will skip further data source-related steps, such as entering credentials, because you completed these previously.
BigQuery permissions
To grant Search Ads 360 access to your BigQuery project, you must have the role of BigQuery Data Owner on the project. If you don’t use basic roles, you must have the following underlying permissions :
- bigquery.tables.getIamPolicy
- bigquery.tables.setIamPolicy
- resourcemanager.projects.getIamPolicy
- resourcemanager.projects.setIamPolicy
- bigquery.datasets.setIamPolicy
- bigquery.datasets.update
By granting Search Ads 360 access to your BigQuery project, you are providing Search Ads 360 service accounts with the following permissions :
Service account type and purpose
Service account and permissions required in customer-owned BigQuery project
Datafusion service account
This service account is used to display fields from a data source in Google Ads UI.
service-460246280103@gcp-sa-datafusion.iam.gserviceaccount.com
- BigQuery Data Viewer on the table
Dataproc service account
This service account is used to execute the data load pipelines.
460246280103-compute@developer.gserviceaccount.com
- BigQuery Data Viewer on the table
- BigQuery Metadata Viewer on the dataset
To apply these permissions manually in BigQuery, check Grant access to a resource .
Using VPC Service Controls
If you use VPC Service Controls ( VPC-SC ), this perimeter restricts access to your BigQuery project by all services. To allow Data Manager to import data from your BigQuery project to Search Ads 360, the project must be configured with ingress and egress rules . You can allow these rules to be configured automatically, or if needed, you can configure them manually. The following sections describe both methods.
Configure automatically
Data Manager can apply the required rules for you. If the rules are not already configured when you begin setting up BigQuery as a data source, you are prompted to apply them during the enablement workflow. When you click Apply, the necessary rules on the required resources are granted on your behalf.
In order to consent to the automatic configuration, you must meet both of these conditions:
- You have the necessary IAM permission to apply the rules
- Your organization’s VPC-SC configuration allows you to apply the rules
Configure manually
To configure the rules yourself, open Cloud Console , then edit the VPC service parameter rules with the following configuration:
460246280103-compute@developer.gserviceaccount.com
service-460246280103@gcp-sa-datafusion.iam.gserviceaccount.com
All projects. At minimum, select the project that hosts the table you want to use.
BigQuery APIbigquery.googleapis.com
Cloud Resource Managercloudresourcemanager.googleapis.com
Cloud Storage APIstorage.googleapis.com
460246280103-compute@developer.gserviceaccount.com
service-460246280103@gcp-sa-datafusion.iam.gserviceaccount.com
All projects. At minimum, select the project that hosts the table you want to use.
Cloud Storage APIstorage.googleapis.com
Troubleshoot errors
Setup errors
- Ensure that your conversion goal has successfully connected to the chosen connection. Otherwise, no data will come in.
