modifying membership levels mid seaon

We are wishing to change the start and end levels to one of our membership categories(Corporate). The start and end amounts will be modified, and the names of the levels will be modified. There are a few concerns I have.

1. We will be moving from the current 8 levels of memberships to only 6. The bottom three levels will now become one level. $.01 - $999.99. What is the best way to approach this update? Do I inactivate the lowest two levels, and change the start and end amount on the third from the lowest? If I inactivate levels, does that somehow inactive the active memberships that are tied to active gifts?

2. How will these changes effect current donors who have active memberships with the settings that are currently established. i.e. will it automatically bump them up/down to the new levels, will it not effect people with existing memberships?

I have a gift on hold from March until I can get this figured out so any help would be very much appreciated. Thanks all!

Heather L. Hoyt
Development Coordinator
Omaha Symphony
1605 Howard Street
Omaha, NE 68102
tel: 402.342.3836 x125
fax: 402.342.3819
  • Heather,

    We had some level adjustments here in recent months so I did lots of testing to see what would happen.

    If you inactivate levels, constituents with memberships at those levels will not be affected. They would only be affected when they come up for renewal and they will have to renew at a different level because the level they are at is inactive.

    If I were in your situation I would probably keep the bottom level and change the amounts then inactive the two levels above that.

    I'd also do some testing in your test database to see what happens.

    No matter what, you're trends are going to be a bit weird for a while.

    Dale

  • Heather,

    We have adjusted our membership levels many times and I never changed an exiting level but instead create new levels.  

    We have three different revolving memberships organizations with 8 or more levels within each.  All our memberships are revolving which means they begin on the date we receive their donation and end one year later. 

    By creating new levels we are still able to accommodate the old level membership forms which are still out there until they are replaced by the new membership forms.  When the old forms stop rolling in we then inactivate the old levels. 

    Making new levels rather than updating exisiting levels allows us to easily see which members have rolled over into the new levels.    This also allows a gradual move into the new levels rather than having to call individuals who have received the old membership form for their renewal.

  • Terry thanks for the reponse. I'm not sure I understand you. We also have a revolving membership setup. Do you inactivate all 8 levels first, and create 8 new levels, then when 1 fiscal season has rolled over, and there are no longer active memberships tied to the "old" levels you delete the inactivated levels?

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Thursday, April 02, 2009 2:10 PM
    To: Heather Hoyt
    Subject: Re: [Tessitura Development Forum] modifying membership levels mid seaon

    Heather,

    We have adjusted our membership levels many times and I never changed an exiting level but instead create new levels.  

    We have three different revolving memberships organizations with 8 or more levels within each.  All our memberships are revolving which means they begin on the date we receive their donation and end one year later. 

    By creating new levels we are still able to accommodate the old level membership forms which are still out there until they are replaced by the new membership forms.  When the old forms stop rolling in we then inactivate the old levels. 

    Making new levels rather than updating exisiting levels allows us to easily see which members have rolled over into the new levels.    This also allows a gradual move into the new levels rather than having to call individuals who have received the old membership form for their renewal.

    From: Heather Hoyt <bounce-heatherhoyt8769@tessituranetwork.com>
    Sent: 4/2/2009 12:28:07 PM

    We are wishing to change the start and end levels to one of our membership categories(Corporate). The start and end amounts will be modified, and the names of the levels will be modified. There are a few concerns I have.

    1. We will be moving from the current 8 levels of memberships to only 6. The bottom three levels will now become one level. $.01 - $999.99. What is the best way to approach this update? Do I inactivate the lowest two levels, and change the start and end amount on the third from the lowest? If I inactivate levels, does that somehow inactive the active memberships that are tied to active gifts?

    2. How will these changes effect current donors who have active memberships with the settings that are currently established. i.e. will it automatically bump them up/down to the new levels, will it not effect people with existing memberships?

    I have a gift on hold from March until I can get this figured out so any help would be very much appreciated. Thanks all!

    Heather L. Hoyt
    Development Coordinator
    Omaha Symphony
    1605 Howard Street
    Omaha, NE 68102
    tel: 402.342.3836 x125
    fax: 402.342.3819



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.
  • Hi Heather,

    No we never delete the levels either.  We actullay keep both the old and new active at the same time.  Then as the old stop coming in we inactivate the old levels. 

    To try to explain...because of the revolving issue there are always old forms out there for a while (3 to 6 months) that make it difficult for us to just change over to the new levels.  Therefore we let those old forms come in and allow them to renew at the old level if they have the old form.  This has always worked very smoothly for us even though it may take a year before everyone is moved to the new level.

  • Hi Terry,
     
    How do you have two active levels tied to the same membership category that have similar criteria, e.i. if the original level is for $500-$999 and the new level is $500-$1,500, when someone gives a gift of $500 and both levels are active, then how do you assure the gift will trigger the new membership, vs the original? Make sense? I didn't know you could have more than 1 active membership level that had overlapping criteria(start and end amounts).
     
    If we aren't really concerned about old forms coming in, and we are intending to renew or enter new gifts to these updated levels, then do you think the best way would be to inactivate the original levels and create new ones?


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Thursday, April 02, 2009 2:27 PM
    To: Heather Hoyt
    Subject: Re: [Tessitura Development Forum] RE: modifying membership levels mid seaon

    Hi Heather,

    No we never delete the levels either.  We actullay keep both the old and new active at the same time.  Then as the old stop coming in we inactivate the old levels. 

    To try to explain...because of the revolving issue there are always old forms out there for a while (3 to 6 months) that make it difficult for us to just change over to the new levels.  Therefore we let those old forms come in and allow them to renew at the old level if they have the old form.  This has always worked very smoothly for us even though it may take a year before everyone is moved to the new level.

    From: Heather Hoyt <bounce-heatherhoyt8769@tessituranetwork.com>
    Sent: 4/2/2009 2:21:26 PM

    Terry thanks for the reponse. I'm not sure I understand you. We also have a revolving membership setup. Do you inactivate all 8 levels first, and create 8 new levels, then when 1 fiscal season has rolled over, and there are no longer active memberships tied to the "old" levels you delete the inactivated levels?

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Thursday, April 02, 2009 2:10 PM
    To: Heather Hoyt
    Subject: Re: [Tessitura Development Forum] modifying membership levels mid seaon

    Heather,

    We have adjusted our membership levels many times and I never changed an exiting level but instead create new levels.  

    We have three different revolving memberships organizations with 8 or more levels within each.  All our memberships are revolving which means they begin on the date we receive their donation and end one year later. 

    By creating new levels we are still able to accommodate the old level membership forms which are still out there until they are replaced by the new membership forms.  When the old forms stop rolling in we then inactivate the old levels. 

    Making new levels rather than updating exisiting levels allows us to easily see which members have rolled over into the new levels.    This also allows a gradual move into the new levels rather than having to call individuals who have received the old membership form for their renewal.

    From: Heather Hoyt <bounce-heatherhoyt8769@tessituranetwork.com>
    Sent: 4/2/2009 12:28:07 PM

    We are wishing to change the start and end levels to one of our membership categories(Corporate). The start and end amounts will be modified, and the names of the levels will be modified. There are a few concerns I have.

    1. We will be moving from the current 8 levels of memberships to only 6. The bottom three levels will now become one level. $.01 - $999.99. What is the best way to approach this update? Do I inactivate the lowest two levels, and change the start and end amount on the third from the lowest? If I inactivate levels, does that somehow inactive the active memberships that are tied to active gifts?

    2. How will these changes effect current donors who have active memberships with the settings that are currently established. i.e. will it automatically bump them up/down to the new levels, will it not effect people with existing memberships?

    I have a gift on hold from March until I can get this figured out so any help would be very much appreciated. Thanks all!

    Heather L. Hoyt
    Development Coordinator
    Omaha Symphony
    1605 Howard Street
    Omaha, NE 68102
    tel: 402.342.3836 x125
    fax: 402.342.3819



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.
  • Heather,
     
    If you are not concerned about old forms coming in then yes, the best thing would be to turn off the old levels.  If, like us you are concerned about old forms it is very easy while in Post Contribution to click on the membership tab and choose the level you want the contribution to go towards.  Or, if you forget to do this while in Post Contribution you can change the level under the History tab once you have processed the membership.  After changing a level under the History tab the AVC amount may be incorrect, you can fix this by clicking on the Contributions button at the bottom of the History window, this will open a new window (Contributions associated with this membership), click the recalc button and your AVC should be corrected.
     
    Terry
     

    ***************************
    Terry Stevens
    Database Administrator
    Midland Center for the Arts
    1801 W. St. Andrews Rd.
    Midland, MI 48640
    www.mcfta.org
    stevens@mcfta.org
    Ph: 989-631-5930 ext. 1210
    Fx: 989-631-7890
    ***************************

     


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Heather Hoyt
    Sent: Friday, April 03, 2009 10:40 AM
    To: Stevens, Terry
    Subject: RE: [Tessitura Development Forum] RE: modifying membership levels mid seaon

    Hi Terry,
     
    How do you have two active levels tied to the same membership category that have similar criteria, e.i. if the original level is for $500-$999 and the new level is $500-$1,500, when someone gives a gift of $500 and both levels are active, then how do you assure the gift will trigger the new membership, vs the original? Make sense? I didn't know you could have more than 1 active membership level that had overlapping criteria(start and end amounts).
     
    If we aren't really concerned about old forms coming in, and we are intending to renew or enter new gifts to these updated levels, then do you think the best way would be to inactivate the original levels and create new ones?


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Thursday, April 02, 2009 2:27 PM
    To: Heather Hoyt
    Subject: Re: [Tessitura Development Forum] RE: modifying membership levels mid seaon

    Hi Heather,

    No we never delete the levels either.  We actullay keep both the old and new active at the same time.  Then as the old stop coming in we inactivate the old levels. 

    To try to explain...because of the revolving issue there are always old forms out there for a while (3 to 6 months) that make it difficult for us to just change over to the new levels.  Therefore we let those old forms come in and allow them to renew at the old level if they have the old form.  This has always worked very smoothly for us even though it may take a year before everyone is moved to the new level.

    From: Heather Hoyt <bounce-heatherhoyt8769@tessituranetwork.com>
    Sent: 4/2/2009 2:21:26 PM

    Terry thanks for the reponse. I'm not sure I understand you. We also have a revolving membership setup. Do you inactivate all 8 levels first, and create 8 new levels, then when 1 fiscal season has rolled over, and there are no longer active memberships tied to the "old" levels you delete the inactivated levels?

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Thursday, April 02, 2009 2:10 PM
    To: Heather Hoyt
    Subject: Re: [Tessitura Development Forum] modifying membership levels mid seaon

    Heather,

    We have adjusted our membership levels many times and I never changed an exiting level but instead create new levels.  

    We have three different revolving memberships organizations with 8 or more levels within each.  All our memberships are revolving which means they begin on the date we receive their donation and end one year later. 

    By creating new levels we are still able to accommodate the old level membership forms which are still out there until they are replaced by the new membership forms.  When the old forms stop rolling in we then inactivate the old levels. 

    Making new levels rather than updating exisiting levels allows us to easily see which members have rolled over into the new levels.    This also allows a gradual move into the new levels rather than having to call individuals who have received the old membership form for their renewal.

    From: Heather Hoyt <bounce-heatherhoyt8769@tessituranetwork.com>
    Sent: 4/2/2009 12:28:07 PM

    We are wishing to change the start and end levels to one of our membership categories(Corporate). The start and end amounts will be modified, and the names of the levels will be modified. There are a few concerns I have.

    1. We will be moving from the current 8 levels of memberships to only 6. The bottom three levels will now become one level. $.01 - $999.99. What is the best way to approach this update? Do I inactivate the lowest two levels, and change the start and end amount on the third from the lowest? If I inactivate levels, does that somehow inactive the active memberships that are tied to active gifts?

    2. How will these changes effect current donors who have active memberships with the settings that are currently established. i.e. will it automatically bump them up/down to the new levels, will it not effect people with existing memberships?

    I have a gift on hold from March until I can get this figured out so any help would be very much appreciated. Thanks all!

    Heather L. Hoyt
    Development Coordinator
    Omaha Symphony
    1605 Howard Street
    Omaha, NE 68102
    tel: 402.342.3836 x125
    fax: 402.342.3819



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.
  • Heather,

    I agree with the other posts about creating new levels and inactivating the old ones.

    1 more thing to consider is reporting in the long term. If you want to show migration or other trending reports, I would suggest creating a local system table that would be used a mapping or definitions table.

    Basically, it would say, old level "X" = new level "Y". Then in your reporting you can use this local table to show that your members renewed at the same level.

    Our membership dept changed all the levels once, and then 1 year later, changed them all back. OMG. Anyhow, this local table helped for certain types of reporting analysis.

    Good Luck,

    Christian

  • I wanted to revive this thread, as we're about to go through a Membership Levels refresh. We intend creating a whole new structure and will deactivate the old Levels.

    This seems straightforward for new and renewals handling.

    My question is about Pledges that have already had pending Memberships created in the current structure, in some cases many years ahead. 

    Any advice about what to do here, do i need to manually adjust the Levels on all Pending memberships, or is there some automatic means of recalculating the Level on Pending records once we change or rules?

    Thanks

    Peter

     

     

  • Peter, it's a good question. I am not sure what will happen to those existing pending memberships. My advice would be to make the change in TEST first and see what happens. I suspect that the pending memberships will not automatically change, but I am not 100% sure. Then, if my suspicion is correct depending on the quantity of pending memberships, I would either manually adjust them or write a script to adjust them.

    Christian @ The Tech Museum

    On Thu, Aug 25, 2011 at 8:42 PM, Peter Nelson <bounce-peternelson1130@tessituranetwork.com> wrote:

    I wanted to revive this thread, as we're about to go through a Membership Levels refresh. We intend creating a whole new structure and will deactivate the old Levels.

    This seems straightforward for new and renewals handling.

    My question is about Pledges that have already had pending Memberships created in the current structure, in some cases many years ahead. 

    Any advice about what to do here, do i need to manually adjust the Levels on all Pending memberships, or is there some automatic means of recalculating the Level on Pending records once we change or rules?

    Thanks

    Peter

     

     

    From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com>
    Sent: 4/6/2009 3:21:27 PM

    Heather,

    I agree with the other posts about creating new levels and inactivating the old ones.

    1 more thing to consider is reporting in the long term. If you want to show migration or other trending reports, I would suggest creating a local system table that would be used a mapping or definitions table.

    Basically, it would say, old level "X" = new level "Y". Then in your reporting you can use this local table to show that your members renewed at the same level.

    Our membership dept changed all the levels once, and then 1 year later, changed them all back. OMG. Anyhow, this local table helped for certain types of reporting analysis.

    Good Luck,

    Christian




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Thanks Christian, we did make the change in Test and the new Levels are now available in that field’s dropdown on the Membership screen, so manual adjustment seems like an option.

     

    I get a little nervous about the Memberships Update utility undoing manual changes, but it doesn’t appear to touch the Level calculations so should be safe!

     

     

    Peter Nelson

    Business Analyst, Information Systems

    T 02 9250 7180  M 0401 714 246 

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    SOH_LOGO.gif

    FACEBOOK.gifTWITTER.gifYOUTUBE.gifBLOG.gif

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Saturday, 27 August 2011 02:07
    To: Peter Nelson
    Subject: Re: [Tessitura Development Forum] modifying membership levels mid seaon

     

    Peter, it's a good question. I am not sure what will happen to those existing pending memberships. My advice would be to make the change in TEST first and see what happens. I suspect that the pending memberships will not automatically change, but I am not 100% sure. Then, if my suspicion is correct depending on the quantity of pending memberships, I would either manually adjust them or write a script to adjust them.

     

    Christian @ The Tech Museum

     

    On Thu, Aug 25, 2011 at 8:42 PM, Peter Nelson <bounce-peternelson1130@tessituranetwork.com> wrote:

    I wanted to revive this thread, as we're about to go through a Membership Levels refresh. We intend creating a whole new structure and will deactivate the old Levels.

    This seems straightforward for new and renewals handling.

    My question is about Pledges that have already had pending Memberships created in the current structure, in some cases many years ahead. 

    Any advice about what to do here, do i need to manually adjust the Levels on all Pending memberships, or is there some automatic means of recalculating the Level on Pending records once we change or rules?

    Thanks

    Peter

     

     

    From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com>
    Sent: 4/6/2009 3:21:27 PM

    Heather,

    I agree with the other posts about creating new levels and inactivating the old ones.

    1 more thing to consider is reporting in the long term. If you want to show migration or other trending reports, I would suggest creating a local system table that would be used a mapping or definitions table.

    Basically, it would say, old level "X" = new level "Y". Then in your reporting you can use this local table to show that your members renewed at the same level.

    Our membership dept changed all the levels once, and then 1 year later, changed them all back. OMG. Anyhow, this local table helped for certain types of reporting analysis.

    Good Luck,

    Christian




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
    Please consider the environment before printing this email.

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====