API Connectors

users-love-us medal soc2
Send your RTB House data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabaseGemini EnterpriseCursorManusGrok

RTB House Connector Reference

16 metrics24 dimensions
Fields

 

https://connectors.windsor.ai/rtbhouse?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,cost,impressions,subcampaign,date

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