Typically, our mail list preparation projects consist of multiple input files (of various formats and structures), which we convert to our client's standard format. The files are then put through a series of standardization and cleansing process, which includes validating postal information (CASS Certification), parsing names, moving displaced data to the correct fields, removing junk data, genderizing the records, flagging unmailable records, Nth select data etc.

The output is a mail list which is standardized to USPS requirements, and with duplicates removed.

We work with various types of files such as delimiter, fixed width, excel, access, dbf. We convert files into the format and layout clients need.

In conversion, we ensure

• No truncation of data elements.
• Field name are mapped accurately.
• No displaced data due to "dirty characters"
• Check for maximum length of each field to find any abnormalies.

Following are some of the data standardization processes at DataPlus:

• Format data to upper case, the preferred USPS format.
• Parse name or reversed names into prefix, first, middle, last, suffix components. Fix any displaced name components.
• Parse addresses into their data element. For eg, CSZ into City, State, Zip.
• CASS certified the list.
• Gender-code the file.
• Flag unmailable records according to project specifications.
• Flag foreign records.

• Right field displaced data. For example, move company found in ADDRESS to COMPANY field; or names found in ADDRESS to NAME field.
• Remove junk or unwanted characters or words, eg “N/A”, “NOT SUPPLIED”, UNKNOWN”, “FGFGFGFG”, etc.
• Nth Select mail list.
• Others custom edit as instructed or as needed.

48 months move.
NCOA Processing Acknowledgement Form must be previously received and approved prior to processing.

Deduplication Logic:

• One mail per person (individual level)
• One mail per household (household level)
• One mail per company (company level)
• Customized merge/purge logic

We could help data entry projects from sweepstakes, questionnaires etc.

We work with our partner Data to Strategy Group (D2SG) to provide customer database analysis.

Analysis often involves transaction data and/or demographics data.

Customer are segmented based on the transaction and demographics data.

The analysis results could be used to create targeted marketing campaigns for various segments of customers, to cross-sell, up-sell, retain existing customers and acquire new customers.

Three marketing priorities drive our analyses. Getting customers, Keeping customers, and Growing customers. We quantify how you are doing, what you should do, and why you should do it, within a framework you can use to measure and to set financial goals.

Understanding your customers develops through analyzing what they do with you. Our approach begins with maximizing customer behavioral data, whether transactions with a financial measure such as sales, or activities that signals involvement. Offers, products, spending levels, and purchase patterns are analyzed to develop a full picture of behavior.

Combining a thorough look at behavior with demographics allows us to develop a complete picture of customers, who they are, and what relationships they have - or should have - with you. Understanding demographics this way allows for more personal offers and creative messages, even when customers are of equal financial value.