How I Rank a Donor List: A Framework Borrowed From Enterprise Sales

Every nonprofit I've worked with has the same problem hiding in plain sight: a donor list with hundreds or thousands of names, and no real sense of who on it actually matters.

Not "who gave the most last year." Who matters — meaning who has the capacity, the connection to your mission, and the realistic likelihood of giving a transformational gift if someone simply asked the right way.

In enterprise sales, we called this qualifying a pipeline. Nobody selling seven-figure software deals treats every lead the same, and nobody should treat every donor the same either. Here's the framework I actually use.

Capacity, affinity, and timing — in that order

Most nonprofits rank donors by one thing: how much they gave last time. That's a mistake. It tells you what happened, not what's possible.

I rank against three factors instead:

Capacity — What could this person realistically give, based on what's visible? Real estate, business ownership, past giving to other organizations, career trajectory. This isn't about being invasive. It's about not underestimating someone because they've only ever given $250.

Affinity — How connected is this person to your mission, specifically? A board member's neighbor who came to one gala has different affinity than someone who's volunteered monthly for three years. Affinity is usually the most underused signal in a donor database, because it lives in notes and memory, not fields.

Timing — Is there a natural moment to have this conversation? A recent liquidity event, a milestone anniversary, a life change. Timing is the difference between an ask that lands and one that gets a polite "not right now."

Why lapsed donors are usually where the gold is

If I had to guess where the single best opportunity sits in most small nonprofit databases, it's not in the current donor list. It's in the lapsed one.

Someone who gave meaningfully three or four years ago and then quietly stopped almost never stopped because they stopped caring. They stopped because nobody followed up, the org went through a leadership change, or a single bad experience went unaddressed. That's a warm relationship with cold follow-through — the easiest kind to revive, and the kind every organization has sitting untouched.

Turning this into an actual list

Once I've scored a database against capacity, affinity, and timing, I'm not left with vague impressions — I'm left with a ranked list. The top 15-20 names get real attention: research, a personalized outreach plan, and a plan for who makes the ask and how. Everyone below that gets segmented into simpler, lower-touch cultivation, because not every donor needs — or wants — the same level of relationship.

This is the exact instinct that made me effective closing large accounts in corporate sales: you don't spread equal energy across every lead. You find the handful that matter most, and you go deep.

If you're staring at a spreadsheet full of names and no idea where to start, that's usually the first sign your development function needs this kind of audit before anything else.