Top Postcode Dashboard Listing (none) for State and Country

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).