Not exactly techincal but since forum would be involved in all aspects I thought I'd post here -- what the best practice for this?
The Web is a wonderful thing but it has resulted in far to many records with No postal address. I've been making my way thru a few records (100K+ due to no prior clean up/oversite).
The BO or Web create records with only an email (or BO often neither postal or email). These records with no address have a Mail Restriction of "No Address", Street1 is ***No Address*** and the zip is our zip code 10019.
The result of course is that our zip code statistics are distorted. While we can instruct/remind folks to manage this zip accordingly - I'm wondering if any site has found a way to isolate them better.
I almost want a separate zip code to be applied possible after review OR separate country UNKNOWN.
Continous review and clean are needed I understand but really would like a good way to isolate the Unknown geo folks. And knowing what others have done can boost my suggestions here. Thanks
You say that the records with no address have a Street1 of "***No Address***", which suggests that they actually do have a row in T_ADDRESS, which should make it easy to update and isolate these records, assuming you or someone at your org has SQL access to your data.
10019 is a real Zip, and you've seen why using a real zip for fake addresses is bad. I would recommend something like "99999", which is what we use, and which is our Default Postal_Code in T_DEFAULTS.
We also set all such addresses to geo_area = 0 ("Bad Zips").