Data requirements
-
Header format
o
Must contain a heading label for each data column
(eg. Name,Address,City,State,Customerid,etc)
-
Separate columns for each data field
o
eg.
Name in column one, address in column two,etc.
-
Separate
rows for each record
o
Each data record should be in a separate row
-
Required data columns
o
At a minimum, you must have name, address,city,state
and zip data fields, each field in a separate column, and each different record
on a new row
-
Optional data columns
o If you require
additional items, we allow one (1) additional address field (address2) and five (5) custom fields, clearly and
distinctly labeled (eg. Customerid, promotional code,etc)
List Requirements
-
File formats
o we accept any file
that can be accessed through MS Excel 2000, as long as the data is formatted as
described above
TXT,CSV,ASC,MDB
-
Submission
o
We recommend uploading your list at the time of your
order, through our online upload section, specifically for list. This ensures
that your list is placed in the correct location inside your customer and order
repository.
o
You can also upload your list at a later time from the
UPLOAD LIST link located at the bottom of your order details page
o
Emailing your list to list@kaieos.com is acceptable, yet NOT
recommended, since all order notifications and changes are handled through our
automated systems, and email is a manual process. Avoid delays and potential
list mixups by uploading your list in time.
-
Zip/Stuffit
For
quicker and reliable file transfers, we recommend using a compression utility
such as Winzip or Stuffit to compress lists that contain over 1000 records
List processing
In order to provide you with fast and reliable service,
we request that you follow the requirements above. Download our sample Excel
spreadsheet and use it as a guide.
Our process is highly automated, and any improperly
provided files require manual intervention, and some tasks are extremely time
comsuming.
Not following the
requirements will certainly result in delays and additional costs.
Our services include de-duplication, address verification,zip+4 adjustments, pre-sorted barcoding and CASS
certification.