5.3.5 Revenue Schedule / Revenue Schedule Daily Data Fields

Here you find information about all revenue schedule fields. You should not have to edit any of these fields manually. If you like to overwrite AdServer data please use the 4.13 Manual Delivery Data function. This table is to explain the function of ADvendio, not the handling for the end user.

Revenue Schedule Object Fields

Field LabelAPI NameData TypeHelp Text
Accumulated Delivery Till NowADvendio__AccumulatedDeliveryTillNow__cNumber(18, 0)This value will be filled automatically by ADvendio Trigger. It sums up the total Delivery of the Campaign Item for this and all prior Revenue Schedules.
AmountADvendio__Amount__cCurrency(16, 2)This value will be filled automatically by a script. It displays the amount of the of the assigned campaign item.
Amount net/netADvendio__Amount_net_net__cCurrency(16, 2)This value will be filled automatically by a script. It displays the agency net (N2) of the of the assigned campaign item.
Campaign ItemADvendio__Campaign_Item__cMaster-Detail(Campaign Item)The connection to the campaign item will be assigned automatically when a new campaign item is created.
DaysADvendio__Days__cNumber(18, 0)This field shows the number of days of the current month (RS) / day (RSD).
Delivered AIsADvendio__Delivered_AIs__cNumber(18, 0)This value will be filled automatically by a script. It displays the delivered AIs of the assigned campaign item.
Delivered AIs (3rd Party)ADvendio__DeliveredAIs3rdParty__cNumber(18, 0)This value will be filled automatically by a script when using a 3rd Party Reporting System like Ad-Juster, Moat etc. It displays the delivered AIs from a external Source of the assigned campaign item.
Delivered AIs (manual)ADvendio__DeliveredAIsManual__cNumber(18, 0)This field can be used to override the Delivered AIs manually. Pls refer to the table hierarchy here 5.3.4 Delivery Data Fields.
Delivered ClicksADvendio__Delivered_Clicks__cNumber(18, 0)This value will be filled automatically by a script. It displays the delivered clicks of the assigned campaign item.
Delivered Clicks (3rd Party)ADvendio__DeliveredClicks3rdParty__cNumber(18, 0)This value will be filled automatically by a script when using a 3rd Party Reporting System like Ad-Juster, Moat etc. It displays the delivered Clicks from a external Source of the assigned campaign item.
Delivered Clicks (manual)ADvendio__DeliveredClicksManual__cNumber(18, 0)This field can be used to correct the Delivered Clicks manually.
End DateADvendio__EndDate__cFormula (Date) This field displays the end date of the month.
Gross amount (RS)ADvendio__Gross_amount_RS__cFormula (Currency) This field displays the Gross amount.
Invoice Amount (B1)ADvendio__InvoiceAmountB1__cFormula (Currency) This field displays the Invoice Amount (B1).
Invoice Amount (B2)ADvendio__InvoiceAmountB2__cFormula (Currency) This field displays the Invoice Amount (B2).
Invoice Amount (B3)ADvendio__InvoiceAmountB3__cFormula (Currency) This field displays the Invoice Amount (B3).
Invoice Amount (N1)ADvendio__InvoiceAmountN1__cFormula (Currency) This field displays the Invoice Amount (N1).
Invoice Amount (N2)ADvendio__InvoiceAmountN2__cFormula (Currency) This field displays the Invoice Amount (N2).
Invoice Amount (N3)ADvendio__InvoiceAmountN3__cFormula (Currency) This field displays the Invoice Amount (N3).
Invoice Amount ForecastADvendio__InvoiceAmountForecast__cFormula (Currency) This field calculates the invoice amount forecast depending on linear distribution, start of the campaign item and month.
Invoice Quantity (manual)ADvendio__InvoiceQuantityManual__cNumber(18, 0)This field can be used to overwrite the Invoice Quantity. Pls refer to the table hierarchy here 5.3.4 Delivery Data Fields.
Invoice Quantity (RS)ADvendio__InvoiceQuantity__cFormula (Number) 

Using Linear Distribution the quantity is distributed by the number of days. Otherwise, manual fields can be used to override the ad server values, manual fields are capped. If no manual fields are used, the numbers from the ad servers are used and also capped.

Where items are linearly distributed, the Invoice Quantity (RS)  is rounded to be a whole number. Where non-linear, the delivery data/activities dictate the Invoice Quantity (RS), which may mean having decimal places. 

Invoice Quantity ForecastADvendio__InvoiceQuantityForecast__cFormula (Number) This field calculates the invoice quantity forecast depending on linear distribution, start of the campaign item and month.
MonthADvendio__Month__cDateThis value will be filled automatically by a script. It displays the month in which the revenue was made.
Quantity Manual (Formula)ADvendio__QuantityManualFormula__cFormula (Number) This field is used to check, if Invoice Quantity (manual) is blank. If this is the case, Delivered AIs (manual), Delivered Clicks (manual) or Viewed AIs (manual) are used. Pls refer to the table hierarchy here 5.3.4 Delivery Data Fields.
Start DateADvendio__StartDate__cFormula (Date) This field displays the start date of the month.
UniqueKeyADvendio__UniqueKey__cText(255) (External ID)The UniqueKey will be filled automatically by a script.
Video MetricADvendio__VideoMetric__cNumber(18, 0)Displays completed views (video views 100%) for CPCV items.
Video Metric (manual)ADvendio__VideoMetricManual__cNumber(18, 0)Overwrites the completed views (video views 100%) for CPCV items.
Video Metric (3rd Party)ADvendio__VideoMetric3rdParty__cNumber(18, 0)This value will be filled automatically by a script when using a 3rd Party Reporting System like Moat etc. It displays the 100% viewed video count from an external Source of the assigned campaign item.
Viewed AIsADvendio__ViewedAIs__cNumber(18, 0)This field will be automatically filled by a script. It displays the delivered viewed ad impressions of the assigned campaign item.
Viewed AIs (manual)ADvendio__ViewedAIsManual__cNumber(18, 0)Enter the Viewed AIs manually to override the delivered viewed ad impressions. Pls refer to the table hierarchy here 5.3.4 Delivery Data Fields.
Viewed AIs (3rd Party)ADvendio_ViewedAIs3rdParty_cNumber(18, 0)This value will be filled automatically by a script when using a 3rd Party Reporting System like Moat etc. It displays the viewed AIs from an external Source of the assigned campaign item.
YearADvendio__Year__cFormula (Date)This value will be filled automatically by a script. It displays the year in which the revenue was made.