Members

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

A sample file is provided below:

92KB

members_all_until_2025_09_16.csv

Available Data:

• memberId: Unique ID of the member

• tenantId: ID of the tenant where the member was created

• active: Status indicating if the member is active (true = 1 / false = null)

• channelId: ID of the channel the member is assigned to

• channelIdentifier: Identifier of the channel the member is assigned to

• firstName: Member's first name

• lastName: Member's last name

• gender: Member's gender

• email: Member's email address

• phone: Member's phone number

• birthDate: Member's date of birth

• lastLevelRecalculation: Date of the last recalculation of the member's tier

• address: Member's address details

• loyaltyCardNumber: Member's loyalty card number

• createdAt: Date when the member was created

• updatedAt: Date when the member was last updated

• levelId: ID of the tier the member is in

• manuallyAssignedLevelId: ID of the tier the member has been manually assigned to

• agreement1: Status indicating if the member agreed to the basic legal agreement (true = 1 / false = null)

• agreement2: Status indicating if the member agreed to the marketing agreement (true = 1 / false = null)

• agreement3: Status indicating if the member agreed to the data processing agreement (true = 1 / false = null)

• company: Member's company details

• transactionsCount: Number of transactions placed by the member

• transactionsAmount: Total gross value of the transactions placed by the member

• transactionsAmountWithoutDeliveryCosts

• transactionsAmountExcludedForLevel

• averageTransactionAmount: Average value of all transactions placed by the member

• lastTransactionDate: Date of the last transaction placed by the member

• firstTransactionDate: Date of the first transaction placed by the member

• levelAchievementDate: Date of the last upgrade or downgrade of the member's tier

• referrerMemberId: Member ID of the member's referrer

• labels: Custom attributes set for the member

• anonymized: Status indicating if the member's data has been anonymized (true = 1 / false = null)

• referralToken: Unique referral token of the member

• currency: Currency in which the member places transactions

• storeCode: Code of the tenant where the member was created

• currentLevel: ID and name of the tier the member is in

• registeredAt: Date when the member was registered (if not specified, it will be the same date as createdAt date)

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

• deletedAt: Date when the member was deleted

• customFields: Values of the custom fields defined for the member profiles

Please note the default wallet balance details are exported only upon the change in the member's details, not each time the default balance changes.

• defaultAccount: Balance of the member's default wallet