Skip to main content

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.
Google BigQuery is Google Cloud’s data warehouse. Add BigQuery as a Connection to Innkeepr to use data that already lives in your warehouse, without additional tracking on your website.

Getting Started

  1. From your workspace’s Connections page, click Add connection.
  2. Choose Google BigQuery.
  3. Enter your Google Cloud project ID.
  4. 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
  5. Give this service account the roles listed under Permissions in your project.
  6. Innkeepr checks that the service account can list your datasets and run queries.
  7. Map the columns of each table Innkeepr should read (see below).
  8. 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:
with this mapping:
becomes this event in Innkeepr:
Use the event names and properties from the Innkeepr Spec, so Innkeepr can use the events for Objectives and Signals.

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.