Setting up a destination with BigQuery
1. Create service account in Google Cloud
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.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 |