RTB House Connector Reference

The RTB House connector exposes 40 fields (16 metrics, 24 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

RTB House Fields

RTB House Campaign fields

The Campaign report of the RTB House connector includes 22 fields.

ID	Type	Name	Description
advertiser_url	TEXT	Advertiser Url	Advertiser url
campaign	TEXT	Campaign	The Campaign Name
clicks	NUMERIC	Click Count	The Click Count
conversion_count	NUMERIC	Conversion Count	The Conversion Count
conversion_value	NUMERIC	Conversion Value	The Conversion Value
cost	NUMERIC	Campaign Cost	The Campaign Cost
cr	NUMERIC	Conversion rate	The CR
ctr	PERCENT	CTR	The CTR
date	DATE	The Date	The Date
device	TEXT	Device	Device type
ecpa	NUMERIC	ECPA	Effective Cost Per Action: Cost / Conversions
ecpc	NUMERIC	ECPC	Effective Cost Per Click: Cost / Clicks
ecpm	NUMERIC	ECPM	Effective Cost Per Mille: (Cost / Impressions) * 1000
impressions	NUMERIC	Impression Count	The Impression Count
pc_conversion_count	NUMERIC	Post-Click Conversion Count	The post-click Conversion Count
pc_conversion_value	NUMERIC	Post-Click Conversion Value	The post-click Conversion Value
pv_conversion_count	NUMERIC	Post-View Conversion Count	The post-view Conversion Count
pv_conversion_value	NUMERIC	Post-View Conversion Value	The post-view Conversion Value
roas	PERCENT	Return on ad spend: Conversion value / Cost	The ROAS
subcampaign	TEXT	Subcampaign	Subcampaign
subcampaign_id	TEXT	Subcampaign Id	Subcampaign id
totalcost	NUMERIC	Total Cost	The Campaign Cost

RTB House other fields

The RTB House connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024|20