What the BigQuery Channel Integration Does
The BigQuery Channel Integration lets you import marketing data from channels that don't have a native adtribute connection. As long as the cost data already lives in a BigQuery table, you can surface it as a named channel in your dashboards — alongside natively connected channels like Meta or Google.
The column logic is identical to the Custom Channel (Sheets) integration. The only difference is the underlying data source: a BigQuery table instead of a Google Sheet.
Common use cases:
Influencer marketing — import influencer spend tracked in your BigQuery warehouse so it appears alongside paid channel data.
Affiliate programs — bring in affiliate network costs already aggregated in BigQuery.
Regional ad platforms — connect spend from platforms without native adtribute integrations.
Consolidated warehouse data — any scenario where channel cost data already flows into BigQuery from other systems.
Where to Find It
Navigate to Sources layer → Connections tab → Create Connection → BigQuery Channel.
Setup
Step 1 — Create the Connection
Click Create Connection in the Connections sidebar and select BigQuery Channel. Then fill in:
Connection name — a recognizable label for this connection (e.g., "Influencer").
Description (optional) — a note explaining the data source (e.g., "Influencer spend data from BigQuery").
Channel name — the name that will appear in dashboards for this channel. This is distinct from the connection name.
Step 2 — Grant Permissions
Give the adtribute service account access to your BigQuery data:
Grant the adtribute service account access to your GCP project:
[email protected]Assign the BigQuery Data Viewer role.
Make sure the BigQuery table is stored in a multi-region EU cluster.
Step 3 — Provide Source Identifiers
Enter the three identifiers that locate your table:
Field | Description |
Project ID | The GCP project containing the dataset |
Dataset ID | The dataset containing the table |
Table ID | The specific table to read from |
Step 4 — Map Columns
Map the columns in your BigQuery table to adtribute channel fields.
Mandatory fields:
adtribute Field | Description |
Channel ID | Unique identifier for the channel row |
Channel Start Date | Start date of the reporting period |
Channel End Date | End date of the reporting period |
Optional fields:
adtribute Field | Description |
Channel Spend | Cost amount for the period |
Channel Hour | Hour-level granularity |
Channel Campaign | Campaign name or identifier |
Channel AdSet | Adset name or identifier |
Channel Ad | Ad name or identifier |
Channel Impressions | Impression count for the period |
Channel Clicks | Click count for the period |
Step 5 — Connect
Click Connect. adtribute begins syncing data from your BigQuery table into your account. The channel will appear in your attribution dashboards once the first sync completes.
Need Help?
If you run into issues with permissions, table access, or column mapping, reach out to your adtribute data team contact.