The membership model includes information of users in your Thanx database.Documentation Index
Fetch the complete documentation index at: https://docs.thanx.com/llms.txt
Use this file to discover all available pages before exploring further.
SFTP Exports
Sample memberships.csv
Thanx Connex
Table name:
membershipsAttributes
| 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. |