SFTP
Flip.to can be configured to export data daily via SFTP, which you can use to import the data to your CRM on an automated schedule.
To get started, reach out to our Customer Success team and have the following details ready:
SFTP server address
Port number
User credentials
Preference for target folder, otherwise data will be placed in an "Import" folder
Advocacy Data
Advocacy data will be provided in a CSV file, named using the following format:
yyyy-MM-ddTHH:MM:SS__advocacy.csv for instance, 2024-03-28T10-00-18__advocacy.csv.
| Field | Type | Description |
|---|---|---|
property-id | Guid | Flip.to property ID |
first | Text | The user's first name |
last | Text | The user’s last name |
Email address | The user's email address | |
create-date | DateTime | The date/time the user has signed up |
language-code | Text | The ISO 639-1 Code for the language. For instance, English will be represented by |
is-privacy-restricted | Boolean | True if the user is part of GDPR, or False otherwise |
category | Text | The category (friend or anonymous) of the user |
is-incentive-requested | Boolean | True if the user has requested an incentive, or False otherwise |
opt-out | DateTime | If the user has opted out, the date & time they have made that request |
campaign | Text | The name of the Flip.to campaign the user was part of |
Advocacy data is available 30 days after the user shared their contact information. This window is reserved for the platform to complete the remainder of the user journey.
All data is screened to ensure a clean list—users who unsubscribed, whose emails have bounced or who are covered by privacy regulations (GDPR, CCPA, etc.) will be excluded.
Example of Advocacy data
| property-id | first | last | create-date | language-code | is-privacy-restricted | category | is-incentive-requested | opt-out | campaign | |
|---|---|---|---|---|---|---|---|---|---|---|
30c030eb-5b53-435e-9178-4db6d8c852df | John | Smith | john@email.com | 2023-02-26T00:10:01.5143306 | en | FALSE | Friend | TRUE |
| Pre-Stay - Default variation |
30c030eb-5b53-435e-9178-4db6d8c852df | Larry | Jones | larry@email.com | 2023-02-26T00:20:55.7643191 | en | FALSE | Friend | TRUE |
| Photo Contest |
878bced6-1620-495e-98ce-79b1c1395f90 | Mary | Jane | mary@email.com | 2023-02-26T00:24:55.5968445 | en | FALSE | Friend | TRUE |
| Homepage |
Discovery Data
The Discovery data will be exported as a CSV, named using the following format:
yyyy-MM-ddTHH:MM:SS__discovery.csv, for instance 2024-03-28T10-00-58__discovery.csv.
| Field | Type | Description |
|---|---|---|
property-id | Guid | Flip.to property ID |
create-date | DateTime | The date/time the user has signed up |
first | Text | The user's first name |
Email address | The user's email address | |
adults | Number | The number of adults, if any, the user has selected in ther plan |
children | Number | The number of children, if any, the user has selected in their plan |
arrival | Date | The date that the user intends to arrive. |
departure | Date | The date that the user intends to depart. |
promo-code | Text | The promo code, if any, that the user has added |
language-code | Text | The ISO 639-1 Code for the language. For instance, English will be represented by |
is-guest | Boolean | True if the user made a reservation, False otherwise |
is-privacy-restricted | Boolean | True if the user is part of GDPR, or False otherwise |
opt-out | DateTime | If the user has opted out, the date & time they have made that request |
interests | Text | A comma delimited string with list of user interests |
Discovery data is available 10 days after the user shared their contact information. This window is reserved for the platform to complete the remainder of the user journey.
All data is screened to ensure a clean list—users who unsubscribed, whose emails have bounced or who are covered by GDPR will be excluded.
Example of Discovery data
| property-id | create-date | first | adults | children | arrival | departure | promo-code | language-code | is-guest | is-privacy-restricted | opt-out | interests | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
dcb6ff4e-8a32-4248-ac7f-328dd320ca8e | 2024-02-09T00:08:05.0250466 | John | john@email.com | 2 | 0 | 2024-05-31 | 2024-06-02 |
| en | FALSE | FALSE |
|
|
dcb6ff4e-8a32-4248-ac7f-328dd320ca8e | 2024-02-09T00:08:16.8457396 | Linda | linda@email.com | 2 | 1 | 2024-02-27 | 2024-03-02 |
| en | FALSE | FALSE | 2024-02-11T17:07:00 |
|
878bced6-1620-495e-98ce-79b1c1395f90 | 2024-02-09T00:21:48.6920241 | Debra | debra@email.com | 3 | 2 | 2024-06-28 | 2024-07-05 |
| en | FALSE | FALSE |
| alcohol|art|happy_hour|local_gem|social |
1a286873-6c57-4cb9-abe2-cf4621622330 | 2024-02-09T00:22:24.7366345 | Joe | joe@email.com | 4 | 0 | 2024-07-19 | 2024-07-22 |
| en | FALSE | FALSE |
| costume_cosplay|dont_miss|festival|literature|offbeat |
Last updated