Data Manager

Upload data collections that can be mapped to data-driven activities and used for data tracking purposes.

Data Collections

You can create multiple data collections. Each collection can contain one or more data uploads. Read the data format and upload specs here.

Each collection upload must have the same column headings as the first upload, but additional columns may be appended.

Data upload format & specs

Data

Options/Limits

File format

Uploads must be in .csv

File size

Maximum collection size is capped at 34.33MB

Columns

Maximum 20 columns per upload

Headings

The first row will be the column heading. Heading names must be consistent for each upload, although additional columns may be appended after the first upload.

Rows

Maximum 200 columns per upload

Collection

A collection can consist of up to 20 different uploads

Total Rows

The total number of rows can be 20 000 (in 20 uploads)

Unique Identifier

Each data upload must contain at least one unique identifier. International formatting standards are to be observed.

Date Formats

Format

Example

Parsed As

DD/MM/YYYY

01/12/2020

01 December 2020

D/MM/YYYY

1/12/2020

01 December 2020

DD/M/YYYY

01/1/2020

01 January 2020

D/M/YYYY

1/1/2020

01 January 2020

DD MONTH YYYY

01 Feb 2020

01 February 2020

DD LONG_MONTH YYYY

01 February 2020

01 February 2020

YYYY-MM-DD

2020-03-01

01 March 2020

Unique Identifiers

There are three ways in which to identify users in the data upload:

User ID or code - this option requires you to have a User Code column heading, e.g. Employee Code, Identity Number, etc.

Email - data in this column must contain valid email addresses.

Telephone - data in this column must be formatted using the international standard: +2712345678.

Data Upload Samples

Coming soon

Data Upload Editing

You can edit cells (apart from headings) directly in the data uploaded.

To clear or delete a row/column, right-click to open the options menu.

You can search your data using the search feature (top right)

When a row is deleted, the row number is also deleted, e.g. if you delete row 5, there will never be another row 5 in that upload.

Collections can be Linked or Not Linked

Linked Collections have been linked to one or more integration points

Not Linked collections have been uploaded but are not actively being used anywhere.

Last updated