SFTP Exports
Sample memberships.csv
Thanx Connex
Table name:
membershipsAttributes
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.