# Google BigQuery

Collective Audience™ can allow you to filter which ad slots to run your campaigns on based on permuted segments stored in a Google BigQuery database.

## Step 1 — Configure BigQuery access

First go to [Google BigQuery](https://console.cloud.google.com/bigquery) and select the table containing your permutive segments.

 ![](https://s3.eu-west-1.amazonaws.com/outline-assets.collectiveaudience.co/uploads/a579229e-61bc-476b-887f-f4ebec869d46/e2fc2ace-60ff-4334-8872-f42c370380e7/1-go-permutive-table.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIA4G6VWWYWENBOMIQL%2F20261016%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20261016T230000Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjECYaCWV1LXdlc3QtMSJGMEQCIFIVLlTsgTg96wh%2B13hbcBBtTjtouLzGHYFUQwAMyGCgAiBZQvQLCUm0fJPROIy9UX0zelwKaJXHduvgCeOJjz9zHirGBQjv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAIaDDgzOTU3NzQxNzI2MCIM0yab%2Fsb9UPYpqt2CKpoFuB%2BEa5MwONKzFCbtf5wiVAAVRaYR9GmGt6NdMSaKWAK2%2BOb%2BLlpx%2F7ratzmo5gOwnpVXaX%2FyyDJmygkNiMOc%2BgpZ%2FhbNJEfn8TloAI3BYdgaAX5xIMxfElG1K1uLvqeo%2F6U%2FmVj2%2BFlCBT9JxUJDO19Xuaen5xUsRewtRqOWeD9x47bV4x5%2BB3O9QDZOk2LC%2Bu7J1NSYWN3qnLJDOWv5tNMbN%2FKBj0FHzZDzZH7Wx80eg81oATJXexfevFkg0pXRaTrdloHnNhzBft1Jrn9Etddl5rA754DWiTULdpjC%2BCcYhEZNmJcWNnzvkFAZZIleU5QyGSJvlUlWAVzPswAhXPHyvnSu27cxmTKXgphDOHTN3Voxp%2FxYNTJk83LqQzjoTrOdS4q4phhD3Hz5eJm9nJkc2ImiYxz2UBGhRx8Zeb4j%2Fi1ml%2BrnZbxzsNegZdlIYVLCr9vbTpCNpOXisVtb%2FBOzaF7YL6fnhiEzCuuHVDISjdVDV46UnRfpFlvSjO15nPzRHDGbfLfADew7iMYlQVec4B3GZp0QCpnqFDXYPKAxUHbIot%2BjO9NK0qaQOMNqkI3fL6IOXYGz0GMTXqL4mPhd3ET5Jb9SwWRUbnOfY1rrkt7JD6Zu%2BgmijASDdnpvxeMND7EvJ9hBwn7eEWbX9VkBVpSM0T7pUbFtsKzecam6yDn6EwCFw2QO1AfSnYyeG%2FFxsQUzj0cXEMuCk%2FryoSOxY2MVnEkK2dQn9cM74B8SQfCRq%2B0c8TK6Mch3CQ29OkUEeGtIh9j%2F4JF3NcqkBAntcbbvH%2BJDXMakkwybgisr7GwsMoidrDxI%2FAwyPpDADt9e8%2BQweALbpQY0mo4GZNaEu0Rc5nAqH1J5OjBbEydoiIMSQHah2UgHMOu0ytYGOrIBA7%2BJIQPrc8lI3Xk%2FuX9wOXXeLdPxQv0gQ5r10iRjh1hC9aT3%2BK%2BLKUDZo0SxrxFWA7bcxdNYA9kBsmm%2F9gA25vfZ4quNROTqd17T3k3NJT7JJGWCTIt3KxpyePhbKVJEXcfWhVOEL2EwBC7cBAcqe5PlBwWAgwnqhyVopkionYKI49pKBD4BxaU0zkBWmMjB0UdxMqY8L8%2Bc0CC3wpqY75IKUc7Y6yqARbgBVuNlQyiHzA%3D%3D&X-Amz-Signature=ab9c624da1ade8b449cb9499fb1a5f267b366b059193f5573bef7970aceec45c&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1616x725")

Click on **Share** and then **Add principal**.

 ![](https://s3.eu-west-1.amazonaws.com/outline-assets.collectiveaudience.co/uploads/a579229e-61bc-476b-887f-f4ebec869d46/33359804-55e8-4f0c-acab-af8261982435/2-select-share.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIA4G6VWWYWENBOMIQL%2F20261016%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20261016T230000Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjECYaCWV1LXdlc3QtMSJGMEQCIFIVLlTsgTg96wh%2B13hbcBBtTjtouLzGHYFUQwAMyGCgAiBZQvQLCUm0fJPROIy9UX0zelwKaJXHduvgCeOJjz9zHirGBQjv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAIaDDgzOTU3NzQxNzI2MCIM0yab%2Fsb9UPYpqt2CKpoFuB%2BEa5MwONKzFCbtf5wiVAAVRaYR9GmGt6NdMSaKWAK2%2BOb%2BLlpx%2F7ratzmo5gOwnpVXaX%2FyyDJmygkNiMOc%2BgpZ%2FhbNJEfn8TloAI3BYdgaAX5xIMxfElG1K1uLvqeo%2F6U%2FmVj2%2BFlCBT9JxUJDO19Xuaen5xUsRewtRqOWeD9x47bV4x5%2BB3O9QDZOk2LC%2Bu7J1NSYWN3qnLJDOWv5tNMbN%2FKBj0FHzZDzZH7Wx80eg81oATJXexfevFkg0pXRaTrdloHnNhzBft1Jrn9Etddl5rA754DWiTULdpjC%2BCcYhEZNmJcWNnzvkFAZZIleU5QyGSJvlUlWAVzPswAhXPHyvnSu27cxmTKXgphDOHTN3Voxp%2FxYNTJk83LqQzjoTrOdS4q4phhD3Hz5eJm9nJkc2ImiYxz2UBGhRx8Zeb4j%2Fi1ml%2BrnZbxzsNegZdlIYVLCr9vbTpCNpOXisVtb%2FBOzaF7YL6fnhiEzCuuHVDISjdVDV46UnRfpFlvSjO15nPzRHDGbfLfADew7iMYlQVec4B3GZp0QCpnqFDXYPKAxUHbIot%2BjO9NK0qaQOMNqkI3fL6IOXYGz0GMTXqL4mPhd3ET5Jb9SwWRUbnOfY1rrkt7JD6Zu%2BgmijASDdnpvxeMND7EvJ9hBwn7eEWbX9VkBVpSM0T7pUbFtsKzecam6yDn6EwCFw2QO1AfSnYyeG%2FFxsQUzj0cXEMuCk%2FryoSOxY2MVnEkK2dQn9cM74B8SQfCRq%2B0c8TK6Mch3CQ29OkUEeGtIh9j%2F4JF3NcqkBAntcbbvH%2BJDXMakkwybgisr7GwsMoidrDxI%2FAwyPpDADt9e8%2BQweALbpQY0mo4GZNaEu0Rc5nAqH1J5OjBbEydoiIMSQHah2UgHMOu0ytYGOrIBA7%2BJIQPrc8lI3Xk%2FuX9wOXXeLdPxQv0gQ5r10iRjh1hC9aT3%2BK%2BLKUDZo0SxrxFWA7bcxdNYA9kBsmm%2F9gA25vfZ4quNROTqd17T3k3NJT7JJGWCTIt3KxpyePhbKVJEXcfWhVOEL2EwBC7cBAcqe5PlBwWAgwnqhyVopkionYKI49pKBD4BxaU0zkBWmMjB0UdxMqY8L8%2Bc0CC3wpqY75IKUc7Y6yqARbgBVuNlQyiHzA%3D%3D&X-Amz-Signature=82ae35bcbabe2a9144b689cfdca3ea40a7a3592db5af5224eca742e6ec07e905&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1320x280")

In **new principals** add *beop-permutive-sync@opinion-project.iam.gserviceaccount.com*. In **role**, choose *BigQuery Data Viewer*. Finally click on **Save**.

 ![](https://s3.eu-west-1.amazonaws.com/outline-assets.collectiveaudience.co/uploads/a579229e-61bc-476b-887f-f4ebec869d46/7c23d75c-c95f-4f12-8c75-d45bdb5c2708/3-add-beop-service-account.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIA4G6VWWYWENBOMIQL%2F20261016%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20261016T230000Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjECYaCWV1LXdlc3QtMSJGMEQCIFIVLlTsgTg96wh%2B13hbcBBtTjtouLzGHYFUQwAMyGCgAiBZQvQLCUm0fJPROIy9UX0zelwKaJXHduvgCeOJjz9zHirGBQjv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAIaDDgzOTU3NzQxNzI2MCIM0yab%2Fsb9UPYpqt2CKpoFuB%2BEa5MwONKzFCbtf5wiVAAVRaYR9GmGt6NdMSaKWAK2%2BOb%2BLlpx%2F7ratzmo5gOwnpVXaX%2FyyDJmygkNiMOc%2BgpZ%2FhbNJEfn8TloAI3BYdgaAX5xIMxfElG1K1uLvqeo%2F6U%2FmVj2%2BFlCBT9JxUJDO19Xuaen5xUsRewtRqOWeD9x47bV4x5%2BB3O9QDZOk2LC%2Bu7J1NSYWN3qnLJDOWv5tNMbN%2FKBj0FHzZDzZH7Wx80eg81oATJXexfevFkg0pXRaTrdloHnNhzBft1Jrn9Etddl5rA754DWiTULdpjC%2BCcYhEZNmJcWNnzvkFAZZIleU5QyGSJvlUlWAVzPswAhXPHyvnSu27cxmTKXgphDOHTN3Voxp%2FxYNTJk83LqQzjoTrOdS4q4phhD3Hz5eJm9nJkc2ImiYxz2UBGhRx8Zeb4j%2Fi1ml%2BrnZbxzsNegZdlIYVLCr9vbTpCNpOXisVtb%2FBOzaF7YL6fnhiEzCuuHVDISjdVDV46UnRfpFlvSjO15nPzRHDGbfLfADew7iMYlQVec4B3GZp0QCpnqFDXYPKAxUHbIot%2BjO9NK0qaQOMNqkI3fL6IOXYGz0GMTXqL4mPhd3ET5Jb9SwWRUbnOfY1rrkt7JD6Zu%2BgmijASDdnpvxeMND7EvJ9hBwn7eEWbX9VkBVpSM0T7pUbFtsKzecam6yDn6EwCFw2QO1AfSnYyeG%2FFxsQUzj0cXEMuCk%2FryoSOxY2MVnEkK2dQn9cM74B8SQfCRq%2B0c8TK6Mch3CQ29OkUEeGtIh9j%2F4JF3NcqkBAntcbbvH%2BJDXMakkwybgisr7GwsMoidrDxI%2FAwyPpDADt9e8%2BQweALbpQY0mo4GZNaEu0Rc5nAqH1J5OjBbEydoiIMSQHah2UgHMOu0ytYGOrIBA7%2BJIQPrc8lI3Xk%2FuX9wOXXeLdPxQv0gQ5r10iRjh1hC9aT3%2BK%2BLKUDZo0SxrxFWA7bcxdNYA9kBsmm%2F9gA25vfZ4quNROTqd17T3k3NJT7JJGWCTIt3KxpyePhbKVJEXcfWhVOEL2EwBC7cBAcqe5PlBwWAgwnqhyVopkionYKI49pKBD4BxaU0zkBWmMjB0UdxMqY8L8%2Bc0CC3wpqY75IKUc7Y6yqARbgBVuNlQyiHzA%3D%3D&X-Amz-Signature=84aeaa6838dd7d66bdf4c63591bfcc9be5f79ddeab1ceadbd2eb9dce7251062c&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =630x612")

## Step 2 — Configure Collective Audience™ service account role

First, go to [Google IAM](https://console.cloud.google.com/iam-admin/iam) and click **Add** to add a new service account.

In **new principal** enter *beop-permutive-sync@opinion-project.iam.gserviceaccount.com*. In **role** choose *BigQuery Job User*. Finally click on **save**.

 ![](https://s3.eu-west-1.amazonaws.com/outline-assets.collectiveaudience.co/uploads/a579229e-61bc-476b-887f-f4ebec869d46/a227f896-d415-49c6-8404-429d41d34589/4-add-beop-role.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIA4G6VWWYWENBOMIQL%2F20261016%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20261016T230000Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjECYaCWV1LXdlc3QtMSJGMEQCIFIVLlTsgTg96wh%2B13hbcBBtTjtouLzGHYFUQwAMyGCgAiBZQvQLCUm0fJPROIy9UX0zelwKaJXHduvgCeOJjz9zHirGBQjv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAIaDDgzOTU3NzQxNzI2MCIM0yab%2Fsb9UPYpqt2CKpoFuB%2BEa5MwONKzFCbtf5wiVAAVRaYR9GmGt6NdMSaKWAK2%2BOb%2BLlpx%2F7ratzmo5gOwnpVXaX%2FyyDJmygkNiMOc%2BgpZ%2FhbNJEfn8TloAI3BYdgaAX5xIMxfElG1K1uLvqeo%2F6U%2FmVj2%2BFlCBT9JxUJDO19Xuaen5xUsRewtRqOWeD9x47bV4x5%2BB3O9QDZOk2LC%2Bu7J1NSYWN3qnLJDOWv5tNMbN%2FKBj0FHzZDzZH7Wx80eg81oATJXexfevFkg0pXRaTrdloHnNhzBft1Jrn9Etddl5rA754DWiTULdpjC%2BCcYhEZNmJcWNnzvkFAZZIleU5QyGSJvlUlWAVzPswAhXPHyvnSu27cxmTKXgphDOHTN3Voxp%2FxYNTJk83LqQzjoTrOdS4q4phhD3Hz5eJm9nJkc2ImiYxz2UBGhRx8Zeb4j%2Fi1ml%2BrnZbxzsNegZdlIYVLCr9vbTpCNpOXisVtb%2FBOzaF7YL6fnhiEzCuuHVDISjdVDV46UnRfpFlvSjO15nPzRHDGbfLfADew7iMYlQVec4B3GZp0QCpnqFDXYPKAxUHbIot%2BjO9NK0qaQOMNqkI3fL6IOXYGz0GMTXqL4mPhd3ET5Jb9SwWRUbnOfY1rrkt7JD6Zu%2BgmijASDdnpvxeMND7EvJ9hBwn7eEWbX9VkBVpSM0T7pUbFtsKzecam6yDn6EwCFw2QO1AfSnYyeG%2FFxsQUzj0cXEMuCk%2FryoSOxY2MVnEkK2dQn9cM74B8SQfCRq%2B0c8TK6Mch3CQ29OkUEeGtIh9j%2F4JF3NcqkBAntcbbvH%2BJDXMakkwybgisr7GwsMoidrDxI%2FAwyPpDADt9e8%2BQweALbpQY0mo4GZNaEu0Rc5nAqH1J5OjBbEydoiIMSQHah2UgHMOu0ytYGOrIBA7%2BJIQPrc8lI3Xk%2FuX9wOXXeLdPxQv0gQ5r10iRjh1hC9aT3%2BK%2BLKUDZo0SxrxFWA7bcxdNYA9kBsmm%2F9gA25vfZ4quNROTqd17T3k3NJT7JJGWCTIt3KxpyePhbKVJEXcfWhVOEL2EwBC7cBAcqe5PlBwWAgwnqhyVopkionYKI49pKBD4BxaU0zkBWmMjB0UdxMqY8L8%2Bc0CC3wpqY75IKUc7Y6yqARbgBVuNlQyiHzA%3D%3D&X-Amz-Signature=4f86ce9d8e73029dbd0d1150fcb2c31f8be3275114a852811e7cf68d081eabf4&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1618x494")

## Step 3 — Give us table path

To be able to pull permutive segments from BigQuery, we need to know the path of the table containing your permutive segments. This path follows the pattern *project.dataset.tablename*. Give us this path to let us enabling permutive retargeting.