Territory Heat Mapping Options: Location Density, Sum, and Average

You can easily build a heat map of your Excel spreadsheet data! Here are the heat mapping options that you can choose:

Location density map

If you would like to color a county map according to the number of locations (density), then use this option. For example, if one county has 100 locations and another county has 10 locations, then the county with 100 locations will be red and the county with 10 locations will be green (you can flip the color sequence).

Sum of Any Numeric Field

This will create a territory heat map according to the sum of any value in your dataset. For example, let’s say you have an Excel spreadsheet with customer locations and annual sales. You can just add this data to your Mapline account and then easily build a map that will show the total sales by county. If the total sales of all customers in one county is $1,000,000 and only $10,000 in another county, then the county with the higher sales will be colored red and the low sales county will be colored green (you can flip the color sequence).

Average of Any Numeric Field

This will create a territory heat map according to the average of any value in your dataset. For example, let’s say you have an Excel spreadsheet with customer locations and annual sales. You can just add this data to your Mapline account and then easily build a map that will show the average customer sales by county. If the average customer sales in one county is $1,000,000 and only $10,000 in another county, then the county with the higher average sales will be colored red and the low average sales county will be colored green (you can flip the color sequence).

Mapline offers a wide range of territory boundaries which can be added to your map. See Mapline’s Available Territories to see what is offered as well as step-by-step instructions on how you can add them to your map.