14. Database Mastery - Foundation Directory
By the end you'll be able to
- Search Foundation Directory Online (or a free alternative) by subject, geography, and gift size.
- Read a foundation profile for the three signals that predict a real fit.
- Cross-reference FDO data with the foundation's actual 990 filings.
- Identify foundations that fund by invitation only and exclude them from your pipeline.
Foundation Directory Online (FDO) is the standard subscription database for private foundation research, and there are free alternatives (ProPublica Nonprofit Explorer, Cause IQ free tier, Candid's free 990 search) that get you most of the way for zero dollars. This lesson teaches you to use whichever tool you have access to without wasting hours.
You will learn to search foundations by subject area, geographic focus, grant amount range, and recent giving history, and to read a foundation profile for the three signals that matter most: do they fund organizations like yours, in places like yours, at amounts that would be useful to you. You will also learn to cross-reference FDO data with the foundation's actual 990 filings, because stated priorities and actual giving patterns frequently diverge.
By the end you should be able to build a shortlist of ten to twenty private foundation prospects for a specific program, knowing for each one their median grant size, their typical recipients, and whether they accept unsolicited proposals at all. The mistake to avoid is building a long list of foundations that sound right but only fund through invitation, because that list will never produce a single award.
Common mistakes
These are the traps learners hit most often on this topic. Knowing them in advance is half the fix.
Building a long list of beautiful misfits.
A list of forty foundations that "sound right" but never fund organizations like yours is worse than a list of eight that actually do. Length is not quality.
Skipping the 990 verification.
FDO and foundation websites describe intent. The 990 describes behavior. If you only read the intent, you will build pipelines on language and lose them to reality.
Practice problems
Try each on paper first. Click Show solution only after you've made a real attempt.
- Problem 1For a hypothetical youth mental health nonprofit operating in three Northeast states, describe how you would build a shortlist of ten private foundation prospects using any FDO or free-tier tool.
Show solution
Subject set to "mental health" plus the synonym "behavioral health," geography limited to MA, CT, and RI, and target gift size set to 100K to match what the program could absorb. Sort results by most recent year of giving, exclude any foundation marked "by invitation only," and pull the most recent 990-PF for each of the top fifteen. Drop any whose Part XV grants paid schedule shows no recipients in the three states or no grants in the target size range, leaving roughly ten qualified prospects.
Practice quiz
- Question 1Which of the following is a free alternative to Foundation Directory Online?
- Question 2Why does the lesson stress cross-referencing FDO data with actual 990 filings?
- Reflection 3You build a list of fifteen "perfect fit" foundations. Eight of them only accept proposals by invitation. What do you do?
Lesson 14 recap
Foundation databases are useful only when you read them critically and cross-reference against 990 filings. The goal is a short list of foundations that actually fund organizations like yours, in places like yours, at amounts that would matter.
Coming next: Lesson 15 — Keyword Triangulation
Next, we tackle the vocabulary problem directly with keyword triangulation, the technique that surfaces opportunities your competitors miss.
Saved in your browser only — no account, no server.