Runs on Windows and Mac
Have a Question?
Search Help:

How do I?

Create territories by ZIP code from file

This article describes how to build sales territories on map using a file with territory definitions.
Related article: Create territories by county or state from file.
Related article: Design sales territories by ZIP code.

In Map Business Online you can setup sales territories by ZIP code, county, state and other alignment layers like Census tracts or MSA.

  1. In this article we will look at the case when you already have Excel (or comma/tab delimited text) file that maps ZIP codes to sales territories. That file must have content similar to one you can see on the picture below.
  1. Before you start let’s decide whether territories are allowed to intersect. If you want to keep your territories disjoint then do the following:
    1. Open Map & Data window if it is not already open.
    2. Click gear icon on Map & Data window toolbar. ‘Manage map and data’ dialog will pop up.
    3. Select ‘Territory options’ tab in ‘Manage map and data’ dialog.
    4. Uncheck ‘Allow territories to intersect’ box.
  1. To start building territories from file click ‘Create territories’ icon on Map Business Online’s toolbar. That will start ‘Create territories’ wizard.
  1. Skip first page of the wizard as it provides just an explanation – click ‘Next to plotting data’ button.
  1. On ‘Select data’ page choose Excel file that contains your sales territory definitions. Click Browse button to locate that file. Click Next button when ready. Map Business Online will start uploading the Excel file selected.
  1. Select worksheet or range to plot data from. This page appears only if you have more than one data range or worksheet in selected Excel file. Click Next button.
  1. On the next page choose the column that contains ZIP code as postal code. Make sure that other columns stay unselected – select <None> in all other boxes. Normally Map Business Online automatically makes correct selections. Just check that automatic selections are as expected.

    Check the box on the page instructing Map Business Online to skip any ZIP codes that have no corresponding boundary.

    Click Next button.
  1. Map Business Online will start plotting ZIP codes on map. That may take some time depending on number of ZIP codes you have. Once plotting is finished following page will popup with results. If not all ZIP codes are plotted you may want to check ZIP codes column in your Excel file for errors.

    Click ‘Next to creating territories’ button.
  1. On the following page select column containing territory names. Normally Map Business Online makes right selection automatically.

    Check that territories will be created by ZIP code. If ZIP codes option is not selected automatically then you must have selected wrong columns on step 7 above.

    Click ‘Create territories’ button.
  1. Creating territories may take some time. When territories are created you will see following page with summary of results.

    Click Done button to finish ‘Create territories’ wizard to see territories on map.
  1. You may want to zoom or pan map to see your territories. See this article on how to navigate around map: Zoom & pan map.

    You can also move territory callouts for better view.
  1. Following help articles may be useful when designing territories:
  1. This article explains how to show total sales or demographic data value in territory label: Customize territory labels.