Examples of "Dirty Data"
- Redundant Tracking
- Inconsistent Data Entry
Run following queries to keep your data clean in Raiser's Edge application.
- (Zip or State or Country s blank) and send email t o this address = 'Y'
- Primary Addressess or Primary Salutation is blank
- Preferred Address is blank
- Name contains Test
- Constituent has a spouse, but no individual relationship is set up.
- Constituent is deceased, but no deceased datae is entered
- Constituent is deceased, but spouse is not marked as "Head of Household"
- Neither spouse is marked as "Head of Household"
- Title is blank or primary addressee/salutation is blank for key indicator = 'I' (Individual)
- Title 1 or First name or Last name is blank
- Address 1 is blank
- (Spouse is deceased or marital status is Divorced/Separated/Widowed), but primary salutation contains Mr. and Mrs.
- Address not validated
- Constituent code is blank
- Preferred name is blank
- Emails with common typos or incorrect emails (e.g. email@example.com )
- Hard bounced emails still active
- Required attributes are missing
- Gifts without tracking attributes
- Unacknowledged gifts, tributes
- No solicitor assigned to a gift
- Event registration missing a linked gift
- Actions not assigned to a fundraiser
Keep following data CLEAN.
- Address - Use Address validation with USPS, NCOA
- Age - Lexis Nexis
- Credit Card - Expired credit card information needs to be updated
- Deceased information - Find Obituary information also.