Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

The Texas Bluebird Society Uses MapPoint to Split up and Prioritize a Mailing List

This is a discussion on The Texas Bluebird Society Uses MapPoint to Split up and Prioritize a Mailing List within the MP2K Magazine Articles forums, part of the Map Forums category; Texas_Bluebird_Society.jpg The Texas Bluebird Society is a non-profit organization in Texas with a mailing list of over 7,000 (members and ...

  1. #1
    Pauline Tom's Avatar
    Pauline Tom is offline Junior Member White Belt
    Join Date
    Jan 2013
    Posts
    1

    The Texas Bluebird Society Uses MapPoint to Split up and Prioritize a Mailing List

    The Texas Bluebird Society is a non-profit organization in Texas with a mailing list of over 7,000 (members and former members). We wanted to send word of an upcoming event in Kerrville, TX with as much bang for the buck with a limited budget for postage.

    The Kerrville Convention and Visitors Bureau (CVB) agreed to pay an amount for 1st class postage for the event flier for those most likely to attend and stay overnight.

    From event evaluations, the organization knew those living less than 60 minutes away would not stay overnight. We directed MapPoint to find members who lived at least 60 minutes away, and the CVB budget allowed out to 240 minutes away.

    For those who lived within 60 minutes, those who our event evaluations show are the most likely to attend, the organization sent the flier by first class postage.

    With the remaining budget funds available, the organization sent fliers outward from the point where CVB allowance ended.

    MapPoint made the strategic plan possible by following the following steps.

    First, the complete membership list was imported into MapPoint.

    Sixty, 120, and 250 minute drivetimes were created around Kerrville. Ultimately, we wanted to place each address into one of the following buckets: 0 to 60 minutes, 60 to 120 minutes, 120 to 250 minutes, and over 250 minutes.


    From here we did "Export to Excel" four times from within MapPoint. First, to export the entire Member Spreadsheet, we exported from the Legend, the others were exported by right-clicking on the polygons.

    All the worksheets exported from MapPoint were moved into a single Excel Workbook and we inserted three columns into the complete MemberSpreadsheet.

    We then used the MATCH() function in each of those columns to indicate
    whether that Member Number appears on the other lists.

    With sorting we were then able to figure out which ones are between 60min and 150min and which ones are between 150min and 240min.

    The spreadsheet list contains confidential member information and thus we have not included it here, but the steps in the spreadsheet were simple enough, hopefully the description above is enough for you to follow effectively.

    Fairly simple, Aye? Any questions please post below.

    We also used MapPoint to identify potential volunteers from the membership list to help with the event, radiating out by distance in travel time.

    Last edited by Eric Frost; 01-18-2013 at 07:04 PM.

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: The Texas Bluebird Society Uses MapPoint to Split up and Prioritize a Mailing List

    That cluster to the east of Dallas Fort Worth is interesting - it looks to be centered around Wills Point which is officially the "Bluebird Capital of Texas". The local town fair every April is the "Bluebird Festival" - complete with stalls selling bird boxes, and a "Little Miss Bluebird". I'm usually there with a model railroad club who set up in the old T&P depot.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: The Texas Bluebird Society Uses MapPoint to Split up and Prioritize a Mailing List

    Small world!

    There are over 50 addresses on the member list in Wills Point.

    Oh I see an event on the home page of their web site: Saturday, 04/27/2013 - Wills Point Bluebird Festival - Wills Point, TX
    Last edited by Eric Frost; 01-18-2013 at 05:16 PM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-30-2009, 07:38 AM
  2. Texas Loves Virtual Earth
    By VirtualEarth MSDN Blog in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 09-22-2008, 04:12 AM
  3. Microsoft Virtual Earth: All over the map in Texas!
    By VE For Government in forum Bing Maps Blogs & Tweets
    Replies: 1
    Last Post: 09-18-2008, 07:19 AM
  4. Direct Mailing Adresses
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-28-2003, 01:45 PM
  5. newsgroups oder mailing lists for MapPoint Programming?
    By blackmap in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-07-2003, 09:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66