List Export Variable Glossary

Welcome to our new Audience pages! Please take our brief survey at the bottom of this page.

For any list, you can export any or all user variable data into a downloadable CSV file by clicking the spreadsheet icon on its row within the Lists page and selecting from the available options. For more information and instructions, see Export Lists and User Profile Data.

Below is a glossary of all the default field names you’ll find in the CSV; the header names for each column correspond to the internal variables stored on every user’s “profile” object. These field names (below) are the default Sailthru-tracked variables. All other column headers that follow are external, custom variables that you have set on the user.

Clicks - The total number of clicks

Domain - The domain for user

Email Hash - The hashed email of the user; this only appears if you don’t have PII enabled

Email Message - If there was a failure in delivery (soft or hard-bounce), this was the response returned to Sailthru

Email Status – The email’s status (e.g. delivered, hard-bounced, soft-bounced)

Email Status Time – If there was a failure in delivery (soft or hard-bounce), this was the time Sailthru received the delivery response

Engagement  – The user’s current engagement level

First Purchase Time – The date and time that the user first made a purchase

Geolocation City – The geolocated city of the user

Geolocation Country - The geolocated country of the user

Geolocation State – The geolocated state of the user

Geolocation Zip - The geolocated zip code (if applicable)

Largest Purchase Item Price – The largest purchase item price

Last Click - Date and time that the user last clicked a message

Last Open - Date and time that the user last opened a message

Last Pageview - Date and time that the user last viewed a page

Last Purchase Time – The date and time of the latest purchase

Lifetime Message - Total count of messages sent to this user of their lifetime

List Signup - The date and time that the user signed up to the specific list that was exported

Lists  – All the lists that the user is currently signed up to

Opens - The total number of opens

Optout Time - The date and time that the user opted out

Pageviews - The total number of pageviews

Profile Created  – The date and time the user’s profile was created in the system

Profile Id - The internal Sailthru ID for the user

Purchase Count – The number of purchases made by the user

Purchase Incomplete – The number of current incomplete purchases

Purchase Price – The user’s total revenue to date. Note that the figure uses 4 decimal point notation, as does the Purchase API (i.e. $99 would be 9900)

Signup - The date and time the user was signed up to their first list

Top Device – The user’s most often used device

Top