Setting up a destination with BigQuery
1. Create a BigQuery Table for your Converge Data
console.cloud.google.com
bigquery
and pick the BigQuery service.
Empty table
as a Source. Create a new Data set and call it converge_data
, in the Table-field choose a name for your table, e.g. events
.
Schema
2. Stream Converge Data into your BigQuery table
converge-bigq-account
and click on Create and continue.
.json
.
$ip_address
all the way to $email
.
Events that typically do not have an $email
property associated with them (e.g. $page_load
) will still contain this property if we were able to identify this profile before the $page_load
happened.
Profile Information Overview
profile_id
field in your events table may become out of date.
Under the ‘Advanced’ tab of the BigQuery destination configuration, you can configure a table to stream these profile merges to.
You can create this table as follows:
converge_data
), create a new table, e.g. profile_merges
.Schema
(A, C)
(B, C)
Later on, profile C could be merged into profile D:(C, D)
In this case, profiles A, B, and C, would all be mapped to D. To deal with this, we recommend creating a (materialized) view that recursively resolves these mappings. Here’s an example query to achieve this:first_touch_properties
etc. columns are deprecated and are no longer being filled, see here.session_id
and session_properties
columns.
A multi-touch model can be broken down into the following steps:
First Touch
Last Touch
first_touch_properties
and first_touch_session_id
last_touch_properties
and last_touch_session_id
first_touch_paid_properties
and first_touch_paid_session_id
last_touch_paid_properties
and last_touch_paid_session_id
session_id
and session_properties
columns in the Converge data.
These allow full flexibility in building custom attribution models while maintaining correctness.
your-project-name
, your-dataset-name
and your-table-name
with your appropriate values. Converge Feature | Supported |
---|---|
Custom Events | |
Filters | |
Server-side Conversions |