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)

ID Type Name Description
adgroup TEXT Ad Group The Ad Group
appt_count NUMERIC Appt Count The Appt Count
audience_name TEXT Audience Name The Audience Name
avg_sales_value NUMERIC Avg Sales Value The Avg Sales Value
channel TEXT Channel The Channel
client_id TEXT Client ID Client ID
client_name TEXT Client Name Client Name
clientcost NUMERIC Client Cost The Client Cost
conversions NUMERIC Conversions The number of sales (conversions).
cpa NUMERIC CPA The CPA
cpl NUMERIC CPL The CPL
cpl_sources_desktop TEXT CPL Sources Desktop The CPL Sources Desktop
cpl_sources_mobile TEXT CPL Sources Mobile The CPL Sources Mobile
cps NUMERIC CPS The CPS
cps_sources_desktop TEXT CPS Sources Desktop The CPS Sources Desktop
cps_sources_mobile TEXT CPS Sources Mobile The CPS Sources Mobile
cpt NUMERIC CPT The CPT
creative TEXT Creative The Creative
cvr PERCENT CVR Leads to sales conversion rate.
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
date DATE Date The Date
day TEXT Day The Day
day_of_month TEXT Day of month Day of the month
daypart TEXT Daypart The Daypart
grosscost NUMERIC Gross Cost The Gross Cost
impacts NUMERIC Impacts The Impacts
ipa NUMERIC IPA The IPA
ipl NUMERIC IPL The IPL
ips NUMERIC IPS The IPS
lead_actions_new TEXT Lead Actions New The Lead Actions New
lead_actions_returning TEXT Lead Actions Returning The Lead Actions Returning
lead_attribute_4 TEXT Lead Attribute 4 The Lead Attribute 4
lead_attribute_5 TEXT Lead Attribute 5 The Lead Attribute 5
lead_baseline NUMERIC Lead Baseline The Lead Baseline
lead_origins_direct TEXT Lead Origins Direct The Lead Origins Direct
TEXT Lead Origins Organic Search The Lead Origins Organic Search
TEXT Lead Origins Paid Search The Lead Origins Paid Search
lead_sale_conv_rate PERCENT CVR (Duplicate) Leads to sales conversion rate.
lead_sources_desktop TEXT Lead Sources Desktop The Lead Sources Desktop

Adalyser fields (lead_sources_mobile to tvrs)

ID Type Name Description
lead_sources_mobile TEXT Lead Sources Mobile The Lead Sources Mobile
lead_uplift TEXT Lead Uplift The Lead Uplift
leadcount NUMERIC Lead Count (Sessions Duplicate) The number of leads (sessions).
length TEXT Length The Length
linkkey TEXT Link Key The Link Key
market TEXT Market The Market
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
platform TEXT Platform The Platform
position_text TEXT Position (text) The Position
product TEXT Product name The Product
programme TEXT Programme The Programme
roi PERCENT ROI Return on investment.
roi_rate PERCENT ROI (Duplicate) Return on investment.
sale_attribute_4 TEXT Sale Attribute 4 The Sale Attribute 4
sale_attribute_5 TEXT Sale Attribute 5 The Sale Attribute 5
sale_count NUMERIC Sales Count (Conversions Duplicate) The number of sales (conversions).
sale_origins_direct TEXT Sale Origins Direct The Sale Origins Direct
TEXT Sale Origins Organic Search The Sale Origins Organic Search
TEXT Sale Origins Paid Search The Sale Origins Paid Search
sale_sources_desktop TEXT Sale Sources Desktop The Sale Sources Desktop
sale_sources_mobile TEXT Sale Sources Mobile The Sale Sources Mobile
sale_value_actions_new TEXT Sale Value Actions New The Sale Value Actions New
sale_value_actions_returning TEXT Sale Value Actions Returning The Sale Value Actions Returning
sale_value_attribute_4 TEXT Sale Value Attribute 4 The Sale Value Attribute 4
sale_value_attribute_5 TEXT Sale Value Attribute 5 The Sale Value Attribute 5
sale_value_origins_direct TEXT Sale Value Origins Direct The Sale Value Origins Direct
TEXT Sale Value Origins Organic Search The Sale Value Origins Organic Search
TEXT Sale Value Origins Paid Search The Sale Value Origins Paid Search
sale_value_sources_desktop TEXT Sale Value Sources Desktop The Sale Value Sources Desktop
sale_value_sources_mobile TEXT Sale Value Sources Mobile The Sale Value Sources Mobile
sales_value NUMERIC Sales Value The Sales Value
saleshouse TEXT Sales House The Sales House
sessions NUMERIC Sessions The number of sessions (leads).
source TEXT Source The name of the Windsor connector returning the row
status TEXT Status The Status
time TEXT Time The Time
timezone TEXT Timezone The Timezone
today DATE Today Today's date
tvrs NUMERIC TVRS The TVRs

Adalyser fields (type to year_week_iso)

ID Type Name Description
type TEXT Type The Type
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).
weekstart TEXT Week Start The Week Start
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