Query Tips: How To Find Donor-Advised Fund Gifts In ResearchPoint 7580

Query Tips: How To Find Donor-Advised Fund Gifts In ResearchPoint

Published

Nearly $1 charitable dollar in every $10 in the U.S. came from a donor-advised fund or DAF. Directed donations from DAFs have grown in recent years; in fact, during the first half of 2020 donor-advised fund distributions increased approximately 30%. They accounted for over $9 billion in contributions. Major gift offices are very interested in knowing which of your donors may have a DAF. Are you poised to identify them?

What's a Donor-Advised Fund?

DAFs are like a charitable investment account established by an individual to support charitable organizations. Cash, securities or other assets can be contributed into the fund and an immediate tax deduction is generally eligible to the donor. Then the donor can recommend grants, through the fund administrator, to IRS-qualified public charities.

They're very popular with individuals in their 50’s and 60’s that want to accumulate charitable dollars for both current and planned gifts. Think Gen X and Baby Boomers, respectively. Some donors have complex assets and use a DAF to leverage their illiquid assets.

Also good to know is that a charitable organization beneficiary can be named to receive the balance of the funds when the advising DAF donor passes away. For this reason, planned gift offices too might be interested in receiving a list of potential DAF donors within your ranks.

More Facts About DAFs

Here are some additional facts about DAFs that increase their attractiveness:

  • According to the National Philanthropic Trust (NPT) there were nearly $150 billion in assets under administrator management.

  • DAFs distributed over 20% of their funds in recent years compared to the 5% distribution requirement for foundations.

  • Over half of grants are distributed to organizations in the donor’s home state.

  • Fewer than 1% of DAF donations are anonymous – most donors ask the administrator to reveal the name of the original donor.

  • The median account balance is around $20,000, while the average DAF grant is $4,000.

Two Steps to Finding DAF Donors in ResearchPoint

All of this good information evokes excitement about finding your organization’s donors who have established a DAF. Because the actual gift comes from the fund administrator and not the original donor, it’s not all that simple a prospect research hunt to identify them; but with ResearchPoint® - your prospect research software tool - you have a leg up on the pursuit. There are only 2 steps you’ll need to take to find some results.

Step 1:

Screen one or more constituent records through the WealthPoint data sources. This can be done by screening one record at a time, or by screening groups of two-or-more records grouped into a research list. Specifically, you’re going to be looking for clues within the gift listings returned from the NOZA Database of Philanthropy. The more records screened, the more likely you’ll be to find returned results.

This Knowledgebase Solution tells you more. But wait! Your list of desired records isn’t yet in ResearchPoint, but it’s in Raiser’s Edge? Here’s how to quickly move your list into ResearchPoint for screening.

Step 2:

Create these two ad hoc queries in ResearchPoint. The first query has been narrowly defined to identify confirmed gift listings from NOZA. It uses both name and address to find matching results. These results, if any are returned, take little time to confirm the matched data. It’s nearly certain the listing is connected to the household where your constituent resides.

The second query employs a much wider filter - looking for gift listings that match to the constituent’s name only. These results will be more voluminous and may take additional time to review, investigate and confirm that the gift listing is connected to the household in which your constituent resides. The output I’ve suggested may produce multiple line results for the same individual. You can create an export definition in ResearchPoint to further filter the reported information to desired attributes only. Check out our Blackbaud Target Analytics community article ResearchPoint Export Tips: Creating An Export Definition With Attributes to learn more and watch an instructional video!

Query 1: DAF Donors to Nonprofit Organizations (Confirmed or Level 4 Confidence)

Description: Confirmed or level 4 confidence matched gifts to nonprofit organizations from DAF donors as found in NOZAsearch

Include records where:

  • Wealth Information\Philanthropic Gifts\Rejected is equal to No

  • And (Wealth Information\Philanthropic Gifts\Match code is one of P07, S07

  • Or Wealth Information\Philanthropic Gifts\Confirmed is equal to Yes)

  • And (Wealth Information\Philanthropic Gifts\Name contains Advised

  • Or Wealth Information\Philanthropic Gifts\Name contains DAF

  • Or Wealth Information\Philanthropic Gifts\Name contains D.A.F.

  • Or Wealth Information\Philanthropic Gifts\Name contains Fund)

b59aefb4a91eecc8f7ac32ff71f4dc5f-huge-pi


Query 2: DAF Donors to Nonprofit Organizations (Unconfirmed or Levels 1-3 Confidence)

Description: Unconfirmed or levels 1-3 confidence matched gifts to nonprofit organizations from DAF donors as found in NOZAsearch

Include records where:

  • Wealth Information\Philanthropic Gifts\Rejected is equal to No

  • And (Wealth Information\Philanthropic Gifts\Match code is one of P12, S12, P13, S13, P21, S21

  • Or Wealth Information\Philanthropic Gifts\Confirmed is equal to No)

  • And (Wealth Information\Philanthropic Gifts\Name contains Advised

  • Or Wealth Information\Philanthropic Gifts\Name contains DAF

  • Or Wealth Information\Philanthropic Gifts\Name contains D.A.F.

  • Or Wealth Information\Philanthropic Gifts\Name contains Fund)

836811500783e008f141c0b367d6faf6-huge-pi

Useful Query Output Fields:

  • First name

  • Last/Organization/Group/Household name

  • Address (Primary)\City

  • Address (Primary)\State abbreviation

  • Wealth Information\Philanthropic Gifts\Confirmed

  • Wealth Information\Philanthropic Gifts\Match code

  • Wealth Information\Philanthropic Gifts\Name

  • Wealth Information\Philanthropic Gifts\Organization

  • Wealth Information\Philanthropic Gifts\Gift type

  • Wealth Information\Philanthropic Gifts\Gift year

  • Wealth Information\Philanthropic Gifts\Low amount

  • Wealth Information\Philanthropic Gifts\High amount

  • Wealth Information\WealthPoint screening date

a32c5e1d5fc9751fb072fbf85f20ace9-huge-pi

If you need help in creating these queries in ResearchPoint, reach out to our stellar Support Analyst team at www.Blackbaud.com, Support, and then Chat.

News Blackbaud Target Analytics Tips and Tricks 04/06/2021 8:15pm EDT

Leave a Comment

1 Comments

You must have been reading my mind…my client was asking for something like this…Thanks!

Thanks for your feedback Carolyn! I'm also working on instructions to find family foundation donors as well. Please connect directly if you need immediate assistance. Take care,

Share: