# Members

The Members file contains information about all your loyalty program's members.&#x20;

A sample file is provided below:

{% file src="/files/Llk4DtS1wxd3Xk6D7p3P" %}

**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)

{% hint style="warning" %}
**Deleted members** are not exported by default. If you want to have it enabled for your environment, please contact Open Loyalty support team.
{% endhint %}

* **deletedAt:** Date when the member was deleted
* **customFields**: Values of the custom fields defined for the member profiles

{% hint style="danger" %}
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.
{% endhint %}

* **defaultAccount**: Balance of the member's default wallet


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.openloyalty.io/technical-guide/data-exports/data-structure-and-types/members.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
