Skip to main content
The membership model includes information of users in your Thanx database.

SFTP Exports

Sample memberships.csv

Thanx Connex

Table name: memberships

Attributes

Signup Location

signup_location uses the current location name, or an available address if the name is missing. It is NULL when neither is available. A location ID can still be present without a label. signup_location_id corresponds to location_id in Purchases and Locations. The attribution method describes location evidence, rather than the signup channel. Current methods and certainty levels are: Attribution depends on retained evidence, which may be incomplete. Once a method other than Unknown is assigned, incremental updates do not automatically replace it. An Unknown result can resolve when an eligible purchase with a known location becomes available.

Registered Device

had_registered_device is true when a qualifying registration is retained for the program’s native app. It does not confirm a current installation, push reachability, or recent activity. false means no qualifying registration is retained; it does not mean the user never installed or used the app.

Favorite Location

favorite_location contains one distinct, nonblank captured preference. It is NULL when no preference or multiple distinct preferences are available. This text may differ from the current location name. favorite_location_id is populated only when that text uniquely and exactly matches a current location label. Otherwise, it is NULL. The text can remain when the ID is NULL; a current match does not establish the location’s historical identity.