Models
Memberships
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. |