LogoLogo
HomepageCase studiesBook a demo
Technical Guide
Technical Guide
  • Introduction
  • Getting Started Guide
    • Authentication
    • Member Registration Configuration
    • Add Webhook
    • Add Member
    • Create Campaign
    • Add Transaction
    • Add Custom Event Schema
    • Create Achievement
    • Add Custom Event
  • Terms Reference
  • Backward Compatibility Policy
  • API Reference
  • Postman Collection
  • User Guide
  • Integration
    • Introduction
    • Overview of Integration Methods
    • Tools and Technologies
    • Integration Examples
      • Lambda
      • Zapier
      • AWS EventBridge
      • Kafka
  • API Fundamentals
    • Overview
    • Environments Capabilities
    • How to Query
    • Limits
    • Best Practices
  • Authentication
    • Admin Token
    • Access Token (API Key)
    • Enabling SSO Login
      • Okta
      • Microsoft Entra ID
  • Webhooks
    • Overview
    • Best Practices
  • S3 Bucket Data exports
    • Overview
    • Set Up S3 Bucket Integration
    • Data Structure and Types
      • Achievements
      • Achievement Usage
      • Campaigns
      • Campaign Calculated Effect Result
      • Campaign Execution
      • Custom Events
      • Members
      • Rewards
      • Rewards Redemption
      • Tiers
      • Transactions
      • Tenants
      • Unit Transfers
Powered by GitBook
On this page

Was this helpful?

  1. S3 Bucket Data exports
  2. Data Structure and Types

Members

Last updated 20 days ago

Was this helpful?

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

A sample file is provided below:

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)

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

307KB
members_all_until_2025_03_06.csv