When you are creating territories from a file it is important that the file is properly prepared.

Datasets that can be used to create territories

Not all available datasets can be used to create a territory. Some datasets are quite complex and become more so when combined with your own data. Geographic datasets are created by drawing lines made up of multiple datapoints. The more of these points the more complex they are. Even straight lines can have multiple datapoints. We are constantly working to increase the number of datasets that can be used to create territories.

Duplicates

If your file has duplicate entries then this will cause errors. For each geographic area you are using there should be one row in your spreadsheet I.e. if you are creating a territory of zips for each zip you will be adding to the territory there will be a corresponding row in your spreadsheet. If the same ZIP appears more than once it will cause an error.

ZIP Codes VS ZCTAs

In eSpatial we use ZCTAs (Zip Code Tabulation Areas). These are essentially Zip codes that have population. This means that we do not support Zip codes for PO boxes or Military or company Specific Zips. There are 43000 zip codes in the US approximately and these are constantly being updated and some go in or out of use. In cases where you have a Zip code in your file that does not exist in our dataset you will get an error message. Rest assured we have ZCTA coverage for all populated areas. For unpopulated areas we have “filled in the blanks” with areas containing a unique eSpatial 5 digit code starting with E. This ensures that your territories will completely cover the required area.

Templates

Here are some sample datasets that you can use as a template.

Did this answer your question?