Have you ever wanted to group your customers together and visualize the highest performing Zip Codes, Counties, or State Territories? Well, now Mapline empowers you to build heat maps of your data with a simple copy and paste from Excel! Use our heat mapping tool to inform you in identifying growth opportunities or help you know where to focus your marketing investments. Determine the best areas to allocate capital investments or determine high-performing territories.
Heat Mapping In Your Business
It’s easy to build heat maps using any columns from your spreadsheet. For example, if you have a list of customers and their annual sales in your spreadsheet, then you can make a heat map three different ways:
Customer Density where each Zip Code (for example) will be colored according to the number of customers within that boundary
Customer Total Sales where each Zip Code would be colored according to the total sales from all customers in the territory
Customer Average Sales where each Zip Code would be colored by the average (per customer) sales
We’ve been hard at work on some awesome mapping updates! Check out our most recent enhancements:
Search Locations on Map:
Use the Search Box to quickly zoom to locations on your current map.
Easier to Manage Shared Maps:
See who your map is shared with and easily grant permissions.
Quickly Show or Hide Data Layers:
Easily check the box to show or hide certain locations.
We’ve also officially launched our Mapline Plus Membership–which gives you even more feature to improve your mapping! Take a look at all you get as a member! Additionally, you can try it out for free by sharing us on your favorite social network. No payment info is require–once you share, your account gets membership for a month. It’s that easy!
I wanted to give an update on some of the enhancements we’ve made with the mapping views. When you leave your map, your zoom levels will be saved so that you can start back up right where you left off! If you close your browser, no need to worry because when you come back to your map, you will have your last view showing by default.
We have about a billion enhancements to make, and we just can’t code fast enough! Thanks for all your feedback, and PLEASE keep the suggestions coming!
Also, it is super helpful to see how you are actually using the application. Drop us a note and let us know how you have found it useful or what you would need for it to be more useful.
The first time I was ever asked to make a map, I just didn’t get the point. I could hold everything I needed in my spreadsheet. Why plot a bunch of dots on a map? Little did I know… there are some pretty sweet treasures found within maps!
What’s Mapping All About
With the growth of technology, mapping has transformed into a far greater tool than just dots on a wall. Most customer presentations contain maps, and businesses identify growth opportunities once they can see their options and assess the competition. Strategies are enhanced with the ability to visualize information and interact with the click of a button.
Mapping is a powerful tool to perform visual analysis, create dynamic reports, and deliver compelling presentations. And what business would want to pass that up?
Why Build Maps?
Let’s role play a customer presentation. The PowerPoint is on the screen with the same performance recap slides that were used last time–only updated. We’ve done this before. Several times. Next comes the pitch to grow business… Compelling? Well… perhaps. Or boring.
Now let me walk you through another scenario where maps are used to be more compelling. Perhaps the presentation dialog would go something like this:
“[Click] Here are our manufacturing plants…”
“[Click] Here are your distribution centers and retail locations…”
“[Click] And here are your distribution centers within 25 miles of our plant which we don’t currently supply… Let’s focus on Atlanta.”
“[Zoom to Atlanta] You have 36 locations in Atlanta, and we would like to trial supplying 5 of your sites with product. During the trial, we will create a disaster recovery plan which will give you security of supply.”
“[Zoom Out to see Southeast US] We have two other manufacturing plants within 200 miles of Altanta which can supply product in case of a disruption in our Atlanta plant. Additionally, since our production facility is within 25 miles of your distribution center, we expect to save you $1.5 million in transportation costs for this trial period.”
It’s all about data visualization to simplify business. Anytime I meet with a client, their first response is how impressed they are with how well I know their business… Then they ask for a copy of the map. Mapping is instrumental to identify growth opportunities–even in markets which are perceived to be exhausted. You become a hero. Congratulations.
How to Make Spreadsheet Data Awesome
We’ve tried to make it simple. In fact, we tried to make it so simple that even our mom could do it… It really comes down to a two step process. Copy your spreadsheet data (along with any columns of data you would like to filter on) and paste it into the mapping tool. Then click “View My Map!” It’s that easy. Within minutes you will have an incredibly powerful tool to enhance your business.
Mapping has transformed the way we do business. It assists with building product rollout strategies; it give perspective to customers during sales presentations; it highlights competitors; it gives visualization to otherwise boring spreadsheet data. Begin Mapping Now to get started building your own visual solution!