Sign into your account with your e-mail address and password (the information used when the account was created).
Click on
“Place an Order” (located at the top of the screen or the left panel of the"Account Tab")
- You will now be placed in the “Choose Services” section of the site
Click on the tab that contains the service(s) you wish to order (example: Address Hygiene and Update, Data Append etc.) each tab
contains a listing of different services and multiple services can be ordered on one file.
Select “Next” after all desired services have been selected (located at the bottom right hand corner of the screen).
- Choose Options (if Applicable) page will display the necessary forms required for some selected services such as
Move48,Move18, email processing, etc and will display the expiration date. If you do not have a current form on file you
will be able to click on a link later in the process to get the form, to fill out and send it in to Customer Service
- Load File – this is where you need to give us information about your file so it can be uploaded for processing
Select appropriate file type-
changes to this process are:
For
Delimited files, there is now a box to let us know the type of delimiter you are using
(default is “,”) if your file is
TAB delimited this box needs to contain a
“T”.
Also there is now a check box to let us know if your data file has a HEADER row or not. If it does have a header check this box.
For
Fixed ASCII files, we now require a
“Layout File” to upload along with your data file. We provide a link to a
“Sample Layout File” for you to download and save to your file system,
make the necessary modifications to define your file layout to us. (Once modified you can continue to use your new layout file provided your data remains the same.) When you have
the layout file ready to upload, click the browse button beside the layout file box to grab it and the click the browse button towards the bottom to upload your data file.
Select “Next” to proceed with the uploading of your file.
- Validate Input – Once the file has been read in we will present you with possible mapping of the data you uploaded. During the evaluation of your data we may have
found some discrepancies in your data. Clicking on the red arrow beside the listed discrepancies will provide details. You may want to correct these discrepancies or simply
proceed. The discrepancies will not prevent the file from processing. For more details on the mapping and validation see the section below,
During the reading of your data we have made assumptions about how your data should be mapped for processing that may or may not be correct.
Review this mapping and make any necessary adjustments you need to make to ensure the mapping of your data is correct.
Select “Next” to proceed with your order.
This is where you will choose the desired turn-around time for the service(s) you selected and see an estimated cost of your order.
In this area you can also click the link to the necessary form(s) required for the services you selected. (if a form is required)
You can also use the “Special Services” box to pass on any special instruction required to process your order.
If you need a PO or reference number that information can be supplied here.
Under Billing Info – select how you are paying for the order.
Then click “Confirm and Submit” to complete the process of placing your order.
This is the final step in the process
It displays the information about the order you just placed with Listcleanup.com
You have now completed the placement of your order and you may now place another order or simply log out of your account.
Once your order is in the system for processing it goes through a verification process.
The system will read your data file and attempt to verify the file.
If your data does not pass verification, please review your file and resolve the issue(s) listed.
If you have difficulties resolving the issue(s), please contact Customer Service at (855) 631-5050 or
email
listcleanup-Customerservice@authenticom.com.
When you receive email notification your order has completed, you will simply log into your account select
“Account” at the top of the screen then select
“View Orders / Retrieve Files”
Thank you for choosing Listcleanup.com and please feel free to contact us with any questions or assistance.
Remember we have Customer service reps to assist with any of these functions. You can call us at (855) 631-5050
or email
listcleanup-Customerservice@authenticom.com.
Customer Service reps are available Monday – Friday from 8:30 am – 5:00 pm CST
For a downloadable version of these instructions click
How To Place An Order
File Mapping
If there is a header, the header is read and column names are used and tested against a list of possible matches for our expected headers. (e.g. first name)
If the file has no header, the first 100 lines are read and tested against known patterns. There aren’t known patterns for every column. For instance, there is no way to distinguish between a
city and a last name. However, the parser can look for telephone numbers, zip codes, states and address lines because these have distinct patterns.
Validation of the data
After the headers have been mapped, the rest of the data is read assuming that it is the type of data that we were expecting. For instance, if the column was determined to contain address data,
then the rest of the columns are compared against the address pattern. If they do not match the expected pattern, then a message is raised.
Other types of validation done include:
Are the number of columns the same for every line
Are the number of characters the same for every line (fixed length only)
Determine confidence in the data
The confidence in the data is determined by line validation and column validation. Confidence comes down to how likely it is the file will pass through the system without customer
service intervention. It is supposed to let the customer know if there are places in the file with data issues that MIGHT need to be addressed.
JUST BECAUSE A COLUMN FLAGS DOES NOT MEAN THAT THE DATA IS BAD.
The confidence that a column is mapped correctly is done by taking the number of columns that didn’t match the expected pattern and dividing it by the overall number of columns.
The confidence for each column is then averaged. Along with this is the number of lines that had to be skipped because of incorrect column count.
For example, if we have a file with 1000 lines and 10 columns with the following layout:
- 200 had to be skipped because of column count problems
- Columns are: First Name, Last Name, Address1, Address2, City, State, Zip, Web, Phone, Email
- The columns mapped are: Address1, State, Zip
- 50 lines of addresses did not match
- 100 lines of states did not match
- 200 lines of zip codes did not match
The average column confidence is based on the remained 800 lines that weren’t skipped
- Address confidence is 750 / 800 = 93.75%
- State confidence is 700 / 800 = 87.5%
- Zip code confidence is 600 / 800 = 75%
The overall confidence that the columns were mapped correctly is the average of the three values, 85%. So far, the file has a GOOD chance of being parsed without customer service intervention.
Add the fact that 200 lines were skipped due to incorrect column count and the average is now only 80%, which is a FAIR chance of going through the system without customer service intervention.
For a downloadable version of these instructions and more information about the validation of data click
How To Place An Order
- Start by clicking “Forgot Password”.
- Enter your email address. Your password will be emailed to you.
(If your email address has changed, you must supply the email address used when account was created.
Once logged in you can update your email address.)
- dbaseIII (.dbf)
- Comma (.csv) or Tab delimited
- ASCII fixed length
Excel, Access, and Word files are not accepted. However, at least one or more of
the above file formats are supported by Excel, Access, and Word.
If you do not have one of these options, then contact Listcleanup.com and we will
review your file and determine if we can perform the conversion for a minimum charge.
Please contact listcleanup-Customerservice@authenticom.com
or call (855) 631-5050 for information on conversion options.
We do not provide technical support for Excel, Access, and Word. Please contact
Microsoft Tech Support for assistance.
I have an Excel file, how do I convert it to comma delimited (.csv)?
- The correct Processing Acknowledgement Form must be received and entered into our system for NCOA orders.
Documents and Forms
- Billing information must be entered for new accounts and confirmed for repeat customers
after “Proceeding to Checkout.”
- An automated notification to the login email address or fax number you provided
would indicate that your file has either “passed” or “failed data verification.”
If the file has “failed” please contact customer service at
listcleanup-Customerservice@authenticom.com or call (855) 631-5050. Many times the file we received
can be corrected. Please do not re-submit your file.
No. Listcleanup.com accepts one file per order. Multiple files that are uploaded
within a zipped file will not process.
Typically orders are purchased with a credit card at the end of the order process.
The credit card information can be saved as your default billing for future orders,
or the information can be entered after each order. You have the opportunity to
verify your billing or make changes with each order.
You may cancel the order online before the order is purchased. After the file is
uploaded you will have the option to “Cancel,” “Revise,” or “Proceed to Checkout.”
Choose “Cancel” to terminate the order.
Please contact Listcleanup.com at (855) 631-5050 if the order has already begun processing.
If we process the order, it is subject to regular charges.
An automated notification to the login email address or fax number will be sent
with instructions on how to retrieve your file.
Your file will be returned in the same format it was submitted along with appended
information added after the last field based upon the service(s) selected. All files
are “zipped” when retrieved.
How long will my file be available to retrieve from my account after the order is
completed?
After the order is completed and you have been notified by email or fax, your file
is available on our system for 7 days. After 7 days the completed file will not
be available for download, unless a special request for restoration is made. Restoration
may not be available with certain services. In most cases, an additional charge
of $35.00 will apply to files restored after this 7 day period. File restoration
will generally take 48-72 hours.
For clients pre-approved for FTP transfer, please contact
listcleanup-Customerservice@authenticom.com or call (855) 631-5050 to make arrangements to process
your file. Your file will not be processed until Listcleanup.com has been contacted.
Additional handling charges may apply.
For clients who place orders frequently using the same service(s) and file formats each time, please
ask about out AutoFTP option.
Email should be used as a last resort and only at the recommendation of Client Services.
Additional handling charges may apply to place files submitted via email.
The signed Processing Acknowledgment Form (PAF) is required by the United States
Postal Service prior to processing your file. Documents and Forms
for more information on how to complete the form.
In an attempt to standardize foreign addresses to domestic standards, CASS (Coding
Accuracy Support System) tends to corrupt foreign addresses. For this reason, we
recommend eliminating foreign addresses from your input file. Also, since all of
our services are domestic in nature, foreign addresses will not incur matches to
updated addresses, phone numbers, etc.
If your file contains Canadian addresses try our Canadian NCOA Product.