StrategicDB offers companies a Free Data Audit in order to help businesses establish a data cleaning strategy. So what are some things that are typically included in a data audit:
- Duplicates – The amount of duplicates in your CRM. While the only true way to establish all duplicates in your CRM is to use your business rules a quick test of identifying duplicates using: website, phone number, address or email address is a good way to estimate the percentage of duplicates in your system. Typically, duplicate rates range that we have seen range from 10% to 30%. It is advisable to de-dupe if the amount of duplicates is greater than 5%.
- Data Completeness – Looking at certain mandatory fields that are important for your business we can look at data completeness per field and overall percentage of records with fully complete records. While no data is 100% complete, we aim to have 90% completeness per each field and overall completeness score of over 85% across the mandatory fields. If your data completeness is below that you may need to append that data using third party databases. We also advise clients to append data prior to de-duping as it will increase the identification of duplicates.
- Recency – By looking at how recent your data is, it can give an indication if data validation is needed. The timeframe to establish if you need to validate data is different for each business. For some two years and older are the problem while for others any record that is greater than 6 months in activity or creation are the ones that should be reviewed.
- Standardization issues – Looking at fields and seeing the different variations is a way to see if data normalization/standardization is needed. For example, we may find that country is spelled in different way, ‘US’, United States’, ‘USA’ can all be standardized to ‘United States’.
- Other Possible Problems: Depending on the client and their needs we may look into Parent/Child hierarchies, Unsubscribe/Bounce Rates, data quality by sales rep and establish and analysis of current data governance techniques.
Once a data audit is done, the next step is to establish data quality project plan. It will also help businesses justify their need to do data cleaning. Finally a data audit is used to establish a before benchmark and after to see the results of your data cleaning initiative. Get your free data audit today!