Sotto configures and runs this export internally on your behalf. To set one up, contact support@withsotto.com with your destination SFTP details, desired file format (CSV or JSON), and schedule. The schema below describes the output you receive.
What’s included
Each exported user record contains three categories of data: profile fields, custom data fields, and segment membership. The custom data and segment columns reflect your current configuration at export time.Profile fields
Custom data fields
Each configured custom data field appears as its own column. Column names are derived from the field name by prependingcustom_, lowercasing, trimming whitespace, and replacing spaces with underscores.
Example: “Favorite Hobby” becomes custom_favorite_hobby.
Custom fields default to
null (blank) when no value is set.
Segment membership
Each segment appears as a boolean column named{segment_id}-{segment_name}, where the name is lowercased, trimmed, and has spaces replaced with underscores.
Example: segment 123 named “California Residents” becomes 123-california_residents. The value is true if the user is in the segment, otherwise false.