Memberships - Thanx

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

SFTP Exports

Sample memberships.csv

Thanx Connex

Table name: memberships

Attributes

Column	Data Type	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.
`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.
`phone`	`string`	The user’s phone number. This column will be empty unless the SMS opt-in consent was signed and enabled by Thanx staff.
`alternate_pos_id`	`string`	An alternate user identifier sent to certain in-store POS systems when loyalty is applied at the register. Currently only used by the Toast POS integration, where it matches the `APPLIED_LOYALTY_ID` field on Toast POS reports.

Communication Preferences NPS Feedback

⌘I