# Import/Export & Expiring Ratecards

There are three methods that can be used to create new ratecards:

* One can export existing ratecards along with all ratecard lines, edit the exported Excel template and then use that template to import new ratecards.
* One can create new ratecards directly in Excel and import the new ratecard.
* Or the copy tool provides a shortcut for copying existing ratecards to other date ranges or products.

## Ratecard Line EXPORT <a href="#toc112239902" id="toc112239902"></a>

In the Ad Module, navigate to the menu **Setup -> Import/ Export Ratecards**.

Under ratecard line import select either Export Standard or Export Listing/Classified Ratecards and select the applicable product(s) and the dates range.

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

Check the box for the ratecard(s) you wish to export to Excel to use as a template.

Click on the button “Download Selected Ratecards”.

The Excel sheet opens with the header and line details of the Ratecard(s) allowing you to edit information or remove or add ratecard lines. When finished, save the file.

![](https://1373611743-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FllEJ9TfSuWgLHCHbB30c%2Fuploads%2Fgit-blob-8dd29fd99b950e38f7da56fc031cbbc7e37b6bd3%2F1%20\(11\).png?alt=media)

## Ratecard Line IMPORT <a href="#ref112155695" id="ref112155695"></a>

Select Import Standard Ratecard Lines or Import Listing Ratecard Lines on the left menu, depending on the type of ratecard you plan to import.

For exported ratecards, click the “Select” button and browse to find the file created by the ratecard export process. For new ratecards click the button “Download Template” and fill in the data from the exported file being sure to populate required fields. The format and requirements are included in the section of this document titled “Template Fields”.

Click the button “Test Import File”. If there are errors in the template, then the system will alert you to the errors. Click the OK to the message and the details of the errors displays.

{% hint style="warning" %}
Note - Ratecard ID's must be unique for a new ratecard to be created. If you re-use an existing Ratecard ID, new rate lines will appended to the existing ratecard. Use caution to ensure you are using unique ID's if you are expecting new Ratecards to be created.

Ratecard Line IDs must not contain spaces

Also - if you are appending ratecard lines to an existing ID, ensure that the Product ID is correct for that Ratecard ID.
{% endhint %}

Correct any errors in the template and re-save. On the import screen remove the erroneous file by using the x remove button. Re-select the corrected file.

Repeat the test import and correction process until all errors are removed, the import will not process if any errors are present.

Click on “Import File” and the system will import the file and give you an import ID.

## Ratecard Copy <a href="#toc112239904" id="toc112239904"></a>

This feature allows a shortcut to copy existing ratecards and is normally used where different ratecards are needed but ratecard line items are similar across all ratecards.

Navigate to the menu **Setup -> Import/ Export Ratecards.** On the left side menu, select **Ratecard Copy -> Export Standard** or **Listing Ratecards**.

Choose the product(s) from the drop-down menu and choose the appropriate expiration date range then click “Get Ratecards”.

Check the box or boxes for the Ratecards you’d like to export then click “Download Selected Ratecards”.

![](https://1373611743-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FllEJ9TfSuWgLHCHbB30c%2Fuploads%2Fgit-blob-53764b92081c01435b71dc98a15b29fe72f83be0%2F3%20\(17\).png?alt=media)

The spreadsheet displays the ratecard header for exported Ratecards.

Edit the sheet to include only the Ratecards you’d like to import back into the system by changing products or start/end dates. The sheet auto defaults the same product Id and a Start Date and End Date one year from the original Ratecard dates. These can be changed as needed.

On the Copy node screen, select the template and import the file.

You can also Download a new template and fill out the columns or use the sheet which you just exported and edited.

If there are any errors in the file, the system alerts you to the errors and you can then remove the file from the import screen. Then edit the spreadsheet with corrections, save and repeat the upload process. Then click the Import File button again.

The system provides a success message with the new Ratecard ID. Click OK.

Navigate to the **Product Setup menu -> Ratecards** node and search on the product.

The Ratecard you imported is displayed by the Selection Type and Ratecard ID. Note that the Ratecard edited information from the spreadsheet display including the dates.

## View Imported Ratecard <a href="#toc112239905" id="toc112239905"></a>

Click the node “List of Imported Ratecard Lines”. Choose the import ID from the drop-down menu and click on “Get Ratecards”. The imported cards display with a hyperlink to each Ratecard ID.

Click the hyperlink to the Ratecard ID, and the details display. You can make any edits and changes to the Ratecard, which is now available for use in the campaign entry screen.

## Template Fields - Standard <a href="#toc112239906" id="toc112239906"></a>

See[ **Importing / Exporting Digital GAM Rates**](https://docs.navigaglobal.com/naviga-ad/2025.1/naviga-ad-modules/advertising/setup/import-export-and-expiring-ratecards/importing-exporting-digital-gam-rates) for additional template fields now supported.

<table data-header-hidden data-full-width="true"><thead><tr><th width="235"></th><th width="116"></th><th width="473.4240422721268"></th><th></th></tr></thead><tbody><tr><td><strong>Field Name</strong></td><td><strong>Example</strong></td><td><strong>Data Source</strong></td><td><strong>Mandatory/ Optional</strong></td></tr><tr><td>Product ID</td><td>BF</td><td>This must match the Naviga value of the digital product ID.</td><td>Mandatory</td></tr><tr><td>Ratecard ID</td><td>70</td><td>Alphanumeric value of the ratecard ID, with no spaces. Must be unique to create a new ratecard. If not unique it will append the lines to existing ratecard id </td><td>Mandatory</td></tr><tr><td>Ratecard Description</td><td>2016</td><td>Alphanumeric Description of the ratecard free entry.</td><td>Optional, but strongly recommended or ratecard is difficult to select in campaign entry.</td></tr><tr><td>Default Frequency Rate Discount Schedule</td><td>20111</td><td>This is the discount schedule which must match the Naviga value of the discount setup in the system</td><td>Optional</td></tr><tr><td>Apply Frequency Discounts without Contract</td><td>TRUE</td><td><p>TRUE for yes if you want to apply the default frequency rate of the discount schedule.</p><p>FALSE for No if you don’t want to apply it.</p></td><td>Optional</td></tr><tr><td>Client Type</td><td>CORP</td><td>This is the corresponding client type ID value of the advertiser ID as defined in the advertiser maintenance. These values are setup in the Setup -> Client Type setup.</td><td>Optional</td></tr><tr><td>Client</td><td>244534, 244654*A1, 265444, 365444*Book</td><td>This is the advertiser ID which must match the value in the system. You can also enter multiple client IDs separated by commas. You can also enter client IDs and Brands. You can leave blank if you want the Ratecard to be accessible for all advertisers in order entry.</td><td>Optional</td></tr><tr><td>Currency ID</td><td>EU</td><td>Must match the Naviga currency ID.</td><td>Optional; and MUST leave blank for local currency.</td></tr><tr><td>Edition</td><td>Christmas</td><td>Must match the Edition ID value in Naviga for this product</td><td>Optional and only applies to print ratecards.</td></tr><tr><td>Start Date</td><td>5/16/2019</td><td>MM/DD/YYYY format of the start date when this ratecard can be displayed and used in the campaign entry screen.</td><td>Mandatory</td></tr><tr><td>End Date</td><td>12/31/2019</td><td>MM/DD/YYYY format of the end date when the ratecard expires</td><td>Mandatory</td></tr><tr><td>Original Ratecard ID</td><td>102</td><td>Ratecard ID that this rate is replacing. This is used by Manage Expiring Ratecards process when you wish to replace the old rate with the new rate in packages, classified templates, etc.</td><td>Optional</td></tr><tr><td>Color</td><td>BW</td><td>Value must match the Color ID in the Print Color Setup menu under the Setup -> Advertising Setup menu.</td><td>Optional</td></tr><tr><td>Line Description</td><td>Banner AD</td><td>Free entry description of the ratecard line</td><td>Mandatory</td></tr><tr><td>Allow Description Override</td><td>Y</td><td>Y for Yes and N for No to allow user in the entry line to override the description</td><td>Optional</td></tr><tr><td>Section</td><td>SAT</td><td>Must match the section ID for the product.</td><td>Optional.</td></tr><tr><td>Position</td><td>DISP</td><td>Must match the position ID for the product.</td><td>Optional.</td></tr><tr><td>Ad Type</td><td>CPC</td><td>Must match AD Type ID value in Naviga in the AD Type table</td><td>Mandatory</td></tr><tr><td>G/L Type</td><td>NL</td><td>Must match G/L Type ID value in Naviga in the G/L Type table</td><td>Mandatory</td></tr><tr><td>Sizes</td><td>300x250</td><td>Must match Naviga size ID as in the Size table for digital products</td><td>Mandatory</td></tr><tr><td>Default Production Status</td><td>1</td><td>Must match the ID for the production status in Naviga</td><td>Optional</td></tr><tr><td>Columns</td><td>3</td><td>Numeric value of the number of columns</td><td>Optional</td></tr><tr><td>Depth</td><td>6</td><td>Numeric value for the depth (height) value in inches.</td><td>Optional</td></tr><tr><td>Production Link</td><td>https://www.msgl.com</td><td>Must match Naviga Production Links entered in the Setup menu</td><td>Optional</td></tr><tr><td>External ID</td><td>123</td><td>Matches the external ID of the external ratecard if any.</td><td>Optional. This field is not used directly by Naviga Ad, but can be exported to 3rd party systems along with orders using this rateline</td></tr><tr><td>Rate</td><td>2200</td><td>Numeric; free entry for the rate per line.</td><td>Mandatory</td></tr><tr><td>Use AD Server Inventory</td><td>TRUE</td><td>TRUE for yes or FALSE for No for the GAM products</td><td>Optional</td></tr><tr><td>No Tax</td><td>Y</td><td>Y for No tax for the line and N for yes tax for the line.</td><td>Optional</td></tr><tr><td>Monday Override Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Tuesday Override Rate</td><td>299</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Wednesday Override Rate</td><td>288</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Thursday Override Rate</td><td>270</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Friday Override Rate</td><td>250</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Saturday Override Rate</td><td>400</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Sunday Override Rate</td><td>450</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Weekdays Override Rate</td><td>344</td><td>Numeric value to override the base rate as well as days of the week’s rates</td><td>Optional</td></tr><tr><td>Weekends Override Rate</td><td>355</td><td>Numeric value to override the base rate to override Saturday and Sunday rates</td><td>Optional</td></tr><tr><td>Special Override Date 1</td><td>06/02/2021</td><td>Date format for a date where a special override is allowed.</td><td>Optional</td></tr><tr><td>Special Override Date Rate 1</td><td>200</td><td>Numeric amount which is a rate that overrides the usual rate only on the Date 1 above.</td><td>Optional</td></tr><tr><td>Repeat override date and rate 2, 3, 4 and 5</td><td></td><td>Repeat of the above two columns as needed for more dates and rates</td><td>Optional</td></tr><tr><td>Cancel at Full Value</td><td>FALSE</td><td>TRUE for yes or FALSE for No</td><td>Optional</td></tr><tr><td>Unit of Measure</td><td>INCHES</td><td>Leave blank for Undefined. Options are INCHES, CENTIMETERS, MILLIMETERS, or AGATES</td><td>Optional, but necessary if you use Minimum/ Maximum depth options below.</td></tr><tr><td>Minimum Depth</td><td>1</td><td>Numeric amount of the minimum depth of the ad to be eligible for this rate.</td><td>Optional</td></tr><tr><td>Maximum Depth</td><td>3</td><td>Numeric amount of the maximum depth of the ad to be eligible for this rate.</td><td>Optional</td></tr><tr><td>Use Columns Count in Calc</td><td>FALSE</td><td>TRUE for yes or FALSE for No. This is used in conjunction with the minimum / maximum above.</td><td>Optional</td></tr><tr><td>Allow Rate on Packages</td><td>FALSE</td><td>TRUE for yes or FALSE for No</td><td>Optional</td></tr><tr><td>Flat Rate Ind</td><td>FALSE</td><td>TRUE for yes or FALSE for No</td><td>Optional</td></tr><tr><td>Lines</td><td>420</td><td>Numeric value. Used in the Page Eq calculation</td><td>Optional</td></tr><tr><td>Category Tree</td><td>AUTO,EMPL</td><td>Alphanumeric Category Tree ID. Comma separated if this rate can be used in multiple categories.</td><td>Optional</td></tr><tr><td>Package Only Ind</td><td>FALSE</td><td>TRUE for yes or FALSE for No</td><td>Optional</td></tr><tr><td>Default Qty</td><td>1000</td><td>Numeric Value. Really only relevant for a CPM, CPC, etc.</td><td>Optional</td></tr><tr><td>Disc Escalation Qty</td><td>15:5;20:10;30:25</td><td>Numeric value. Format is Up to Qty : Discount Percent. Separate rows with semi-colon. In the example provided. From 0-15 Column Inches (CM, MM) you would get a 5% discount. From 15-20 Col Inches you would get a 10% discount and from 20-30 Col Inches you would get a 25% discount.</td><td>Optional</td></tr><tr><td>Disc Escalation Rounding</td><td>10</td><td>Used in conjunction with above Discount Escalation Qty. Leave blank for No Rounding. 1, 5, or 10 for Rounding to the nearest dollar, 5 dollars or 10 dollars (or other currency)</td><td>Optional</td></tr><tr><td>Rate Escalation Qty</td><td><p>50000:210;</p><p>150000:185;200000:165</p></td><td>Numeric value. Format is Up to Qty : Override Rate. Separate rows with semi-colon. In the example provided a quantity from 0-50,000 would have a rate of $210. From 50,000-150,000 the rate would be $185, and up to 200,000 would get a rate of $165.</td><td>Optional</td></tr><tr><td>Cost Rate</td><td>10</td><td>Numeric Value for the Cost Rate (Optional field used in GL Mapping for 3rd party costs)</td><td>Optional</td></tr><tr><td><a href="importing-exporting-digital-gam-rates#additional-template-fields-supporting-gam-targeting">(CONTINUES...)</a></td><td></td><td>40+ additional template fields specific to the GAM targeting tab are available. See link for details</td><td>Optional</td></tr></tbody></table>

Note that if any of the rate columns are left blank, the system applies the base rate value in the column “Rate” to that date.

Also, note that the lines are automatically populated from the sizes provided in the template, pulling the line equivalency from the size table in the menu **Setup -> Advertising Setup -> Size Code Setup**.

![](https://1373611743-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FllEJ9TfSuWgLHCHbB30c%2Fuploads%2Fgit-blob-4e63014ab5b781e6d5a796c7e0f3b766db7ecda4%2F4%20\(34\).png?alt=media)

## Template Fields - Listing <a href="#toc112239907" id="toc112239907"></a>

<table data-header-hidden><thead><tr><th width="148"></th><th width="121"></th><th width="340"></th><th></th></tr></thead><tbody><tr><td><strong>Field Name</strong></td><td><strong>Example</strong></td><td><strong>Data Source</strong></td><td><strong>Mandatory/ Optional</strong></td></tr><tr><td>Product ID</td><td>BF</td><td>This must match the Naviga value of the digital product ID.</td><td>Mandatory</td></tr><tr><td>Ratecard ID</td><td>70</td><td>Alphanumeric value of the ratecard ID, with no spaces. Must be unique to create a new ratecard. If not unique it will append the lines to existing ratecard id </td><td>Mandatory</td></tr><tr><td>Ratecard Description</td><td>2016</td><td>Alphanumeric Description of the ratecard free entry.</td><td>Optional</td></tr><tr><td>Default Frequency Rate Discount Schedule</td><td>20111</td><td>This is the discount schedule which must match the Naviga value of the discount setup in the system</td><td>Optional</td></tr><tr><td>Apply Frequency Discounts without Contract</td><td>TRUE</td><td><p>TRUE (or Y) for yes if you want to apply the frequency rate of the discount schedule.</p><p>FALSE (or N) for No if you don’t want to apply it.</p></td><td>Optional</td></tr><tr><td>Client Type</td><td>CORP</td><td>This is the corresponding client type ID value of the advertiser ID as defined in the advertiser maintenance. These values are setup in the <strong>Setup -> Client Type</strong> setup.</td><td>Optional</td></tr><tr><td>Client</td><td>244534, 244654*A1, 265444, 365444*Book</td><td>This is the advertiser ID which must match the value in the system. You can also enter multiple client IDs separated by commas. You can also enter client IDs and Brands. You can leave blank if you want the Ratecard to be accessible for all advertisers in order entry.</td><td>Optional</td></tr><tr><td>Currency ID</td><td>EU</td><td>Must match the Naviga currency ID.</td><td>Optional; and leave blank for local currency.</td></tr><tr><td>Edition</td><td>Christmas</td><td>Must match the Edition ID value in Naviga for this product</td><td>Optional. Note: Editions are not currently supported in Listing type ads, so this should be left blank.</td></tr><tr><td>Start Date</td><td>5/16/2019</td><td>MM/DD/YYYY format of the start date when this ratecard can be displayed and used in the campaign entry screen.</td><td>Mandatory</td></tr><tr><td>End Date</td><td>12/31/2019</td><td>MM/DD/YYYY format of the end date when the ratecard expires</td><td>Mandatory</td></tr><tr><td>Original Ratecard ID</td><td>102</td><td>Ratecard ID that this rate is replacing. This is used by Manage Expiring Ratecards process when you wish to replace the old rate with the new rate in packages, classified templates, etc.</td><td>Optional</td></tr><tr><td>Color</td><td>BW</td><td>Value must match the Color ID in the Print Color Setup menu under the <strong>Setup -> Advertising Setup</strong> menu.</td><td>Optional</td></tr><tr><td>Line Description</td><td>Banner AD</td><td>Free entry description of the Ratecard line</td><td>Mandatory</td></tr><tr><td>Allow Description Override</td><td>Y</td><td>Y for Yes and N for No to allow user in the entry line to override the description</td><td>Optional</td></tr><tr><td>Lines</td><td>1</td><td>Numeric value of the lines entered</td><td>Optional</td></tr><tr><td>Section</td><td>SAT</td><td>Must match the section ID for the product.</td><td>Optional.</td></tr><tr><td>Position</td><td>DISP</td><td>Must match the position ID for the product.</td><td>Optional.</td></tr><tr><td>Ad Type</td><td>CPC</td><td>Must match AD Type ID value in Naviga in the AD Type table</td><td>Mandatory</td></tr><tr><td>G/L Type</td><td>NL</td><td>Must match G/L Type ID value in Naviga in the G/L Type table</td><td>Mandatory</td></tr><tr><td>Columns</td><td>3</td><td>Numeric value of the number of columns</td><td>Optional</td></tr><tr><td>Depth</td><td>6</td><td>Numeric value for the depth (height) value in inches, cm, or mm.</td><td>Optional</td></tr><tr><td>Production Link</td><td>https://www.msgl.com</td><td>Must match Naviga Production Links entered in the Setup menu</td><td>Optional</td></tr><tr><td>External ID</td><td>123</td><td>Matches the external ID of the external ratecard if any.</td><td>Optional. This field is not used directly by Naviga Ad, but can be exported to 3rd party systems along with orders using this rateline</td></tr><tr><td>Base Qty</td><td>10</td><td>Numeric free entry of base quantity</td><td>Optional. This is how many you get (in inches, words, lines, etc.) for the base rate. Anything over this Quantity will be charged the Overage rate below.</td></tr><tr><td>Base Rate</td><td>200</td><td>Numeric free entry for rate per quantity</td><td>Mandatory</td></tr><tr><td>Overage Rate</td><td>2</td><td>Numeric value for the overage rate in case there is one.</td><td>Optional</td></tr><tr><td>No Tax</td><td>Y</td><td>Y for No tax for the line and N for yes tax for the line.</td><td>Optional</td></tr><tr><td>Monday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Monday</td><td>Optional</td></tr><tr><td>Monday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Monday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Tuesday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Tuesday</td><td>Optional</td></tr><tr><td>Tuesday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Tuesday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Wednesday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Wednesday</td><td>Optional</td></tr><tr><td>Wednesday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Wednesday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Thursday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Thursday</td><td>Optional</td></tr><tr><td>Thursday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Thursday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Friday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Friday</td><td>Optional</td></tr><tr><td>Friday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Friday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Saturday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Saturday</td><td>Optional</td></tr><tr><td>Saturday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Saturday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Sunday Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for Sunday</td><td>Optional</td></tr><tr><td>Sunday Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Sunday Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Weekends Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for weekends</td><td>Optional</td></tr><tr><td>Weekends Override Base Rate</td><td>300</td><td>Numeric value to override the base rate</td><td>Optional</td></tr><tr><td>Weekends Override Overage Rate</td><td>12</td><td>Numeric value to override the overage rate</td><td>Optional</td></tr><tr><td>Weekdays Override Base Quantity</td><td>10</td><td>Override numeric value of base quantity for any weekday</td><td>Optional</td></tr><tr><td>Special Override Date 1</td><td>01/03/2022</td><td>Override date for which you’ll add an override rate and quantity below</td><td>Optional</td></tr><tr><td>Special Override Date Base Qty 1</td><td>1</td><td>Override quantity for the first date</td><td>Optional</td></tr><tr><td>Special Override Date Overage Rate 1</td><td>10</td><td>Override overage rate for the Date 1</td><td>Optional</td></tr><tr><td>Repeat for the above rows till Rate 5</td><td></td><td></td><td></td></tr><tr><td>Cancel at Full Value</td><td>FALSE</td><td>TRUE for yes or FALSE for No</td><td>Optional</td></tr><tr><td>Unit of Measure</td><td>INCHES</td><td>Leave blank for Undefined. Options are INCHES, CENTIMETERS, MILLIMETERS, or AGATES</td><td>Optional, but necessary if you use Minimum/ Maximum depth options below.</td></tr><tr><td>Minimum Depth</td><td>1</td><td>Numeric amount of the minimum depth of the ad to be eligible for this rate.</td><td>Optional</td></tr><tr><td>Maximum Depth</td><td>3</td><td>Numeric amount of the maximum depth of the ad to be eligible for this rate.</td><td>Optional</td></tr><tr><td>Use Columns Count in Calc</td><td>FALSE</td><td>TRUE for yes or FALSE for No. This is used in conjunction with the minimum / maximum above.</td><td>Optional</td></tr><tr><td>Category Tree</td><td>AUTO,EMPL</td><td>Alphanumeric Category Tree ID. Comma separated if this rate can be used in multiple categories.</td><td>Optional</td></tr><tr><td>Package Only Ind</td><td>FALSE</td><td>TRUE for yes or FALSE for No</td><td>Optional</td></tr><tr><td>Default Qty</td><td>1000</td><td>Numeric Value. Really only relevant for a CPM, CPC, etc.</td><td>Optional</td></tr><tr><td>Disc Escalation Qty</td><td>15:5;20:10;30:25</td><td>Numeric value. Format is Up to Qty : Discount Percent. Separate rows with semi-colon. In the example provided. From 0-15 Column Inches (CM, MM) you would get a 5% discount. From 15-20 Col Inches you would get a 10% discount and from 20-30 Col Inches you would get a 25% discount.</td><td>Optional</td></tr><tr><td>Disc Escalation Rounding</td><td>10</td><td>Used in conjunction with above Discount Escalation Qty. Leave blank for No Rounding. 1, 5, or 10 for Rounding to the nearest dollar, 5 dollars or 10 dollars (or other currency)</td><td>Optional</td></tr><tr><td>Default Production Status</td><td>1</td><td>Must match the ID for the production status in Naviga</td><td>Optional</td></tr></tbody></table>

## Managing Ratecard Changes <a href="#toc112239908" id="toc112239908"></a>

Ratecards are used not only in order entry where a user manually selects the ratecard and ratecard line, but also in the following:

* Listing ads via the booking wizard where the ratecard is automatically selected based on the template chosen
* In Packages where the ratecard is auto-selected based on the package chosen (both in classified packages and in regular packages)
* On Group Ratecards as an override for a particular product and rateline.

It is because of these various associations that it became necessary to have an easy way to update all of these associations when ratecards are updated.

In both the Standard Ratecards and the Listing Ratecards, there is now a column in the export called “Original Ratecard ID”. This should be manually populated with the Ratecard ID from the current Ratecard, and a new, unique Ratecard ID entered in the “Ratecard ID” column. Then, when it is time to update the associated classified templates, packages, and group rate cards, the Manage Expiring Ratecards process can be run.

This is best explained with an example. Let us assume that you are creating the 2023 ratecards by downloading the 2022 Ratecards and applying a % increase to the prices. Your export will look something like this:

<figure><img src="https://1373611743-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FllEJ9TfSuWgLHCHbB30c%2Fuploads%2Fgit-blob-0fe722067b3f23138263bbf6fa3b4a4e6900bab3%2F5%20(38).png?alt=media" alt=""><figcaption></figcaption></figure>

You will want to take the Ratecard ID (102 in the example) and move it to the Original Ratecard ID column. Then enter in a new, unique value for the Ratecard ID which will be used for the new ratecard. Update the start and end dates to reflect when these new rates will be valid and update the prices and anything else that will be changing for the new year.

Import your new ratecard using the steps outlined above in the *Digital Ratecard Line* Import section.

The next step will be to update the associations. In this example, I will want to update all the packages, classified templates, and Group Ratelines that are using ratecard ID 102 and replace them with the new ratecard.

Navigate to Setup -> Manage Expiring Ratecards. Enter the expiration date of the expiring ratecard and click select data. Optionally, this can be filtered by product group. You will see reflected here any existing rates that are in use in a package, template or group ratecard and you will see if there is a replacement ratecard available.

![](https://1373611743-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FllEJ9TfSuWgLHCHbB30c%2Fuploads%2Fgit-blob-69f599656f1d9e189e7da4b84956fb0266e5146c%2F6%20\(32\).png?alt=media)

Along the left side, select the line(s) that you wish to update and then select Update Ratecard Links at the bottom of the screen. The system will then replace the original ratecard and rateline ID with the new ratecard and rateline.

The associated ratecard links are not dated, so it is best to run this process only when you are actually ready for the new ratecard to start to be used.
