I am looking to use the GeoArea functionality to build lists built on the criteria of any constituent in q 100 mile radius of Mount Vernon. I have a list of about 900 zip codes.
I am looking to see if anyone has used the GeoArea. Did it work for you? How did you set it up?
LeeAnn-
Thanks for the response. I would be interested in knowing whether IT manually entered all the zip codes in the SQL script or if they had some other process?
Seth R. Ghitelman
Systems Administrator
__________________________________
George Washington’s Mount Vernon
P.O. Box 110, Mount Vernon, Virginia 22121
O: 703.799.6846 | F: 703.799.8645 sghitelman@mountvernon.org
mountvernon.org | @mountvernon
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of LeeAnn Day Sent: Wednesday, July 27, 2016 9:53 AM To: Ghitelman, Seth <SGhitelman@mountvernon.org> Subject: Re: [Tessitura Marketing Forum] Geo Area - Set up and Use
We set up Geographic Area. The way we’ve used it is in T-stats to give us more information for Marketing campaigns and also for our Development Department to show for grant applications.
We did it by county in our state and then by state for out of state. We set up all states that are out of state in all caps (example: ALABAMA) where in-state counties are sentence case (example: Hillsborough) to make it easier to look at.
We (Marketing) gave the I.T. Department a list of ZIP codes for each county in our state. Every once in a while we have to update it because new ZIPs are being added and when they are, those people go into an unassigned bucket.
From: Seth Ghitelman <bounce-sethghitelman9456@tessituranetwork.com> Sent: 7/27/2016 9:19:50 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
That's a good question. The person who did this for me no longer works here so I can't ask her. She did say at the time that it was an easy process. I can ask our current DBA if there is any documentation for the process she ran.