New Memberships/Donors

We have a membership level which starts at a certain donation amount. We would like to track how many new (ever) people have given at this level, thus have this membership.

We have tried the membership reports, and tried to pull lists based on membership trends, inception dates, initiation dates, membership categories and levels. The data continually gives us constituents who have been long-time donors and give every year. In some cases constituents may have skipped a year due to the time of giving, but we were hoping there would only be a handful of these.

Has anyone been able to do this or something similar? If you have created a report, are you willing to share?

Thanks so much. Any help is appreciated.

Parents
  • Hi Marie!

    You could try using extractions to get this list.  Create a supression segment for anyone with a membership record with status of inactive, deactivated, merged, canceled.  Then, a positive segment for anyone with a membership record with status of active, awaiting payment, suspended, lapsed, pending (and you can narrow this down to the specific level you want by including this in the segment). 

    This should get you a list of anyone who has a current membership and has not had one prior.

  • Nick,

    Thanks for the suggestion. I will try that.

     

    Marie Kocher

    Development Assistant

    Kansas City Ballet

    1616 Broadway

    Kansas City, MO  64108

    (816) 931-2232 x 1310

    www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Barnett
    Sent: Tuesday, March 30, 2010 12:41 PM
    To: Marie Kocher
    Subject: Re: [Tessitura Development Forum] New Memberships/Donors

     

    Hi Marie!

    You could try using extractions to get this list.  Create a supression segment for anyone with a membership record with status of inactive, deactivated, merged, canceled.  Then, a positive segment for anyone with a membership record with status of active, awaiting payment, suspended, lapsed, pending (and you can narrow this down to the specific level you want by including this in the segment). 

    This should get you a list of anyone who has a current membership and has not had one prior.

    From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com>
    Sent: 3/30/2010 12:00:06 PM

    We have a membership level which starts at a certain donation amount. We would like to track how many new (ever) people have given at this level, thus have this membership.

    We have tried the membership reports, and tried to pull lists based on membership trends, inception dates, initiation dates, membership categories and levels. The data continually gives us constituents who have been long-time donors and give every year. In some cases constituents may have skipped a year due to the time of giving, but we were hoping there would only be a handful of these.

    Has anyone been able to do this or something similar? If you have created a report, are you willing to share?

    Thanks so much. Any help is appreciated.




    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!

Reply
  • Nick,

    Thanks for the suggestion. I will try that.

     

    Marie Kocher

    Development Assistant

    Kansas City Ballet

    1616 Broadway

    Kansas City, MO  64108

    (816) 931-2232 x 1310

    www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Barnett
    Sent: Tuesday, March 30, 2010 12:41 PM
    To: Marie Kocher
    Subject: Re: [Tessitura Development Forum] New Memberships/Donors

     

    Hi Marie!

    You could try using extractions to get this list.  Create a supression segment for anyone with a membership record with status of inactive, deactivated, merged, canceled.  Then, a positive segment for anyone with a membership record with status of active, awaiting payment, suspended, lapsed, pending (and you can narrow this down to the specific level you want by including this in the segment). 

    This should get you a list of anyone who has a current membership and has not had one prior.

    From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com>
    Sent: 3/30/2010 12:00:06 PM

    We have a membership level which starts at a certain donation amount. We would like to track how many new (ever) people have given at this level, thus have this membership.

    We have tried the membership reports, and tried to pull lists based on membership trends, inception dates, initiation dates, membership categories and levels. The data continually gives us constituents who have been long-time donors and give every year. In some cases constituents may have skipped a year due to the time of giving, but we were hoping there would only be a handful of these.

    Has anyone been able to do this or something similar? If you have created a report, are you willing to share?

    Thanks so much. Any help is appreciated.




    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!

Children
No Data