Members

The Members file contains information about all your loyalty program's members.

Delta export. Each daily file contains member profiles created or updated during that day. Upsert on memberId and keep the row with the latest updatedAt.

File: analytics/Members/members_YYYY_MM_DD.csv Primary key: memberId

A sample file is provided below:

members_all_until_2025_09_16.csv

92KB

Open

Available Data:

Column	Type	Can be empty	Description
memberId	uuid	No	Unique member ID
tenantId	uuid	No	ID of the tenant where the member was created
active	boolean	Empty = false	Whether the member is active
channelId	—	—	ID of the assigned channel
channelIdentifier	—	—	Identifier of the assigned channel
firstName	string	Yes	Member's first name
lastName	string	Yes	Member's last name
gender	—	—	Member's gender
email	string	Yes	Member's email address
phone	string	Yes	Member's phone number
birthDate	—	—	Member's date of birth
lastLevelRecalculation	—	—	Date of the member's last tier recalculation
address	—	—	Member's address details
loyaltyCardNumber	—	—	Member's loyalty card number
createdAt	datetime	No	Date when the member was created
updatedAt	datetime	No	Date when the member was last updated
levelId	—	—	ID of the member's tier
manuallyAssignedLevelId	—	—	ID of the manually assigned tier
agreement1	—	—	Whether the member accepted the basic legal agreement
agreement2	—	—	Whether the member accepted the marketing agreement
agreement3	—	—	Whether the member accepted the data-processing agreement
company	—	—	Member's company details
transactionsCount	—	—	Number of member transactions
transactionsAmount	—	—	Total gross value of member transactions
transactionsAmountWithoutDeliveryCosts	—	—	Total transaction value without delivery costs
transactionsAmountExcludedForLevel	—	—	Transaction value excluded from tier calculations
averageTransactionAmount	—	—	Average value of member transactions
lastTransactionDate	—	—	Date of the last member transaction
firstTransactionDate	—	—	Date of the first member transaction
levelAchievementDate	—	—	Date of the last tier upgrade or downgrade
referrerMemberId	—	—	Member ID of the referrer
labels	—	—	Custom attributes set for the member
anonymized	—	—	Whether the member data has been anonymized
referralToken	—	—	Unique member referral token
currency	string	Yes	Currency used for member transactions
storeCode	—	—	Code of the tenant where the member was created
currentLevel	—	—	ID and name of the member's tier
registeredAt	—	—	Registration date. Defaults to createdAt when omitted.
deletedAt	datetime	Yes	Date when the member was deleted
customFields	json object	Yes	Values of profile custom fields
defaultAccount	json object	Yes	Default wallet balance: accountId, activePoints, earnedPoints, spentPoints, lockedPoints, expiredPoints, blockedPoints, and transferredPoints

Deleted members are not exported by default. If you want to have it enabled for your environment, please contact Open Loyalty support team.

defaultAccount, currentLevel, and the transactions* aggregates are captured when the member row is exported. A balance change or a new transaction does not by itself put the member into the next day's file, so these values can be several days old. For balances across every wallet, use the Wallet Balance snapshot. For tier changes, use Member Tier Changes.