# RTB House
# Introduction
The RTB House module enables automatic collection of data from your advertising system.
# An example of operation
- We configure the module in the platform by granting access to the RTB House
- We set the module on the schedule - the data will be collected and stored in witcloud dataset
- 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 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)