Import Campaign Lines
Users can import lines for an existing campaign in the advertising system.
Campaign Import Lines
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”.
Delete Current Lines
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.
Import Template
Click the button “Download Template”.
This will open the excel spreadsheet for you to fill out. The fields are as follows:
External Line ID
123SH
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.
Optional
Agency Line ID
123456
Free form matching ID for the line in the Agency's system. This will be entered onto the Other Tab, Other Identifiers section.
Optional
3rd Party
12
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.
Optional
4th Party
123
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.
Optional
Product
BF
Naviga ad Product ID
Mandatory
Ad Type ID
FR
Naviga ad Ad Type ID from Ad Type Setup
Mandatory
Rate Card ID
64
Rate Card ID from Rate Card Setup
Optional
Rate Card Line ID
1745
Rate Card Line ID from Rate Card Setup
Optional
Size Description
Leaderboard Takeover
This is the line description. It's often, but not always the size of the ad.
Mandatory
Ad Server Line Description
Home Page Takeover
Free Format Alpha Numeric Description for the Ad Server Line
Optional
Creative Type
S
Value hard coded in the advertising system to be video or file Valid Options are: S=Standard V=Video M=Master/Companion
Optional
Size Codes
250x300
Size ID from Ad Size Setup
Mandatory
Companion Dimensions
1x3
Free alphanumeric
Optional
Template ID
SH1
GAM Template ID
Optional
GL Type
CPM
G/L Type ID from G/L Type Setup
Mandatory
Section
Cultural
Section ID, from product's section setup
Optional
Position
INV
Position ID, from product's position setup
Optional
Ad Serving Platform
IG
Ad Server Platform ID (Not from Ad Server Integration, from Ad Serving Platform Setup)
Optional
Start Date
12/1/2016
Free form date
Mandatory
End Date
12/31/2016
Free form date
Mandatory
Delivery Method
E
Alpha code field. Options as follows: E = Deliver Evenly F=Frontloaded Delivery A=As Fast As Possible
Optional
Delivery Priority
4
Numeric field. Number ranges from 2 - 16, and valid numbers will depend upon the Google Line Type.
Optional
Labels
380075467
Numeric field representing the labels selected. These are the ID's of the label, which can be seen in Ad Server Integration setup
Optional
Max Duration
30
Numeric field. This will only display when the Creative Type is Video.
Optional
Allow Same Advertiser
TRUE
Valid options are TRUE or FALSE or Y/N.
Optional
Display Creatives
ONLY_ONE
Valid Options are: ONLY_ONE, ONE_OR_MORE, ALL_ROADBLOCK, AS_MANY_AS_POSSIBLE, CREATIVE_SET Only relevant to Standard and Video Creative types
Optional
Rotate Creatives
EVEN
Valid Options are: EVEN, OPTIMIZED, MANUAL, or SEQUENTIAL
Optional
Goal Type Limit
NONE
Will appear only if ad type has GAM Line Type of Click Tracking or Price Priority. Valid options here are: NONE LIFETIME DAILY
Optional
Share of Voice
100
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"
Optional
Target Platform
BROWSER
valid entries are: BROWSER MOBILE_APP VIDEO_PLAYER
Optional
UDF Keys
INET.LINE*PICKLIST*1
Valid formats are: INET.LINE*PICKLIST*1 INET.LINE*NUMERIC*2
INET.LINE*TEXT*3
INET.LINE*DATE*4 The numbers at the end of the line should be replaced with the ID of the specific UDF field desired.
Optional
UDF Values
1000000
Must match the format of the above UDF - whether that is a picklist, numeric, text or date field.
Optional
Frequency Time Unit
DAY
valid entries are: MINUTE HOUR DAY WEEK MONTH LIFETIME POD STREAM UNKNOWN
Optional
Frequency Units
1
Per User Units. Works with the setting above and. The example given would limit the ad to display only 2x per day per user.
Frequency Max Qty
2
Max frequency - works along with the two settings above.
Optional
Regions
21171
This is the ID of the Geo Location from GAM
Optional
IncludeExcludeRegion
Y
Y/N value
Optional
Jan-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Feb-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Mar-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Apr-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
May-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Jun-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Jul-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Aug-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Sep-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Oct-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Nov-22
0
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Dec-22
1
Free quantity, but date has to fit between the start and end dates of the campaign.
Mandatory
Total Qty
12
Free quantity
Optional
Price Per Unit
100.00000
Free form $
Mandatory
Total Amount
1200
Free form $
Optional
Notes
Importing this line
Free form alphanumeric notes on the line as desired.
Optional
Include Ad Unit IDs
87642399, 87642519*21732251258, 21698962035
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.
Optional
Exclude Ad Unit IDs
21740211698,233044272,21740211440
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.
Optional
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.
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.
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.
Click OK and note the new line(s) are now added to the campaign.
This new line(s) can be edited and they will reflect the data imported.
Last updated
Was this helpful?