ShareASale Field Reference


Fields

IDTypeNameDescription
account_idTEXTAccount IDSame as affiliate_id
account_nameTEXTAccount NameSame as affiliate
affiliateTEXTAffiliateThe Affiliate Name
affiliate_idTEXTAffiliateIDThe Affiliate ID
averageorderNUMERICAverage OrderThe Average Order Value
bonuscommissionsNUMERICBonus CommissionsThe Bonus Commissions
campaignTEXTCampaignSame as affiliate
clicksNUMERICClicksThe Number of Clicks
commissionsNUMERICCommissionsThe Number of Commissions
conversionNUMERICConversionThe Conversion Rate
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
day_of_monthTEXTDay of monthDay of the month
epcNUMERICEPCThe Earnings Per Click
grosssalesNUMERICGrossSalesThe Gross Sales
impressionsNUMERICImpressionsThe Number of Impressions
leadcommissionsNUMERICLead CommissionsThe Lead Commissions
leapfrogcommissionsNUMERICLeap Frog CommissionsThe Leap Frog Commissions
manualcreditsNUMERICManual CreditsThe Number of Manual Credits
monthTEXTMonthNumber of the month
netsalesNUMERICNet SalesThe Net Sales
numbbonusesNUMERICNumb BonusesThe Number of Bonuses
numberofsalesNUMERICNumber of SalesThe Number of Sales
numbleadsNUMERICNumb LeadsThe Number of Leads
numbleapfrogNUMERICNumb Leap FrogThe Number of Leap Frog
numbpaypercallNUMERICNumb Pay Per CallThe Number of Pay Per Call
numbsalesNUMERICNumb SalesThe Number of Sales (Duplicate)
numbtwotierNUMERICNumb Two TierThe Number of Two Tier
organizationTEXTOrganizationThe Organization
paypercallcommissionsNUMERICPay Per Call CommissionsThe Pay Per Call Commissions
salecommissionsNUMERICSale CommissionsThe Sale Commissions
sourceTEXTSourceThe name of the Windsor connector returning the row
spendNUMERICSpendSame as commissions
todayDATETodayToday's date
totalcostNUMERICTotal CostSame as commissions
transactionfeesNUMERICTransaction FeesThe Transaction Fees
twotiercommissionsNUMERICTwo Tier CommissionsThe Two Tier Commissions
voidsNUMERICVoidsThe Number of Voids
websiteTEXTWebsiteThe Website
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