# Import Campaign Lines

Users can import lines for an existing campaign in the advertising system.

## Campaign Import Lines <a href="#toc437599623" id="toc437599623"></a>

User can import any number of lines with any number of various ad types for different Products, similar to the user creating these lines directly in Naviga Ad.

To do so, navigate to an existing campaign. Click the node Line Items. Click the button “Import”.

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

### Delete Current Lines <a href="#toc510076057" id="toc510076057"></a>

When the pop up screen displays to import the lines, there is a chance for user to delete current lines in a campaign and import the new ones from the excel sheet. This is by choosing the button “Delete Current Lines”. If you click this button, this allows you to import any number of campaign lines and delete the existing current lines on this campaign at the same time.

If you would like to retain the existing campaign lines and add to them, then do not click on this delete button.

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

## Import Template <a href="#toc510076058" id="toc510076058"></a>

Click the button “Download Template”.

This will open the excel spreadsheet for you to fill out. The fields are as follows:

<table data-full-width="true"><thead><tr><th>Field Name</th><th width="215">Sample</th><th width="405">Source</th><th>Optional/ Mandatory</th></tr></thead><tbody><tr><td>External Line ID</td><td>123SH</td><td>Free form matching external ID for the line in another application such as GAM. This will be entered onto the Other Tab, Other Identifiers section, and also in the Google Line ID field.</td><td>Optional</td></tr><tr><td>Agency Line ID</td><td>123456</td><td>Free form matching ID for the line in the Agency's system. This will be entered onto the Other Tab, Other Identifiers section.</td><td>Optional</td></tr><tr><td>3rd Party</td><td>12</td><td>Free form ID of the external 3rd party matching ID to this campaign line. This will be entered onto the Other Tab, Other Identifiers section.</td><td>Optional</td></tr><tr><td>4th Party</td><td>123</td><td>Free form ID of the external 3rd party matching ID to this campaign line. This will be entered onto the Other Tab, Other Identifiers section.</td><td>Optional</td></tr><tr><td><strong>Product</strong></td><td>BF</td><td>Naviga ad Product ID</td><td>Mandatory</td></tr><tr><td><strong>Ad Type ID</strong></td><td>FR</td><td>Naviga ad Ad Type ID from Ad Type Setup</td><td>Mandatory</td></tr><tr><td>Rate Card ID</td><td>64</td><td>Rate Card ID from Rate Card Setup</td><td>Optional</td></tr><tr><td>Rate Card Line ID</td><td>1745</td><td>Rate Card Line ID from Rate Card Setup</td><td>Optional</td></tr><tr><td><strong>Size Description</strong></td><td>Leaderboard Takeover</td><td>This is the line description. It's often, but not always the size of the ad.</td><td>Mandatory</td></tr><tr><td>Ad Server Line Description</td><td>Home Page Takeover</td><td>Free Format Alpha Numeric Description for the Ad Server Line</td><td>Optional</td></tr><tr><td>Creative Type</td><td>S</td><td>Value hard coded in the advertising system to be video or file<br>Valid Options are:<br>S=Standard<br>V=Video<br>M=Master/Companion</td><td>Optional</td></tr><tr><td>Size Codes</td><td>250x300</td><td>Size ID from Ad Size Setup</td><td>Mandatory</td></tr><tr><td>Companion Dimensions</td><td>1x3</td><td>Free alphanumeric</td><td>Optional</td></tr><tr><td>Template ID</td><td>SH1</td><td>GAM Template ID</td><td>Optional</td></tr><tr><td><strong>GL Type</strong></td><td>CPM</td><td>G/L Type ID from G/L Type Setup</td><td>Mandatory</td></tr><tr><td>Section</td><td>Cultural</td><td>Section ID, from product's section setup</td><td>Optional</td></tr><tr><td>Position</td><td>INV</td><td>Position ID, from product's position setup</td><td>Optional</td></tr><tr><td>Ad Serving Platform</td><td>IG</td><td>Ad Server Platform ID (Not from Ad Server Integration, from Ad Serving Platform Setup)</td><td>Optional</td></tr><tr><td><strong>Start Date</strong></td><td>12/1/2016</td><td>Free form date</td><td>Mandatory</td></tr><tr><td><strong>End Date</strong></td><td>12/31/2016</td><td>Free form date</td><td>Mandatory</td></tr><tr><td>Delivery Method</td><td>E</td><td>Alpha code field. Options as follows:<br>E = Deliver Evenly<br>F=Frontloaded Delivery<br>A=As Fast As Possible</td><td>Optional</td></tr><tr><td>Delivery Priority</td><td>4</td><td>Numeric field. Number ranges from 2 - 16, and valid numbers will depend upon the Google Line Type.</td><td>Optional</td></tr><tr><td>Labels</td><td>380075467</td><td>Numeric field representing the labels selected. These are the ID's of the label, which can be seen in Ad Server Integration setup</td><td>Optional</td></tr><tr><td>Max Duration</td><td>30</td><td>Numeric field. This will only display when the Creative Type is Video.</td><td>Optional</td></tr><tr><td>Allow Same Advertiser</td><td>TRUE</td><td>Valid options are TRUE or FALSE or Y/N.</td><td>Optional</td></tr><tr><td>Display Creatives</td><td>ONLY_ONE</td><td>Valid Options are:<br>ONLY_ONE, ONE_OR_MORE, ALL_ROADBLOCK, AS_MANY_AS_POSSIBLE, CREATIVE_SET<br>Only relevant to Standard and Video Creative types</td><td>Optional</td></tr><tr><td>Rotate Creatives</td><td>EVEN</td><td>Valid Options are:<br>EVEN, OPTIMIZED, MANUAL, or SEQUENTIAL</td><td>Optional</td></tr><tr><td>Goal Type Limit</td><td>NONE</td><td>Will appear only if ad type has GAM Line Type of Click Tracking or Price Priority. Valid options here are:<br>NONE<br>LIFETIME<br>DAILY</td><td>Optional</td></tr><tr><td>Share of Voice</td><td>100</td><td>Numeric field (no decimal) between 0 and 100 representing the goal % on a sponsorship type campaign. This field will be hidden if the Google line type (related to the ad type) is "standard"</td><td>Optional</td></tr><tr><td>Target Platform</td><td>BROWSER</td><td>valid entries are:<br>BROWSER MOBILE_APP VIDEO_PLAYER</td><td>Optional</td></tr><tr><td>UDF Keys</td><td>INET.LINE*PICKLIST*1</td><td><p>Valid formats are:<br>INET.LINE*PICKLIST*1<br>INET.LINE*NUMERIC*2</p><p>INET.LINE*TEXT*3</p><p>INET.LINE*DATE*4<br>The numbers at the end of the line should be replaced with the ID of the specific UDF field desired.</p></td><td>Optional</td></tr><tr><td>UDF Values</td><td>1000000</td><td>Must match the format of the above UDF - whether that is a picklist, numeric, text or date field.</td><td>Optional</td></tr><tr><td>Frequency Time Unit</td><td>DAY</td><td>valid entries are: MINUTE<br>HOUR<br>DAY<br>WEEK<br>MONTH<br>LIFETIME<br>POD<br>STREAM<br>UNKNOWN</td><td>Optional</td></tr><tr><td>Frequency Units</td><td>1</td><td>Per User Units. Works with the setting above and. The example given would limit the ad to display only 2x per day per user.</td><td></td></tr><tr><td>Frequency Max Qty</td><td>2</td><td>Max frequency - works along with the two settings above.</td><td>Optional</td></tr><tr><td>Regions</td><td>21171</td><td>This is the ID of the Geo Location from GAM</td><td>Optional</td></tr><tr><td>IncludeExcludeRegion</td><td>Y</td><td>Y/N value</td><td>Optional</td></tr><tr><td><strong>Jan-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Feb-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Mar-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Apr-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>May-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Jun-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Jul-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Aug-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Sep-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Oct-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Nov-22</strong></td><td>0</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td><strong>Dec-22</strong></td><td>1</td><td>Free quantity, but date has to fit between the start and end dates of the campaign.</td><td>Mandatory</td></tr><tr><td>Total Qty</td><td>12</td><td>Free quantity</td><td>Optional</td></tr><tr><td><strong>Price Per Unit</strong></td><td>100.00000</td><td>Free form $</td><td>Mandatory</td></tr><tr><td>Total Amount</td><td>1200</td><td>Free form $</td><td>Optional</td></tr><tr><td>Notes</td><td>Importing this line</td><td>Free form alphanumeric notes on the line as desired.</td><td>Optional</td></tr><tr><td>Include Ad Unit IDs</td><td>87642399,<br>87642519*21732251258,<br>21698962035</td><td>Numeric field representing the ad unit ID from GAM. This can be found in Naviga Ad in the ID column in Ad Units node of Ad Server Integration setup. Multiple ad units are separated by commas. A Child Ad Unit will be represented with an asterisk between the parent and child.</td><td>Optional</td></tr><tr><td>Exclude Ad Unit IDs</td><td>21740211698,233044272,21740211440</td><td>Numeric field representing the ad unit ID from GAM. This can be found in Naviga Ad in the ID column in Ad Units node of Ad Server Integration setup.</td><td>Optional</td></tr></tbody></table>

Once you enter the data, save the excel template to your desktop and note the path.

Click the “Select” button in the import pop up screen and browse to find the saved excel. Choose the file to upload it.

You must click the button “Check Data” before performing the import to correct any errors.

If you have errors, you will receive a message indicating this and when you click OK, you will be given the location and reason for the error.

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

Click close and return to the pop-up import screen. Click the “Remove” x button.

Correct the indicated errors in the template. Resave the template to your desktop. Then repeat the process of uploading the file till all errors have been corrected.

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

Once all the data is correct, click the button “Import Lines”. You will receive a warning that only valid rows will be imported. Click OK, and then you will receive a success message of the import.

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

Click OK and note the new line(s) are now added to the campaign.

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

This new line(s) can be edited and they will reflect the data imported.
