Export Columns

Customer Columns

Column	Contents
Customer ID	WordPress user ID. Blank for guests
Customer Type	Registered or Guest
First Name / Last Name	Billing first and last name
Full Name	First and last name together. Falls back to the account's display name if both are empty
Email	Billing email (or the account email if no billing email is saved)
Phone	Billing phone
Company	Billing company
Address Line 1 / Address Line 2	Billing street address
City	Billing town / city
County / State	Billing county or state
Postcode	Billing postcode / ZIP
Country	Full country name, e.g. United Kingdom (UK)
Date Registered	When the account was created. Blank for guests

Order & Spend Columns

All of these only count orders that match your date range and order statuses.

Column	Contents
Order Count	Number of matching orders
Total Spent	Sum of order totals, minus refunds. A plain number using your store's decimal places, no currency symbol
Average Order Value	Total Spent divided by Order Count
First Order Date	Date of their earliest matching order
Last Order Date	Date of their most recent matching order

Dates are written as YYYY-MM-DD HH:MM in your site's timezone, which sorts correctly in any spreadsheet.

YetiRaffles Column

Column	Contents
Promo Sign-up	The name of the YetiRaffles promo competition the customer signed up through. Blank if they didn't, or if YetiRaffles isn't installed

Where Contact Details Come From

1. YetiExport starts with the billing details from the customer's most recent matching order
2. For registered customers, any billing details saved on their account (Users > Edit or My Account > Addresses) take priority, as these are usually the most up to date

Empty account fields never overwrite details from an order, so you always get the most complete record available.

Need Help?

If you have questions or need assistance, check out our Troubleshooting Guide or FAQ.