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

Parents
  • 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

Reply
  • 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

Children
No Data