The membership model includes information of users in your Thanx database.

SFTP Exports

Sample memberships.csv

Thanx Connex

Table name: memberships

Attributes

ColumnData TypeDescription
merchant_idstringThe unique identifier of the merchant in Thanx.
user_idstringThe unique identifier of the user in Thanx.
signup_program_idstringThe unique identifier of the program that resulted in a user creating an account.
first_namestringThe user’s first name.
last_namestringThe user’s last name.
emailstringThe user’s email address.
birthdaystringThe user’s birthday. This is formatted as MM/DD.
zip_codenumberThe user’s zip code.
tier_statusstringThe 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_joinedbooleanDid the user has joined the loyalty program.
has_registered_cardbooleanDid the user registered a credit card.
is_signup_merchantbooleanDid the user sign up to this merchant (rather than having a previously created account)
user_joined_attimestampThe date the user created an account. This is in UTC.
user_entered_crm_attimestampThe date the user was added to the database, regardless of whether they joined the loyalty program. This is in UTC.
email_last_opened_attimestampThe date this user last opened an email. This is in UTC.
merchant_uidstringThe unique identifier for the merchant in Thanx APIs.
user_uidstringThe unique identifier for the user in Thanx APIs.