Using solicit codes vs. attributes

Options
Hi everyone. So I've been hired as the database manager. One of my tasks has been to clean up the database, implement policies and procedures that are better suited for the department. 

Currently, they have a "Mail Restriction" attribute with a drop down list of different restrictions. The proper place for something like this is the solicit code but I am not sure if this is worth changing just because it isn't being used properly. I would appreciate people's opinions on using the mail restriction attribute vs. solicit codes and any positive or negatives you can think of.



Many thanks.

Courtney
Tagged:
«1

Comments

  • I'll be honest. We use a mail attribute to indicate when people should receive a mailing (usually for our newsletter - those folks may not pull as a donor, but someone has indicated that they are important to us and should receive a mailing. Or an event invite).

    I suppose it's not much different than using mail codes to exclude (which we do use).

    But, I will say, it's near impossible to maintain. Unless you have a plan to go back through and review attributes - they live there in perpetuity.
  • Thank you everyone. Since solicit code is not being used in our database, I am wondering if I can use this as an inclusion now since the mail restriction attribute seems to be well established. We have a group of people that should be solicited for all events, whether they fall into list parameters or not. This would have to be managed on a yearly basis because they are board, ceo contact list, board member assistants etc. It is a small list but opinions again would be appreciated. 
  • There isn't any right or wrong, but if and when I leave my position I want whoever takes my place to be able to figure out why I did what I did. Taking over someone else's database isn't fun when there are multiple attributes to decifer. Solicit codes I think are easier for someone else to understand. 
  • I have heard before that solicit codes do NOT allow you anywhere to enter a comment vs. attributes that do - so that's one possible differentiation factor choosing one over the other.
  • The issue I've had with using solicit codes and using criteria of 'not one of' in your query is duplication of data/gifts.  It will show gifts for each solicit code even if you ask it to not include duplicates.

     
  • I have a solicit code Invite to all Events and I use Attributes to track groups and the events they should be invited to.  Using a General Rule template to know who should be invited to a particular event I can code them as soon as they become a member of that group.  So even if someone is not affiliated by a group they would get picked up in the mailing because of the solicit code.  I can pull my mailing list by the Attribute Description "2015 Holiday" Party AND solicit code "Invite to all Events"

    Hope this helps.

    Example:  

    Attribute:

    Category: Office List Group

    Description: Foundation Board Member



    Attribute:

    Category: FY2014/2015

    Description:2015 Holiday Party
  • Jane - Just wondering, how do you track people who no longer fall into your grouping. Do you somehow check this and remove their event coding?
  • Yes, I send a pdf report to the group contact with all current members and ask them to update their groups (change,add,remove).  Prior to the beginning of the FY we add the event attributes with the FY upcoming Large events (using global add/constituent attributes from a query by group).  

    I run Event Attribute mail lists (include the solicit code - Invite to all events) for the team to review before we finalize the mail list to make sure we invite everyone we need to (or omit those we don't want to invite).  The general rule has been a great tool for me to maintain the events.

    Jane
  • To be more specific, when someone is no longer a member I change the attribute code to zFormer Foundation Board.  I also remove them from any upcoming events they were already coded for.  z helps to sort those old members to the bottom of the drop down list in attributes.
  • Dawn Lowe:

    I find that it is easier to use solicit codes for contact exclusion because it is visible on the BIO 1 Tab and easy to use in Query or Mailings.  The one negative I see is that you cannot add notes when you use solicit codes but you can with attribute.  

    I'd like to second Dawn's suggestion for using Solicit codes to exclude, rather than include.  The biggest reason for this is to simplify mailings.  For example, filters in quick letters only have an "Exclude selected" option for Solicit Codes.

    image

    On the other hand, Attributes in quick letters allows one to include OR exclude constituents with specific constituent attributes:

    image

    Thus, one can create a mailing list, using constituent codes or constituent attributes to select the recipient groups, while using the solicit codes to manage exclusions, all without creating a query.

  •  

    Dawn Lowe:

    There really is not a right or wrong in using Attributes vs. Solicit Code, it's a preference.  I find that it is easier to use solicit codes for contact exclusion because it is visible on the BIO 1 Tab and easy to use in Query or Mailings.  The one negative I see is that you cannot add notes when you use solicit codes but you can with attribute.  If I use the solicit code do not mail, there's no way to state why, but if I use an attribute I can add description and comments indicating why we are not allowed to  mailed to the constituent

    Example Constituent Attribute Contact Exclusion, do not mail, description written request by donor, Comments Donor requested no future mailingsor event invitations etc..  Refer to Impormatic article Using Solicit Codes Effectively in Raiser's Edge (Google article).  



    Hope this helps.

    We use the solicit codes, and enter the reason in the Notes tab.  We created a note type called "Solicit Code Explanation".  However, in the past it wasn't used consistently (it is now).  It's simply of matter of who is doing the data entry and how well the procedures are enforced.  It is frustrating to find a solicit code such as "Do Not Contact" or "Do Not Mail" which was probably entered years ago and there is no reason why!

     
  • We were hoping to use solicit codes in line with data proetction, does anyone add a action with a code so they have evidence of when permissions are recived or where data has come from?


    Am i correct in thisnking people are suggesting using solicit codes for opt out as per data protection (mail)and attributes for opt ins (email)
  • Mikaela, as far as using Solicit codes for data protection, we do have something similar. Although our organization does not share/sell our donor lists, one of our previous department managers was a big believer in the future of shared data. Because of this, we instituted the Solicit code "No Share" for any donor who prefers not to have their information shared. That way, if another manager comes along who wants to insititute sharing procedures, we already have the privacy system in place.


    On the main topic of using Solicit codes for mailings, we recently switched to Solicit codes for all mailing info, inclusions and exclusions. Art has a great point about Solicit codes and Quick letters, but since we don't use Quick letters (most of our mailings are exported and merged out-of-house), we find Solicit codes more useful for reducing Attributes clutter.
  • I switched from Solicit Codes to Attributes years ago after encountering difficulties with Solicit Codes.  We export data and deal with it outside of RE for mailings and such, so RE canned process restrictions don't matter.


    We have 3 Mailing Attributes, for 3 different categories of mail.  The Description dropdown includes Mail All, Employee (i.e. inter-office and save the postage!), Electronic Only, Print Only, Remove per Constituent, Do Not Mail per Org (i.e. someone on our staff says to take someone off the list), and Special Instructions (i.e. solicit once a year in the spring, or don't solicit until May 2017, etc.).  Every time an Attribute is added or changed, the Date is updated and the Comment includes additional information or a "see ConstNote" with additional information (such as a copy-and-paste of an email thread) about the Attribute.


    The Attributes are mBR (the umbrella name for our big in-kind gift drives), mNL (donor newsletter), and mIS (invitations & solicitations...or "other mail").  The "m" prefix puts them together on the Attributes Tab.  Many of our reply vehicles include an opt-out section, with 2-3 of these options (i.e. "check here to be removed from our newsletter mailing list").


    If you put Include in one place and Exclude on another, be sure to document which one takes priority if a record ends up with both.  Actually, document the heck out of whatever system you set up!  As Karen mentioned, when you leave the org (for whatever reason...win the lottery and no longer need to work =) ), you want your successor to be able to easily understand how and why things are set up.
  • For the most part, our solicit codes are used for exlusions.  We have created a note type for solicit codes.  This way we can document who added the code and why.  If the constituent sent us an email to opt out of something, we copy the email into the note.  If we recieve a letter, we can scan it in to our paperless system and reference it in the note.  

    If we decide to add solicit codes such as No Contact, it has been helpful to know who requested it and why. If the constituent requested it, it is no problem to remove the solicit code if they contact us again to opt back in.  However, if the solicit code was added by a staff member, we can read the note and determine if the code should be kept on. 
  • Michelle - do you have this note as a required field when people add a solicit code (if thats even possiable) otherwise how do tyou ensure this happens?


    Thanks
  • No, it's not required.  Only a handful of people are able to put solicit codes on anyway. We have found that most poeple do not want to have learn how to enter data into Raiser's Edge, so it is easier for them just send us the request.  


    Not all of our solicit codes require notes.  We also have solicit codes so that we can exclude records if they have an affiliation to an area of the college that we should not solicit. For instance, we have the Dance Center that does their own fundraising and events.  We process the gifts, so the records are in our database. If the only affiliation they have is to the Dance Center, we certainly do not want to solicit them from this office.  The only time we enter a note for the Center attributes is if we get a request from someone there that they are working with an individual personally but there is no known affinity yet.


    There are also attributes specific to the Centers and other non-academic units for their use, but we found that it was to hard to exclude the ones who only had affinity to a particular center from the ones who are active all around the college. 
  • For data pulling sake its much easier to be able to pull by solicit codes than by attributes. I will say that both have the problem of not having "To" colums to notify that at a time someone requested a solicit code but changed their minds. 
  • I disagree on what is easier. I think that attributes are easier as do not even need to have an "exclude" query - in Mail (from which we "should" be doing most of our mailings) you use the attribute tab to exclude any/all attribute(s).
  • Jane Kenny:

    The issue I've had with using solicit codes and using criteria of 'not one of' in your query is duplication of data/gifts.  It will show gifts for each solicit code even if you ask it to not include duplicates.

     

    Not one of does not work like you think it will.  You are best served merging queries and SUBtracting out the Solicit Codes that you do not want included. 

    In regards to dupes in your query list.  That is always going to happen.  Query is a grouping tool not a reporting tool.  You need to pull your query through Export or a canned report to filter out dupes. :-)

     

  • Courtney Klein:

    Thank you everyone. Since solicit code is not being used in our database, I am wondering if I can use this as an inclusion now since the mail restriction attribute seems to be well established. We have a group of people that should be solicited for all events, whether they fall into list parameters or not. This would have to be managed on a yearly basis because they are board, ceo contact list, board member assistants etc. It is a small list but opinions again would be appreciated. 

    Definitely headed in a good direction. We also have fine-tuned our Solicit Codes to include more detail. For instance, we have a "Do not mail - Partner record" when we must have two records for a married couple, "Solicit only through business" for major foundation contacts who should also receive invitations at home but not solicitations. Be careful you do not create so many that it is easy to forget to include/exclude when building a mailing list etc.

  • Our organisation has always used Solicit codes to exclude from mailings. However, with the potential change in fundraising regulations we are looking into moving over to Attributes. We are running our data through MPS and DPS to flag individuals who no longer wish to be contacted, but we need to record a date that this was flagged, hence why we are looking at Attributes.

    In addtion to this, we may need to start recording when an individual is opting in or out of receiving specific mailings, and again a date and comment will need to be added. But the down side of using attributes is that there is no 'To' date that can be used if an individual decides to change their mailing preference.

    We feel that a separate module needs to be developed to record mailing preferences, and to keep all historical preferences logged going forward.
  • Nicola Rendell:

    Our organisation has always used Solicit codes to exclude from mailings. However, with the potential change in fundraising regulations we are looking into moving over to Attributes. We are running our data through MPS and DPS to flag individuals who no longer wish to be contacted, but we need to record a date that this was flagged, hence why we are looking at Attributes.

    In addtion to this, we may need to start recording when an individual is opting in or out of receiving specific mailings, and again a date and comment will need to be added. But the down side of using attributes is that there is no 'To' date that can be used if an individual decides to change their mailing preference.

    We feel that a separate module needs to be developed to record mailing preferences, and to keep all historical preferences logged going forward.

    Nicola, you should add this to the RE:7 Idea Bank, and then post a link back here.  Additionally, this could be helpful for those using Online Express (OLX) if we ever get the ability to allow constituents to deteremine what kind of emails they want to receive from us. 

  • Jen Claudy:

    Nicola Rendell:

    Our organisation has always used Solicit codes to exclude from mailings. However, with the potential change in fundraising regulations we are looking into moving over to Attributes. We are running our data through MPS and DPS to flag individuals who no longer wish to be contacted, but we need to record a date that this was flagged, hence why we are looking at Attributes.

    In addtion to this, we may need to start recording when an individual is opting in or out of receiving specific mailings, and again a date and comment will need to be added. But the down side of using attributes is that there is no 'To' date that can be used if an individual decides to change their mailing preference.

    We feel that a separate module needs to be developed to record mailing preferences, and to keep all historical preferences logged going forward.

    Nicola, you should add this to the RE:7 Idea Bank, and then post a link back here.  Additionally, this could be helpful for those using Online Express (OLX) if we ever get the ability to allow constituents to deteremine what kind of emails they want to receive from us. 

     

    I was just thinking that! I cant find any existing ideas on this - has anyone else created one?

  • Courtney Klein:

    Hi everyone. So I've been hired as the database manager. One of my tasks has been to clean up the database, implement policies and procedures that are better suited for the department. 

    Currently, they have a "Mail Restriction" attribute with a drop down list of different restrictions. The proper place for something like this is the solicit code but I am not sure if this is worth changing just because it isn't being used properly. I would appreciate people's opinions on using the mail restriction attribute vs. solicit codes and any positive or negatives you can think of.


    Many thanks.

    Courtney

    Last week I saw a preview for upcoming features for NXT and this will be included soon in both NXT "standard" RE (driven by new regulations in the UK).

  • Courtney Klein:

    Hi everyone. So I've been hired as the database manager. One of my tasks has been to clean up the database, implement policies and procedures that are better suited for the department. 

    Currently, they have a "Mail Restriction" attribute with a drop down list of different restrictions. The proper place for something like this is the solicit code but I am not sure if this is worth changing just because it isn't being used properly. I would appreciate people's opinions on using the mail restriction attribute vs. solicit codes and any positive or negatives you can think of.


    Many thanks.

    Courtney

    Hi Courtney,

    We actually use both. Before we had the solict code table we used attributes so we've continued the process. In our database Attributes are both positive and negative statements, but the Solict code is restricted to a negative statement e.g. No mail, unsubscribed to eblasts etc. I like the solicit code table because it is right on the Bio 1 tab and staff don't need to hunt for this type of information.

  • I prefer attributes as you can filter them out via mail and not have to worry about excluding them via query AND you can add a note/comment and date.

Categories