Import territories from a file

This article demonstrates how to visualize sales territories by importing a file with existing territory assignments.

In MapBusinessOnline you can build sales territories from various alignment layers including ZIP codes, counties, states, Census tracts, and MSA. Design your sales territories from scratch by following the steps presented in the article: Manually create territories one-by-one. Often our users already have sales territories designed in CRM or a salesforce management system. They use MapBusinessOnline to visualize the territories on a map and optimize them using geographical factors such as drivetime and connectivity.

Note: here we will present steps required to build sales territories from USPS 5-digit ZIP codes. Building territories from other alignment layers is similar.

• Preparation steps
• Import your territories

Preparation Steps

1. Do you allow your territories to intersect? Let's make the decision now and adjust the territory intersection option as follows.

2. Open the Manage map and data dialog. Click the Gear icon at the top of the main toolbar to open the dialog.

3. In the dialog select the Territory options tab and change the intersection settings as desired.

4. Make sure that ZIP code map layer is visible. Do that by checking visibility box in Map & Data window.

Import Your Territories

1. Enter/copy territory assignments into an Excel or comma/tab delimited file. Each row in the file shall map a ZIP code to a territory like you can see on the picture below.

2. Go to MapBusinessOnline app. Click the Territories button on the main toolbar to start the Create territories wizard.

3. On the first page choose the Import territories option.

4. On the Select data source page choose the File tab and select the file with the territory assignments. Click the Browse button to locate the file.
   
   In the instructions we want to demonstrate all Create territories wizard options and therefore will click Next, but you can click the Create territories button and let MBO figure the rest.

5. If the territory file contains more than one worksheet or range, select the one with territory assignments. Click Next.

6. The next page allows you to choose a territory alignment layer (ZIP in our case) and map required location columns. MapBusinessOnline analyzes the data you import and makes the choices for you automatically. Just check that the automatic selection is correct (it is in our case).
   
   When creating territories by ZIP code you will have the Ignore point-only (no-boundary) ZIP codes option. The choice will instruct MapBusinessOnline to skip any ZIP code in your data that has no corresponding boundary (PO boxes, high-rises, etc.).
   
   Click Next.

7. MapBusinessOnline will choose a territory name column for you. Correct it if necessary. Click the Create territories button.

8. MapBusinessOnline will start importing the territories. At the end it will show a summary of territories processed. Click the Done button to finish territories importing.

9. The territories are on the map now!

Related articles

• Manually create territories one-by-one
• Change territory color, transparency & outline
• Customize territory labels – Learn how to total sales or demographic data in a territory and display the value in a territory label.
• Rename a territory and edit notes
• Delete a territory
• Hide geographies that are not part of any territory