PDA

View Full Version : New to Forum, need a consultant



KC Truby
03-09-2009, 01:19 AM
I have a project and need help. kctruby@msn.com

I sell a marketing system to CPA firms and they license the ad copy for exclusive rights in a geographic area selected by zip codes.

Our goal is to break up the USA and the 39,000 or so zip codes (list attached from InfoUSA) into areas of 10,000 businesses each. The 2nd colum is the total number of businesses in that certain zip.

My objective is to import the zip into a program like map point, and then plot the total number of businesses in that zip code onto the screen next to the zip code number. I would then go into map point and select by hand the zip codes to be included in a certain area, until I came up with approximately 10,000 business listings. This is just my idea on how it might work, I am open to other ideas.

I have hired staff to do this work as you can see by the attached power point they created for orange county. We left a lot of zip codes off the count and came up with to few territories. We also ended up building some territories that don't make a lot of sense.

My end objective is to come up with a 3rd column on the spread sheet that denotes territory 1 or 2 or 3 or 991 etc. This spread sheet will be used in my web site so that when a prospect for our accounting services logs onto our web site in Kansas City, the prospect will be asked for their zip code and the web site will search the database of zips and pull up the local CPA information and plug it into the web site. Of course if a prospective customer logs on from Denver, they will enter their local zip code and the look and feel will change for the local Denver CPA. I am sure you have seen this done before.

I have attached a sample of the work we have already done and the list of zip codes with counts that I am hoping can be imported to map point and plotted on a map so that we can go in and create contiguous territories for our accountants to use the license marketing material.

Thank you for your ideas
Please feel free to call me
KC Truby
760 479 0052

www.5minutebooks.com (http://www.5minutebooks.com/)

Eric Frost
03-17-2009, 07:50 AM
Are you still looking for help?

We will be starting a Consultants/Companies section soon.

Eric