Meet the TheyDo Agent

Read more in our blog→

BigQuery integration

Connect TheyDo to BigQuery to pull warehouse data into your metrics. Once set up, your metrics will update automatically from BigQuery — no manual data entry needed.

Before you start

  • You need integration-management permission in TheyDo.
  • We recommend working with a data analyst or BigQuery account owner during setup.
  • Have a BigQuery table ready to test the connection — you'll need its full table reference in the format project_id.dataset_id.table_name.

Need help getting started? Reach out to support@theydo.com with the subject line "BigQuery Integration" and the team will walk you through it.

How to set up the BigQuery integration

  1. Go to Settings > Integrations in TheyDo.
  2. Find BigQuery under Data integrations and select Enable.

Step 1: Choose an authorization method

You have two options:

Option A — Use TheyDo's service account (recommended) This is the simpler approach. Assign the BigQuery User and BigQuery Data Viewer roles in your Google Cloud project to TheyDo's service account: bigquery-integrations@theydo.iam.gserviceaccount.com

Option B — Use your own service account If you prefer to use your own credentials, provide a Service Account JSON Key from your Google account.

Step 2: Name your instance

Enter an Instance Name — this is how this connection will appear in TheyDo. Useful if you plan to connect multiple BigQuery instances.

Step 3: Test your connection

Enter the full reference of a BigQuery table to verify the connection:

project_id.dataset_id.table_name

You can find this under Details > Table ID in BigQuery. TheyDo uses this to confirm it has the right permissions and can access your data.

  1. Click Test and authorize to complete the setup.

Adding multiple instances: You can connect more than one BigQuery instance by repeating these steps.

Prepare your data in BigQuery

Your tables need to return the correct columns for each metric type:

Metric type Required columns
CSAT date, positives, negatives, respondents
CES date, respondents, value
NPS date, detractors, promoters, respondents
RATIO date, numerator, denominator
OTHER date, value

For the Other metric type, TheyDo pulls a pre-calculated average value — make sure that value is already computed in your BigQuery data.

Supported data types:

  • Date columns: DATE
  • Metric value columns: INTEGER, FLOAT, or NUMERIC

Column aliasing: If your table uses different column names, use SQL aliasing in your query. For example:

SELECT det AS detractors, ... FROM project_id.dataset_id.your_table_name