Data Hygiene: How to Keep Data Clean and Healthy!
To ensure consistent data entry by all users, every organization (even those run by a single person) should have a DES1 (Data Entry Standards) document that clearly outlines what information the organization aims to maintain and how it is entered in the database. Not only will the DES document act as a solid resource for data entry procedures, (especially for organizations with multiple CiviCRM users), it also serves as a tool to retain organizational knowledge. The preservation of organizational knowledge is vital to all organizations, but especially so for smaller organizations with only one or two CiviCRM users and organizations with high employee turnover rates.
Here are some ways to keep your staff "in the know" regarding data entry procedures and policies:
- Ensure your organization has a DES1 - if not, create one and keep it up-to-date
- Train new staff
- Provide ongoing refresher courses for existing staff (including training on any new system functionality)
- Use structured forms and fields as suggested in one of our previous blog posts titled "Online Forms: The key to streamlining data entry and ensuring data integrity!"
The only way to preserve data hygiene is to validate, clean and refresh it periodically (e.g. remove duplicate entries, update verbiage in forms, etc.). A good preventive maintenance plan would include:
- An audit of your data to identify the areas to be cleaned - use your DES as a guide2
- A clean-up plan/strategy that will limit downtime and not overwhelm - start with the most important areas first and avoid costly mistakes:
- Always backup3 your database before you begin
- Avoid data loss - consider disabling instead of deleting
- Get it right the first time - ask for help from those who know your data best
- Use of activities to track the different phases of your clean-up plan and schedule future maintenance
The more data you have (and the more people you have entering it), the more frequently you will need to schedule preventive maintenance.
If you are a Cividesk customer, your Customer Success Manager would be happy to help. We can assist you with the creation of a clean-up plan as well as the execution of it.
1. Click HERE to view an example of a DES document
2. Future blog posts will include CiviCRM-specific queries and groupings that should be assessed
3. Cividesk clients must currently email firstname.lastname@example.org to create a support ticket requesting a backup, but soon you will be able to backup your database directly via the Desk!