How to Use Your Nonprofit CRM to Identify Major Gift Prospects You Already Have

Your next major donor is probably already in your database. Not maybe. Not theoretically. They’re in there right now, quietly sitting in a spreadsheet alongside thousands of other names, waiting for someone to notice the signals they’ve been sending for years. The challenge isn’t finding new people. It’s knowing where to look and what patterns actually matter.

So let’s do a li’l deep dive into exactly that. In this post, we’re walking through how to use your nonprofit CRM to surface major gift prospects from your existing relationships, how to score and segment them intelligently, and how to build a pipeline that actually moves, without expensive prospect research firms or starting from scratch.

First, Define What “Major Gift” Actually Means for You

Before running a single report, get clear on your threshold. Major gifts are typically defined as $5,000 or above, but that number should reflect your organization’s budget reality and revenue goals. A $5,000 gift is transformational for a $300K organization. A $50,000 threshold might make more sense for a $10M shop.

Here are some practical steps to nail your definition:

• review your operating budget and identify a gift size that would represent 1-2% of annual revenue,
• aim for this donor segment to cover 10-20% of your annual fundraising goal,
• create CRM custom fields to tag tiers, such as “Major: $10k+” or “Stretch: $25k+”, so your team operates from the same framework.

Protip: Lock this definition before touching your CRM. Inconsistent thresholds create messy data and misaligned team priorities. Revisit it quarterly with your board to align thresholds with campaign cycles.

The CRM Reports That Surface Hidden Major Gift Prospects

This is where the real discovery happens. Most nonprofits have the data, but they never pull these specific reports. And here’s the wild part: 68.43% of nonprofit donation revenue comes from major donors giving over $5,000, yet they represent only 0.77% of the average donor base (Fundraising Report Card). That tiny slice deserves some deliberate attention.

Start with these four essential queries:

Report Type	What It Uncovers	Your CRM Action
Lifetime Giving	Cumulative high-capacity donors	Sort your top 100; export for screening
RFM Analysis (Recency, Frequency, Monetary)	Recent upgraders and high-frequency givers	Score 1-5 per metric; prioritize 4-5-5 combinations
Donor Loyalty	Year-over-year increasers, long-term givers	Flag anyone giving 5+ consecutive years
Lapsed Major Donors	Past big givers who went quiet	Tag as “Re-engage” for personalized outreach

The insight most teams miss? Someone giving $1,000 per year for 10 years has already demonstrated $10,000 in lifetime commitment (DonorPerfect). That person belongs in your major gift conversation, even if no single check ever crossed your threshold.

Segment Smarter to Narrow 10,000 Records to 100 Real Prospects

Raw data doesn’t give you a portfolio. Segmentation does. Layering multiple filters is what transforms your entire donor database into a prioritized action list, and it’s honestly one of the more satisfying parts of this process once you see it click.

Combine these dimensions in your CRM:

• engagement signals: event attendance, volunteer hours, email open rates, advocacy actions,
• giving patterns: recurring donors who have also made one-time upgrades, or donors who gave during a capital campaign,
• demographic overlays: employer affiliations, real estate holdings, professional titles in contact notes.

Cross-reference your CRM notes with publicly available information, too. Board overlaps, political giving history, and professional recognitions are affinity signals hiding in plain sight. This “affinity mining” approach turns qualitative observations into prioritized prospect flags, no expensive add-on required.

Try This AI Prompt to Accelerate Your Prospect Analysis

If you’re staring at a spreadsheet of exported CRM data and aren’t sure where to start, let AI do some of the heavy lifting. Copy and paste this prompt into ChatGPT, Gemini, Claude, or whatever tool you use daily:

I'm a fundraiser at [ORGANIZATION NAME], a nonprofit focused on [MISSION DESCRIPTION]. I've exported a list of donors with the following columns: name, total lifetime giving, years of giving, largest single gift, last gift date, and event attendance count. My major gift threshold is [DOLLAR AMOUNT]. Please analyze this data and identify the top prospects based on capacity, loyalty, and engagement signals. Suggest a prioritized list and explain your reasoning for each top prospect.

