Visualize Customers on a Map
As a new sales manager, Buddy Woods needed to make sure he understood how his customer base is distributed across the USA. He also wanted to make sure his sales associates had ready access to the same information. After all, knowing your customer is a critical element of selling.
Problem: A sales manager desires a broad map visualization of all customers across the USA to share with his staff. He’d like them color coded or symbolized to reflect customer type and he would like to include labels noting 2016 Sales, Key Contact, and Phone number.
Solution: Import a customer address spreadsheet into business mapping software, such as MapBusinessOnline. Include a column for customer type: house account, bio tech, distributor, and reseller. Adjust labeling options through the import process and using the color code by symbol button choose or import a symbol of your choice.
Seeing is Understanding - Know Your Customer
Buddy first job was to sit down with his best technical sales people and make sure the data was available. It required a little bit of clean up and a few more location components to the data. His predecessor had only required ZIP codes location data. Buddy knew that was problematic for data accurate visualizations. If he imported only ZIP codes onto the business map he’d get multiple points piled on top of one another.
Import Your Customers
Our sales manager asked his admin to collect and update addresses for all customers. That way he’d see an accurate distribution of all customer across the map. MBO allows importing up to 250,000 records per map.
With the data cleaned up Buddy let his admin import the data into MapBusinessOnline. 
- Create an Excel spreadsheet where each row is an address location. Make sure the location information is broken out in separate columns for Name, Address, City, State and ZIP code
- Make sure your column headings are labeled
- Click the Import or Plot button in the mapping application
- Pay attention to confirm address columns are placed where they should be
- Be sure the MBO “Name” field matches the appropriate Customer Name field in your data
- Adjust labeling options to your liking
- Click Plot to place the points on the map
Color and Symbol Assignment
With the customer data on the map, Sales Manager Wood’s administrator chose an appropriate symbol for all customers and color coded and sized the symbols to reflect customer type. Color coding points is easy, starting with clicking the Color Code with Symbols button: 
- Select your data if there is more than one import data set available on the map project
- Check Summary only if you want to summarize by county, state or ZIP code. Buddy does not want to summarize.
- Choose the column of your data controlling color coding
- Choose a range if necessary (for numeric value color coding)
- Choose your desired symbols and adjust size or color as required
- Choose a scheme for No Data in the controlling field
- Click Done or Preview
Data point color coding can be easily adjusted by simply revisiting the process.
Maps Are for Sharing
Buddy made a few suggestions and in short order his map was done and his customer visualization was ready to be shared. Buddy used MBO MapShare to publicly share his business map customer visualization through interactive web maps with his sales team. With MBO for teams, sharing is included in the subscription.
Buddy’s team, for the first time, could easily click on an MBO map link and see the entire customer breakdown. They were able to look up customer records by name or ZIP code, query customer contact info and view other data that Buddy shared.
Now that’s a sales team.
Learn How Our Customers are Succeeding with MapBusinessOnline
"MapBusinessOnline one of the most powerful tools I have as a Regional Channel Manager. It’s a difficult task to visually represent the vast amount of data that I have to present to my customers and team members. MBO makes it easy to represent, configure, and manipulate the data on to an effective map. A picture is worth a thousand words, and MBO allows me to create a perfect picture."
Ed Ku
Regional Channel Manager
ABB
"MapBusinessOnline is an amazing tool that I use every week. When you are creating zip code footprints and trying to determine what zip codes fall within a range of a business, this tool couldn't be any easier to use. There's actually so many functions that are great but specifically I use MapBusinessOnline to create either a mile radius or a drive time radius from a business location. I then use that radius to determine which zip codes fall within the radius. Why is this important? Because I then export the zip codes and use another software that gets me exact counts of how many people fall within that radius in those zip codes. It's Amazing!
I highly recommend this software!"
Chris Farcher
The Mailworks
Account Manager
"Truly the easiest business mapping application I have ever used."
Chad Seaverns
National Sales Manager
www.nfdnetwork.com
Popular MapBusinessOnline features
Build fast map visualizations of your business data
Visualize business data on map with various symbols
Emphasize customers density with heat maps
Create powerful reports and presentations with maps
Share business maps
Share editable maps with your sales force
Print large format map views
