Default address used for walk-up constituent accounts

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 Spieler
IT Development and Training Manager

Editor, Season Program

FLORIDA GRAND opera
8390 NW 25th Street
Miami, FL 33122
305.854.1643 x. 1521
Box Office: 800.741.1010
To Give a Gift: 305.403.3315
www.FGO.org

2011-2012 • 71ST SEASON • LOVE FORBIDDEN, NOT FORGOTTEN
Luisa Fernanda • La rondine • Rigoletto • Roméo et Juliette

Why don’t you use a fake one like 11111, and then you can easily rule those out?  We use XXXXX so we can easily find and remove them when we mail.

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

The museum has a preponderance of walk-up sales. We have configured the “Category” field to capture zip codes. It is a bit cumbersome as it uses a drop-down; as such we need to continually “encourage” staff to use it …and not enter our business zip code, or some other familiar one. It can be turned on and off as a required field.