Visualize Customers on a Map

With The #1 Customer Mapping Software

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.

  1. 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
  2. Make sure your column headings are labeled
  3. Click the Import or Plot button in the mapping application
  4. Pay attention to confirm address columns are placed where they should be
  5. Be sure the MBO “Name” field matches the appropriate Customer Name field in your data
  6. Adjust labeling options to your liking
  7. 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:

  1. Select your data if there is more than one import data set available on the map project
  2. Check Summary only if you want to summarize by county, state or ZIP code. Buddy does not want to summarize.
  3. Choose the column of your data controlling color coding
    1. Choose a range if necessary (for numeric value color coding)
    2. Choose your desired symbols and adjust size or color as required
    3. Choose a scheme for No Data in the controlling field
  4. 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 has made it easy for DriSteem to locate and compare Rep territories. Every single person in our office has a map from MapBusinessOnline at their desk and refers to it daily. We are thankful to be using MapBusinessOnline for developing our business and outside sales representative team!

Thank you MapBusinessOnline!
"

Abby Rogers
Marketing Coordinator
DriSteem Corporation


MVP Sports Clubs is a sports and health facility management and development company with operations in Central Florida and West Michigan. MVP uses MapBusinessOnline to construct demographic map profiles of a radius surrounding each of their many sports clubs. Such market analysis helps MBO users develop a better understanding of their business which makes strategic planning more effective.

"MBO users develop a better understanding of their business which makes strategic planning more effective."

Mark Hope
Business Manager
MVP Sports


"We've tried the REST now we are using the BEST. After searching and trying other mapping programs for our delivery operations team and finding that we just couldn't get all the features that we required, we finally found MapBusinessOnline. Not only did it have all the features we needed including Longitude/Latitude and optimizing delivery routes, but it provided us tons of other bells and whistles. MBO proved to be a superb tool for our operations team to create routes and territories with the click of a few buttons while also allowing our reporting team to make beautiful maps that help our executive team visualize the story the data was telling. We are using this for the 2nd year in a row and will be renewing when it is time again. We pride ourselves at offering cutting edge applications to our millions of readers and subscribers worldwide and love that MBO helps us stay ahead of the technology curve by continuing to update their product and features. The release of MBO for the Desktop was a great addition and only helps make using the product even easier. To the staff at MBO — Keep up the great work!"

Dow Jones

Popular MapBusinessOnline features

Build fast map visualizations of your business data

Map business data from various sources by street address, city name, ZIP code, or latitude and longitude. Plot 250,000 or more locations on a map at once. All you need to start is a spreadsheet with business data.

Visualize business data on map with various symbols

Assign specific symbols, colors, and sizes to your data points on map. Choose from a wide variety of symbols or create your own. Visually define customers and prospects across multiple locations using symbols color coding.

Emphasize customers density with heat maps

Highlight market areas that generate more business. Visually compare map areas for business potential. Select from a variety of heat map colors and options.

Create powerful reports and presentations with maps

Embed map images into reports. Use interactive maps for effective presentations. Export map as PDF to create large wall maps.

Share business maps

Create interactive maps and share with friends, colleagues, dealers, customers, prospects or vendors. Share territory maps. Email saved JPEG and PNG files or embed map files in PowerPoint presentations. Includes PDF export for larger print formats.

Share editable maps with your sales force

Control shared business maps’ access at team or individual levels. Encourage team collaboration through shared sales territory and customer maps. Improve communications within your sales force through clear business maps.

Print large format map views

Print large maps to use in presentations and project plans. Save maps as PDF files to print as large as 60” x 60” customer maps. Supports multiple pages option to use your home or office printer for large wall maps.