We are finding that the it's difficult to get accurate sales analysis by zip code because of the high number of constituent records that have the same zip code as our business address. It has been our default to use the city, state, and zip from our business address for night-of-show walk-up sales or any transaction where we can not get an address or the customer refuses to give the address. The result of this is that it appears sales in that zip code are off the charts. We can't eliminate this zip code from analysis because it actually does include the majority of our customer base.
I'm curious to know what other organizations use as the "default address" when a real address can not be entered? What do you enter for the street information? Is it the policy to automatically mark these undeliverable or mark it in such a way to encourage getting an accurate address in the future?
Thank you in advance for the feedback!
Chuck Buchanan
92nd Street Y
Hi Charles!
We don't currently do very much with address analysis. So I'm not sure yet how our policy will affect that.
When we don't have enough info for an address we will input Street 1 as 0000 and postal code as O0O 0O0. This helps us quickly remove these people from mailing lists and such.