Skip to main content
The data warehouse destinations are currently in beta. Several features are either missing or subject to change in the future. While in testing, the product is provided as is and its usage is free of charge. This will change in the future once the product has been stabilized and released, after which the product will be billed separately.Please reach out to support if you have any questions or issues while testing the data warehouse destinations.

​
Installation instructions

1. Create service account in Google Cloud

  1. Log into your Google Cloud console at console.cloud.google.com
  2. Choose your relevant Google Cloud Project from the top bar. If you don’t have a Google Cloud Project yet, you can create one following the instructions here.
  3. In the sidebar menu, choose IAM and admin > Service accounts.  
    bq-s-1
  4. Click on Create Service Account.  
    bq-s-2
  5. Fill in service account name, e.g. converge-bigq-account and click on Create and continue.  
bq-s-3
  1. Under Grant this service account access to the project, choose the BigQuery Data Owner and BigQuery Job User scopes and click on Done.  
bq-s-4
  1. Pick your newly created service account from the list of Service Accounts and choose Manage keys.  
bq-s-5
  1. Click on Add Key and Create new key. In the popup choose JSON and click on Create. This will download a file that ends with .json.  
bq-s-6

2. Send Converge Data to your BigQuery table

  1. In the Converge sidebar, click on
    Data warehouse
    and then click Connect data warehouse.
  2. Select the BigQuery destination and click Next.
  3. Give your destination a name (e.g. BigQuery Data Warehouse) and click Next.
  4. Click the Credentials field and select the .json file containing your service account key created in step 13.
  5. Fill in the Dataset ID with the dataset ID from Google Cloud.
  6. Fill in the Table ID with the table ID you’d like to send data. This table should not exist in BigQuery yet as it will be updated by the destination.
  7. In Advanced configuration, you can optionally fill in the Staging Table ID, if you would like to use a different table name. By default, Converge will use the same table name as the Table ID but with a _staging suffix.
  8. Click Next.
  9. Fill in the Start date with a date in the past from which you’d like to send data. Click Next.
  10. Review any issues and click Connect data warehouse.
Converge will now start sending data to your BigQuery table.

​
Data sent to BigQuery

Converge will send attributed data to BigQuery aggregated by day and ad. The following columns are currently sent to BigQuery: