# RTB House

# 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:

image alt text

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.

image alt text

Select "RTB House" from the list of available modules

image alt text

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

image alt text

# 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

image alt text

And fill out the RTB House authorize form.

image alt text

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.

image alt text

# Setting the module in the schedule

Your RTB House module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)

Last updated: 4/15/2021, 12:30:11 PM