Hey, @karstenkoehler. Thank you for the tip above. This was very helpful. I am now able to create an active list of companies that are within a 60 miles radius of Chicago and have contacts who we have Qualified or are in a Deal stage with. AKA, I am able to view all of the hot prospects that are near me geographically..
For anyone else looking to do something like this, I would highly suggest this free to use website that I came acrross, https://www.freemaptools.com/find-zip-codes-inside-radius.htm
The site allows you to drop a pin on any location and it will then give you a list of all the postal codes within that radius. You can then copy the list of zip codes and paste it into Excel.
They will be listed like this: 60004,49511,60007,49219 .. Therefore, I just used a simple Excel tool that I found online that would seperate the codes into individual cells. I was then able to paste semi-colans into the cells in the right column of the zip codes:
I could then take that list of 700 some Zip codes and post them into the “Postal Code” filter on the HubSpot list and add any other filters I wanted such as, “Qualified Companies” … I am then provided with an awesome list of 724 companies that will be highly important to our teams success,
Thank you again, Karsten. Your the man.