Create and Manage SFTP Audience Destinations

Create an SFTP Audience Destination to export data to an existing SFTP location.

Note: Only users with admin or creator roles can create and manage audience destinations.

Create an SFTP Audience Destination (Default Authentication)

  1. In MXO, go to Analyze > Audience Destinations.
  2. Click + Create.
  3. Enter a unique name for your new destination. For example, BI Reporting.
  4. Optionally, provide a description for your new destination.
  5. Select SFTP from the Destination drop-down.
  6. Select the format in which you want to share the data. Choose one of the following:
    • CSV
    • JSON
    • Data Export v8
  7. Provide the following details about the SFTP server:
    FieldDescription
    ServerURL or IP Address of the SFTP server with which you want to share audience data. For example, ftp-oneserver.emea.cloudapp.azure.com.
    PortSFTP port number. Typically, either 21 (TCP) or 22 (SSH).
    PathLocation in which to store data, relative to root. For example, /www.
    UsernameUsername required to access the SFTP server.
    Access TypeChoose Password and enter the password required to access the SFTP server.

  8. If you selected CSV or JSON format, choose which attributes to share with this destination. Choose either:

    • All attributes. Go to step 12.

    • Specific attributes. Go to step 9.

  9. Click + (add).

  10. Choose the attributes to share and click Select.
    Note: The TID is the only attribute that is always included in the export.
  11. If required, drag and drop the attributes in the preferred order for sharing.
  12. Click Save to finish the creation process.

Once your audience destination is configured, you can start sharing audience data.

Example SFTP Configuration (Default Authentication)

TB - FTP config details

Create an SFTP Audience Destination (SSH Authentication)

  1. In MXO, go to Analyze > Audience Destinations.
  2. Click + Create.
  3. Enter a unique name for your new destination. For example, BI Reporting.
  4. Optionally, provide a description for your new destination.
  5. Select SFTP from the Destination drop-down.
  6. Select the format in which you want to share the data. Choose one of the following:
    • CSV
    • JSON
    • Data Export v8
  7. Provide the following details about the SFTP server:
    FieldDescription
    ServerURL or IP Address of the SFTP server with which you want to share audience data. For example, ftp-oneserver.emea.cloudapp.azure.com.
    PortSFTP port number. Typically, either 21 (TCP) or 22 (SSH).
    PathLocation in which to store data, relative to root. For example, /www.
    UsernameUsername required to access the SFTP server.
    Access TypeChoose SSH and enter the following details:

    • Host Key. Host public key required to authenticate to the SFTP server.

    • Private Key. Client (user) private key required to authenticate to the SFTP server.

    • Passphrase. Passphrase associated with the client private key. Required only if the client private key was encrypted with a passphrase during initial setup.

  8. If you selected CSV or JSON format, choose which attributes to share with this destination. Choose either:

    • All attributes. Go to step 12.

    • Specific attributes. Go to step 9.

  9. Click + (add).

  10. Choose the attributes to share and click Select.
  11. If required, drag and drop the attributes in the preferred order for sharing.
  12. Click Save to finish the creation process.
Once your audience destination is configured, you can start sharing audience data.
Note: If unable to validate the credentials you provide during the creation process, MXO displays an error message to help with troubleshooting.

Example SFTP Configuration (SSH Authentication)

TB - FTP SSH config details

Edit an Audience Destination

To edit an audience destination, follow these steps:

  1. In MXO, go to Analyze > Audience Destinations.

  2. Find the desired audience destination in the list and click the edit icon edit icon to the right.

  3. Edit the audience destination as required.

  4. Click Save to finish the editing process.

Delete an Audience Destination

To delete an audience destination, follow these steps:

  1. In MXO, go to Analyze > Audience Destinations.

  2. Find the desired audience destination in the list and click the delete icon delete icon to the right.

  3. Click Delete to complete the deletion process.