5.3.4 Delivery Data Fields

Here you find the information to all delivery data fields and also the hierarchy for the field Quantity important for your Billing and Accounting. The fields contain raw data, which is not changed in any way by. 

By contrast the data in the Revenue Schedule where ADvendio caps the Invoice Quantity (RS).

Attention

Capping of Invoice Quantity:

The object Delivery Data contains the raw delivery data from AdServer. This data will be transferred to the Revenue Schedules where the amounts for the invoicing process will be calculated. This Invoice Quantity will always be capped on the Booked Quantity of your Campaign Item, meaning that if a position overdelivers, the total quantity that will be invoiced later is not higher than the initial booked quantity.



Delivery Data Object Fields


Name

Label

Inline Help Text

ADvendio__AccumulatedDeliveryTillNow__cAccumulated Delivery Till Now

ADvendio__AdServerID__c

Ad Server ID

AdServer-ID, to which the delivery data refers.

ADvendio__CampaignItem__c

Campaign Item

Campaign-Item, to which the delivery data refers.

ADvendio__Day__c

Day

Day, to which the delivery data relates. If the "type" is monthly, this is set to the first day of the month.

ADvendio__DeliveredAIsManual__c

Delivered AIs (manual)

Enter the Delivered AIs manually.

For invoicing this value overwrites the "Delivered AIs" delivered by the AdServer if there is no entry for the invoice quantity.

For more information about the hierarchy for financing please take a look below.

ADvendio__DeliveredClicks__c

Delivered Clicks

This field will be automatically filled by a script. It displays the delivered clicks of the assigned campaign item.

ADvendio__DeliveredClicksManual__c

Delivered Clicks (manual)

Enter the DeliveredClicks manually.

For invoicing this value overwrites the DeliveredClicks delivered by the AdServer if there is no entry for invoice quantity.

For more information about the hierarchy for financing please take a look below.

ADvendio__DeliveredImpressions__c

Delivered Impressions

This field will be automatically filled by a script. It displays the delivered impressions of the assigned campaign item. For more information about the hierarchy for financing please take a look below.

ADvendio__DeliveredQuantityRatio__c

Delivered Quantity Ratio

This field shows the delivery per site compared to the delivery in this month.

ADvendio__InvoiceAmountB1__c

Invoice Amount (B1) (Monthly)

This field shows the InvoiceAmount B1 for this site. The calculation will be automatically done by ADvendio.

ADvendio__InvoiceAmountB2__c

Invoice Amount (B2) (Monthly)

This field shows the InvoiceAmount B2 for this site. The calculation will be automatically done by ADvendio.

ADvendio__InvoiceAmountB3__c

Invoice Amount (B3) (Monthly)

This field shows the InvoiceAmount B3 for this site. The calculation will be automatically done by ADvendio.

ADvendio__InvoiceAmountN1__c

Invoice Amount (N1) (Monthly)

This field shows the InvoiceAmount N1 for this site. The calculation will be automatically done by ADvendio.

ADvendio__InvoiceAmountN2__c

Invoice Amount (N2) (Monthly)

This field shows the InvoiceAmount N2 for this site. The calculation will be automatically done by ADvendio.

ADvendio__InvoiceAmountN3__c

Invoice Amount (N3) (Monthly)

This field shows the InvoiceAmount N3 for this site. The calculation will be automatically done by ADvendio.

ADvendio__InvoiceQuantityManual__c

Invoice Quantity (manual)

Enter the Invoice Quantity manually.

For invoicing this value overwrites the "DeliveredClicks/AIs" delivered by the AdServer and the Delivered Clicks/AIs manual.

For more information about the hierarchy for financing take a look below.

ADvendio__Month__c

Month

Month, to which the delivery data refer.

ADvendio__PrincipalProvisionN2__c

Principal Provision (N2)

(deprecated)

ADvendio__PrincipalProvisionN3__c

Principal Provision (N3)

(deprecated)

ADvendio__ProratedInvoiceQuantity__c

Prorated Invoice Quantity

Displays the Invoice Quantity per site.

ADvendio__ProvisionSalesHouseN2__c

Provision Sales House (N2) (Monthly)

(deprecated)

ADvendio__ProvisionSalesHouseN3__c

Provision Sales House (N3) (Monthly)

(deprecated)

ADvendio__RevenueSchedule__c

Revenue Schedule

Reference to Revenue Schedule.

ADvendio__RevenueScheduleDaily__c

Revenue Schedule Daily

Reference to Revenue Schedule Daily.

ADvendio__Type__c

Type

Type of the delivery data refer.

ADvendio__UniqueKey__c

Unique Key

The Unique Key is delivered by the AdServer-Gateway to assign and update the delivered data right. It is important for the calculation based on the delivery data. Please do not change it.

ADvendio__UnitName__c

Unit Name

Name of AdServer-ID, to which the delivery data refer.

ADvendio__VideoMetric__cVideo MetricThis value will be filled automatically by a script. It displays the delivered video metrics (e.g. completed views for CPCV products at DFP)
ADvendio__VideoMetricManual__cVideo Metric (manual)This field can be used to manually override the delivered Video Metrics.

ADvendio__ViewedAIs__c

Viewed AIs

This field will be automatically filled by a script. It displays the delivered viewed ad impressions of the assigned campaign item.

ADvendio__ViewedAIsManual__c

Viewed AIs (manual)

Enter the Viewed AIs manually.

For invoicing this Value overwrites "Viewed AIs" if there is no entry for invoice quantity.

For more information about the hierarchy for financing please take a look below.

Hierarchy of field "Invoice Quantity" in Object Revenue Schedule


The fields Invoice Quantity (manual), Delivered AI (manual), Delivered Clicks (manual) and Viewed AIs (manual) can be filled with manually entered delivery data. If so, these values will be used for invoicing process. To override the Delivery Data please use the 4.13 Manual Delivery Data function.

  • When the field from the 1st column is empty → the listed field from second column will be used for invoicing process. 
  • When the field from second column is empty → the listed field from third column will be used for invoicing process.


Billing Category

1st

2nd

3rd

CPM

Invoice Quantity (manual)

Delivered AIs (manual)

Delivered Impressions

VCPM

Invoice Quantity (manual)

Viewed AIs (manual)

Viewed AIs

CPC

Invoice Quantity (manual)

Delivered Clicks (manual)

Delivered Clicks

CPD*

Quantity--
CPW*Quantity--
CPMo*Quantity--
CPY* Quantity--
Fixed Price*Quantity--



*For CPD, CPW, CPMo, CPY and FixedPrice the field Quantity will be used for the invoicing process only. We recommend you to set the Linear Distribution (Campaign Item) to "true" and not to use the delivery data.