AdRoll Connector Reference

The AdRoll connector exposes 31 fields (11 metrics, 20 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

AdRoll Fields

AdRoll General fields

The General report of the AdRoll connector includes 13 fields.

ID	Type	Name	Description
adnetwork_conversions	NUMERIC	Ad Network Conversions (alias for Conversions)	The number of conversions revenue brought in from AdRoll visitors. Only trackable visitors are counted.
adnetwork_revenue	NUMERIC	Ad Network Revenue (alias for Total conversion value)	The amount of conversion revenue brought in from AdRoll visitors. Only trackable visitors are counted. Default currency is USD.
campaign	TEXT	Campaign	The Campaign Name
clicks	NUMERIC	Clicks	The Number of Clicks
conversions	NUMERIC	Conversions	The number of conversions revenue brought in from AdRoll visitors. Only trackable visitors are counted.
cpa	NUMERIC	CPA	The advertiser spend per conversion/acquisition.
cpc	NUMERIC	CPC	The advertiser spend per click.
ctr	PERCENT	CTR	The rate of clicks to impressions.
date	DATE	Date	The Date
impressions	NUMERIC	impressions	The Number of Impressions Served
revenue	NUMERIC	Revenue	The amount of conversion revenue brought in from AdRoll visitors. Only trackable visitors are counted. Default currency is USD.
spend	NUMERIC	Spend	The Media Spend
totalcost	NUMERIC	Total Cost	The Media Spend (Duplicate)

AdRoll other fields

The AdRoll 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