Day 3

Module 1 | Day 3 of 90

Your donor database is your most valuable asset. A poorly structured database costs you millions in missed opportunities over time.

Donor Database Foundation

Your donor database is not a digital filing cabinet. It is a revenue-generating system. The quality of your data determines the precision of your fundraising.

Essential Database Fields

Every donor record should capture:

Identity & Contact:

• Full name (first, last, middle, prefix, suffix)
• Spouse/partner name
• Complete address with ZIP+4
• Phone (mobile, home, work)
• Email (primary, secondary)
• Preferred communication method

Giving History:

• First gift date and amount
• Last gift date and amount
• Largest gift amount
• Total lifetime giving
• Number of gifts
• Average gift size
• Gift frequency
• Giving pattern (annual, seasonal, sporadic)

Segmentation Tags:

• Donor type (individual, corporate, foundation)
• Giving level (annual fund, major donor, principal donor)
• Recurring status (monthly, quarterly, lapsed)
• Acquisition source (event, direct mail, referral, online)
• Interest area (program affinity)
• Engagement level (high, medium, low)
• Board/staff/volunteer status

Relationship & Cultivation:

• Relationship manager assigned
• Moves management stage
• Last contact date and method
• Next scheduled touch
• Event attendance history
• Volunteer involvement
• Prospect research notes
• Spouse/family giving connections

Data Hygiene Standards

Monthly:

• Process all gifts within 48 hours
• Update addresses from returned mail
• Correct duplicate records
• Update contact information from replies

Quarterly:

• Run NCOA (National Change of Address) updates
• Validate email addresses
• Review and merge duplicate records
• Update deceased records

Annually:

• Full database audit and cleanup
• Wealth screening update
• Segment recalculation
• Archive inactive records

Database Selection Guide

Small nonprofits (<500 donors, <$500K): Bloomerang, DonorPerfect, Little Green Light, or Airtable

Mid-size nonprofits (500-5,000 donors, $500K-$5M): Bloomerang, Neon CRM, Salesforce Nonprofit Success Pack, Virtuous

Large nonprofits (5,000+ donors, $5M+): Raiser's Edge NXT, Salesforce NPSP, Blackbaud CRM

Today's Action Items

1. Audit your current database fields against the essential list
2. Identify and fill critical data gaps
3. Run a duplicate record report and merge duplicates
4. Set up automated gift entry and acknowledgment workflows
5. Document your data hygiene schedule

Key Takeaway

Clean data is money. Every outdated address, missing phone number, and unrecorded interaction is a lost opportunity to connect with a donor who wants to give.

Worksheet

Complete today's worksheet: Database Field Map & Audit

Clozo Academy Proprietary Curriculum — The Nonprofit Growth System