Setting up a destination with BigQuery
The data warehouse destinations are currently in beta. Several features are either missing or subject to change in the future. While in testing, the product is provided as is and its usage is free of charge. This will change in the future once the product has been stabilized and released, after which the product will be billed separately.
Please reach out to support if you have any questions or issues while testing the data warehouse destinations.
1. Create service account in Google Cloud
Log into your Google Cloud console at console.cloud.google.com
Choose your relevant Google Cloud Project from the top bar. If you do not have a Google Cloud Project yet, you can create one following the instructions here.
In the sidebar menu, choose IAM and admin > Service accounts.
Click on Create Service Account.
Fill in service account name, e.g. converge-bigq-account
and click on Create and continue.
.json
.
2. Send Converge Data to your BigQuery table
.json
file containing your service account key created in step 13._staging
suffix.Converge will now start sending data to your BigQuery table.
Converge will send attributed data to BigQuery aggregated by day and ad. The following columns are currently sent to BigQuery:
Column name in BigQuery | Type | Description | Attribution model |
---|---|---|---|
date | DATE | The date of the breakdown | N/A |
channel | STRING | The attributed channel | N/A |
campaign | STRING | The attributed campaign | N/A |
campaign_name | STRING | The name of the attributed campaign | N/A |
adset | STRING | The attributed ad set | N/A |
adset_name | STRING | The name of the attributed ad set | N/A |
ad | STRING | The attributed ad | N/A |
ad_name | STRING | The name of the attributed ad | N/A |
spend_sum | FLOAT | The total spend for the day, as reported by the ad platform (if available for the channel) | N/A |
clicks_sum | FLOAT | The total clicks for the day, as reported by the ad platform (if available for the channel) | N/A |
impressions_sum | FLOAT | The total impressions for the day, as reported by the ad platform (if available for the channel) | N/A |
purchase_conversions_sum | FLOAT | The total purchase conversions for the day, as reported by the ad platform (if available for the channel) | N/A |
purchase_conversions_revenue | FLOAT | The total purchase conversion revenue for the day, as reported by the ad platform (if available for the channel) | N/A |
sessions_direct_session | FLOAT | The total number of sessions attributed by Converge | N/A |
placed_order_events_direct_session | FLOAT | The total number of Placed Order events attributed by Converge | Direct |
placed_order_revenue_sum_direct_session | FLOAT | The total revenue for Placed Order events attributed by Converge | Direct |
new_customer_order_events_direct_session | FLOAT | The total number of New Customer Order events attributed by Converge | Direct |
new_customer_order_revenue_sum_direct_session | FLOAT | The total revenue for New Customer Order events attributed by Converge | Direct |
placed_order_events_first_touch | FLOAT | The total number of Placed Order events attributed by Converge | First Touch |
placed_order_revenue_sum_first_touch | FLOAT | The total revenue for Placed Order events attributed by Converge | First Touch |
new_customer_order_events_first_touch | FLOAT | The total number of New Customer Order events attributed by Converge | First Touch |
new_customer_order_revenue_sum_first_touch | FLOAT | The total revenue for New Customer Order events attributed by Converge | First Touch |
placed_order_events_inv_j_shaped | FLOAT | The total number of Placed Order events attributed by Converge | Inverse J Shaped |
placed_order_revenue_sum_inv_j_shaped | FLOAT | The total revenue for Placed Order events attributed by Converge | Inverse J Shaped |
new_customer_order_events_inv_j_shaped | FLOAT | The total number of New Customer Order events attributed by Converge | Inverse J Shaped |
new_customer_order_revenue_sum_inv_j_shaped | FLOAT | The total revenue for New Customer Order events attributed by Converge | Inverse J Shaped |
placed_order_events_j_shaped | FLOAT | The total number of Placed Order events attributed by Converge | J Shaped |
placed_order_revenue_sum_j_shaped | FLOAT | The total revenue for Placed Order events attributed by Converge | J Shaped |
new_customer_order_events_j_shaped | FLOAT | The total number of New Customer Order events attributed by Converge | J Shaped |
new_customer_order_revenue_sum_j_shaped | FLOAT | The total revenue for New Customer Order events attributed by Converge | J Shaped |
placed_order_events_last_touch | FLOAT | The total number of Placed Order events attributed by Converge | Last Touch |
placed_order_revenue_sum_last_touch | FLOAT | The total revenue for Placed Order events attributed by Converge | Last Touch |
new_customer_order_events_last_touch | FLOAT | The total number of New Customer Order events attributed by Converge | Last Touch |
new_customer_order_revenue_sum_last_touch | FLOAT | The total revenue for New Customer Order events attributed by Converge | Last Touch |
placed_order_events_linear | FLOAT | The total number of Placed Order events attributed by Converge | Linear |
placed_order_revenue_sum_linear | FLOAT | The total revenue for Placed Order events attributed by Converge | Linear |
new_customer_order_events_linear | FLOAT | The total number of New Customer Order events attributed by Converge | Linear |
new_customer_order_revenue_sum_linear | FLOAT | The total revenue for New Customer Order events attributed by Converge | Linear |
placed_order_events_participation | FLOAT | The total number of Placed Order events attributed by Converge | Participation |
placed_order_revenue_sum_participation | FLOAT | The total revenue for Placed Order events attributed by Converge | Participation |
new_customer_order_events_participation | FLOAT | The total number of New Customer Order events attributed by Converge | Participation |
new_customer_order_revenue_sum_participation | FLOAT | The total revenue for New Customer Order events attributed by Converge | Participation |
placed_order_events_time_decay | FLOAT | The total number of Placed Order events attributed by Converge | Time Decay |
placed_order_revenue_sum_time_decay | FLOAT | The total revenue for Placed Order events attributed by Converge | Time Decay |
new_customer_order_events_time_decay | FLOAT | The total number of New Customer Order events attributed by Converge | Time Decay |
new_customer_order_revenue_sum_time_decay | FLOAT | The total revenue for New Customer Order events attributed by Converge | Time Decay |
placed_order_events_u_shaped | FLOAT | The total number of Placed Order events attributed by Converge | U Shaped |
placed_order_revenue_sum_u_shaped | FLOAT | The total revenue for Placed Order events attributed by Converge | U Shaped |
new_customer_order_events_u_shaped | FLOAT | The total number of New Customer Order events attributed by Converge | U Shaped |
new_customer_order_revenue_sum_u_shaped | FLOAT | The total revenue for New Customer Order events attributed by Converge | U Shaped |