Windsor brings all your ShareASale data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
ShareASale Field Reference

Fields
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 |
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 |
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 |
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_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 |