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
Ah, good old 10128!
We use 99999 as the postal code for accounts that have no valid address. I’ve set up an entry in tr_citystate where zip5 = 99999, city = No Valid Address, state = XX. I have a procedure that updates the mail restrictions for accounts with a primary address with a postal code of 99999 to No Valid Address so we don’t inadvertently mail to those accounts.
We set the street address to No Valid Address or else something descriptive like “Stage Director, 2012 Romeo and Juliet.”
Lucie
______________________________
Lucie SpielerIT Development and Training Manager
Editor, Season ProgramFLORIDA GRAND opera8390 NW 25th StreetMiami, FL 33122305.854.1643 x. 1521Box Office: 800.741.1010To Give a Gift: 305.403.3315www.FGO.org2011-2012 • 71ST SEASON • LOVE FORBIDDEN, NOT FORGOTTENLuisa Fernanda • La rondine • Rigoletto • Roméo et Juliette
We use 99999 as both the street and the postal code, and suppress anything with that from all mailings. We also do collect full address info from walk-ups generally, or at least email. Something identifying besides just the name.