Query Tip: Utilizing Summarized WealthPoint Information Fields

Published

Many ResearchPoint users are aware of and utilize the detailed WealthPoint data fields (such as specific fields within the various databases such as NOZA “Gift type”, real estate “Building area”, FEC (“Occupation”, etc.), that are available when creating queries.

I would encourage you to not forget about the very important “Wealth Information” summary fields (see screen shot below) that are available for both your query’s criteria and output.

“Wealth Summary Fields” in ResearchPoint summarize aspects of the various WealthPoint databases that are searched and matched.

I find such fields as total confirmed real estate assets or number of properties that a prospect has as helpful fields that our software calculates in creating queries. This is true with any of the confirmed assets (Securities, Business, or Income/compensation) as well as Wealth indicator assets. You are then able to find specific types of assets totaled for you, in particular when you include it in your query output – the fields you wish to include under “Results fields to display”.

I also like including the total number of confirmed philanthropic gifts if you are trying to find those who give to many nonprofits and are repeatedly philanthropic, or those with a confirmed affiliation to a Foundation.

How do you and others at your organization like to utilize these summarized “Wealth Information” fields? Please do share!

News ARCHIVED | Blackbaud Target Analytics® Tips and Tricks 10/20/2015 9:25am EDT

Added by Carol Belair

1 Comments

Randy Bunney Oct '15

Good points, Carol. This sort of meta or summary data about prospects is a good way to uncover insight about individuals in lists, as well as the overall quality of the lists. Naturally we are interested in the summary fields that display"Yes" in fields such as confirmed business, securities, or other giving. I too like the include the number of gifts, just as I do number of confirmed businesses, securities, securities. The nice thing about summary fields is that your output does not produce multiple rows when constituents are business owners / officers in multiple companies for example. Such output can quickly turn a simple file of a few thousands records into tens of thousands of rows. There are nifty Excel add-ons, such as AbleBits that will solve consolidate multiple cells into one. But that's beyond the scope of this post. So, the summary fields that Carol has drawn our attention become pointers to us for which donor's WealthPoint record may merit, for example, hand review. Naturally, in most cases, we will be combining WealthPoint data in addition to internal data such as giving or relationship. I spend most of my time during discovery work at scale for clients. So, i took WealthPoint summary output to the next level that combine summary wealth info with summary internal data. I call such derivied variables "Smart Filters," in part to brand the output but also to make the language less techy. Such Smart Filters allow the user to quickly zero in on the top potential prospects Finally, such summary data is user-friendly, helping to avoid overcoming people with massive amounts of data. The latter is particularly an issue if you get detailed info on hard assets.