7.7.1.5.1 Xandr - Mapping Media Campaign/Campaign Item to Insertion Order / Line Item



Entity (Xandr)

Field (Xandr)

Example

ADvendio Object

ADvendio Field

Mapping / Additional Information

Entity (Xandr)

Field (Xandr)

Example

ADvendio Object

ADvendio Field

Mapping / Additional Information

Insertion Order

Name

Mapping Campaign 2

Media Campaign

Name



Insertion Order

External Code



Media Campaign

Alternate Order Id



Insertion Order

Description



Media Campaign 

Internal Comment



Insertion Order

State

Active/Inactive

Media Campaign 

AdServer Status



Insertion Order

Currency

EUR

Campaign Item

CurrencyIsoCode



Insertion Order

Flight Dates (non-seamless)

Start Date 



Campaign Start Date/Campaign End Date



Insertion Order

Budget

Unlimited

Impression

Revenue





Set to unlimited for all IOs



Insertion Order

Budget Type (Seamless only)

Impression 

Revenue





Set to Revenue for all Seamless IOs

Insertion Order

Billing Periods (Seamless only)

01.01.2019-unlimited

Media Campaign

Start date of Billing Period will be set according to Media Campaign Start Date.



Insertion Order

Advertiser

Test Mapping Account

Media Campaign

Account

Advertiser ID will be saved in ADvendio object External Account ID

Line Item

Line Item Type

Augmented

Standard

Guaranteed

Campaign Item or

Campaign Item → Ad Price → Ad Spec → Ad Type

Ad Type



Line Item

Insertion Order

Mapping Campaign 2

Campaign Item

AdServer ID Order ID

Once existing mapped by Insertion Order ID

If Item Order is not yet existing, we create them according to Salesforce records

Line Item

Name

Xandr Test_Xandr Test_ROS (XANDR)

Campaign Item

Name



Line Item

ID

123456

Campaign Item

Ad ID



Line Item

External Code



Campaign Item

Alternate Id



Line Item

State

Active/Inactive

Campaign Item

AdServer Status

Inactive as default

Line Item

Currency

EURO (EUR)

Campaign Item

CurrencyIsoCode



Line Item

Flight Dates / Start Date

1/10/2019 12:00 AM America/Scoresbysund

Campaign Item

StartDate



Line Item

Flight Dates / End Date

1/10/2029 11:59 PM America/Scoresbysund

Campaign Item

EndDate



Line Item

Budget Type

Unlimited 

Impressions

Revenue 





Always set to Impressions

Line Item

Budget / Lifetime

Unlimited

Custom Budget



Campaign Item → Ad Price → Ad Spec → Ad Type



Goal Type






Line Item

Budget / Daily

Unlimited

Custom Budget

Pace Lifetime Budget

Campaign Item or

Campaign Item → Ad Price → Ad Spec → Ad Type

Secondary Goal Type




Line Item

Delivery Type (Guaranteed only)



Campaign Item or

Campaign Item → Ad Price → Ad Spec → Ad Type

Delivery Type



Line Item

Delivery Rate Type

ASAP

Evenly

Campaign Item or

Campaign Item → Ad Price → Ad Spec → Ad Type

Delivery Rate Type

If empty, Evenly pacing setting will be set.

Line Item

Impression Budget (Lifetime)



Campaign Item

or Campaign Item → Ad Price → Ad Spec → Ad Type

Booking Quantity



Line Item

Impression Budget (Daily)



Campaign Item or

Campaign Item → Ad Price → Ad Spec → Ad Type

Secondary Goal Quantity



Line Item

Flight Pacing Settings (Daily Budget)

 

Campaign Item or

Campaign Item → Ad Price → Ad Spec → Ad Type

Secondary Goal Budget

 

Line Item

Exclusive %



Campaign Item

or Campaign Item → Ad Price → Ad Spec → Ad Type

Goal Percent

Ad Type value will be used if field at Campaign Item is empty

Line Item

Flight Pacing Settings (Pacing Percent)

 

Campaign Item

