Institutional Records

Hello all,

Our Development Department has come across a problem that could be solved by Version 11--but I'm looking for any input on how other organizations handle this:

Our Institutional records are set up such that there is a Corporate or Foundation record to which any contributions are entered, and there are associated records for all of the Organizational Contacts.  BUT, if we want to pull lists based on contributions, we don't get these associated contacts--we just get the institutional record, which doesn't have accurate, specific contact information for any of the various contacts--CEOs, Assistants, Board Members, etc. 

Our Institutional Giving director faces this problem most often, and has created an Attribute to flag the individuals associated with institutions with which he has relationships--those he would want to invite to openings based on their institution's giving, etc.  We closely monitor this attribute and generate a list based on the attribute for mailings, invitations, etc.  BUT, it means we can't pull lists based on Contribution to Gala or Capital--because the Organizational Contact pulls in the segment based on the attribute (more accurately), and the Institutional record pulls on the, say, Gala or Capital segment based on Contribution.  The records don't dedupe.

Not only is this a waste of our resources, and, if both materials make it out the door, unprofessional, but I'm not convinced that there isn't a better way to do this.  Is there a way to pull all records associated with another record?  I also don't think our Attribute is the best practice way of pulling the Institutional list to begin with.

Any advice would be much appreciated.

 

Thanks,

Frannie O'Connell

  • This is uncharted territory for me specifically but I remembered seeing something at the Tess conference about this and figured I'd at least share. Then someone more knowledgeable then I may have more to add!

    When you building the criteria for a list (or extraction segment) there is an Associations button in the bottom right hand corner of the criteria screen. When you open it you can get a few options to include Association Types, Filter by list, Include Inactive, etc.

    I'd suggest checking that out and seeing if it's what you're looking for!

  • Frances,

     

    In the version we have, when we are creating a list, we are able to pull the associated records. In the window to select our criteria for our list, we have an “Associations” Button. Attached is a screen shot of where we can do this. It should give you any associated records to those you are originally making the list from.

     

    I do know that in earlier versions there was a checkbox to include associated records at some point in the list making process.

     

    I hope this helps.

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W. Pershing Road, Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Thursday, December 01, 2011 5:32 PM
    To: Marie Kocher
    Subject: [Tessitura Development Forum] Institutional Records

     

    Hello all,

    Our Development Department has come across a problem that could be solved by Version 11--but I'm looking for any input on how other organizations handle this:

    Our Institutional records are set up such that there is a Corporate or Foundation record to which any contributions are entered, and there are associated records for all of the Organizational Contacts.  BUT, if we want to pull lists based on contributions, we don't get these associated contacts--we just get the institutional record, which doesn't have accurate, specific contact information for any of the various contacts--CEOs, Assistants, Board Members, etc. 

    Our Institutional Giving director faces this problem most often, and has created an Attribute to flag the individuals associated with institutions with which he has relationships--those he would want to invite to openings based on their institution's giving, etc.  We closely monitor this attribute and generate a list based on the attribute for mailings, invitations, etc.  BUT, it means we can't pull lists based on Contribution to Gala or Capital--because the Organizational Contact pulls in the segment based on the attribute (more accurately), and the Institutional record pulls on the, say, Gala or Capital segment based on Contribution.  The records don't dedupe.

    Not only is this a waste of our resources, and, if both materials make it out the door, unprofessional, but I'm not convinced that there isn't a better way to do this.  Is there a way to pull all records associated with another record?  I also don't think our Attribute is the best practice way of pulling the Institutional list to begin with.

    Any advice would be much appreciated.

     

    Thanks,

    Frannie O'Connell




    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!

    Nutcracker 2011

  • The Associations button the criteria set will give you what you want, as the others have suggested.  Here’s a link to the documentation that will explain how it works.

     

    In v11 you will do essentially the same thing in this situation, except you will be selecting affiliations instead of associations.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • Great! This is exactly what I was looking for!  Now we just have to clean up all our associations... :) Thank you all!

  • Hi Franny,

     

    For what it’s worth, I’d be happy to talk to you a little bit about cleaning up associations. We did this over the summer after I learned more about pulling associations at the Tess conference and it’s been a HUGE help for us in pulling lists for exactly the purposes you describe. I do usually have to do some manual editing to the list, but it’s been so much cleaner than it’s ever been before. Let me know if you want to chat!

     

    Gina Napolitano
    Development Associate
    Kaufman Center

    129 W. 67th St.
    New York, NY 10023
    P. 212 501 3356
    F. 212 874 7865
    kaufman-center.org

    cid:image001.gif@01CB2378.8302FD50

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Friday, December 02, 2011 11:45 AM
    To: Gina Napolitano
    Subject: RE: [Tessitura Development Forum] Institutional Records

     

    Great! This is exactly what I was looking for!  Now we just have to clean up all our associations... :) Thank you all!

    From: Kevin Sheehan <bounce-kevinsheehan4372@tessituranetwork.com>
    Sent: 12/2/2011 8:57:03 AM

    The Associations button the criteria set will give you what you want, as the others have suggested.  Here’s a link to the documentation that will explain how it works.

     

    In v11 you will do essentially the same thing in this situation, except you will be selecting affiliations instead of associations.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     




    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!

  • We’re only using Street 3 when absolutely necessary (because we don’t have room for it on ticket headers, which we use as address labels)—and that for business addresses in Individual records. We leave the company name in Salutation 1 for organization records. We’re trying not to send mail to the company, but to the people at the company.

     

    We are handling people who work at companies via affiliations. We have a few different affiliation types that we use: Primary Contact, Grants Contact, Tickets/Benefits Contact, Primary Contact, Employee (for corporations); Teacher (for schools). So for mailings having to do with tickets, I’d pull the Tickets/Benefits Contact(s) affiliated to the company that holds the tickets.

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera