Setting Up Appeal Codes

Options
Hi,



So far this community has been amazing with advice, and as a new user to RE I need all the advice I can get.  So here I go again.



I would like to know how sites are using appeal codes.  Do you have a set number of appeal codes that are used year after year or do you set them up each year with the year embedded in the code.  i.e.   DM16NEWS (Direct Mail 2016 Newsletter).   I am looking at setting up a new gift coding process, currently we set up appeals each year.  Does anyone have appeal codes that are used year after year, adding to the list when appropriate.  Here's an example of what I am thinking:



CAMPAIGNS:   "Hospital", "Research Centre", "CMN", or "Rehab Centre" (our 4 main fundraising branches)

APPEALS:  "Spring Newsletter", "Fall Newsletter", "Equipment Appeal", "Mental Health Appeal", "Event", "Telefund", "Unsolicited", etc.

Packages:   "Golf tournament", "Letter A", "Letter B", "Phone Call", "Race"

FUNDS:  Unrestricted, Oncology, Equipment, ER, etc.

SUB-GROUP:   Sponsorship, Event, Donation



This seems a lot cleaner then creating new codes each year, and easier for reporting.  Does anyone do anything like this??  What are the potential downfalls?   



Thanks, Rita

 
Tagged:

Comments

  • We do both.  Ongong appeals are generic - e.g., Honorarium, Unsolicited, Donor Trip...  Others do have dates embedded - e.g., MN201509 for the Marketing Newsletter for Sept 2015.



    In very limited instances we use Packages to clarify the generic appeal  - e.g., a Package of Rwanda2014 for the Donor Trip appeal to specify the 2014 Donor Trip to Rwanda
  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Rita, you will find orgs do it both ways - same appeal code and one for each year.  It needs to be based on the orgs needs. 



    While I like the idea of using the same, for most of mine I have the year.  This is because the appeal especially at year end crosses our fiscal year end.  So I'm not easily able to query filter by just the appeal name.  December letter can get result in gifts to 2015 fund received in 2015 and in 2016.  And after our cut off date, gifts go into 2016 fund.  So, easiest for me is unique appeal names.  Need to do what works. 



    Have some others that are generic and used every year.
  • Marie Stark
    Marie Stark ✭✭✭✭✭
    Ancient Membership Facilitator 3 Name Dropper Photogenic
    We use generic appeals. For those related to Events, we use a package for each year.
  • We have three categories of appeals: ongoing, direct mail, and event.



    Ongoing:

    This includes things like Honor/Memorial (appeal = HM), third party fundraising (3PF), General (General, natch), etc.

    My predecessor felt it necessary to create new iterations of these for every fiscal year (e.g., HM FY15). I, however, find that to be basically useless and labor intensive. I've switched us over to just using the same appeal year after year.



    Direct mail:

    Appeals are set for each new piece sent out, with packages denoting the ask level of each piece.

    Nomenclature:

    BD0715 A2

    Appeal means: "Base Donors" July 2015 appeal, and the package A2 typically means an ask array of something like $15-$35



    Note: My predecessor just used three digit appeal codes that went up sequentialy with each new piece (e.g. 437, 438, etc). Do not do this. If your'e going to have a code, make it mean something. There's no reason not to make data meaningful. 



    Event:

    We create appeals for each year's event (e.g., Gala FY15, Gala FY16, etc.). I saw someone on here say that they use one appeal and denote different years via packages, but what we do is use package to track different types of giving within the event. So for our yearly gala, I have separate packages for silent auction, live auction, ticket sales, corporate sponsor, individual sponsor, cash call, etc. This helps year-over-year reporting a great deal. We know exactly what pieces of the event did better or worse than years past, and then we can decide how we want to strategize that piece of the event for the next year.



    Overall, the goal is always to capture more data in a way that is not labor intensive. Data is good, but complicated data is unreliable because there's a higher rate of error. 



    Final note: don't overlook "appeal category" and "package category." These can be invaluable when trying to report on similar appeals and packages year over year, and there's lots of creative ways to use them.



     
  • [deleted]
  • We use new appeal codes each year, for the most part.  This helps us compare year to year results for a particular mailing.  It's useful when you are looking at your donor trends or thinking about planning the next year's mailing calendar.
  • Rita- JoAnn is right, orgs do it both ways depending on their needs.  T

    That said,personally, it seems redundant to me since you can pull reports based on date.  I have the same appeals that are used year after year and do not have the year embedded in the appeal code.



    I have, in the past, inherited databases that had embedded a year in every code and had used all these letters in the codes: AF09P (Annual Fund Appeal 2009 Parent), problem was, as there were different DB managers along the way, the shifted the format and were not consistent with what had been utilized before their arrival.  It made deciphering and find all the appeals codes for reporting VERY difficult!  I spend months housekeeping to figure out the coding and clean it up.  So please, for yourself and whoever comes after you in a million years, please find a clear concise way of coding -- and/or keep a journal of the codes accessible for all in your department  smiley

Categories