Clarisights supports Google BigQuery (GBQ) as a data source that could contain the internal attribution data or any other data, that you want to ingest and use in your reports.


The first step is to share the access of your BQ table with our Google Cloud service account.
The ID of the service account is -
101712083634-compute@developer.gserviceaccount.com
And the permissions we need are -
a) bigquery.jobs.create at the project level
b) bigquery.dataViewer at the dataset level

If the BigQuery table is using an external data source, you also need to grant permission to access that external data source. In case of a Google Cloud Bucket, you'll need to grant the "Storage Object viewer" -permission for the bucket that the table is using.


After these permissions are given, please reach out to our customer success team with the following details:

  • Project Name

  • Dataset Name

  • Table Name

We will then verify that our system has access to this table using this information.

Creating a Data source on Clarisight with GBQ

The first step would be to create a Custom Analytics channel, or a POD channel - depending on your requirements. If you need the data as a standalone source, then create a POD channel; if it needs to be joined to an advertising channel using joining keys like campaign/adgroup/adset etc, then create a Custom Analytics channel.

Please refer to these help docs for creating a Custom Analytics channel and creating a POD channel.

Notes-

  1. We are unable to run SQL queries at our end on a table that you have. If you need to run a SQL query on an existing table to get the output you need (for ingesting into Clarisights), then we suggest you look at the scheduled query feature that GBQ has. Google's documentation regarding this is here.

  2. We are unable to integrate views, the data needs to be in an actual table for us to be able to pull it. This is because, the data in a view cannot be exported but the data in a table can be - according to the officially listed limitations of views in Google's documentation here.

  3. In one custom analytics/POD channel, you can only integrate the data from a single GBQ table. You can however have multiple such channels that each integrate data from a different GBQ table.

Did this answer your question?