or Campaign Item → Ad Price → Ad Spec → Ad Type

Secondary Goal Percent

 

Line Item

Revenue Type/ Cost per day



Fixed Free

CPM

CPC

CPA

vCPM

Cost Plus 

AdPrice

Billing Category

Currently used by ADvendio:

CPM,

CPC,

vCPM,

Fixed Fee (Cost per day)

Line Item

Revenue Value 

Per day 100 EUR 

Campaign Item

Depending on configuration:

Calculated from Campaign Item Amount N2/N3 divided by Quantity

OR

Field: AdServer Price



Line Item

Roadblocking (Guaranteed
& Standard)

Normal

Partial

ExactMatch

Campaign Item → Ad Price → Ad Spec → Ad Type

Roadblocking Type



Line Item

Ad Size (Guaranteed Only)

250x300

Campaign Item → Ad Price → Ad Spec → Ad Type

Master

If empty, “any sizes” will be the default option.

Line Item

Master

250x300

 

Depending on configuration:

  • Reporting Slot (AI)

  • Reporting Slot (view AI)

  • Reporting Slot (Clicks)

If no reporting slot will be submitted and roadblocking is enabled, “any creative” option will be selected as Master in Xandr.

Line Item

Delivery Type

Exclusive

Impressions

Campaign Item

Delivery Type

AdType Guaranteed:

  • Exclusive:

    • Seamless (Pacing = false)

    • Standard (Pacing = false, Safety Pacing = false)

  • Impressions: 

    • Seamless (Lifetime Pacing = true, Daily Budget = 0, Daily Budget Imps = 0)

    • Standard (Lifetime Pacing = true, Daily Budget = ignored, Daily Budget Imps = ignored)

Line Item

Priority



Campaign Item

or Campaign Item → Ad Price → Ad Spec → Ad Type

Priority



Line Item

Allow RTB competition



Campaign Item

RTB Competition



Line Item

Optimization / Conversion Tracking

Primary KPI:

No performance Goal

CPC

CPA

CTR

Campaign Item

Billing Category = CPC

for CPC (ALI) we set:

Optimization enabled

CPC goal = CPC price from ADvendio (see Revenue Value)

Goal Priority = Performance

Line Item

Supply Type

Managed

Open Exchange

Deals





Set to Managed and Open Exchange

Line Item

Frequency

1-255 per 1 Hour, Day, Week, Month, Lifetime

Campaign Item

Frequency



Line Item

Recency

1 per X hours, days, weeks, months





Not Used

Line Item

Inventory



Campaign Item → Selected AdServer ID

Campaign Item → Ad Spec → AdServer ID AdSpec Assignment

AdServer ID

Category = Inventory

Line Item

Connection



Campaign Item → Selected AdServer ID

AdServer ID

Category = Connection

Line Item

Device

Desktop & Laptops, Tablet, Phones

Campaign Item → Selected AdServer ID

AdServer ID

Category = Device

Line Item

Supply Type

Web Placements, Mobile Placements, Apps Placements

Campaign Item → Selected AdServer ID

AdServer ID

Category = Device

Line Item

Key Value



Campaign Item

AdServer Targeting



Line Item

Geography



Campaign Item → Selected AdServer ID

AdServer ID 

Category = Geography

Line Item

Postal Code



Not supported





Line Item

Daypart



Campaign Item

Day & Time Targeting



Line Item

System



Campaign Item → Selected AdServer ID

AdServer ID

Category = Device

Line Item

Segment



Campaign Item

AdServer Targeting



Line Item

Brand



Campaign Item → Selected AdServer ID

AdServer ID



Line Item

Manage Creatives

 

Campaign Item

Creative Management

Available for Standard Ad Types

Campaign

Flight End

12/15/2020 12:00 AM

Campaign Item

Xandr Campaign Settings

Available for non-seamless Standard Ad Types:

  • By default, the Xandr Campaign will use the runtime set at the level of Campaign Item/Line Item. To change to unlimited, select Unlimited runtime from the picklist field.