We decided to go the route of using Zeta for our NCOA processing moving forward after many hours of manual data manipulation to make other options work for us. The process was super easy and smooth. What I didn't realize until a week later is that our policy is that Apt, Ste, Unit, etc goes in Street2 but when the data came back and was imported it had it all in Street1. Has anyone had this happen and has a clever script to fix it? Conversely, is it better if we just change our company data standards to match what the USPS uses?
We put Apt/Ste/Unit/etc... in Street1. In fact, we pretty much avoid Street2 altogether. We used to use the # sign, but switched to Apt/Ste/Unit/etc... a year or so ago, but we still left it in Street1 at that time, too. Either way, we have had no issues with either in terms of mailing, and we have been using this standard for 10 years.
I do not know if one way is "better" or "worse", but Street1 works for us just fine.
Madeline Dummerth (Past Member) said:Conversely, is it better if we just change our company data standards to match what the USPS uses?
This is a wise approach, imho. If you have SSMS access to your data, I could suggest some code to find/fix the matching street1/2 data that's been created.