> For the complete documentation index, see [llms.txt](https://docs.flip.to/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.flip.to/docs/integrations/crms/sftp.md).

# 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](/docs/support/customer-success.md) 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.

<table><thead><tr><th width="218">Field</th><th width="159">Type</th><th>Description</th></tr></thead><tbody><tr><td>property-id</td><td>Guid</td><td>Flip.to property ID</td></tr><tr><td>first</td><td>Text</td><td>The user's first name</td></tr><tr><td>last</td><td>Text</td><td>The user’s last name</td></tr><tr><td>email</td><td>Email address</td><td>The user's email address</td></tr><tr><td>create-date</td><td>DateTime</td><td>The date/time the user has signed up</td></tr><tr><td>language-code</td><td>Text</td><td>The ISO 639-1 Code for the language. For instance, English will be represented by <code>'en'</code>, Spanish will be represented by <code>'es'</code>, etc.</td></tr><tr><td>is-privacy-restricted</td><td>Boolean</td><td>True if the user is part of GDPR, or False otherwise</td></tr><tr><td>category</td><td>Text</td><td>The category (friend or anonymous) of the user</td></tr><tr><td>is-incentive-requested</td><td>Boolean</td><td>True if the user has requested an incentive, or False otherwise</td></tr><tr><td>opt-out</td><td>DateTime</td><td>If the user has opted out, the date &#x26; time they have made that request</td></tr><tr><td>campaign</td><td>Text</td><td>The name of the Flip.to campaign the user was part of</td></tr></tbody></table>

{% hint style="info" %}
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.
{% endhint %}

### Example of Advocacy data

<table data-full-width="true"><thead><tr><th width="239">property-id</th><th>first</th><th>last</th><th width="165">email</th><th width="128">create-date</th><th>language-code</th><th width="187">is-privacy-restricted</th><th width="110">category</th><th width="199">is-incentive-requested</th><th width="87">opt-out</th><th>campaign</th></tr></thead><tbody><tr><td>30c030eb-5b53-435e-9178-4db6d8c852df</td><td>John</td><td>Smith</td><td>john@email.com</td><td>2023-02-26T00:10:01.5143306</td><td>en</td><td>FALSE</td><td>Friend</td><td>TRUE</td><td><br></td><td>Pre-Stay - Default variation</td></tr><tr><td>30c030eb-5b53-435e-9178-4db6d8c852df</td><td>Larry</td><td>Jones</td><td>larry@email.com</td><td>2023-02-26T00:20:55.7643191</td><td>en</td><td>FALSE</td><td>Friend</td><td>TRUE</td><td><br></td><td>Photo Contest</td></tr><tr><td>878bced6-1620-495e-98ce-79b1c1395f90</td><td>Mary</td><td>Jane</td><td>mary@email.com</td><td>2023-02-26T00:24:55.5968445</td><td>en</td><td>FALSE</td><td>Friend</td><td>TRUE</td><td><br></td><td>Homepage</td></tr></tbody></table>

## 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                                                                                  |

{% hint style="info" %}
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.
{% endhint %}

### Example of Discovery data

<table data-full-width="true"><thead><tr><th width="153">property-id</th><th width="137">create-date</th><th>first</th><th width="168">email</th><th>adults</th><th>children</th><th width="123">arrival</th><th width="135">departure</th><th width="126">promo-code</th><th width="107">language-code</th><th>is-guest</th><th width="189">is-privacy-restricted</th><th width="128">opt-out</th><th>interests</th></tr></thead><tbody><tr><td>dcb6ff4e-8a32-4248-ac7f-328dd320ca8e</td><td>2024-02-09T00:08:05.0250466</td><td>John</td><td>john@email.com</td><td>2</td><td>0</td><td>2024-05-31</td><td>2024-06-02</td><td><br></td><td>en</td><td>FALSE</td><td>FALSE</td><td><br></td><td><br></td></tr><tr><td>dcb6ff4e-8a32-4248-ac7f-328dd320ca8e</td><td>2024-02-09T00:08:16.8457396</td><td>Linda</td><td>linda@email.com</td><td>2</td><td>1</td><td>2024-02-27</td><td>2024-03-02</td><td><br></td><td>en</td><td>FALSE</td><td>FALSE</td><td>2024-02-11T17:07:00</td><td><br></td></tr><tr><td>878bced6-1620-495e-98ce-79b1c1395f90</td><td>2024-02-09T00:21:48.6920241</td><td>Debra</td><td>debra@email.com</td><td>3</td><td>2</td><td>2024-06-28</td><td>2024-07-05</td><td><br></td><td>en</td><td>FALSE</td><td>FALSE</td><td><br></td><td>alcohol|art|happy_hour|local_gem|social</td></tr><tr><td>1a286873-6c57-4cb9-abe2-cf4621622330</td><td>2024-02-09T00:22:24.7366345</td><td>Joe</td><td>joe@email.com</td><td>4</td><td>0</td><td>2024-07-19</td><td>2024-07-22</td><td><br></td><td>en</td><td>FALSE</td><td>FALSE</td><td><br></td><td>costume_cosplay|dont_miss|festival|literature|offbeat</td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.flip.to/docs/integrations/crms/sftp.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.