Integrate Channels via BigQuery
Bring marketing data from any channel that already lives in BigQuery — influencer networks, affiliate programs, regional ad platforms — directly into your dashboards.
What the BigQuery Channel Integration Does
Section titled “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
Section titled “Where to Find It”Navigate to Sources › Connections, click Create Connection and select BigQuery Channel.
Step 1 — Create the Connection
Section titled “Step 1 — Create the Connection”Click Create Connection on the Connections page 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.
Then click Next.
Step 2 — Grant Permissions
Section titled “Step 2 — Grant Permissions”Give the adtribute service account access to your BigQuery data:
- Grant the adtribute service account access to your GCP project:
adtribute-pipeline@adtribute-374219.iam.gserviceaccount.com - Assign the BigQuery Data Viewer role.
- Make sure the BigQuery table is stored in a multi-region EU cluster.
Step 3 — Provide Source Identifiers
Section titled “Step 3 — Provide Source Identifiers”Enter the three identifiers that locate your table:
| Field | Description |
|---|---|
| BigQuery Project ID | The GCP project containing the dataset |
| BigQuery Dataset ID | The dataset containing the table |
| BigQuery Table ID | The specific table to read from |
Step 4 — Map Columns
Section titled “Step 4 — Map Columns”Map the columns in your BigQuery table to adtribute channel fields.
Mandatory fields:
| adtribute Field | Description |
|---|---|
| Channel ID Column | Unique identifier for the channel row |
| Channel Start Date Column | Start date of the reporting period |
| Channel End Date Column | End date of the reporting period |
Optional fields:
| adtribute Field | Description |
|---|---|
| Channel Spend Column | Cost amount for the period |
| Channel Hour Column | Hour-level granularity |
| Channel Campaign Column | Campaign name or identifier |
| Channel Adset Column | Adset name or identifier |
| Channel Ad Column | Ad name or identifier |
| Channel Impressions Column | Impression count for the period |
| Channel Clicks Column | Click count for the period |
Step 5 — Connect
Section titled “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?
Section titled “Need Help?”If you run into issues with permissions, table access, or column mapping, reach out to your adtribute data team contact.