How Do I Set Up an FTP Integration?
Last updated: November 17, 2026
An FTP integration lets your systems drop data files on Ambition's FTP or SFTP server, where they're picked up and processed into metrics. It's a good fit when your source system can export files on a schedule but isn't able to post to a web address.
Required permissions:
The Integrations: Edit permission is required to set up an FTP integration.
Add the FTP Integration
Navigate to Admin --> Data --> Integrations.
On the Available tab, type "FTP" in the Find an integration search box.
Click on Enable next to FTP. The Settings page for the new integration will open.
Fill In the Integration Details
Replace the default name in the Integration Name field with one that names the source system, such as "Phone System Exports".
Add the email address of whoever should hear about file problems in the Admin Email Address field.
Click on Save.
Optional: Once the email is saved, turn on the Admin Notifications toggle so that person is told when no files arrive for a business day.
Add Record Fields to the Data Format Page
Set the Data Formatting Information
Click on Data Format in the integration's side menu.
Choose CSV or JSON under Data Format to match the files your system will export.
Optional: If your JSON files have nested data, flatten it in the JSON Transformer section that will appear.
Under Data Schema, choose Daily Totals if each row in your file is one user's total for one day, or Records if each row is a single activity.
Add Fields That Will Appear on Your Data Files
Edit the starter rows in the Field Mappings table to match your file. Daily Totals starts with email and date rows, and Records starts with an id row.
Click on Add Field Mapping to add a row for every other column in your file.
Type each column header in the Field Key field exactly as it appears in your file, including capitalization.
Type the name users will see in Ambition in the Display Name field.
Pick what each column holds, such as Email Address, Date, Number, or Dimension, from the Field Type drop-down menu.
Click on Save Data Format. The Please confirm before saving pop-up will appear.
Check that the User Identification and Date Fields sections of the pop-up list the right columns.
Type "I UNDERSTAND" in the text box.
Click on Confirm to apply your entries.
Note:
New FTP integrations start in Sandbox Mode, which hides their metrics until you turn it off. Follow these steps to disable Sandbox Mode for your integration.