AdRoll Field Reference

Sample

Sample

https://connectors.windsor.ai/adroll?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv

Fields


Fields

IDTypeNameDescription
adnetwork_conversionsNUMERICAd Network Conversions (alias for Conversions)The number of conversions revenue brought in from AdRoll visitors. Only trackable visitors are counted.
adnetwork_revenueNUMERICAd 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.
campaignTEXTCampaignThe Campaign Name
clicksNUMERICClicksThe Number of Clicks
conversionsNUMERICConversionsThe number of conversions revenue brought in from AdRoll visitors. Only trackable visitors are counted.
cpaNUMERICCPAThe advertiser spend per conversion/acquisition.
cpcNUMERICCPCThe advertiser spend per click.
ctrPERCENTCTRThe rate of clicks to impressions.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
day_of_monthTEXTDay of monthDay of the month
impressionsNUMERICimpressionsThe Number of Impressions Served
monthTEXTMonthNumber of the month
revenueNUMERICRevenueThe amount of conversion revenue brought in from AdRoll visitors. Only trackable visitors are counted. Default currency is USD.
sourceTEXTSourceThe name of the Windsor connector returning the row
spendNUMERICSpendThe Media Spend
todayDATETodayToday's date
totalcostNUMERICTotal CostThe Media Spend (Duplicate)
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20