Creating an attribute such as VIP
Options
Hi Everyone,
I would love to get feedback. I work at an organization where people can be categorized in many different ways. I was considering creating an attribute such as vip, with a drop down menu with options such as Gala "A" List, politician and so on. I would use this to be sure certain groups of people are grouped into exports or not if they happen to fall outside of certain criteria. And also, gives a quick snapshot of their level of importance to my organization.
Thoughts?
Thank you,
Courtney
I would love to get feedback. I work at an organization where people can be categorized in many different ways. I was considering creating an attribute such as vip, with a drop down menu with options such as Gala "A" List, politician and so on. I would use this to be sure certain groups of people are grouped into exports or not if they happen to fall outside of certain criteria. And also, gives a quick snapshot of their level of importance to my organization.
Thoughts?
Thank you,
Courtney
Tagged:
0
Comments
-
Sounds like a lot of work to keep it accurate and updated - that would be my concern especially with multiple users having access to attribute. If I had to do it, I would definitely use a dropdown table as you suggested. Depending on how you plan to use this info, have you considered solicit code? Might work but not really the best use of the field.
So, can a person just have one VIP rating? What if I qualify for two or more categories?
It's a good question to ask here - hope you get lots of feedback.0 -
We use constituent code for this: we have Politician, VIP, etc so we can see very quickly their relationship to the org. We also have a VIP events attribute, with a table that we can drop down and slect the events that we wish to ensure they are flagged for. It makes it very easy when pulling event lists. As with anything, it's training people to be consistent in their data entry. I like using the event attribute because I can add a date so we can clean it up as needed.0
-
I would recommend thinking through the following things:
1) How often will these change?
2) How often will you update them?
3) Are there any other places where this data is already stored (ie - the Gala list is actually a package of an appeal, the politician is an organizational relationship, etc.)? Do you really need another field or do you need to find a way to pull this information based upon how it is already entered into RE?
4) As previously asked, how will you handle this if a person fits two of your VIP categories?
If you have an ongoing data maintenence plan and you really do need another field, I think that the attribute may be the way to go. It can allow you to easily include or exclude people, sort them into categories, etc. I personally wouldn't recommend solicit codes because doing so would really complicate using these codes in connection to a mailing.0 -
When I started as DBA, there was an "A list" and a separate "VIP" solicit code which were previously used. Since Raiser's was in place for multiple years prior my involvement, there were thousands of records with those solicit codes, but no easy way to determine why the codes were applied. It made audit/updating almost impossible.
So I have done just what you are thinking. We use "Key Constituent" as the category name and a table menu for further description. Multiple use of the category is allowed and our users know to add the date and brief comments as to why it was added. Audits/updates are very easy since I can query on each table entry and show the date & comments.0 -
I am rethinking options for this.
Our Cheif Advancement Officer hates lots of constituent codes so I am avoiding having a ton especially when there will be a small group of people that fall into that constituent code. Likewise, I despise that in basic queries, if one of the outputs is constituent code then people will be pulled multiple times depending on how many their record has.
When dealing with maintenance, Vicki you are right - it would be easy to manage and cleanup. The Gala vip list goes to events, etc. Does anyone have an opinion about using this as a placement for former board as well? So their constituent code would become individual but using vip and drop down menu former board.
I think people could have multiple vips and if pulling lists, I would have to specify which ones to include.
Thanks for the feedback. Keep it coming!0 -
Since we have multiple entities and boards, I do have a seperate "Board Member" attribute category. This way I can select Current, Former, or Emeritus for each of our boards (some sit on more than one), as well as identify other constituents who sits on other boards with our current CEO. I also do this for board committee membership.
As far as pulling lists for people with multiple VIPs attributes: making the query criteria for the category description "<ask>", you can pick any combination of those on demand every time you run that query.0 -
We use a similar attribute for President's contacts with drop down choices. It is helpful when mailing invitations to events and for the Christmas card list. Although a list is easily pulled and sorted, because of the size it has grown to, it is a bear to manage. The President's Office reviews it once a year, but the corrections/additions/deletions to it are enormous. We ask ourselves every year of the validity of maintaining what amounts to a contact list when we should be tracking prospects and gifts. Perhaps an Excel spread sheet kept in the President's Office may be something to consider. We use constituent codes of our Board of Trustees and former Trustees--dates to and from are easily entered.0
-
Rita Bayer:
We use constituent codes of our Board of Trustees and former Trustees--dates to and from are easily entered.We also use constituent codes for our board of trustees, past trustees, and trustee emeriti. It doesn't happen often but I do get requests to pull board members from a certain era - having the dates to and from is the best way to extract this information. Very important when someone is being celebrated or mourned.
When I started in my position we had people that were flagged as "Forget me not." It started as a constituent code, was changed to an attribute. Neither the Constituent cod nor the attribute helped as they were not maintained as no one had ownership. We have a new system where important people are assigned a staff manager - which is stored in attributes and restricted by a table. This new system is working much better as it is being included in weekly gift reporting, weekly review of managed prospects, special consideration is given during appeals and invitations to events.0 -
Let me throw this into the mix -- what about using the BB Giving Score or another prospect rating? You can also add notes and link it to other categories.0
-
Nicole San Miguel:
Let me throw this into the mix -- what about using the BB Giving Score or another prospect rating? You can also add notes and link it to other categories.Courtney didn't say if they have prospect module. As to Giving Score while you can add notes on a score record, I didn't think categories were editable. Pretty sure they are set by BB. I'd be hesitant to try to use them for something else in case down the road it's decided that you want to use giving score ratings as intended (won't get into here whether the ratings are accurate).0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 3 Blackbaud Staff Discussions
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board