Comp Membership Reason

Has anyone setup a method to track the reason for Comp Memberships.

We will be giving out a number of Comp Memberships over time and a single customer could have over their life with BAM a number of comp memberships for a number of reasons.  I'm trying to figure out a clean way to track the reason that someone got a comp membership.

Examples of some of the reasons might be Things Like:

  • Customer Service
  • Gave to an Auction and was given a membership
  • The NYC Municipal ID program

This list will ebb and flow over time.

I've considered using a attribute for each reason.  The challenge with this is that TX_CUST_KEYWORD keeps all of the values in a string.  This then seem to make list pulling on these dates a bit difficult if someone uses a non supported data format for the string.  If I remember correctly between did not work very well either.

Question:

1. Does anyone have a robust solution for this?

2. Do you have suggestions for more robust custom attributes with dates?