Data Restructuring

In this day and age your data may come from a variety of sources and be received in many different formats. Additionally, data may not always be entered consistently. This can result from different people capturing data independently on their own computers or as a result of mergers and acquisitions.

The problems that we often see are: data in the wrong fields, combinations of upper and mixed case, address lines that are so long that they will not print in allotted areas as well as inconsistent and sometimes inflexible entry of contact name information. This can affect address accuracy and deliverability, increase operational costs and also limit your ability to utilize some of the new, advanced personalization techniques that are emerging.

Unfortunately, data can be the Achilles heel on direct mail programs. However, we can help to avoid most data challenges through the following services:

• Systematic Data Analysis
• Relocating the Right data to the Right fields
• Splitting Excessively Long Address Lines
• Splitting Contact Name Strings
• Case Conversions
• Reformatting to Adhere to Canada Post Addressing Standards