So we pull zip codes/postal codes 2 different ways: either off a person's Constituent Record (from member card scans or ticket scans), or we ask for it in a Survey question.
I am starting to expand out on the dashboard's capabilities, including adding an area map to show exactly what states/countries our visitors are coming from.
This is where I started running into a problem. Seeing the visual made me see that some states seemed weird to have on our map, so I did some digging and found some discrepancies (all fixed thanks to Chris Wallingford on another forum post). Anyway, in trying to pinpoint what was wrong to fix the other stuff, I opened up a whole new can of worms. When I used my Pivot Table (which is the exact same data as the area map), for State and Country it was listing (none) for a lot of the General Public responses (aka the ones we get from those surveys).
Some of them are pulling correctly on Gen.Pub because at some point someone at that zip code bought a ticket or a membership, or otherwise had some sort of record Tessitura could link the zip code correctly back to. The problem is not all of our Gen.Pub tickets have that link. So I'm assuming the (none) is because Tessitura has no way of linking that survey question to any state or country.
Is there a way to change the settings in Tessitura so that it will pull those? I asked in the Solution Center at last TLCC and they said it would be a SQL project. Is there any other way of doing it other than messing in the SQL server (we are relatively new and I have 0 SQL experience...I also don't want to waste Extended Services hours on it in case the way they set it up breaks something else).
I wish the zip codes pulled in city and state the way they do when you input them in a constituent record, but, unfortunately, there isn't a setting to change to make it work. 60% of our visitors are walk-up so we lose a lot of info since most are tourists and we don't have constituent records with matching zip codes.
So it sounds like something for the Ideas Board? lol
Am I right in thinking you have a bunch of orders in the constituent 0 account that have zip/postcode data stored in CSIs?
If the pivot point has moved from Constituent ID to Order ID could you not store the postcodes in one of the custom order fields? They exist in analytics. Transferring that over could be a nightly SQL job but it's not a hard one.