Standardise coding and definition - e.g. to ensure item, product, profile or category codes, values and their descriptions, together with data fields such as job title, job function, marketing measures are uniform - with any value ranges standardised across all records. This will prevent data misinterpretation, enable more accurate selection and help identify gaps in your data.

Data restructure and enhancement
- Improve data format and field layout
- Splitting fields containing mixed names or data
- Defining gender from first names
- Correctly casing Irish, Scottish... surnames - Macdonald > MacDonnald etc.
- Salutation generation
- Standardisation of data value descriptions and codes - i.e. for gender,
  standardise categories for: Male, Female, Joint, Conflicting and Unknown

Compare database content across multiple files or snapshots of your data over time - on a record by record, field by field basis. This helps you identify records that have changed so you can more easily understand and analyse behaviour change or ensure you are using the right file for your analysis or mailing!

Merge and integrate disparate or difficult to link databases and lists... ...website interest, order details, acquisition databases, customer files, sales lead and CRM data, financial transactions, data marts, prospect files and mailing lists, e-mail address lists, research surveys, spreadsheets, etc., then create multi-list/database source codes, report overlap, create new unique reference numbers, etc., and prepare the data for import into any system.

Create and maintain a fully merged customer and prospect marketing database - giving you a single 360° view for highly targeted marketing. We can take your data in any format, improve quality, manage updates and campaigns, apply analytics and make selections and extracts for mailing, e-mailing, tele-marketing or even list rental, if you wish to generate additional revenue from your data.   

Migrate your data from one system to another, including audit and control of the transformation process and re-parenting of orphan transactions resulting from duplicate record removal. We can optionally use external data to suppress extinct businesses, relocated employees, deceased individuals or changes in their addresses. Specifically we are able to structure address information to retain delivery notes and department information, standardise product and other coding and descriptions, adjust field lengths including intelligent abbreviation, set flags to group companies and contacts into appropriate organisation structures (or individuals within households), and much more.

Enrich a database by merging one or more business, consumer, lifestyle or marketing databases or spreadsheets, and adding SIC, TV, geo-demographic, etc., profiling codes. We can also verify your data against suppression files such as National Change of Address (NCOA), Telephone Preference Service (TPS), Mailing Preference Service (MPS), Gone-away Suppression (GAS), Deceased, etc., and the opt-in element of the UK Electoral Roll. Telephone numbers can also be verified and/or appended.

Produce mailing files - including managing campaigns, making selections and list extractions and preparation for Mailsort and Walksort discounts.

Interactive UK, European and Worldwide address validation - to further enhance records that fail to be matched during the batch address enhancement process, we can interactively verify each address against a postal address file using a mix of look-up options. Clearly it is best if errors are corrected at time of data capture as this manual process can be both lengthy and costly. We therefore recommend using data capture enhancement software which can be embedded within an on-line web form, sales lead/CRM system or an operational data entry screen. < For interactive - to speed up data entry at point of capture - and batch worldwide address enhancement software, click here