ShareASale Connector Reference

26 metrics26 dimensions

Fields

The ShareASale connector exposes 52 fields (26 metrics, 26 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

ShareASale Fields

The ShareASale connector includes 52 fields.

ShareASale fields (account_id to voids)

ID	Type	Name	Description
account_id	TEXT	Account ID	Same as affiliate_id
account_name	TEXT	Account Name	Same as affiliate
affiliate	TEXT	Affiliate	The Affiliate Name
affiliate_id	TEXT	AffiliateID	The Affiliate ID
averageorder	NUMERIC	Average Order	The Average Order Value
bonuscommissions	NUMERIC	Bonus Commissions	The Bonus Commissions
campaign	TEXT	Campaign	Same as affiliate
clicks	NUMERIC	Clicks	The Number of Clicks
commissions	NUMERIC	Commissions	The Number of Commissions
conversion	NUMERIC	Conversion	The 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_of_month	TEXT	Day of month	Day of the month
epc	NUMERIC	EPC	The Earnings Per Click
grosssales	NUMERIC	GrossSales	The Gross Sales
impressions	NUMERIC	Impressions	The Number of Impressions
leadcommissions	NUMERIC	Lead Commissions	The Lead Commissions
leapfrogcommissions	NUMERIC	Leap Frog Commissions	The Leap Frog Commissions
manualcredits	NUMERIC	Manual Credits	The Number of Manual Credits
month	TEXT	Month	Number of the month
netsales	NUMERIC	Net Sales	The Net Sales
now	TIMESTAMP	Now	Current timestamp
numbbonuses	NUMERIC	Numb Bonuses	The Number of Bonuses
numberofsales	NUMERIC	Number of Sales	The Number of Sales
numbleads	NUMERIC	Numb Leads	The Number of Leads
numbleapfrog	NUMERIC	Numb Leap Frog	The Number of Leap Frog
numbpaypercall	NUMERIC	Numb Pay Per Call	The Number of Pay Per Call
numbsales	NUMERIC	Numb Sales	The Number of Sales (Duplicate)
numbtwotier	NUMERIC	Numb Two Tier	The Number of Two Tier
organization	TEXT	Organization	The Organization
paypercallcommissions	NUMERIC	Pay Per Call Commissions	The Pay Per Call Commissions
salecommissions	NUMERIC	Sale Commissions	The Sale Commissions
source	TEXT	Source	The name of the Windsor connector returning the row
spend	NUMERIC	Spend	Same as commissions
today	DATE	Today	Today's date
totalcost	NUMERIC	Total Cost	Same as commissions
transactionfees	NUMERIC	Transaction Fees	The Transaction Fees
twotiercommissions	NUMERIC	Two Tier Commissions	The Two Tier Commissions
voids	NUMERIC	Voids	The Number of Voids

ShareASale fields (website to year_week_iso)

ID	Type	Name	Description
website	TEXT	Website	The Website
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

API Connectors

ShareASale Connector Reference

ShareASale Fields

ShareASale fields (account_id to voids)

ShareASale fields (website to year_week_iso)