Chris, I have used Microsoft MapPoint... It imports CSV, XLS and can connect to SQL databases. So while it works pretty good for the mapping part, I found is that Marketing usually has a hard time acting on that kind of data. It ends up being a neat visualization with little effective ROI. Also be careful that the process allows for the users not to give a zip as admissions staff will make up data if there is no skip button when a patron refuses... they punch in their own zip or the museums to avoid arguing with the patron.
Rich Rich Cherry Director Balboa Park Online Collaborative A Project of the Benbough Operating Foundation 2131 Pan American Plz San Diego, CA 92101 B: (619) 819-8331 F: (619) 819-8230 rcherry at balboaparkonline.org -----Original Message----- From: mcn-l-bounces at mcn.edu [mailto:[email protected]] On Behalf Of Chris Scrofani Sent: Monday, June 29, 2009 6:33 PM To: Museum Computer Network Listserv Subject: [MCN-L] Zip Code Statistics Hello All, We are thinking about asking our visitors for their zip code when they enter our museum. We know that many other museums do this as well. We are curious as to the best way to use the collected data though. I'm curious if there is a type of "zip code stats" type of program or website, that allows you to import a text file (.csv or other), and then analyzes the zip codes and shows you graphs / maps / lists of where your visitors come from. Does anyone know of something like this? How do you all interpret your zip code data once it has been collected? Thanks, Chris -- Chris Scrofani Network Administrator Honolulu Academy of Arts 900 South Beretania Street Honolulu, HI 96814 Tel. 808 532-3625 cscrofani at honoluluacademy.org _______________________________________________ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l The MCN-L archives can be found at: http://toronto.mediatrope.com/pipermail/mcn-l/
