Members

Export the full member list as a CSV file — useful for reporting, backups, or reconciling with an external CRM.

File format: CSV

Sample CSV file

Members Sample Export.csv

12KB

Open

Field reference

The export contains 36 columns, listed below in the order they appear in the file. Every member in your program is exported as a single row, regardless of whether the member is active or anonymized.

Field	Description
memberId	Unique Open Loyalty identifier (UUID) of the member
tenantId	Identifier (UUID) of the tenant the member belongs to
active	1 if the member account is active, empty if inactive
channelId	Identifier of the channel the member was registered in, if channels are used
firstName	First name
lastName	Last name
gender	male, female, or not_disclosed
email	Member's email address
phone	Phone number, including country code
birthDate	Date of birth, in ISO 8601 format with time and offset (for example 1994-10-25T00:00:00+01:00)
lastLevelRecalculation	Timestamp of the last tier recalculation for this member (for the default tier set)
address	Address as a JSON object with the keys street, address1, address2, province, city, and postal. Exported as [] when no address is stored
loyaltyCardNumber	Loyalty card identifier
createdAt	Timestamp the member record was created in Open Loyalty
updatedAt	Timestamp of the most recent change to the member record
levelId	Identifier (UUID) of the tier the member currently belongs to (for the default tier set)
manuallyAssignedLevelId	Identifier (UUID) of the tier assigned manually by an admin (for the default tier set). Empty when the tier was granted automatically by the program rules
agreement1	Marketing consent flag — 1 if granted, empty if not
agreement2	Marketing consent flag — 1 if granted, empty if not
agreement3	Marketing consent flag — 1 if granted, empty if not
company	Company data as a JSON object (name and tax ID). Exported as [] when no company data is stored
transactionsCount	Total number of transactions registered for the member
transactionsAmount	Total value of the member's transactions
transactionsAmountWithoutDeliveryCosts	Total transaction value with delivery costs excluded
transactionsAmountExcludedForLevel	Portion of the transaction value excluded from tier calculation
averageTransactionAmount	Average value per transaction
lastTransactionDate	Date of the member's most recent transaction
firstTransactionDate	Date of the member's first transaction
levelAchievementDate	Date the member reached their current tier (for the default tier set)
referrerMemberId	Identifier (UUID) of the member who referred this member, if any
labels	Labels as a JSON array of key–value pairs, for example [{"key":"served","value":"yes"}]. Exported as an empty value when the member has no labels
anonymized	1 if the member has been anonymized, empty otherwise
referralToken	The member's unique referral code
currency	Currency used for the member's transaction values
storeCode	Code of the store the member is assigned to
registeredAt	Registration timestamp. Can differ from createdAt when the registration date was set explicitly during an import or via the API

Reading the values

• All timestamps are exported in ISO 8601 format with a timezone offset, for example 2024-10-04T09:15:30+02:00.

• Boolean fields (active, agreement1/2/3, anonymized) use 1 for true and an empty cell for false.

• address, company, and labels hold structured JSON inside a single CSV cell. If you open the file in a spreadsheet editor, keep the column as text so the JSON is not reformatted.

• Empty cells mean the field is not filled in for that member — they are not removed from the file.

If you plan to re-import this file elsewhere (e.g., via Member Segments), make sure you keep a consistent identifier column — email, phone, or loyalty card number — and don't mix identifier types within the same file.