# Preprint Zones / Zone Configration

## Zone Groups Setup <a href="#toc21458135" id="toc21458135"></a>

Zones give user the ability to build multiple distribution layers for Inserts/Preprints. Each layer contains smaller zones within the group. User can create this data within the Advertising system or import it using system provided templates. Zones allow user to store up to 5 dimensions of data. For example, in postal code 10012 there are XX subscribers, XY non-subscribers, YY dealers, and so forth. The Zone Groups hierarchy allows the order entry user to select a city and it could auto select all child zip codes. The Zone selection in Order Entry allows user to see and select from this hierarchy and even build a radius map.

Note that Zone Group must be setup for the Zones tab to appear in the campaign line entry screen. When you create zones, they must be assigned to a group.

Navigate to the menu **Setup -> Product Setup -> Zone Groups**. Select a product from the drop-down menu.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-a677cbd161125bd276fc0b4d996c5f17abbec32c%2Fimage%20(773).png?alt=media" alt=""><figcaption></figcaption></figure>

Click the button “Add a New Group”. Enter the information in the respective fields as needed.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-d72d56fa1d26898c8da671dac2c0dcca70e76bd6%2Fimage%20(695).png?alt=media" alt=""><figcaption></figcaption></figure>

The sort codes allow for the display of the group in alphabetical order.

Continue to build sub-groups as needed and click the save button after each group is created.

Alternatively, you can import the hierarchical group structure using the provided template. Click on the button “Import Data”.

![](https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-2348a1916f82ee208db8baf932e09375a4bdfa86%2F3%20\(44\).png?alt=media)

Click the button “Download Empty Template” to fill out all the groups and sub-groups from scratch. Or if you have some groups in the system on which you’d like to build, click the button “Download Template with Current Groups”. This template downloads the sheet prefilled with existing information from the Advertising system.

The template consists of the following fields:

<table><thead><tr><th width="155">Field Name</th><th>Example</th><th width="314">Conditions</th><th>Mandatory/ Optional</th></tr></thead><tbody><tr><td><strong>Group ID</strong></td><td>SH2</td><td>Must match the group ID already existing in the advertising system</td><td>Mandatory</td></tr><tr><td>Group Name</td><td>First sub- group</td><td>Alphanumeric value for the group name for column one</td><td>Optional</td></tr><tr><td><strong>Parent ID</strong></td><td>SH1</td><td>Must match the parent group ID which already exists in the advertising system</td><td>Mandatory</td></tr><tr><td>Country Code</td><td>US</td><td>Country code value</td><td>Optional</td></tr><tr><td>Postal Code</td><td>10583</td><td>Alphanumeric value for the zip code</td><td>Optional</td></tr><tr><td>Latitude</td><td>44.0051</td><td>Numeric Latitude of the location</td><td>Optional</td></tr><tr><td>Longitude</td><td>73.7846</td><td>Numeric Longitude of the location</td><td>Optional</td></tr></tbody></table>

You can click the button on the import window to “Replace Current Groups” and this overwrites the current groups for this product. If left unchecked at the value “No”, then the groups originally in the system will remain and the imported ones will be added according to the layout in the template.

When finished, save the template to your desktop and upload it to the Advertising system using the button “Import Groups” on the import window. When finished, click the save button.

## Zone Setup <a href="#toc21458136" id="toc21458136"></a>

The system allows for a more detailed setup for zones for the date-based products. Click the node “Zone Setup” on the tree.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-3995b851f5506db415b93e89833e7540241349a3%2Fimage%20(167).png?alt=media" alt=""><figcaption></figcaption></figure>

