Integration of RTB House with BigQuery
Connect RTB House to Google BigQuery using WitCloud to collect daily campaign performance, cost and conversion data for your advertisers.
Updated
Introduction
This module connects to the RTB House reporting API and stores your retargeting data in Google Cloud BigQuery. For each advertiser it collects daily campaign statistics (impressions, clicks, cost and conversions per subcampaign) and the individual conversions RTB House attributes to your campaigns, so you can analyze them next to the rest of your marketing data.
Configuration guide
Follow the steps below to connect RTB House with BigQuery. Once the setup is complete, your RTB House data is transferred to your BigQuery project on a schedule.
You need the username and password you use to sign in to your RTB House panel. If you have already authorized RTB House in WitCloud, you can pick that authorization from the list instead.
Module setup
Go to Integrations in the menu and click Add integration.

Select RTB House from the list of available integrations.

Enter the Collect name, e.g., "RTB House PL".

Authorization
Click Authorize next to Select Rtb House authorization. Once you have an authorization, this button changes to Re-authorize.

Enter your RTB House Username and Password and click Create. WitCloud checks the credentials with RTB House before saving them, and shows an error in the window if they are not accepted. The saved authorization is named after the username and is selected for you.

If you have already authorized RTB House, choose that authorization from the Select Rtb House authorization list and skip this step.
Advertisers and settings
Select one or more advertisers in Select advertisers. The list shows the advertisers your RTB House account can access. Each advertiser you select becomes a separate data collect, named "Collect name - advertiser name" (for example "RTB House PL - Demo Advertiser PL").

Choose the Count convention: ATTRIBUTED, POST_VIEW, ALL_POST_CLICK or ALL_CONVERSIONS. It is the RTB House setting that decides which conversions are counted in your reports. It applies to performance campaigns; for branding campaigns RTB House reports only cost, impressions, clicks and CTR, so the conversion columns of the campaign statistics stay empty.

Click Show advanced settings to choose Tables to collect. Both tables, summary_stats and conversions, are selected by default, and at least one must stay selected.

Click Next.
Historical data and scheduling
Enter the number of days of history in Historical Data. The value is required and can be at most 365.

A data synchronization schedule is created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your RTB House data will now be synchronized with BigQuery on the schedule.
Data schema
The data is stored in the tables below, one pair per advertiser.
Data schema for rtbhouse_conversions
| Field Name | Mode | Type |
|---|---|---|
| conversionTime | NULLABLE | TIMESTAMP |
| conversionIdentifier | NULLABLE | STRING |
| conversionHash | NULLABLE | STRING |
| cookieHash | NULLABLE | STRING |
| conversionValue | NULLABLE | FLOAT |
| commissionValue | NULLABLE | FLOAT |
| lastClickTime | NULLABLE | TIMESTAMP |
| lastImpressionTime | NULLABLE | TIMESTAMP |
| advertiserName | NULLABLE | STRING |
| currency | NULLABLE | STRING |
Data schema for rtbhouse_summary_stats
| Field Name | Mode | Type |
|---|---|---|
| day | NULLABLE | DATE |
| advertiser | NULLABLE | STRING |
| advertiserName | NULLABLE | STRING |
| currency | NULLABLE | STRING |
| subcampaign | NULLABLE | STRING |
| subcampaignHash | NULLABLE | STRING |
| cr | NULLABLE | FLOAT |
| impsCount | NULLABLE | INTEGER |
| clicksCount | NULLABLE | INTEGER |
| conversionsCount | NULLABLE | INTEGER |
| conversionsValue | NULLABLE | FLOAT |
| ecpa | NULLABLE | FLOAT |
| ctr | NULLABLE | FLOAT |
| campaignCost | NULLABLE | FLOAT |
