Quarterly data address hygiene

I’ll add that we as an organization had used TRG in the past, however we now use Tessitura’s preferred vendor eBay Marketing (formerly to be MBS). They were great, fast, and VERY cost efficient. Doing the NCOA on our database of 400,000+ records took less than 30 minutes and the cost was almost nominal. It might be worth the effort look at using eBay instead of TRG.

Randall A. Mitchell
Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
Sent: Thursday, April 03, 2014 12:36 PM
To: Randall A. Mitchell
Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

Hi Tiffany,

I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

Using TRG for NCOA

TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

TRG does their NCOA processing via Acxiom Corporation.

Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

Example

Good Move = 1 (Match - New address returned. Record will be updated.)

Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

I’ll add that we as an organization had used TRG in the past, however we now use Tessitura’s preferred vendor eBay Marketing (formerly to be MBS). They were great, fast, and VERY cost efficient. Doing the NCOA on our database of 400,000+ records took less than 30 minutes and the cost was almost nominal. It might be worth the effort look at using eBay instead of TRG.

Randall A. Mitchell
Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
Sent: Thursday, April 03, 2014 12:36 PM
To: Randall A. Mitchell
Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

Hi Tiffany,

I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

Using TRG for NCOA

TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

TRG does their NCOA processing via Acxiom Corporation.

Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

Example

Good Move = 1 (Match - New address returned. Record will be updated.)

Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)