Hi!
Our Dev dept is working on a grant application that wants to know how many patrons from outside a 50-mile radius will attend our shows this season. Based on our 22-23 sales, is there a way to estimate a projection for 23-24 or even to tell how many people attended from outside a 50 mile radius?
Thanks for any help you can provide!
Have you set up your Geo Areas? It would require figuring out the zip code ranges for what is in your 50-mile radius, but you could then set up a Geo Area that looks at all zip codes outside that range. It is a matter of setting up a system table and then altering the stored procedure. I'm not comfortable writing my own stored procedures, but I found it pretty simple to update the existing one (if you know a little SQL). https://www.tessituranetwork.com/Help_System/Content/Criteria%20Sets/Working%20With%20Geographic%20Area.htm
Whether populated into Geo Area or a Constituent Division Element for Analytics, there are maths to calculate the distance between two points using longitude and latitude. Therefore, this requires collecting the longitude and latitude pairs for the approximate centers of postal codes (via online repo somewhere) and calculating the distance from the venue's longitude and latitude to that of the constituents' postal codes.