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.

You can send these files as frequently as you wish.

Each file must be encoded in UTF-8 with standard CSV conventions:

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:

Host: ftp.infinity.co
User: user@domain.com@{igrpId}

E.g.

user@infinitycloud.com@1

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:

infinity_transactions-{YYYYMMDD}.csv

E.g.

infinity_transactions-20111201.csv