How have folks found the best way to visualize the Postal Code data within Tessitura? I'm trying to draw up some Analytics widgets/dashboards that will present things cleanly. I can draw up a scatter map, but that gets cluttered rather quickly.
Previously, we had mostly on-site sales, and our staff would ask the zip code survey question of each guest, and we could pull the results. Currently, our sales are online-only, so the survey question isn't possible.
How have you folks found it best to display the answer to the age-old question of 'Where are our guests coming from?'
We've been using Geo Area because it's slightly easier for folks that don't know all the zip codes to understand. It did take some set up in SQL to get our important geo areas coded in but has been totally worth the extra work. I'm currently using a pie chart, though it's not my favorite way to visualize this kind of data. I've also used a treemap which visually is very clear (in my opinion).
Same with us. Our Geo area correspond to the Local Government Area's in Aus because it's often a reporting requirement. Education love it and as census data also pivot on this it's easy (aka possible) to look at your database wrt national census data. Geo area can be popped into your scatter map as additional detail.
Other than that I do a top 10-20 of post codes
I'm interested! When I looked up 'Geo Area', it said there would be some SQL work needed:
"
Would this be possible without a customization? Without fine-tuning, I don't know if that would be usable for us.
If you have someone on staff with SQL knowledge, it's a bit time-consuming but very doable!
That sounds good. My SQL knowledge is quite limited- is there a how-to for this? Or would it be safer to stay away if I'm not confident?
I did this pretty early in my SQL journey. If you'd like, I can send you my updated LP_UPDATE_GEOAREA as an example if you shoot me your email address. You need to add in all the different geo areas you want into the system table TR_GEO_AREA first and then use those id numbers to edit your procedure.
I did a little presso on Geo area in Analytics:https://docs.google.com/presentation/d/1FeQF6SdnvOBl-7Am_GF02BD4O946nl-x-RA8oWoG13s/edit?usp=sharing
If you need I can send my LP_UPDATE_GEOAREA as a comparison. It was just a hack of the one that's already there.
HI Madeline, could you please send me your GEOAREA procedure? I've been asked to track zip code data too and I'm trying to see if I can do it without a consulting requst.
Sure - shoot me your email address and I'll send it over! Mine is specifically for Maryland geo areas but it should give you the gist of how I updated it with my comments in the code.
I did a bunch of this work to have Core Market, Regional Market and then Regional Areas... Happy to share - just email me (mfrench@cballet.org)