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	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 'en', Spanish will be represented by 'es', etc.
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	email	create-date	language-code	is-privacy-restricted	category	is-incentive-requested	opt-out	campaign
30c030eb-5b53-435e-9178-4db6d8c852df	John	Smith	[e-mail]	2023-02-26T00:10:01.5143306	en	FALSE	Friend	TRUE		Pre-Stay - Default variation
30c030eb-5b53-435e-9178-4db6d8c852df	Larry	Jones	[e-mail]	2023-02-26T00:20:55.7643191	en	FALSE	Friend	TRUE		Photo Contest
878bced6-1620-495e-98ce-79b1c1395f90	Mary	Jane	[e-mail]	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	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 'en', Spanish will be represented by 'es', etc.
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	email	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	[e-mail]	2	0	2024-05-31	2024-06-02		en	FALSE	FALSE
dcb6ff4e-8a32-4248-ac7f-328dd320ca8e	2024-02-09T00:08:16.8457396	Linda	[e-mail]	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	[e-mail]	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	[e-mail]	4	0	2024-07-19	2024-07-22		en	FALSE	FALSE		costume_cosplay|dont_miss|festival|literature|offbeat