• Replies 4 replies
  • Subscribers 332 subscribers
  • Views 34 views
  • Users 0 members are here
Related

Recovery from NCOA Delinquency?

Brian Jones
$organization

Dearest Friends and Colleagues Across the Network--

A little backstory before I begin--we've been atrocious at keeping up with NCOA changes. As in we really haven't been keeping up at all. For years. Children have been born and grown since we've kept up with this stuff. (Whoops ...)

And so, here I am, with a drive and desire to do better. To pull our data up by the bootstraps, dust ourselves off, and make good. I recently did a mailer and my printer sent me back a couple of NCOA lists, and I'm wondering where to begin with them. Of course, the printer's lists don't contain the constituent IDs that I had in my original list (DOH), and there are 1665 records in the list of moves.

Before I dig in and start doing them all by hand, I'm wondering if there are folks who have any experience in this realm of recovery from NCOA delinquency with tips, tricks, or an allusion to resources to review and learn from? I've taken a look at the NCOA report in Tess, but it's sort of a mystery amongst mysteries to me at the moment.

Thank you for your thoughts and reflections on this!

  • $organization

    Hi Brian,

    If your database is seriously out of date, you may want to use a service like http://www.melissadata.com/ to get it in good order.  I used them about ten years ago and they were reasonably priced.  Then you would have account numbers and could ask for the data to be returned in Tessitura NCOA program friendly.

    Susan

     

  • Former Member
    Former Member $organization

    Hi Brian,

    NCOA utility/report in Tessitura looks complicated, but it is not, if you can devote a little time to read through it and play with it in test.  It will save you time in comparison to preparing a procedure of your own, designing the input format for Tessitura, and communicating that to your mailer.  Tessitura's preferred vendor for NCOA processing became a part of eBay Enterprise recently.  Below is the contact information:

    Anderson Rodriguez

    Associate NCOA/List Rental Processing, Delivery Operations     

    eBay Enterprise

    631 851 5146   F 631 851 5215  

    Anderodriguez@ebay.com

    You will need to have your entire database processed for addresses in use, and you will get the addresses back in the standard format you like to be imported into Tessitura using the Tessitura utility.  All your addresses in your database would then be updated in the standard format until someone online or in the box office types the address in a non-standard format.  So, this is needs to be repeated regularly.  There is a cost, of course, but it is quite reasonable.  One thing the process does not do is to provide demographic data such as children, deceased, etc..  All it does is to give you the standard form of the addresses, provide the forwarding address, if there is one, and mark those that cannot be matched with US Mail's master list as "Do Not Mail".  The latter may get tricky, as mismatches will be pooled in with those, who actually filed a "Do Not Mail" request with US Mail.  Most times, mail with mismatched names would be delivered anyhow, but it will be marked as DNM in Tessitura and will be excluded from your lists, if you do not edit them.

    I hope you find this information useful.  Please let me know, if you have any questions.

  • $organization

    This just in from late notice--thank you both for your help! I've been pulled away on a couple things this past week but am trying to circle back in on this and figure it all out. Thank you!!!

  • $organization

    Hi Brian,

     

    I have used EBay Enterprise  here at Houston Ballet and I highly recommend them.

     

    Thanks,

    Bobby Moseley

    Houston Ballet

    601 Preston Street

    Houston, TX 77002

    (713) 535-3253

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Ahmet Unal
    Sent: Wednesday, September 30, 2015 5:42 PM
    To: Moseley, Bobby
    Subject: Re: [Tessitura Marketing Forum] Recovery from NCOA Delinquency?

     

    Hi Brian,

    NCOA utility/report in Tessitura looks complicated, but it is not, if you can devote a little time to read through it and play with it in test.  It will save you time in comparison to preparing a procedure of your own, designing the input format for Tessitura, and communicating that to your mailer.  Tessitura's preferred vendor for NCOA processing became a part of eBay Enterprise recently.  Below is the contact information:

    Anderson Rodriguez

    Associate NCOA/List Rental Processing, Delivery Operations     

    eBay Enterprise

    631 851 5146   F 631 851 5215  

    Anderodriguez@ebay.com

    You will need to have your entire database processed for addresses in use, and you will get the addresses back in the standard format you like to be imported into Tessitura using the Tessitura utility.  All your addresses in your database would then be updated in the standard format until someone online or in the box office types the address in a non-standard format.  So, this is needs to be repeated regularly.  There is a cost, of course, but it is quite reasonable.  One thing the process does not do is to provide demographic data such as children, deceased, etc..  All it does is to give you the standard form of the addresses, provide the forwarding address, if there is one, and mark those that cannot be matched with US Mail's master list as "Do Not Mail".  The latter may get tricky, as mismatches will be pooled in with those, who actually filed a "Do Not Mail" request with US Mail.  Most times, mail with mismatched names would be delivered anyhow, but it will be marked as DNM in Tessitura and will be excluded from your lists, if you do not edit them.

    I hope you find this information useful.  Please let me know, if you have any questions.

    From: Brian Jones <bounce-brianjones7980@tessituranetwork.com>
    Sent: 9/30/2015 1:39:38 PM

    Dearest Friends and Colleagues Across the Network--

    A little backstory before I begin--we've been atrocious at keeping up with NCOA changes. As in we really haven't been keeping up at all. For years. Children have been born and grown since we've kept up with this stuff. (Whoops ...)

    And so, here I am, with a drive and desire to do better. To pull our data up by the bootstraps, dust ourselves off, and make good. I recently did a mailer and my printer sent me back a couple of NCOA lists, and I'm wondering where to begin with them. Of course, the printer's lists don't contain the constituent IDs that I had in my original list (DOH), and there are 1665 records in the list of moves.

    Before I dig in and start doing them all by hand, I'm wondering if there are folks who have any experience in this realm of recovery from NCOA delinquency with tips, tricks, or an allusion to resources to review and learn from? I've taken a look at the NCOA report in Tess, but it's sort of a mystery amongst mysteries to me at the moment.

    Thank you for your thoughts and reflections on this!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!