RTB House data source
Getting started
- Inside the admin panel click Add Data Source.
- Choose RTB House from the list.
- Authenticate using your RTB House Username and Password.
- Enable required reports.
- Click Save.
Available reports
SegmentStream allows to import the following reports from RTB House.
Category statistics
Table name
rtbHouseCategoryStatsReport_{USER_LOGIN}_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
category | STRING | NULLABLE |
categoryId | INTEGER | NULLABLE |
conversionsValue | INTEGER | NULLABLE |
impsCount | FLOAT | NULLABLE |
clicksCount | INTEGER | NULLABLE |
ctr | FLOAT | NULLABLE |
conversionsRate | FLOAT | NULLABLE |
campaignCost | FLOAT | NULLABLE |
cpc | FLOAT | NULLABLE |
conversionsCount | INTEGER | NULLABLE |
currency | STRING | NULLABLE |
date | DATE | NULLABLE |
Additional transformation settings
Besides default reports import, SegmentStream allows to apply additional transformations for the data and help prepare cost data reports grouped by UTM.
This might be very handy if you need to stitch cost data with website sessions or send cost data into Google Analytics.
To enable this transformation use “Import cost data grouped by UTM” setting. Once enabled, a new table with cost data grouped by UTM will appear in your data warehouse.
Table name
rtbHouseCosts_{SHOP_NAME}_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
date | DATE | NULLABLE |
cost | FLOAT | NULLABLE |
clicks | FLOAT | NULLABLE |
impressions | FLOAT | NULLABLE |
utmTerm | INTEGER | NULLABLE |
utmCampaign | STRING | NULLABLE |
utmContent | STRING | NULLABLE |
utmMedium | STRING | NULLABLE |
utmSource | STRING | NULLABLE |
currency | STRING | NULLABLE |
UTM matching for campaigns
Currently, SegmentStream supports automatic UTM matching for RTBHouse campaigns only when UTM params are defined inside the URL for each offer in your product feed. Otherwise, you would need to match RTBHouse campaigns mannually inside the SegmentStream admin panel.
By default, the following matching applies for utm_source
and utm_medium
:
utm_source
▸rtbhouse
utm_medium
▸cpc
This matching can be changed inside the admin panel by specifying appropriate values UTM source and UTM medium options.
This document was last updated on October 2, 2020. If you notice any gaps, outdated information or simply want to leave some feedback to help us improve our documentation, please let us know!