How Do I Format Data for an FTP Integration?
Last updated: November 17, 2026
An FTP integration accepts data in one of two shapes: Daily Totals, where your system has already added up each person's numbers for the day, or Records, where each row is a single activity that Ambition counts for you. Every file you send has to follow the shape and column names set on the integration's Data Format page.
Required permissions:
The Integrations: Edit permission is required to view an integration's Data Format page.
Check Your Integration's Data Shape
Head to Admin --> Data --> Integrations, select the Enabled tab, and click on your FTP integration's name.
Click on Data Format in the side menu.
Under Data Schema, note whether Records or Daily Totals is selected.
Under Field Mappings, note each value in the Field Key column. These are the exact headers your files must use.
Build a Daily Totals File
Each row holds one person's totals for one day. Columns can only use the Email Address or Unique Employee Identifier field type, plus Date and Number. Date/Time isn't allowed.
email,date,calls,emails,appointments
jason@yourcompany.com,2026-11-02,11,12,3
sarah@yourcompany.com,2026-11-02,6,9,10If Ambition receives another row for the same person and date, the new values will replace the old ones. For example, if a 9:00 AM file gives Jason 2 calls and a 9:05 AM file gives him 3, Jason will show 3 calls. One file can also hold several days, which is useful for backfilling past data or correcting earlier days.
Build a Records File
Each row is one activity, such as a call or a booking. Every row needs a Unique Record Identifier, an employee identifier, and a Date/Time or Date. Text values such as type or status use the Dimension field type, and amounts use Number.
email,created_date,record_id,type,status,booking_date,revenue
jason@yourcompany.com,2026-11-02 07:59:23,abc124,call,completed,,
jason@yourcompany.com,2026-11-02 10:44:33,abc127,appointment,not started,,
jason@yourcompany.com,2026-10-27 14:04:19,abc130,booking,completed,2026-11-02,400.00Your metric settings in Ambition decide which rows count. For example, a Calls metric might only count rows where type is "call" and status is "completed." If a file resends a record ID Ambition already has, that record will be updated instead of added twice, so a refunded booking can be resent with its new revenue amount.
Follow the Rules for Every File
Headers must match the Field Key values exactly, including capitalization. Column order doesn't matter, and extra columns are ignored.
CSV files must include every header, even when a column has no values.
Each row counts toward one specific day, not a week or month.
Send dates as YYYY-MM-DD and date/times as YYYY-MM-DD hh:mm:ss. Ambition assumes these are in local time, so email GetHelp@Ambition.com if your system sends UTC.
Note:
A CSV file missing a header won't process. Its error will start with "The uploaded file is missing theā¦", name the missing header, and point out any column that looks like a misspelling of it.