10 Mar Garbage In – Garbage Out
The importance of good data quality

With most Customer Relationship Management systems there are ways to improve the quality of the data being entered.
- Use drop-down lists/lookup tables where possible for accurate data selection.
- Specify the correct field types – don’t try putting dates into character fields for example.
- Use formatting rules where possible.
- Decide on any rules you or your company want for the use of punctuation and spaces in company names and phone numbers.
- Implement workflow or other processes to improve the user experience of the system and to do some of the routine data collection automatically where possible. For example, if the corresponding sales person is determined by the company postcode – get the system to manage this for you.
- Use fields only for a single purpose.
- Set up duplicate detection rules where possible.
Let’s have a look at some examples:
Data Quality Considerations
A bit of planning in the beginning can make life easier for yourself in the future. Before creating a new ‘company’ or ‘contact’ record it is recommended that you search the database to ensure that a record does not already exist with the same details. When searching, any misspelling will mean that the record is not found. It is important to consider the fact that in the majority of cases your CRM database is a shared system and there are other people using the data. This simply means that you need to take a little extra care to ensure that the integrity of the database is maintained for everyone.
Think about standards for your data, for example:
- Company Name – punctuation or spaces e.g. BBC; B.B.C.; B B C.
- Contact Name – This will vary depending on the system you use, some will have one field for the entire contact name (eg: Ms Pam Mannell), others will separate out the fields for the title (Mr, Mrs etc), the First Name and the Last Name.
- Phone numbers – Consider standardising on spaces within the number itself as this will impact searching. Consider whether all your numbers are UK based or you need to allow for international numbers.
- County and Country – use a lookup table for consistent data entry e.g. Hertfordshire not Herts. if possible. However, this is not always possible if you have international contacts.
- Implementing “AKA” (Also Known As) fields can be very effective in reducing duplicates.
Drop-Down Lists
Wherever possible keep this list of options as short as possible, often users only select from the ones they can see in the visible part of the list rather than scrolling.
Analysis
- All records created in the last week.
- All records without a postcode (or any other field that is of particular importance to you).