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.

​
Installation Instructions

1. Create service account in Google Cloud

  1. Log into your Google Cloud console at console.cloud.google.com

  2. 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.

  3. In the sidebar menu, choose IAM and admin > Service accounts.  

    bq-s-1

  4. Click on Create Service Account.  

    bq-s-2

  5. Fill in service account name, e.g. converge-bigq-account and click on Create and continue.  

bq-s-3

  1. Under Grant this service account access to the project, choose the BigQuery Data Owner and BigQuery Job User scopes and click on Done.  

bq-s-4

  1. Pick your newly created service account from the list of Service Accounts and choose Manage keys.  

bq-s-5

  1. Click on Add Key and Create new key. In the popup choose JSON and click on Create. This will download a file that ends with .json.  

bq-s-6

2. Send Converge Data to your BigQuery table

  1. In the Converge sidebar, click on
    Data warehouse
    and then click Connect data warehouse.
  2. Select the BigQuery destination and click Next.
  3. Give your destination a name (e.g. BigQuery Data Warehouse) and click Next.
  4. Click the Credentials field and select the .json file containing your service account key created in step 13.
  5. Fill in the Dataset ID with the dataset ID from Google Cloud.
  6. Fill in the Table ID with the table ID you’d like to send data. This table should not exist in BigQuery yet as it will be updated by the destination.
  7. In Advanced configuration, you can optionally fill in the Staging Table ID, if you would like to use a different table name. By default, Converge will use the same table name as the Table ID but with a _staging suffix.
  8. Click Next.
  9. Fill in the Start date with a date in the past from which you’d like to send data. Click Next.
  10. Review any issues and click Connect data warehouse.

Converge will now start sending data to your BigQuery table.

​
Data sent to BigQuery

Converge will send attributed data to BigQuery aggregated by day and ad. The following columns are currently sent to BigQuery:

Column name in BigQueryTypeDescriptionAttribution model
dateDATEThe date of the breakdownN/A
channelSTRINGThe attributed channelN/A
campaignSTRINGThe attributed campaignN/A
campaign_nameSTRINGThe name of the attributed campaignN/A
adsetSTRINGThe attributed ad setN/A
adset_nameSTRINGThe name of the attributed ad setN/A
adSTRINGThe attributed adN/A
ad_nameSTRINGThe name of the attributed adN/A
spend_sumFLOATThe total spend for the day, as reported by the ad platform (if available for the channel)N/A
clicks_sumFLOATThe total clicks for the day, as reported by the ad platform (if available for the channel)N/A
impressions_sumFLOATThe total impressions for the day, as reported by the ad platform (if available for the channel)N/A
purchase_conversions_sumFLOATThe total purchase conversions for the day, as reported by the ad platform (if available for the channel)N/A
purchase_conversions_revenueFLOATThe total purchase conversion revenue for the day, as reported by the ad platform (if available for the channel)N/A
sessions_direct_sessionFLOATThe total number of sessions attributed by ConvergeN/A
placed_order_events_direct_sessionFLOATThe total number of Placed Order events attributed by ConvergeDirect
placed_order_revenue_sum_direct_sessionFLOATThe total revenue for Placed Order events attributed by ConvergeDirect
new_customer_order_events_direct_sessionFLOATThe total number of New Customer Order events attributed by ConvergeDirect
new_customer_order_revenue_sum_direct_sessionFLOATThe total revenue for New Customer Order events attributed by ConvergeDirect
placed_order_events_first_touchFLOATThe total number of Placed Order events attributed by ConvergeFirst Touch
placed_order_revenue_sum_first_touchFLOATThe total revenue for Placed Order events attributed by ConvergeFirst Touch
new_customer_order_events_first_touchFLOATThe total number of New Customer Order events attributed by ConvergeFirst Touch
new_customer_order_revenue_sum_first_touchFLOATThe total revenue for New Customer Order events attributed by ConvergeFirst Touch
placed_order_events_inv_j_shapedFLOATThe total number of Placed Order events attributed by ConvergeInverse J Shaped
placed_order_revenue_sum_inv_j_shapedFLOATThe total revenue for Placed Order events attributed by ConvergeInverse J Shaped
new_customer_order_events_inv_j_shapedFLOATThe total number of New Customer Order events attributed by ConvergeInverse J Shaped
new_customer_order_revenue_sum_inv_j_shapedFLOATThe total revenue for New Customer Order events attributed by ConvergeInverse J Shaped
placed_order_events_j_shapedFLOATThe total number of Placed Order events attributed by ConvergeJ Shaped
placed_order_revenue_sum_j_shapedFLOATThe total revenue for Placed Order events attributed by ConvergeJ Shaped
new_customer_order_events_j_shapedFLOATThe total number of New Customer Order events attributed by ConvergeJ Shaped
new_customer_order_revenue_sum_j_shapedFLOATThe total revenue for New Customer Order events attributed by ConvergeJ Shaped
placed_order_events_last_touchFLOATThe total number of Placed Order events attributed by ConvergeLast Touch
placed_order_revenue_sum_last_touchFLOATThe total revenue for Placed Order events attributed by ConvergeLast Touch
new_customer_order_events_last_touchFLOATThe total number of New Customer Order events attributed by ConvergeLast Touch
new_customer_order_revenue_sum_last_touchFLOATThe total revenue for New Customer Order events attributed by ConvergeLast Touch
placed_order_events_linearFLOATThe total number of Placed Order events attributed by ConvergeLinear
placed_order_revenue_sum_linearFLOATThe total revenue for Placed Order events attributed by ConvergeLinear
new_customer_order_events_linearFLOATThe total number of New Customer Order events attributed by ConvergeLinear
new_customer_order_revenue_sum_linearFLOATThe total revenue for New Customer Order events attributed by ConvergeLinear
placed_order_events_participationFLOATThe total number of Placed Order events attributed by ConvergeParticipation
placed_order_revenue_sum_participationFLOATThe total revenue for Placed Order events attributed by ConvergeParticipation
new_customer_order_events_participationFLOATThe total number of New Customer Order events attributed by ConvergeParticipation
new_customer_order_revenue_sum_participationFLOATThe total revenue for New Customer Order events attributed by ConvergeParticipation
placed_order_events_time_decayFLOATThe total number of Placed Order events attributed by ConvergeTime Decay
placed_order_revenue_sum_time_decayFLOATThe total revenue for Placed Order events attributed by ConvergeTime Decay
new_customer_order_events_time_decayFLOATThe total number of New Customer Order events attributed by ConvergeTime Decay
new_customer_order_revenue_sum_time_decayFLOATThe total revenue for New Customer Order events attributed by ConvergeTime Decay
placed_order_events_u_shapedFLOATThe total number of Placed Order events attributed by ConvergeU Shaped
placed_order_revenue_sum_u_shapedFLOATThe total revenue for Placed Order events attributed by ConvergeU Shaped
new_customer_order_events_u_shapedFLOATThe total number of New Customer Order events attributed by ConvergeU Shaped
new_customer_order_revenue_sum_u_shapedFLOATThe total revenue for New Customer Order events attributed by ConvergeU Shaped