Adalyser Connector Reference

23 metrics70 dimensions

The Adalyser connector allows to retrieve data from the Adalyser platform

https://connectors.windsor.ai/adalyser?fields=client_id,client_name,grosscost,clientcost,timezone,date,day,daypart,weekstart,market,platform,channel,programme,product,length,position,linkkey,creative,adgroup,saleshouse,status,type,leadcount,lead_sources_desktop,lead_sources_mobile,lead_actions_new,lead_actions_returning,lead_origins_paid_search,lead_origins_organic_search,lead_origins_direct,lead_attribute_4,lead_attribute_5,cpl,cpl_sources_desktop,cpl_sources_mobile,lead_baseline,lead_uplift,appt_count,cpa,sales_count,sale_sources_desktop,sale_sources_mobile,sale_origins_paid_search,sale_origins_organic_search,sale_origins_direct,sale_attribute_4,sale_attribute_5,cps,cps_sources_desktop,cps_sources_mobile,sales_value,sale_value_sources_desktop,sale_value_sources_mobile,sale_value_actions_new,sale_value_actions_returning,sale_value_origins_paid_search,sale_value_origins_organic_search,sale_value_origins_direct,sale_value_attribute_4,sale_value_attribute_5,avg_sales_value,roi,lead_sale_conv_rate&api_key=[your API key]

The Adalyser connector exposes 93 fields (23 metrics, 70 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Adalyser Fields

The Adalyser connector includes 93 fields.

Adalyser fields (adgroup to lead_sources_desktop)

IDTypeNameDescription
adgroupTEXTAd GroupThe Ad Group
appt_countNUMERICAppt CountThe Appt Count
audience_nameTEXTAudience NameThe Audience Name
avg_sales_valueNUMERICAvg Sales ValueThe Avg Sales Value
channelTEXTChannelThe Channel
client_idTEXTClient IDClient ID
client_nameTEXTClient NameClient Name
clientcostNUMERICClient CostThe Client Cost
conversionsNUMERICConversionsThe number of sales (conversions).
cpaNUMERICCPAThe CPA
cplNUMERICCPLThe CPL
cpl_sources_desktopTEXTCPL Sources DesktopThe CPL Sources Desktop
cpl_sources_mobileTEXTCPL Sources MobileThe CPL Sources Mobile
cpsNUMERICCPSThe CPS
cps_sources_desktopTEXTCPS Sources DesktopThe CPS Sources Desktop
cps_sources_mobileTEXTCPS Sources MobileThe CPS Sources Mobile
cptNUMERICCPTThe CPT
creativeTEXTCreativeThe Creative
cvrPERCENTCVRLeads to sales conversion rate.
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
dayTEXTDayThe Day
day_of_monthTEXTDay of monthDay of the month
daypartTEXTDaypartThe Daypart
grosscostNUMERICGross CostThe Gross Cost
impactsNUMERICImpactsThe Impacts
ipaNUMERICIPAThe IPA
iplNUMERICIPLThe IPL
ipsNUMERICIPSThe IPS
lead_actions_newTEXTLead Actions NewThe Lead Actions New
lead_actions_returningTEXTLead Actions ReturningThe Lead Actions Returning
lead_attribute_4TEXTLead Attribute 4The Lead Attribute 4
lead_attribute_5TEXTLead Attribute 5The Lead Attribute 5
lead_baselineNUMERICLead BaselineThe Lead Baseline
lead_origins_directTEXTLead Origins DirectThe Lead Origins Direct
TEXTLead Origins Organic SearchThe Lead Origins Organic Search
TEXTLead Origins Paid SearchThe Lead Origins Paid Search
lead_sale_conv_ratePERCENTCVR (Duplicate)Leads to sales conversion rate.
lead_sources_desktopTEXTLead Sources DesktopThe Lead Sources Desktop

Adalyser fields (lead_sources_mobile to tvrs)

IDTypeNameDescription
lead_sources_mobileTEXTLead Sources MobileThe Lead Sources Mobile
lead_upliftTEXTLead UpliftThe Lead Uplift
leadcountNUMERICLead Count (Sessions Duplicate)The number of leads (sessions).
lengthTEXTLengthThe Length
linkkeyTEXTLink KeyThe Link Key
marketTEXTMarketThe Market
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
platformTEXTPlatformThe Platform
position_textTEXTPosition (text)The Position
productTEXTProduct nameThe Product
programmeTEXTProgrammeThe Programme
roiPERCENTROIReturn on investment.
roi_ratePERCENTROI (Duplicate)Return on investment.
sale_attribute_4TEXTSale Attribute 4The Sale Attribute 4
sale_attribute_5TEXTSale Attribute 5The Sale Attribute 5
sale_countNUMERICSales Count (Conversions Duplicate)The number of sales (conversions).
sale_origins_directTEXTSale Origins DirectThe Sale Origins Direct
TEXTSale Origins Organic SearchThe Sale Origins Organic Search
TEXTSale Origins Paid SearchThe Sale Origins Paid Search
sale_sources_desktopTEXTSale Sources DesktopThe Sale Sources Desktop
sale_sources_mobileTEXTSale Sources MobileThe Sale Sources Mobile
sale_value_actions_newTEXTSale Value Actions NewThe Sale Value Actions New
sale_value_actions_returningTEXTSale Value Actions ReturningThe Sale Value Actions Returning
sale_value_attribute_4TEXTSale Value Attribute 4The Sale Value Attribute 4
sale_value_attribute_5TEXTSale Value Attribute 5The Sale Value Attribute 5
sale_value_origins_directTEXTSale Value Origins DirectThe Sale Value Origins Direct
TEXTSale Value Origins Organic SearchThe Sale Value Origins Organic Search
TEXTSale Value Origins Paid SearchThe Sale Value Origins Paid Search
sale_value_sources_desktopTEXTSale Value Sources DesktopThe Sale Value Sources Desktop
sale_value_sources_mobileTEXTSale Value Sources MobileThe Sale Value Sources Mobile
sales_valueNUMERICSales ValueThe Sales Value
saleshouseTEXTSales HouseThe Sales House
sessionsNUMERICSessionsThe number of sessions (leads).
sourceTEXTSourceThe name of the Windsor connector returning the row
statusTEXTStatusThe Status
timeTEXTTimeThe Time
timezoneTEXTTimezoneThe Timezone
todayDATETodayToday's date
tvrsNUMERICTVRSThe TVRs

Adalyser fields (type to year_week_iso)

IDTypeNameDescription
typeTEXTTypeThe Type
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).
weekstartTEXTWeek StartThe Week Start
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
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