• Replies 11 replies
  • Subscribers 961 subscribers
  • Views 181 views
  • Users 0 members are here
Related

Dynamic list by zip code

Anh Le
$organization
Hi everyone,
 
This isn’t exactly an Analytics question, but this seems like the group that might have an answer to a question that is stumping me!
 
I’d like to have a dynamic list of any patrons in our database who live within 50 miles of our theater. It would be really handy for multiple functions of our department to have this list automatically refresh on a daily basis. That’s approximately 210 zipcodes but I can only think of how to pull this list as an extraction (with each zipcode + wild card characters for the possible four digit extension as its own criteria), which wouldn’t allow me to make it dynamic.
 
Has anyone come up with a solution for how to do this? Thanks in advance for any insight you can share!
 
Anh Le | Director of Marketing & PR
Opera Theatre of Saint Louis | ExperienceOpera.org
ale@opera-stl.org | (314) 963-4294
 
A picture containing shape Description automatically generated
 
 
Parents
  • $organization

    Hi Anh,

    At Mount Vernon , we have a  group called Neighborhood friends which are members who live in the surrounding zip codes. We use Geo Areas to determine who is in the group. As people move in and out of the area they are added or removed when there primary address is updated.  Extended Services help us set up the update portion of the program. The zip codes are added as table in SQL . 

    With Geo Area, you can use that to build a dynamic list. 

    We also added a Geo Area of all constituent within 100 miles of Mount Vernon. The one drawback is an address can only have one Geo Area. 

Reply
  • $organization

    Hi Anh,

    At Mount Vernon , we have a  group called Neighborhood friends which are members who live in the surrounding zip codes. We use Geo Areas to determine who is in the group. As people move in and out of the area they are added or removed when there primary address is updated.  Extended Services help us set up the update portion of the program. The zip codes are added as table in SQL . 

    With Geo Area, you can use that to build a dynamic list. 

    We also added a Geo Area of all constituent within 100 miles of Mount Vernon. The one drawback is an address can only have one Geo Area. 

Children
No Data