Finding Finder Number in Blackbaud CRM™ Query

Have you ever found yourself hopelessly searching for the "finder number" field in Blackbaud CRM™ ad-hoc query and struggling to come up with anything?

You may even use the "Find Field" function, which comes back with zip, zero, nil, nada:

I've been here, and more than once if I'm honest. Even after finding and using the field in the past, it can be hard to remember where it is if you're not using it frequently.

Finder numbers are the unique identifier of a particular mailing assigned to a specific recipient. They are printed on response devices, facilitate expedient data entry, and are the primary ID when communicating back and forth with mail house. If you expected it to be in the root revenue node like Revenue-ID or Source Code, you would be amiss as the field is actually stored in the Revenue > Appeal > Appeal Mailing > Constituent Appeals path:

You can also easily find it in the less frequently used, "Revenue Marketing" source view:

So there you have it! Bookmark this page or save the screenshots to make your life easier next time you're in a bind and need this field to locate a transaction or to include as an output field in lists and reports.

TIP: Don't be surprised if you see missing finder numbers. Since acquisition "list members" are not fully stored in the Constituent Appeals table until they have made a gift, their finder number won't be included in the query results. This is by design and helps your organization comply with direct marketing best practice and regulations not to create records for rented names.

© 2017 BrightVine Solutions | All Rights Reserved

Offices:

Boston*

Charleston*

Charlotte

Nashville

Tallahassee 

Jacksonville/ Savannah

Atlanta 

843-900-4287

  • BrightVine on LinkedIn
  • BrightVine on Facebook
  • Twitter
Let's Connect

BrightVine Solutions, Inc. (BrightVine) is a member of the Blackbaud partner network. BLACKBAUD®, THE RAISER'S EDGE®, BLACKBAUDINTERNETSOLUTIONS®, BLACKBAUD CRM®, and RAISER'S EDGE® are registered trademarks of Blackbaud.  BRIGHTVINE, the BRIGHTVINE® LOGO, BRIGHTVINE DATALOADER® and DELIVERING EXCELLENCE FOR GOOD® are registered trademarks of BrightVine Solutions.

 

All other third-party trademarks mentioned on this website are the property of their respective owners.  Learn more about BrightVine on our blog