Get Data Basey | The Raiser's Edge Program Basics Guide

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 Frequency:  Bi-weekly Benefits:  Helps maintain communicat