My Director of Development needs our overall attendance by state for fiscal year 2023. The problem is we don't have our Geo_Area system table set up yet to pull our zip codes by state (yet, I'm hoping to get that fixed at the TLCC conference next week).
Does anyone else know of a way I might pull what she needs relatively easily without that?
Do your addresses not have a state component?
They do, but our problem is we don't do many online sales (working on increasing that for FY24). So the only way we get data is from asking for zip codes during walk-up sales.
Analytics can probably help you
I have a zip code dashboard created already, but it doesn't break them down by state because we haven't gotten that system table set up yet. Not sure how else I can easily separate those zip codes by state.
To set up Geo Areas you will also need to edit the stored procedure that applies them in SSMS. You set up what the Geo Areas are in the system table, and then you edit the stored procedure to define the zip codes. If you know SQL, it is pretty straightforward to update the procedure by looking at what is there. I suggest trying it in your Test environment first.
I have SQL but haven't played in it enough yet. I have a Solution Center pass for the Conference for them to teach me this (at least as much as they can in 15 minutes).