Dividing the State of California into areas for Alumni Receptions using the "REGION" field

Diana Gray 2

Hello fellow RE users!


We have a ton of Alumni who reside in the state of California, and we are trying to create areas that would be suitable for receptions.  Does anyone already have this in place?  I would be SO grateful to know the areas you named in your "REGION" field table, and the criteria you used in your query to globally define these areas (zip codes?, cities?).


The most populated areas are The Greater Los Angeles area (inland and coastal), and San Gabriel Valley, and San Francisco.  We need to break these down into manageable areas.  Any help you can offer will be very much appreciated!


Thank you,

Diana

Shaun Grace

Hi Diana,


Can't help with California but we did something similar and divided Texas into regions. In the regions table we have North, Northeast, Northwest, Central, South, Southeast and Southwest. We then used counties to decide which region constituents fell in to.


Hope this helps.


Shaun

Diana Gray 2

Thanks so much for your response.  Would you be able to share the parameters for each of the regions you defined for Texas in terms of zip codes?  We wouldn't be able to query for  them by County (as that is not a field we use).  We also have many alums in the great state of Texas!

Shaun Grace

Hi Diana,


We use Address Accelerator, so all of our constituent addresses have the county on them. We used that rather than using zip codes.


Shaun

Hope Fields

We usually divide by county and then group counties together for regional activities.  However, I have to be honest and say that I had not thought of using the region tab to group them.  So, thank you for that idea!