To top

How to create territories when planning a route

There are 2 ways to create territories, both require your address list to be in Excel:

1. When territories are known.
2. When you don’t know your territories.

Learn how to create territories:

  1. When territories are known
    1. Have your entire customer list in one excel file.
    2. Add a column named “Territory”.
    3. Review the addresses and choose a value that represents their territory.
      In this example we divided Dallas demo route to 2 territories and named one territory “a” and the second one “b” (your list doesn’t have to be sorted by territories, they can be mixed).
    4. For each territory, choose the same value (alpha/numeric value).
    5. Import the file into the planner. If you named your new column “territory” the planner will automatically
      recognize it, but you can choose a different name and change the header to territory (inside the wizard).

      Import Wizard-Territory

      Import Wizard-Territory

    6. Review your result and click import now.
    7. Click Plan My Route and our planner will optimize your list according to the territories you’ve set.
      All addresses within the same territory will be allocated one after the other.
      The route continues to the next territory only when all addresses in the same territory were allocated.
      2 routes with separate territories

      2 routes with separate territories


  2. When you don’t know your territories
    1. Enter your list of addresses.
    2. Click Plan My Route. Now that you see your route on the map, you can choose how to separate your territories. Here we will have two territories, one for addresses 2-22 (south) and the second for addresses 23-40 (north).
      Single Route - 2 areas

      Single Route – 2 areas

    3. You can see your addresses on the map without planning your route but after you plan it, you’ll see the address order and it will be much easier to see which is the address that “draws the line” between the territories.

    4. Export your route to excel.
    5. Add a column for territories.
    6. Review the addresses and choose a value that represents their territory.
      (according to the route and map you just got).
    7. Import the file into the planner and follow steps 5-7 above, in part 1.

    + Find out how to import your contact list.

    + Find out how export your route.