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
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.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jennifer BuzzellSent: Thursday, March 15, 2012 8:36 AMTo: rbernard@smm.orgSubject: RE: [Tessitura Ticketing Forum] Default address used for walk-up constituent accounts
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.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Charles BuchananSent: Wednesday, March 14, 2012 5:45 PMTo: Jen BuzzellSubject: [Tessitura Ticketing Forum] Default address used for walk-up constituent accounts
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!