- Data Entry Standards
Having an agreed set of guidelines, for adding data into a CRM system and/or other business systems, is a key starting place for any company wanting to improve data quality. Some of the tips below are ways that might be set out in a typical set of Data Entry Standard guidelines. However, the specifics of your actual data requirements to complete a new record in the system will be business specific and should be established. If you want to read more on Data Entry Standards, please see this blog article.
- Options Sets
For those fields where there is a defined list of values, don’t leave the user to enter the value in a text box! Do you know how many variants of “United Kingdom” you could end up with? My colleague’s favourite is “untied kingdom” – which is looking more and more insightful as time goes by!
- Determine Key Data
For personnel in a customer facing role, time is critical. Determining what data is needed as a minimum to proceed with a relevant transaction can reduce the need for users to have to add extraneous data. To ensure that this essential data is gathered (and entered) the relevant fields should be made mandatory.
- Address Management Tools
The UK has high quality address management tools available for businesses to deploy (1). By incorporating these into the business system, consistency in address format and validity is established.
- Duplicate Detection & Cure
If you are aware of duplicates in your system, then take action. Duplicates are like cockroaches, for every duplicate you’ve spotted there are probably a dozen more lurking! There are tools to assist in identifying potential duplicates and some provide a means to merge records thus eliminating the duplication. QGate offers Paribus 365 to identify and CURE duplicates – you can learn more here.
- Duplicate Prevention
In an ideal world you want to prevent duplicates from getting into the system. Some systems will provide assistance here, for example with Dynamics 365 there are Duplicate Detection Rules which can be setup and go some way to avoiding the obvious duplicates. However, this is only for exact matches and the difficulty is that users may enter companies and contacts in slightly differently to existing records. Using acronyms on some occasions, in full on others and differing names. For example, Bill or William; University College London or UCL; Abbott Limited or Abbott Ltd. QGate offers Paribus 365 to PREVENT duplicates from entering your system with its fuzzy matching capabilities – you can learn more here.
- Integration Tools
Most, if not all businesses are running with multiple systems and often decisions about which system provides all the bells and whistles for one department might be made in isolation to the rest of the business. Potentially a new customer brought on board through successful Marketing may exist as a record within that system but might have to be re-keyed into the Accounts system when an invoice must be raised. When this happens, it may cause errors. To avoid miss-keying of data there are integration tools (1) available to enable the record creation. The record insert can be automated which will speed up processes and also provide continuity in information across the business.
- Reviewing Data Quality
Whilst you may have put in place good practice to maintain a high standard in the quality of data, it is still important to carry out periodic reviews. Capturing and correcting problems early will make for a faster resolution. You can ensure that any rules/guidelines deployed are still valid and being used. For example, it may be worth verifying that the mandatory fields for record entry are still valid. As the business evolves, some of those fields may now be redundant and/or users are having to carry out workarounds to get past a mandatory field. If reviews are scheduled they are more likely to occur so setting out a schedule upfront is also advisable.
- Training and Reminding
Whether your data entry standards are formalised or not, everyone should be made aware of the procedures that the company wishes to follow. The adoption of procedures will be enhanced if personnel can appreciate the benefits to themselves and the business, so highlight the benefits. Include the education on these procedures in the training plan of new personnel and provide feedback, to all concerned, following your scheduled data quality review.
- Data Steward Role
The list above provides guidance on improving and maintaining high-quality data. But who is going to carry out the work?
- Analysing the business needs,
- Reviewing processes,
- Assessing third party tools,
- Overseeing implementation and
- Ongoing reviews/changes?
Having a nominated Data Steward demonstrates an investment in good quality data and will raise the profile of this subject within the business.
Relevant third party tools (1)
|Address Management||Postcode Anywhere
Data-8 Address Validation
|Integration Tools||Scribe Insight
|DeDuplication / Data Cleansing||Paribus 365|
If you require any further information on improving data quality, please contact us to talk to our Data Specialists.