The screen allows you to enter details for each zone using the group structure you created above. You can also enter distribution counts for the [**zone dimensions**](https://docs.navigaglobal.com/naviga-ad/2024.6/naviga-ad-modules/advertising/setup/advertising-setup/zone-dimensions) per day of week. The dimensions are an additional layer of details for the zones. Entering Zone counts here is optional. Many will choose instead to import Zone counts by date or date range and store it against the issue configuration. Counts here are generally used for a backup in the event that actual quantities are not yet available from the circulation system.

You must assign the zone to a group in order for the Zones tab to display on the line item entry screen.

Cluster Codes are free-format and are optional. They are used to group zones together into a truck where if one zone is selected, the other zone(s) are automatically selected. See [**Campaign Insert**](https://docs.navigaglobal.com/naviga-ad/2024.6/naviga-ad-modules/campaigns/creating-campaigns/campaign-line-items/preprints-inserts#forced-zones-clusters) documentation for more info on how this behaves from an end-user perspective.

Note the Inactive flag available for each zone. Use this flag to indicate that a zone that was used in the past will no longer be available for use. For orders that have already been created while the zone was active, the order will not be modified. If you open the order, you will see that it is now inactive, and new orders will not have the option to select that Zone anymore.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-cd33ed6c0b777fb02de1057c1b9b724f428e81ce%2Fimage%20(619).png?alt=media" alt=""><figcaption></figcaption></figure>

Any FUTURE orders that were already booked using that zone will need to manually be edited to have the zone removed if the delivery will not be done to the zone anymore.

## Zone Imports

Zone import and Zone Import by Date Range allow you to enter the zones and circulations for an issue and mass import them into the Ad system instead of manually entering them. The difference between them is that the Zone Import will be expecting a count for each issue date. The Zone import by date range will have a start and stop date and day of week. So you could them import a count for say Wednesdays between Jan 1 and March 31 of a given year, and a different number for Sundays in that same date range.

The Zone import is also imported per product. The Zone import by date range can be done for multiple products simultaneously.

### Zone Import

Navigate to the menu **Setup -> Product Setup -> Zone Import**. Choose the product from the drop-down menu. Only issue based products display in the list.

Click the field “Create Missing Zones” to change its value to “Yes” if you would like the import to create the zones. If the zones are new, and do not exist in the system, this must be a “Yes”. If left as “No”, the template must have Zone IDs that match ones in the system for the issues.

Click the button “Download Template”. This opens a spreadsheet template with the following fields which you can fill out and save to your desktop.

#### Template <a href="#toc40970099" id="toc40970099"></a>

<table data-header-hidden><thead><tr><th width="149"></th><th width="130"></th><th width="267"></th><th></th></tr></thead><tbody><tr><td><strong>Field Name</strong></td><td><strong>Example</strong></td><td><strong>Data Source and Conditions</strong></td><td><strong>Mandatory/ Optional</strong></td></tr><tr><td><strong>Issue Date</strong></td><td>2/28/2019</td><td>This is the date of the issue for the product and must match an existing issue date in the system.</td><td>Mandatory</td></tr><tr><td><strong>Zone ID</strong></td><td>19545</td><td>Free format alphanumeric. Must match system values if the field to create missing zones is set to No.</td><td>Mandatory</td></tr><tr><td>Zone Description</td><td>Philadelphia</td><td>Free format alphanumeric description of the zone ID.</td><td>Optional (but really should use one, even if the same as the ID)</td></tr><tr><td>Parent ID</td><td>CITY</td><td>Zone Group this Zone belongs to. (select the immediate parent here, not the grandparent.)</td><td>Mandatory</td></tr><tr><td><strong>CirculationA</strong></td><td>15000</td><td>Numeric free entry</td><td>Mandatory</td></tr><tr><td><strong>CirculationB, etc</strong></td><td>17500</td><td>Numeric free entry</td><td>Mandatory if you are using additional <a href="../../../advertising-setup/zone-dimensions"><strong>dimensions</strong> </a>in Setup.</td></tr><tr><td>Sort Code</td><td>1</td><td>Value by which the zone is sorted in the list as displayed on menus for users.</td><td>Optional</td></tr><tr><td>Country Code</td><td>US</td><td>This is the 2-digit ISO Country Code.</td><td>Optional</td></tr><tr><td>Postal Code</td><td>19456</td><td>5-digit zip code for the zone.</td><td>Optional</td></tr><tr><td>External Reference</td><td>ABC123</td><td>Alpha-numeric Field used in integration with 3rd party</td><td>Optional</td></tr><tr><td>External Group</td><td>ABC</td><td>Alpha-numeric Field used in integration with 3rd party</td><td>Optional</td></tr><tr><td>Cluster Code</td><td>Truck123</td><td>Concept which Groups Zones together with the purpose of ensuring if one is selected that they all are selected. (like a forced buy)</td><td>Optional</td></tr><tr><td>Is Inactive</td><td>FALSE</td><td>True or False to indicate that the zone is no longer in use</td><td>Optional</td></tr></tbody></table>

On the import page, click on the “select” button and upload the file from your desktop to the system. Click on the button “Test Import File”. The system alerts you to any errors on the sheet.

If there are any, click the x remove button by the template you uploaded to remove it from the system. Then correct all the errors in the sheet. Resave the file to your desktop and then re-upload it, using the select button on the import page.

Repeat this step to test the import file till all errors have been fixed and the system provides you a success message.

Click the button “Import File”. The system provides a success message.

If you navigate to the Issue Configuration node on the tree on the left side of the screen and click on “Zones” hyperlink per issue as per the import, the system displays the zones and circulation, which you imported, attached to the issues.

### Zone Import by Date Range

You can import zones also by start and end date range for a product. Once the end date passes, these zones are no longer valid for the product and will no longer be visible in the line item entry screen.

#### By Date Template <a href="#toc40970101" id="toc40970101"></a>

<table data-header-hidden><thead><tr><th width="161"></th><th width="124"></th><th width="309"></th><th></th></tr></thead><tbody><tr><td><strong>Field Name</strong></td><td><strong>Example</strong></td><td><strong>Data Source and Conditions</strong></td><td><strong>Mandatory/ Optional</strong></td></tr><tr><td><strong>Product ID</strong></td><td>BE</td><td>The ID must match that of a product in the advertising system</td><td>Mandatory</td></tr><tr><td><strong>Start Date</strong></td><td>04/01/2019</td><td>MM/DD/YYYY date format and can be any start date.</td><td>Mandatory</td></tr><tr><td><strong>End Date</strong></td><td>04/01/2022</td><td>MM/DD/YYYY date format and can be any end date past the start date</td><td>Mandatory</td></tr><tr><td><strong>Zone ID</strong></td><td>NW</td><td>The Zone ID must match the zone ID in the advertising system if the field “Create Missing IDs” on the import screen is set to “No”.</td><td>Mandatory</td></tr><tr><td>Zone Description</td><td>Northwest territory</td><td>Text describing the zone</td><td>Optional (but really should use one, even if the same as the ID)</td></tr><tr><td>Parent ID</td><td>BG</td><td>The zone parent ID of the zone for the zone to be imported and must match the value in the advertising system</td><td>Mandatory</td></tr><tr><td><strong>Day of Week</strong></td><td>Monday</td><td>Monday through Sunday using the full word upper or lower case.</td><td>Mandatory</td></tr><tr><td><strong>Circulation A</strong></td><td>20000</td><td>Numeric value for the circulation.</td><td>Mandatory</td></tr><tr><td><strong>Circulation B</strong></td><td>20000</td><td>Numeric value for the circulation.</td><td>Mandatory if you are using additional <a href="../../../advertising-setup/zone-dimensions"><strong>dimensions</strong> </a>in Setup.</td></tr><tr><td><strong>Circulation C</strong></td><td>20000</td><td>Numeric value for the circulation.</td><td>Mandatory if you are using additional <a href="../../../advertising-setup/zone-dimensions"><strong>dimensions</strong> </a>in Setup.</td></tr><tr><td><strong>Circulation D</strong></td><td>20000</td><td>Numeric value for the circulation.</td><td>Mandatory if you are using additional <a href="../../../advertising-setup/zone-dimensions"><strong>dimensions</strong> </a>in Setup.</td></tr><tr><td><strong>Circulation E</strong></td><td>20000</td><td>Numeric value for the circulation.</td><td>Mandatory if you are using additional <a href="../../../advertising-setup/zone-dimensions"><strong>dimensions</strong> </a>in Setup.</td></tr><tr><td>Sort Code</td><td>1</td><td>Value by which the zone is sorted in the list as displayed on menus for users.</td><td>Optional</td></tr><tr><td>Country Code</td><td>US</td><td>This is the 2-digit ISO Country Code.</td><td>Optional</td></tr><tr><td>Postal Code</td><td>10591</td><td>5-digit zip code for the zone.</td><td>Optional</td></tr><tr><td>External Reference</td><td>ABC123</td><td>Alpha-numeric Field used in integration with 3rd party</td><td>Optional</td></tr><tr><td>External Group</td><td>ABC</td><td>Alpha-numeric Field used in integration with 3rd party</td><td>Optional</td></tr><tr><td>Cluster Code</td><td>Truck123</td><td>Concept which Groups Zones together with the purpose of ensuring if one is selected that they all are selected. (like a forced buy)</td><td>Optional</td></tr><tr><td>Is Inactive</td><td>FALSE</td><td>TRUE/FALSE field for whether or not the Zone is Inactive.</td><td>Optional</td></tr></tbody></table>

Follow the same steps to import as in the previous section of this document.

### Zone Export/Import

Navigate to **Setup -> Product Setup** and select the Zone Export/Import node on the left side navigation tree. The important differences in this new import when compared to the other existing imports is that this import is only for configuration imports and updates. **It is NOT for importing Zone counts for the issues as there are no quantities in this template...this is just importing for Zone Setup.** Continue to use the existing Zone Import or Zone Import by Date Range for importing the distribution counts for issues.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-d9ed4cf91e427a967e9a9591740a2bed09c455a6%2Fimage%20(417).png?alt=media" alt=""><figcaption></figcaption></figure>

If the desire is to create brand new Zones from scratch, user can start with the "Download Template" option to download a blank template to then fill in all the required and desired optional fields. If the desire is to update existing data, or do a combination of updating and new zones, then the user can start by Exporting existing data into excel, making modifications, and then importing back in.

#### Zone Export/Import Template

The following fields are available in this template:

<table data-full-width="false"><thead><tr><th width="207">Field</th><th width="123">Example</th><th>Description</th><th>Required?</th></tr></thead><tbody><tr><td>Product ID</td><td>DEMO10</td><td>The ID must match that of a product in the advertising system</td><td>Yes</td></tr><tr><td>Zone ID</td><td>19456</td><td>The Zone ID must match the zone ID in the advertising system</td><td>Yes</td></tr><tr><td>Zone Description</td><td>Anycity</td><td>Text describing the zone</td><td>Yes - This is what the user selects in the UI - so while the import won't fail if it is empty, it won't be very useful if it's blank, so DO fill it in.</td></tr><tr><td>Parent ID</td><td>NE</td><td>The zone group / parent ID of the zone for the zone to be imported and must match the value in the advertising system</td><td>Optional, but it's a good idea for ease of use for the end users to have at least one Zone Group.</td></tr><tr><td>Sort Code</td><td>1</td><td>Value by which the zone is sorted in the list as displayed on menus for users.</td><td>Optional</td></tr><tr><td>Country Code</td><td>US</td><td>This is the 2-digit ISO Country Code.</td><td>Optional for the Import - will be required for Geocoding if intent is to allow users to select zones from a map in order entry</td></tr><tr><td>Postal Code</td><td>19456</td><td>5-digit zip code for the zone.</td><td>Optional for the Import - will be required for Geocoding if intent is to allow users to select zones from a map in order entry</td></tr><tr><td>External Reference</td><td>ABC123</td><td>Alpha-numeric Field used in integration with 3rd party</td><td>Optional - If updating existing records and this field is blank, it will be ignored. If it has data in it, it will overwrite what is existing.</td></tr><tr><td>External Group</td><td>ABC</td><td>Alpha-numeric Field used in integration with 3rd party</td><td>Optional - If updating existing records and this field is blank, it will be ignored. If it has data in it, it will overwrite what is existing.</td></tr><tr><td>Cluster Code</td><td>Truck123</td><td>Concept which Groups Zones together with the purpose of ensuring if one is selected that they all are selected. (like a forced buy)</td><td>Optional</td></tr><tr><td>Is Inactive</td><td>TRUE</td><td>TRUE/FALSE field for whether or not the Zone is Inactive.</td><td>Optional</td></tr></tbody></table>

This import has a new screen to visualize the data and confirm it prior to import. Once the template is filled in with all the desired details, navigate to that file location by clicking on the select button and selecting that file.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-142c6b220cc8bb676e72d3fddab655333d14dfd8%2Fimage%20(442).png?alt=media" alt=""><figcaption></figcaption></figure>

Then click the button Test Import File. Screen will appear with columns from the spreadsheet and results displayed if items are new, changed or unchanged. This gives the user a visual and a chance to go back to the spreadsheet and make modifications if this is different than expected. For example, If I thought I was creating 3 new Zones below, when I saw this and noticed that two of the Zones already existed and what I was importing was different than what was already there, I might want to look at those changed items and see what was there already and make sure I wasn't making a mistake.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-ffd145928085e4c5a5c07210f9c79b155c7df285%2Fimage%20(449).png?alt=media" alt=""><figcaption></figcaption></figure>

If the above screen is displaying what I expected to see, then I can click the button at the bottom of the screen to go ahead and import that data. Click Cancel to go back to the previous screen. If there were errors that needed to be changed, click the X to remove the file, then open it in Excel to make desired changes and re-do the select and Test Import file process.

## Issue Zone Configuration

For the most part, Zones and Zone counts will always be imported. It just isn't practical to manually enter in so many zones...ain't nobody got time for that!

That said, this page is helpful if you need to visualize what you just imported and ensure that what you intended has gone into the correct places, and/or to make a minor correction to something. This displays per issue date selected in the selection criteria at the top. (I will often peek in here to remind myself if I imported in next years zones or not.) Just find the desired dates and click Get Data. The popup display will show the counts for the zones in that issue.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-94e44cb7a6f9478be434f95b8b4416c3c7c33421%2Fimage%20(262).png?alt=media" alt=""><figcaption></figcaption></figure>

If the user clicks the button "Import Zone Values" and then downloads the template with current values, the download will be limited to only the issues in the selected range.

<figure><img src="https://docs.navigaglobal.com/~gitbook/image?url=https%3A%2F%2F1360675651-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252Fr9LzViKpjvDGI1drBSJ6%252Fuploads%252FEDI22nBLtPQ6GVSlGJEU%252Fimage.png%3Falt%3Dmedia%26token%3Dd58ddd41-417b-4c05-9202-39da855d5f63&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=521a15da&#x26;sv=2" alt=""><figcaption></figcaption></figure>

If it isn't desired to limit the dates, the end date can be removed and all issues will be returned.
