# How to Export to FTP

> **Note:** FTP exports are a valuable way to deliver your [Data Builder data tables](https://knowledge.powermyanalytics.com/application/tools/data-builder-guide/) to your own FTP or SFTP server. Data exports are available as a paid add-on on the Business, Grow, and Pro plans, and are included with the Custom plan when your negotiated agreement includes data exports. In this article, we will walk you through creating an FTP export, including connecting an FTP destination, choosing your data, scheduling data refreshes, and managing your exports to ensure seamless data transfer.

## Step 1: Create Your Export and Choose the Destination

1. In [your hub](https://hub.powermyanalytics.com/), select **FTP** from the left navigation pane under **Exports**.
2. Click **\+ Create export**. The Create export wizard opens and walks you through four steps: **Destination**, **Data**, **Schedule**, and **Review**.
3. Under **Destination**, select the FTP or SFTP account you'd like to use.

    - If you haven't yet connected your server, click the plus button to add a destination account. Select the type of FTP connection you want to use (**FTP** or **SFTP**), then enter a name for your server, its host (IP address or URL), and your FTP login username and password. Click **Connect**. Once the account is added, return to the wizard and restart the export setup.
4. Choose a **file format** for your exported files: **CSV** or **JSON**.
5. Enter the **Directory Path** you want to use on your FTP server, then click **Next**.

> **Important:** PMA interacts with your FTP server from the IP address **35.188.118.242** (also shown in the Help panel when connecting your server). If your server restricts access by IP, whitelist this address before connecting.

## Step 2: Choose the Data to Export

> **Note:** A **Data Table** is a single table in Data Builder. A **Dataset** groups related data tables. Exporting a whole dataset sends every data table in it.

1. Under **Data table or dataset**, search for and select either a single data table or an entire dataset from Data Builder.
2. Click **Next**.

## Step 3: Set Your Export Schedule

1. Choose a **Refresh period**: **On demand**, **Monthly**, **Weekly**, **Daily**, or **Hourly**.

    - **On demand:** Your export has no schedule and runs only when you run it manually from the exports list. Leave **Run as soon as you create the export** enabled to run the export immediately after you create it.
    - **Monthly:** Choose a day of the month (1 through 28), the hour, and the timezone.
    - **Weekly:** Choose a day of the week, the hour, and the timezone.
    - **Daily:** Choose the hour and the timezone.
    - **Hourly:** Your export runs every hour; no further settings are needed.
2. For scheduled refresh periods, the **Timezone** is required and determines the local wall-clock time at which your export will run. We suggest setting the time for an hour before the start of your workday. Your export will run on this schedule until you pause or delete it.
3. Click **Next**.

> **Note:** Remember: Each scheduled export will overwrite data in the date range of the Data Builder data table.

- To accumulate data over time, choose a date range with an end date of today or yesterday. When you are creating your data table in Data Builder, choose a **Custom Start** option under **Date Range** to accumulate data over time.
- Fixed time frame options like **Last 7 days** will export only the most recent 7 days of data with each refresh. Data from before that period will not be overwritten.

## Step 4: Review and Create Your Export

1. Under **Review**, check the Destination, Data, and Schedule summaries. Click **Edit** on any card to make a change.
2. Click **Create export**. If you selected On demand and left **Run as soon as you create the export** enabled, your export runs immediately.

## Manage Existing Exports

On the Exports to FTP page, click the three-dot action menu at the end of an export's row to **View logs**, **Edit export**, **Pause export**, **Run export now**, or **Delete export**. On demand exports run only when you select **Run export now**.

## FAQ

### What is the source IP?

PMA exports are transmitted via Google Cloud using the IP address **35.188.118.242**, which can be whitelisted. This IP is also shown in the Help panel when you connect your FTP server.

### What is the data format?

You can choose to export in JSON or CSV format. The file format is selected at the Destination step of the Create export wizard.
