How Affiliate Data Export Works
The Sales report in Analytics lists your affiliates with their referrals, sales, and commission for a chosen date range. You can download that list as a CSV for accounting, performance reviews, or payout preparation.
The file contains one row per selected affiliate. Referrals, new-customer figures, sales, and commission in the CSV match the date range on the report. Affiliate name, email, group, discount code, and date approved are the affiliate's current details.
How to Export Affiliate Data
Open Analytics. In Simple Affiliate, go to Analytics.
Open the Sales report. Select the Sales tab. This is not the Sales (legacy) tab.
Set the date range. The report defaults to Last 90 days. Change Date if you need a different window. Referrals, sales, and commission in the CSV use this range.
Choose affiliate status. Click the filter icon and set Affiliate status:
Active (default): affiliates with positive net sales in the selected date range.
All: every active affiliate, including those with no sales in the range.
Inactive: active affiliates with zero net sales in the range.
Select affiliates. Click the checkbox above the affiliate list to select the affiliates on the current page, or click Select all to include every affiliate that matches your filters.
Export. Click Export to CSV at the top right of the affiliate list. Your browser downloads a file named like
affiliate_sales_YYYY-MM-DD_HHMMSS.csv.
CSV Columns
Each row is one selected affiliate. Money values use two decimal places in the store currency. 1st-time customer is a whole-number percentage (0–100), not a 0–1 fraction.
Column | What it contains |
Affiliate Name | Affiliate first and last name |
Affiliate Email | Affiliate email address |
Date Approved | Date the affiliate was approved, in the store timezone (for example, Jan 15, 2026). Blank if the affiliate has no approval date |
Group | Current group name. Blank if the affiliate is not in a group |
Code | Affiliate discount code. Blank if the affiliate has no code |
Referrals | Confirmed referrals in the selected date range |
New customers | Confirmed first-time customer referrals in the selected date range |
1st-time customer | New customers divided by referrals, as a rounded percentage. 0 when there are no referrals |
New customer sales | Net sales from new-customer referrals in the selected date range |
Total Sales | Total net sales from confirmed referrals in the selected date range |
Total Commission | Total commission earned from confirmed referrals in the selected date range |
Currency | Store currency (for example, USD) |
Important Rules to Remember
Date range: Referrals, new customers, sales, and commission are for the selected date range only. Name, email, group, code, and date approved are current affiliate details.
Selection: The CSV includes only the affiliates you selected. Use Select all when you need everyone who matches the current filters, not only the current page.
Active vs All: Active limits the list to affiliates with positive net sales in the range. All includes active affiliates who did not generate sales in that window.
Affiliate-level vs referral-level: This export is one row per affiliate. For one row per referral, including commission and referral status, see How to view and export referrals.
What Happens Next?
Open the CSV in Excel or Google Sheets to sort, chart, or import the data into your accounting software.