Appeal Code Cleanup

Options
I'm looking to cleanup our long list of Appeal Codes from about 75 down to about 7.  has anyone out here taken on such a task.  Not sure how to get started.  I do have the shortenend list of Appeals and the plan is shorten the list of Appeals down to about 7 and use Package to further identify the Appeal.  Has anyone expereienced this task and how did you handle it?


Mary L. Roundtree

Director, Development Services
Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    I did do some appeal clean up last year.  The biggest question is: are your gifts posted? And will changing appeal have any affect on your financial software/finance reports?  Be sure you know answer to that before changing any records. 


    If they are not posted, changing appeal is much easier. You can just edit on the gift record.  Could consider a gift export/import. If you can create an appeal query of specific gifts, you may be able to change by global change.  Don't know if you can add package at the same time.  Haven't tried that move.


    If gifts are posted, it requires a manual adjustment made to each record.  At least I couldn't find any short cut to that.  It was time consuming. I worked with one appeal at a time and eventually saw my list getting smaller.  Open each gift record, click adjust, go to split gift tab, change appeal.  And you may want a note on adjustment tab why there is an adjustment as viewing adjustment window does not show what adjustment or why one was made.




    My 2 cents...
  • Thank you!
  • I did some clean up similar to this last fiscal year - in addition to what JoAnn mentioned, I found it was not possible for me to make adjustments to campaigns/funds/appeals for posted stock-property gift types.
  • Oh, good information.  Thanks for that.
  • Never bumped up against this particular problem, since all of our appeals have one-year lifespans. We create a new appeal for each year's direct mailing, fundraising event, or acquisition. So if we needed to change something, I would normally just start going forward and make a historical note in the Policies & Procedures log.


    Can you not do a gift import/export once the gifts are posted? Surely that would be much easier and less time-consuming in the long run?
  • Mary Roundtree:

    I'm looking to cleanup our long list of Appeal Codes from about 75 down to about 7.  has anyone out here taken on such a task.  Not sure how to get started.  I do have the shortenend list of Appeals and the plan is shorten the list of Appeals down to about 7 and use Package to further identify the Appeal.  Has anyone expereienced this task and how did you handle it?


    Mary L. Roundtree

    Director, Development Services

    Oh yes -- have tackled this kind of project before and what has been mentioned are most definitely things to take into consideration.  One other thing you might consider since you want to consolidiate and may want to keep the historical code -- is to edit the code to have a prefix of the new code it fits into and/or add that new code to the Description field of the Appeal.  Then you could inactivate the old Appeals if you wanted to. 


     

Categories