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, 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 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
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
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 StevensDatabase 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. 1210Fx: 989-631-7890***************************
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
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 PMHeather, 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, ChristianThis 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!
From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com> Sent: 4/6/2009 3:21:27 PM
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
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christian MauriSent: Saturday, 27 August 2011 02:07To: Peter NelsonSubject: 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:
From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com>Sent: 4/6/2009 3:21:27 PM
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=====