Hi folks - we are working on building out a system to identify major donor prospects from within our database. We are currently using iWave to collect information on select constituents and then want to rank those constituents by assigning values to various pieces of information/criteria collected. Does anyone have best practices and/or a rubric for ranking prospects in this way that they could share?
Hi Cassie! I actually undertook this project a couple of years ago and created three different sets of criteria (one for $10k annual prospects, one for capital prospects, and one for planned giving prospects). Here's the spreadsheet I created with the criteria and point values. We have a custom version of rankings set up in system tables to be list-based, so once I created the list to pull for each criteria set, assigned it to the proper ranking type, and input the values, it calculates the scores for me on the back end.
Thanks so much for sharing this, Colleen! What is the PROScore a reflection of and where is it pulling from?
The PROScore is an iWave score based on the constituent's scores for capacity, affinity, and propensity. It pulls from the iWave section in their record (under the custom tab) which populates when they get batch scored or if we go into their record and score them.
Right - makes sense. And that is the only external criteria that you are specifically ranking? Are you using another system to identify/rank donors who give to other organizations but not yet to Olney?
The Capacity ranges are also from iWave, but other than those everything else is information that lives in Tessitura already. That said, you could try to do that based on their archtype/insight from within iWave (iWave calls them insights, but I think previously they were called Archtypes, because that's the list criteria we have). One of them is based on the constituent having high giving to other orgs, but not to you (or not as much to you). The other option would be to pull based on their giving listed under the Philanthropy section of the Research Tab, but you'd have to manually enter in the information to each record.