Mapline Blog

Tune in for new updates, tips, tricks, and news about Mapline!

How to Create a Map with Segments

Group Pins on Your Maps for Better Insights

Specifying locations with pins helps you identify trends and outliers, but what if you’re looking at too many locations at once? All that data viewed at once can get confusing and start blending together. With the segment feature, you can categorize your pins and narrow in on what you actually want to look at. Follow our step-by-step instructions to add segements to your maps where you can visualize customer segments, location types, regions, and more.

Steps to add Segments to your map

  1. Create a new map and add a dataset on your map.
  2. Click layer options menu next to the layer on your map.
  3. Select the “Segment” option.
  4. Click the “Add tier of segments” button.
  5. Select the category from your Excel spreadsheet that you would like to use as categories on your map.
  6. Click Done.
That’s all it takes to group your pins and assign different icons for different groups of locations!  Sign Up Today

New Feature: Sublayers Work Wonders!

In line with mapping in simplicity, we are proud to release a new mapping tool that puts the “A+” in data analysis. We’re talking about Sublayers. Though the name isn’t as cool as its abilities, we tell you – they bring huge analytical power to the users! Just by a few clicks, it can answer difficult questions such as:
  • How can I identify a particular group of pins?
  • Where are my retail stores with the highest sales located?
  • How can I analyze a particular group of pins with the rest of the pins on my map?
  • How can I create a multi-layered map from my data set?
The answer? The Sublayer feature! It makes mapping simpler while trimming your analysis down in only minutes. How cool is that? Here’s how it works. See the map below? Here, you’re shown a map with crowded pins. Does that mean anything? Not in the first glance. Yes, the map does say something about the locations and the pins represent addresses. But if you really want to know the connections between thse map pins, you need to re-group them by category. Thanks to the new feature, you now have the power to organize your map pins and make your data analysis much less trickier.
When the sublayers feature is applied using “Unique Values,” here’s what you can get. The map pins are categorized on their status – Open or Closed. Notice that the map pins by sublayer also changed so you can easily identify which is which. At the left sidebar, you can also see how many pins are in closed status and how many are in open status.
For further solutions, feel free to use the Custom Groups selection. It will open new ideas as you step in and categorize your pins in different layers. It is also a vital tool to create exceptional map visualizations for presentations. Show your audience the different tiers of dataset that affects your business.
Regroup your data and create a three layer map showing your customers addresses, distribution centers, and competitors. Since each group is represented by unique pin colors, relationship between the groups can be easily identified. Here’s a map using the Custom Groups where you can create different groups and add calculations.

Visualize Sales Territory Performance

Mapping gives you a whole new way to report sales territory performance visually. A territory heat map is the easiest way to visualize performance. Just paste your spreadsheet sales performance data into Mapline to show your customers or locations on a map. Then, you can easily overlay territories to your map to see performance by postal code, county, or state. Each territory will be colored according to the sales performance of all customers or locations within that territory. Also, clicking on a territory will give me a summary of all the included data. And you can easily export that back to Excel if needed. Alternatively, you can also use the Draw Pad if you want something super quick. Just draw a shape on your map that encompasses multiple sales territories. Then, you can click on the shape to see all the data for the locations inside the shape. You can then group it by Rep, Policy, Active or not, or anything else. That’s how easy it is to visualize sales territory performance in mapping. Sign up to get started!

Identify Growth Opportunities With Mapping

Mapping opens a whole new world when you need to identify growth opportunities for your business. Let me give you an example of how simple it is to make better decisions when figuring out where to grow. Let’s say you want to open a new Mexican restaurant, but you want to find the best location that isn’t near a competitor. Don’t get me wrong, I’m sure your food is pretty yummy, but I’m assuming you don’t want to fight with competitors if you can help it. Just paste your spreadsheet list of competitors into Mapline. Once they are on your map, you can use the Filter option to only show other Mexican restaurants. Now you can see your direct competitors and where they are relative to your potential locations. You can even add a 10 mile radius around each of them to see their network coverage. Then you would be able to identify a couple locations that could be HUGE opportunities with NO competitors! And that’s how easy it is to find growth opportunities with mapping. Sign up to start your analysis now!

Minimize Transportation Costs Using Mapping

Let’s say your transportation costs are too high. With Mapline, you can easily optimize your transportation costs by identifying the closest distribution center to your retail stores. Just take your Excel spreadsheet with the list of your store locations and the list of all the distribution centers. You want to find the distribution center that has the shortest distance to each store location. So, once these are pasted into Mapline, just select the Distance Calculations option. Now you need to pick the two data sets that represent the distribution centers and the stores. Once you hit download you will get a spreadsheet that shows the distances between each store and each distribution center. Now, using Excel, you can easily run a minimum formula to find which distribution center is closest to each of your stores. And that’s how easy it is to minimize transportation costs using Mapline! Sign up to try it out yourself.

Streamline Operations with Mapping

Mapline makes it simple for you to streamline operations by identifying backup supply options. Let’s say that you own some gas stations, and there are occasionally supply outages from your fuel supplier. You want to find some backup supply options so that your operations aren’t affected. This is simple to do with mapping. Just plot your gas stations and suppliers in Mapline. This can be added with a simple paste from your Excel spreadsheet. Once the gas stations and suppliers are on your map, just go to the Distance Calculations option and select these two data sets. Once you hit download you’ll get a spreadsheet showing the gas stations along the left rows and the suppliers along the top columns. Where the Row and Column intersects is the distance between the two points. Now that you have a huge distance grid spreadsheet, you can easily run a =SMALL() formula in Excel to identify the first, second, and third closest supply locations to evaluate your options! And that’s how you can streamline operations using Mapline! Sign up to start streamlining your operations with mapping.