Author Archive

Delete a Location From a Dataset

Deleting a location from a dataset that was created from an Excel spreadsheet is very easy. Just follow these very easy steps:

  1. Log in to your Mapline account.
  2. Click “My Data Sets.”
  3. Check the box beside the location you want to delete.
  4. Click the “DELETE” button at the top of the page.
  5. A notification will appear “This will permanently delete this dataset from you account. Are you sure you want to continue?”
  6. Click “OK.”

Continue Reading

Using the Excel Add-In

Downloading the Excel Add-in

Mapline has an add-in for Excel that makes it even easier to create powerful maps. The only requirement to download it is to be a paying user. To starting using the add-in, follow these steps:

  1. Go to the Excel Add-in page to download the add-in.
  2. Follow the steps in the light-box that appears.

Once you’ve downloaded the add-in, you’re ready to start building and updating maps and data sets in Excel. You have three different options available through the add-in: Upload, Replace, and Download.

Upload a data set directly from Excel

Mapline has made it so easy to upload data that you don’t even need to copy and paste your data to create a data set! You can do it all from Excel by following these steps:

  1. Open a spreadsheet in Excel.
  2. Select the data you want to upload and include the headers.
  3. Click the “Mapline” option in your Excel ribbon.
  4. Select the “Upload” option.
  5. Follow the steps in the light-box that appears.

Replace your data set from Excel

If your data set is constantly getting updated, then you can replace your old data from Excel with the newest version to always have up-to-date data on your maps. The replace option will delete the old version of your data set, and you won’t be able to retrieve it from Mapline. So be sure that you have a copy on your computer if you don’t want to lose the data. To replace your data set:

  1. Open a spreadsheet in Excel.
  2. Select the data you want to upload and include the headers.
  3. Click the “Mapline” option in your Excel ribbon.
  4. Select the “Replace” option. (Reminder: This will delete the old version of your data set, and you won’t be able to retrieve it.)
  5. Follow the steps in the light-box that appears.

Download your data set from Mapline directly to Excel

If you make changes to your data set within Mapline, then you can download that data set using the add-in. This will allow you to always have the current version of your spreadsheets on your computer. To download a spreadsheet using the Excel add-in:

  1. Open Excel.
  2. Click the “Mapline” option in your Excel ribbon.
  3. Select the “Download” option.
  4. Follow the steps in the light-box that appears.

Continue Reading

Using Radial Heat Mapping

With Mapline’s radial heat mapping, you’ll find many settings you can configure to view a customized radius circle on a map. This page will explain each of these settings to you.

Basic Radial Heat Mapping Options

When you create a radius map, you can “apply the heat” in two different ways: Areas Around Pins or Overlapping Radius Areas. This is set in the “APPLY HEAT TO” drop down option.

Areas Around Pins

By applying heat to the “AREAS AROUND PINS,” you can quickly see high density pin clusters. If more pins are clustered together, then the areas surrounding these pins will be colored red, and areas that don’t have many pins surrounding them will be colored blue. Just set the “SIZE” for your radius, and this will set the distance around each pin that you would like to mask with the heatmap. This image helps show what a simple heatmap looks like when the heat is applied to “AREAS AROUND PINS.”

Density Radial Heat Mapping

Below the “Apply Heat To” setting, you’ll find an additional “HEATMAP BASED ON” option. When you set this option to “LOCATION DENSITY,” then you can quickly identify the clusters for your pins (as mentioned above). Or you can change this setting to “DATASET VALUES,” to see high value pins. For example, if you have pins representing customers and each pin has the customer’s annual sales, then you could select the “Annual Sales” column, and the heat areas would show the customers with high annual sales.

You should understand that this type of heatmap shows both magnitude and proximity. For example, if you have one location with high sales, the heat on the radius map would appear red. Or if you could have a lot of lower sales locations which are very close to each other, then the heat would also appear red. It can be a bit tricky, but the heat colors are a combined visualization of both proximity and magnitude. This is the reason that the legend won’t show you a numeric value for “red” or “green.” It is because a green area could mean “a low value pin is in the middle of this area,” or it could mean “the area is farther away from a high value pin.” So, the legend will only show “High” and “Low” meaning “High Value or High Proximity” or “Low Value or Low Proximity.”

Overlapping Radius Map Areas

By applying heat to the “OVERLAPPING RADIUS AREAS,” you can quickly see high density areas. With this setting, a radius circle on a map will be drawn around each pin. And areas with a lot of overlapping circles are colored red, and areas with fewer overlapping circles are colored blue. This image helps show what a simple heatmap looks like when the heat is applied to “OVERLAPPING RADIUS AREAS.”

Coverage Radial Heat Mapping

The heat spots show the values within a distance of the color pixel. So, unlike the Density Type heatmap, any color on the Coverage Type heatmap only has a single meaning: the value for a spot on a map. Therefore, a legend can be shown that has numeric values.

When you set the “HEATMAP BASED ON” option to “LOCATION DENSITY,” then you can quickly identify the areas on a map which are within your specified distance (“SIZE”) of your pins. If you have a map with customer pins, and you set the size to 5 miles, then areas with the highest number of customers within 5 miles will be red, and areas with only one customer within 5 miles will be blue.

If you set the “HEATMAP BASED ON” option to “DATASET VALUES,” then this will show you the areas on a map which are have the highest total (or average) value within the specified distance (“SIZE”). For example, if your “SIZE” is set to 5 miles, and you select “SUM” and “SALES,” under the “DATASET VALUES,” then the red areas with the highest total sales within 5 miles would be red, and the areas with the lowest total sales within 5 miles would be blue.

Advanced Radial Heat Mapping Software Options

The “ADVANCED OPTIONS” enable you to customize your radial heat mapping even more. These options include the ability to set the “OPACITY” of your heatmap as well as define whether you would like the outer edges of the heatmap to “FADE” to transparent or not. You can also set the “BLUR” option to blue the colors together more, and finally you can determine whether you would like the “LEGEND” to appear.

Which Radial Heatmapping Type Should I Use?

I’m glad you asked! These heatmap options tell you very different things, and here are some basic use-case scenarios:

  • Use “AREAS AROUND PINS” if you are trying to visualize any of the following:
    • Pockets with high densities of customers.
    • Large customer accounts or areas where many customers are located.
  • Use “OVERLAPPING RADIUS AREAS” if you are trying to visualize the following:
    • Overall high risk areas for disaster recovery planning.
    • Location to hold a seminar.
    • Optimal place for an office location or distribution center.
    • Report performance by geographic areas of customers or sales.

Continue Reading

Mapline-Provided Data Set Permissions and Restrictions

Mapline offers more than 4 million retail locations which can be added to maps. These include locations from over 4,000 retail companies. With this competitive set of data, Mapline enables you to perform competitive analysis and improve your business growth strategies.

Permissions

The following features are available for Mapline datasets:

Restrictions

There are some restrictions on what you can do with the Mapline datasets on your map:

  • Mapline datasets will not appear on a map which is shared with another person outside of your account. In order to share a map with Mapline datasets visible, then the user must be added to your existing account by going to MY ACCOUNT and clicking on ACCOUNT MEMBERS.
  • Mapline datasets will not appear on an embedded map.
  • You cannot view (in a list) nor export the Mapline datasets. You can only add them as pins on a map.

Coming Soon

The follow features are not quite available to use with Mapline data sets, but we are working towards providing these soon:

  • Distance calculations to determine the nearest competitor’s location to your own list of stores.
  • Territory heat mapping to overlay territory boundaries on your map and color them according to the number of locations inside the territory.

Continue Reading