Download a sample of the memberships.csv to preview the data.

Fields Description

MERCHANT_ID
string

The unique identifier of the merchant in Thanx.

USER_ID
string

The unique identifier of the user in Thanx.

SIGNUP_PROGRAM_ID
string

The unique identifier of the program that resulted in a user creating an account.

FIRST_NAME
string

The user’s first name.

LAST_NAME
string

The user’s last name.

EMAIL
string

The user’s email address.

BIRTHDAY
string

The user’s birthday. This is formatted as MM/DD.

GENDER
string
deprecated

The user’s gender.

ZIP_CODE
number

The user’s zip code.

TIER_STATUS
string

The user’s current tier status. There are three tiers: Bronze, Silver, and Gold. They are represented by a custom name set by the merchant.

IS_USER_JOINED
boolean

Did the user has joined the loyalty program.

HAS_REGISTERED_CARD
boolean

Did the user registered a credit card.

IS_SIGNUP_MERCHANT
boolean

Did the user sign up to this merchant (rather than having a previously created account)

USER_JOINED_AT
timestamp

The date the user created an account. This is in UTC.

USER_ENTERED_CRM_AT
timestamp

The date the user was added to the database, regardless of whether they joined the loyalty program. This is in UTC.

EMAIL_LAST_OPENED_AT
timestamp

The date this user last opened an email. This is in UTC.

MERCHANT_UID
string

The unique identifier for the merchant in Thanx APIs.

USER_UID
string

The unique identifier for the user in Thanx APIs.