Connection Info
The Google BigQuery Connection is an Events, Profiles, and Attribution connection.
- Events: Sends events, such as page views or orders, to Innkeepr.
- Profiles: Adds traits, such as email addresses or phone numbers, to Profiles.
- Attribution: Sends conversions with the campaigns they are attributed to.
Getting Started
- From your workspace’s Connections page, click Add connection.
- Choose Google BigQuery.
- Enter your Google Cloud project ID.
- Innkeepr creates a service account for your workspace and shows its email address. It looks like this:
ws-<workspace-id>@innkeepr-bigquery.iam.gserviceaccount.com - Give this service account the roles listed under Permissions in your project.
- Innkeepr checks that the service account can list your datasets and run queries.
- Map the columns of each table Innkeepr should read (see below).
- Click Save.
Map tables to events
Innkeepr reads only the tables you map. For each table, you define which column holds what:
Example
This row in your table:
Sync
Innkeepr reads your mapped tables once a night, one day at a time, with standard SQL queries. Columns that are not in the mapping are ignored. The queries run as jobs in your Google Cloud project, so BigQuery bills them to your project.Permissions
Grant the Innkeepr service account these roles in your project, in Google Cloud Console > IAM & Admin > IAM:
Innkeepr only reads. It does not create, change, or delete tables.