5.3.4 Delivery Data Fields
Here you find the information for 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 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__c | Accumulated 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__c | Video Metric | This value will be filled automatically by a script. It displays the delivered video metrics (e.g. completed views for CPCV products at Google AdManager) |
ADvendio__VideoMetricManual__c | Video 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 the second column will be used for invoicing process.
When the field from the second column is empty → the listed field from the 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.