Event FTP Upload
Infinity’s Enterprise edition supports uploading CSV files which can be used to fire in custom event triggers to the Infinity Tracking system, such as when doing CRM integration.
An event file should contain the following columns, which can appear in any order in the file. These columns generally take the same values as our Event API.
Only the dt field is required. Optional fields may be left out of the file completely if not relevant to any event. Optional fields may include blank values if they are only relevant to some events.
- act (string) Optional - Action of Event (such as DOWNLOAD, EXIT, TRANSACTION), will default to “sale” if not supplied.
- vid (string) Optional - Infinity Visitor ID to associate this event to.
- callRef (string) Optional - Infinity Call Reference to associate this event to.
- t (string) Optional - Title of Event (such as title of product purchased).
- value (string) Optional - Value of this event (aka Event Margin).
- dt (string) Required - UTC Datetime of this event, (format: YYYY-MM-DD HH:MM:SS).
- txv (string) Optional - Transaction Value of this event.
- txc (string) Optional - Transaction Currency of this event (three-letter ISO-4217 currency code, USD, GBP etc).
- txr (string) Optional - Unique Transaction Reference of this event (can be useful with de-duping rules).
- matchMode (string) Optional - Either ‘exact’ or ‘intelligent’ to enable intelligent matching.
- callStartDt (string) Optional - UTC datetime (format: YYYY-MM-DD HH:MM:SS) of when the call started. Only applicable when intelligent matching is enabled.
- srcPhoneNumber (string) Optional - The caller ID in E.164, ‘anonymous’ can be used for anonymous caller IDs. Only applicable when intelligent matching is enabled.
You can send these files as frequently as you wish.
Each file must be encoded in UTF-8 with standard CSV conventions:
- fields separated by commas
- lines separated by newline characters
- fields enclosed with “double quotes” where necessary (e.g. if the value contains a comma)
Date-only Events
If you only record the date of an event, and not the exact time, we recommend setting the time part of the dt field to shortly before midnight (i.e. 23:59:59 if you’re in UTC). This will ensure the CRM event is attributed to a marketing channel and/or related call reference.
For example, if you reference a call that took place at midday, setting the time to “23:59:59” means the CRM event will appear after the call and be attributed correctly. If you set the CRM time to “00:00:00” it would appear to have happened before the call, and would not link up correctly.
Similarly, if you have a landing page with marketing data part-way through the day, then setting the time of the CRM to the end of the day will ensure the marketing data for that CRM event matches up. If the same visitor has multiple landing events throughout the day then the CRM event will be attributed to the last one, but the only way to improve the accuracy here is to record and provide the exact time.
Note that the dt in FTP files must be supplied in UTC, so it should be adjusted for your time zone. For example in Eastern Standard Time (GMT -5) set the time to “18:59:59”, and in Europe (GMT +1), you should set the time to “00:59:59”, and the date to the next day.
Future Dates
The FTP Upload system will reject any file that contains dates in the future. Please ensure that you only upload events with a dt in the past. This is generally not a problem if you are e.g. uploading files once per day containing data for the previous day.
Warning for Excel users
If you are using Microsoft Excel to save CSV files, it will change the format of dt values without asking, each time you open a file.
You must explicitly set a custom format of “yyyy-mm-dd hh:mm:ss” in your dt column before saving the document.
We do not accept Excel’s standard date formatting because of the ambiguity between US and UK local date formats.
FTP Details
The FTP Upload details are:
E.g.
Please contact our Service Desk to request an FTP user account be setup.
You can upload using either FTP or FTPS (secure FTP) using the same host. To use FTPS you will need to accept our SSL certificate.
Upload File Name
The file name format to upload is:
E.g.