How are folks tracking geographic source for Walkup International Guests? In the case where you are not geting full addresses.
For example, you may use Surveys or Custom Fields for your counties postal codes on the General Public Account 0. But you have an international guest, not from your country. Is anyone keeping the country or continent from which the customer is coming from? If so how?
Hi Tom,
We're using the Order Survey functionality to capture US zip codes/states as well as international countries. It exports quite well, but requires a good bit of cleanup - some people might type in 'Spain', others 'ESP', etc.
Thanks,
Are you using a single field or multiples? (For example one for Postal Codes, the other for the country?)
Are you making this a required response? If so, what are staff doing if the customer refuses to provide the information?
Do you know if the surveys can take dropdowns to clean up the quality of the data entry?
It is a one-field, required response with no dropdown, so you can imagine the data cleanliness (or lack thereof). I believe a dropdown can be set up, but for us, I don't think that would be practical. Check out the TR_SURVEY_QUESTION table for more info!
Like the Intrepid Sea, Air & Space Museum, we use order survey with three required questions: 1. Country 2. Zip Code 3. Repeat Visitor. If the guest is international we have an internal code our staff is trained on to complete for Zip Code. Our Country question references the TR_Country table.
We worked with Tessitura's Extended Services to create a report to see our country and zip code information with number of tickets and dollar amount. We prioritize orders with a known CID attached for country/zip information and then look to CID 0 for order survey results.
Hope this information is helpful.
AT the MCA we have a drop down field in our survey with all US zip codes and a list of every other country. It works really well
Yes! The drop-down references a view table that combines TR_Country and the city state table (T_citystate? TX_city_state_...?) to get both the countries and the zips in one drop-down.
Thank You all. This is worth considering. This will be a somewhat larger jump of us. Because we have invested in ~99999 different accounts for each of the zip codes. We have to decide whether to keep that practice and figure out how to add new accounts either for each country. OR move to the Survey approach described here.
Is anyone using this same survey approach to gather emails at the walkup box office?