This works well for quick analysis, but in your day-to-day fundraising work, there’s real value in having AI built directly into your CRM workflow where the full donor context already lives. That’s exactly what platforms like Funraise are building with Fundraising Intelligence integrated natively into the platform, so you’re not constantly copying data between tools or losing context along the way.

Score Your Prospects on Capacity, Affinity, and Inclination

Once you’ve segmented, score. The CAA model (Capacity, Affinity, Inclination) is a practical framework for building a portfolio of 50 to 100 viable major gift prospects. Rate each pillar on a 1-5 scale, and any prospect scoring 12 or higher total becomes a portfolio priority.

Pillar	What to Pull from CRM	Score Boosters
Capacity	Lifetime giving totals, employer data	$50k+ cumulative giving: score 5
Affinity	Event history, volunteer records, personal notes	5+ interactions on record: score 4-5
Inclination	Giving frequency, year-over-year upgrades	Recurring donor with consistent increases: score 5

In our experience, it’s also worth integrating wealth screening annually by exporting your top segments and appending real estate or stock holding data through tools like DonorSearch. Import results back as custom CRM fields. You’d be surprised how often this reveals hidden capacity in donors you’ve quietly underestimated for years.

What We See Nonprofits Get Wrong (Every Single Day)

After working closely with hundreds of nonprofit teams, a few patterns show up constantly before organizations get their CRM strategy right. We’re sharing these not to pile on, but because they’re genuinely fixable once you see them clearly.

The “new donor” obsession. Development teams spend the bulk of their acquisition budget chasing cold prospects while loyal $500-per-year donors with 15-year giving histories sit uncultivated. And yet, 80% of major gifts come from donors already known to the organization (Prospects Influential).

Treating the CRM like a contact list, not a fundraising tool. The database gets updated after events but nobody runs a lifetime giving report until the end of fiscal year, when it’s too late to act on anything.

No pipeline stages, just a folder of “hot prospects.” Without structured moves management in the CRM, cultivation stalls. Gift officers have great conversations and then nothing happens because no one set a follow-up task.

If any of these sound familiar, you’re not alone, and the fix is simpler than most people expect. Funraise was built specifically to solve these workflow gaps, and you can start exploring it for free with no commitments.

“The donors most likely to make a major gift aren’t the ones you haven’t met yet. They’re the ones who’ve been quietly showing up for years while you were busy chasing someone new.”

Funraise CEO Justin Wheeler

Build a Pipeline That Actually Moves

Identifying prospects is only valuable if they move forward. Use your CRM to track every prospect through five defined stages: Identification, Qualification, Cultivation, Solicitation, and Stewardship. Assign gift officers portfolios of 100 to 150 prospects maximum, and keep in mind that cultivation averages six months before a major ask, so tracking time-in-stage helps you catch stalls before they become dead ends.

In 2024, total US charitable giving reached $592.50 billion, a 6.3% overall increase (Giving USA 2025). Major gifts drove a significant portion of that growth, and your CRM data positions you to capture a meaningful share of it without adding headcount.

Protip: Run a weekly pipeline review using a saved CRM list filtered by “Assigned to [Staff Member] + Stage: Cultivation.” This single dashboard habit prevents the most common pipeline failure, which is prospects who got one great meeting and then nothing for four months.

From Identification to Ask: Activate What You Already Know

Once your top 20 prospects are identified and scored, personalize every touchpoint using what’s already in your CRM. Reference specific gifts, events they attended, causes they’ve engaged with. Personalized outreach that reflects genuine knowledge of a donor’s history consistently outperforms generic appeals. That’s not a controversial take, it’s just true.

Upgrade suggestions should also be grounded in RFM data. If someone has given $500 three times in the past year, a $2,000 ask feels logical, not aggressive. Let your CRM tell you what the right number is.

Here’s the thing: your CRM isn’t a passive record-keeper. It’s your most underutilized major gift tool. Start with one report this week, your lifetime giving list sorted by cumulative total, and let the data show you who’s been waiting for a bigger invitation. Teams using Funraise have access to built-in prospecting tools, engagement overlays, and pipeline tracking all in one place. It’s worth exploring, and starting is free.