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.

Integrations list with the Add integration button

Select RTB House from the list of available integrations.

Integration catalog filtered to RTB House

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

Collect name field filled in with the example name RTB House PL

Authorization

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

Authorize button next to the Select Rtb House authorization field

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.

Authorize pop-up with the Username and Password fields filled with placeholder values

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").

Select advertisers drop-down open with two example advertisers

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.

Count convention drop-down open with the four options

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.

Advanced settings open with the Tables to collect field

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.

Historical Data field filled in with 365 days

A data synchronization schedule is created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

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 NameModeType
conversionTimeNULLABLETIMESTAMP
conversionIdentifierNULLABLESTRING
conversionHashNULLABLESTRING
cookieHashNULLABLESTRING
conversionValueNULLABLEFLOAT
commissionValueNULLABLEFLOAT
lastClickTimeNULLABLETIMESTAMP
lastImpressionTimeNULLABLETIMESTAMP
advertiserNameNULLABLESTRING
currencyNULLABLESTRING
Data schema for rtbhouse_summary_stats
Field NameModeType
dayNULLABLEDATE
advertiserNULLABLESTRING
advertiserNameNULLABLESTRING
currencyNULLABLESTRING
subcampaignNULLABLESTRING
subcampaignHashNULLABLESTRING
crNULLABLEFLOAT
impsCountNULLABLEINTEGER
clicksCountNULLABLEINTEGER
conversionsCountNULLABLEINTEGER
conversionsValueNULLABLEFLOAT
ecpaNULLABLEFLOAT
ctrNULLABLEFLOAT
campaignCostNULLABLEFLOAT