Boosting Data Quality: Top 8 Data Integrity Queries in Raiser's Edge
One critical aspect of ensuring maximum benefit from your Raiser’s Edge™ database is maintaining data integrity. One way to accomplish this is through the use of data integrity queries . In this post, we delve into the top 8 data integrity queries in Raiser’s Edge™. 1. Name and Address in ALL CAPITAL LETTERS Query: Create a constituent query that includes all constituents added in the last month. Fields to Output: Constituent ID, Full Name, Address Lines, City, State, Zip Frequency: Monthly Benefits: Review the list to find those online donors who enter their information in all caps. This will allow you to identify and fix the issue before it gets out of hand. 2. Missing Contact Information Query Query: Create a constituent query to identify records missing essential contact information such as email, address, or phone number. Fields to Output: Constituent ID, Full Name, address lines, city, state, zip, phone, email Freq...