Promoting Invitations (lists that are reviewed)

Former Member
Former Member $organization

Hey all, so a fun riddle - when preparing for a save the date or invitation mailing, our special events team will often edit the list after it has been pulled (adding and removing names).  As a result, we can't promote at time of extraction.  We could promote the list as a whole (what used to be done), but I want to promote the segments as separate sources.

As of now, I re-run the extraction - I find the difference between the original list and the final list, add any additions and suppress any removals.  Because there is also a time lag, I also re-extract the list and find the differences between the original list and the re-extracted list to see who to suppress or add.

Does anyone know of/has anyone found a better way to handle this?

Thanks in advance!

 

Carla Moy

Development Manager, 92nd Street Y

  • Carla:

     

    I can think of two possible ways to make your process easier. You can save the extraction as a selected list when you extract, allowing you to simply edit the list in tess as you go. Otherwise, if you keep the tessitura ID numbers in your spreadsheet during review, you can add the new ID numbers to your list and then import the ID numbers and promote that imported list. I’ve used both ways – it’s really up to your preference as to whether you’d like to do your editing in Tess or in Excel.

     

    Hope that helps,

    Laine

     

    --

    Laine Kyllonen

    Database Application Specialist

    Science Museum of Minnesota

    (651) 221-2515

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Carla Moy
    Sent: Tuesday, February 11, 2014 1:42 PM
    To: lkyllonen@smm.org
    Subject: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Hey all, so a fun riddle - when preparing for a save the date or invitation mailing, our special events team will often edit the list after it has been pulled (adding and removing names).  As a result, we can't promote at time of extraction.  We could promote the list as a whole (what used to be done), but I want to promote the segments as separate sources.

    As of now, I re-run the extraction - I find the difference between the original list and the final list, add any additions and suppress any removals.  Because there is also a time lag, I also re-extract the list and find the differences between the original list and the re-extracted list to see who to suppress or add.

    Does anyone know of/has anyone found a better way to handle this?

    Thanks in advance!

     

    Carla Moy

    Development Manager, 92nd Street Y




    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!

  • Former Member
    Former Member $organization in reply to Laine Kyllonen

    Carla,

    At City Center we use Laine's second method of importing when we're working on a mailing that is heavily edited by hand. As long as we have ID numbers we can import them back into Tessitura.

    We also save lists segment by segment, so our special events team is never editing just one big list: they are going through the Board list, the Major Donor list, etc.  This lets us import each list as its own List Manager List, which can then be de-duped in a new extraction and promoted.

    It's a lot of manual work!  But some of our events genuinely are handpicked so it makes sense to treat these lists as manual instead of rule-based.

    -- Mike

  • Former Member
    Former Member $organization

    Thanks, Laine.  The team actually does import the final list into Tess, but if I promote that final list it’s all one source, rather than different sources for the different extraction segments (right?).

     

    Carla Moy

    Development Manager, 92nd Street Y

    212.415.5482

    cmoy@92Y.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Laine Kyllonen
    Sent: Tuesday, February 11, 2014 3:13 PM
    To: Carla Moy
    Subject: RE: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Carla:

     

    I can think of two possible ways to make your process easier. You can save the extraction as a selected list when you extract, allowing you to simply edit the list in tess as you go. Otherwise, if you keep the tessitura ID numbers in your spreadsheet during review, you can add the new ID numbers to your list and then import the ID numbers and promote that imported list. I’ve used both ways – it’s really up to your preference as to whether you’d like to do your editing in Tess or in Excel.

     

    Hope that helps,

    Laine

     

    --

    Laine Kyllonen

    Database Application Specialist

    Science Museum of Minnesota

    (651) 221-2515

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Carla Moy
    Sent: Tuesday, February 11, 2014 1:42 PM
    To: lkyllonen@smm.org
    Subject: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Hey all, so a fun riddle - when preparing for a save the date or invitation mailing, our special events team will often edit the list after it has been pulled (adding and removing names).  As a result, we can't promote at time of extraction.  We could promote the list as a whole (what used to be done), but I want to promote the segments as separate sources.

    As of now, I re-run the extraction - I find the difference between the original list and the final list, add any additions and suppress any removals.  Because there is also a time lag, I also re-extract the list and find the differences between the original list and the re-extracted list to see who to suppress or add.

    Does anyone know of/has anyone found a better way to handle this?

    Thanks in advance!

     

    Carla Moy

    Development Manager, 92nd Street Y




    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!
  • Carla,

     

    Yes, if you import it all as one list then you would get one source. If you want it to be more segmented, you can certainly import multiple lists (sort of like Michael mentioned) and then you’d have a board list, a major donor list, etc.

     

    Laine

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Carla Moy
    Sent: Tuesday, February 11, 2014 2:47 PM
    To: lkyllonen@smm.org
    Subject: RE: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Thanks, Laine.  The team actually does import the final list into Tess, but if I promote that final list it’s all one source, rather than different sources for the different extraction segments (right?).

     

    Carla Moy

    Development Manager, 92nd Street Y

    212.415.5482

    cmoy@92Y.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Laine Kyllonen
    Sent: Tuesday, February 11, 2014 3:13 PM
    To: Carla Moy
    Subject: RE: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Carla:

     

    I can think of two possible ways to make your process easier. You can save the extraction as a selected list when you extract, allowing you to simply edit the list in tess as you go. Otherwise, if you keep the tessitura ID numbers in your spreadsheet during review, you can add the new ID numbers to your list and then import the ID numbers and promote that imported list. I’ve used both ways – it’s really up to your preference as to whether you’d like to do your editing in Tess or in Excel.

     

    Hope that helps,

    Laine

     

    --

    Laine Kyllonen

    Database Application Specialist

    Science Museum of Minnesota

    (651) 221-2515

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Carla Moy
    Sent: Tuesday, February 11, 2014 1:42 PM
    To: lkyllonen@smm.org
    Subject: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Hey all, so a fun riddle - when preparing for a save the date or invitation mailing, our special events team will often edit the list after it has been pulled (adding and removing names).  As a result, we can't promote at time of extraction.  We could promote the list as a whole (what used to be done), but I want to promote the segments as separate sources.

    As of now, I re-run the extraction - I find the difference between the original list and the final list, add any additions and suppress any removals.  Because there is also a time lag, I also re-extract the list and find the differences between the original list and the re-extracted list to see who to suppress or add.

    Does anyone know of/has anyone found a better way to handle this?

    Thanks in advance!

     

    Carla Moy

    Development Manager, 92nd Street Y




    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!




    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!

  • Hi Carla,

    We important the final list and promote that to the record and add the activity/event invites.  We also retain the original extraction in case we want to isolate the source of the patron's addition to the list. 

    Is there a reason or business practice that you want to promote their invitation from different sources?  Event levels or something of that nature that could be managed another way?

    Amber

    _______________________________________________________

    Amber Newsome

    Manager of Special Campaigns
    Segerstrom Center for the Arts

    600 Town Center Drive, Costa Mesa, CA 92626

    T (714) 556-2122 x 4259   F (714) 755-2712
    E ANewsome@SCFTA.org

     

  • Former Member
    Former Member $organization

    Hi Amber - I’d like to see how well each source performs – see how much came in via guests from a chair’s VIP list vs. that segment of specific ticket buyers vs. that segment of patrons with specific wealth screenings in certain zip codes, etc.  I’d like to the breakdown of the event by source, have each segment be separate in that context.  And I’d like to be able to view it all in T-Stats or make a list, etc.  I basically want to capitalize on the full functionality that sources can offer.

     

    Thanks everyone for all your insight.

     

    Carla

     

    Carla Moy

    Development Manager, 92nd Street Y

    212.415.5482

    cmoy@92Y.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Amber Newsome
    Sent: Friday, February 21, 2014 2:26 PM
    To: Carla Moy
    Subject: Re: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Hi Carla,

    We important the final list and promote that to the record and add the activity/event invites.  We also retain the original extraction in case we want to isolate the source of the patron's addition to the list. 

    Is there a reason or business practice that you want to promote their invitation from different sources?  Event levels or something of that nature that could be managed another way?

    Amber

    _______________________________________________________

    Amber Newsome

    Manager of Special Campaigns
    Segerstrom Center for the Arts

    600 Town Center Drive, Costa Mesa, CA 92626

    T (714) 556-2122 x 4259   F (714) 755-2712
    E ANewsome@SCFTA.org

     

    From: Carla Moy <bounce-carlalerman4285@tessituranetwork.com>
    Sent: 2/11/2014 1:19:39 PM

    Hey all, so a fun riddle - when preparing for a save the date or invitation mailing, our special events team will often edit the list after it has been pulled (adding and removing names).  As a result, we can't promote at time of extraction.  We could promote the list as a whole (what used to be done), but I want to promote the segments as separate sources.

    As of now, I re-run the extraction - I find the difference between the original list and the final list, add any additions and suppress any removals.  Because there is also a time lag, I also re-extract the list and find the differences between the original list and the re-extracted list to see who to suppress or add.

    Does anyone know of/has anyone found a better way to handle this?

    Thanks in advance!

     

    Carla Moy

    Development Manager, 92nd Street Y




    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!

  • Carla,

     

    Hmmm… well, this could create more work but perhaps over less time … you could create the initial extraction as you explain, give each individual list to your team for review and then import one, final invite list to Tessitura.  Promote that one list to all of the records for mailing and activities/event use. 

    Then, you could either …

    Return to the original extraction and add the event invite criteria to the source, re-run the extraction and then you have only those who were actually invited to the event; or…

    When you’re trying to determine your response post event, you could add a line of criteria to your original extraction to include the event response, regenerate the extraction and then have a clean group of each original segment with the names of those attended.  You could then save those to lists or promote them post event in an ROI category for use in T-Stats. 

     

    Could either of those potentially work?  You still wouldn’t be able to promote at the time of the extraction.

     

    Otherwise, you could just create the promotions and invites at the time of the initial extraction and then update the response status to “not invited”, “dropped”, or something like that to track who was on the original list and didn’t make the cut?

     

    Amber

     

    _______________________________________________________

    Amber Newsome

    Manager of Special Campaigns
    Segerstrom Center for the Arts

    600 Town Center Drive, Costa Mesa, CA 92626

    T (714) 556-2122 x 4259   F (714) 755-2712
    E ANewsome@SCFTA.org

     

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Carla Moy
    Sent: Friday, February 21, 2014 12:35 PM
    To: Amber Newsome
    Subject: RE: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Hi Amber - I’d like to see how well each source performs – see how much came in via guests from a chair’s VIP list vs. that segment of specific ticket buyers vs. that segment of patrons with specific wealth screenings in certain zip codes, etc.  I’d like to the breakdown of the event by source, have each segment be separate in that context.  And I’d like to be able to view it all in T-Stats or make a list, etc.  I basically want to capitalize on the full functionality that sources can offer.

     

    Thanks everyone for all your insight.

     

    Carla

     

    Carla Moy

    Development Manager, 92nd Street Y

    212.415.5482

    cmoy@92Y.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Amber Newsome
    Sent: Friday, February 21, 2014 2:26 PM
    To: Carla Moy
    Subject: Re: [Tessitura Development Forum] Promoting Invitations (lists that are reviewed)

     

    Hi Carla,

    We important the final list and promote that to the record and add the activity/event invites.  We also retain the original extraction in case we want to isolate the source of the patron's addition to the list. 

    Is there a reason or business practice that you want to promote their invitation from different sources?  Event levels or something of that nature that could be managed another way?

    Amber

    _______________________________________________________

    Amber Newsome

    Manager of Special Campaigns
    Segerstrom Center for the Arts

    600 Town Center Drive, Costa Mesa, CA 92626

    T (714) 556-2122 x 4259   F (714) 755-2712
    E ANewsome@SCFTA.org

     

    From: Carla Moy <bounce-carlalerman4285@tessituranetwork.com>
    Sent: 2/11/2014 1:19:39 PM

    Hey all, so a fun riddle - when preparing for a save the date or invitation mailing, our special events team will often edit the list after it has been pulled (adding and removing names).  As a result, we can't promote at time of extraction.  We could promote the list as a whole (what used to be done), but I want to promote the segments as separate sources.

    As of now, I re-run the extraction - I find the difference between the original list and the final list, add any additions and suppress any removals.  Because there is also a time lag, I also re-extract the list and find the differences between the original list and the re-extracted list to see who to suppress or add.

    Does anyone know of/has anyone found a better way to handle this?

    Thanks in advance!

     

    Carla Moy

    Development Manager, 92nd Street Y




    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!

  • Former Member
    Former Member $organization in reply to Amber Newsome

    In case anyone is curious, we had our DBA create a version of the Delete Promotions and Sources utility which allows you to filter by list.  It allows us to promote when we pull the lists (which we need so the lists can identify which segment they were from), and we then use the new utility to remove the promotions from those who were not sent the invite.  We just add another source to the appeal with the additions.