RTB House

• Introduction
  • An example of operation
  • Data schema
• Configuration
  • Start creating the module
  • Initial settings
  • Authorization with RTB House
  • Setting the module in the schedule

Introduction

The RTB House module enables automatic collection of data from your advertising system.

An example of operation

1. We configure the module in the platform by granting access to the RTB House
2. We set the module on the schedule - the data will be collected and stored in witcloud dataset
3. After the table is processed, you can use other reporting modules or combine it with analytics

Data schema

After starting the module, 2 new tables will appear in the WitCloud dataset:

rtbhouse_summary_stats

Expand for the data schema

day	DATE	NULLABLE
advertiser	STRING	NULLABLE
advertiserName	STRING	NULLABLE
currency	STRING	NULLABLE
subcampaign	STRING	NULLABLE
subcampaignHash	STRING	NULLABLE
cr	FLOAT	NULLABLE
impsCount	INTEGER	NULLABLE
clicksCount	INTEGER	NULLABLE
conversionsCount	INTEGER	NULLABLE
conversionsValue	FLOAT	NULLABLE
ecpa	FLOAT	NULLABLE
ctr	FLOAT	NULLABLE
campaignCost	FLOAT	NULLABLE

rtbhouse_conversions

Expand for the data schema

Field name	Type	Mode
conversionTime	TIMESTAMP	NULLABLE
conversionIdentifier	STRING	NULLABLE
conversionHash	STRING	NULLABLE
cookieHash	STRING	NULLABLE
conversionValue	FLOAT	NULLABLE
commissionValue	FLOAT	NULLABLE
lastClickTime	TIMESTAMP	NULLABLE
lastImpressionTime	TIMESTAMP	NULLABLE
advertiserName	STRING	NULLABLE
currency	STRING	NULLABLE

Configuration

Start creating the module

From the menu on the left, select the Collect tab, then click the Add new data Collect button.

Select RTB House from the list of available modules

Initial settings

In the first step, we only have one field to fill.

Collect name - the name of our module. It will be visible under this name elsewhere on the platform.

Authorization with RTB House

In the next step, we need to grant WitCloud access to RTB House. It is necessary for WitCloud to be able to download data.

To do this, press the Click here to authorize button

And fill out the RTB House authorize form.

After proper authorization, complete the rest of the fields

Count convention - counting convention

Advertisers - list of advertisers available for the account

And click the Finish button.

Setting the module in the schedule

Your module is now created in WitCloud 📊. The final step is to determine the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.

Enter the appropriate range and click the Finish button.