5.3.5 Revenue Schedule / Revenue Schedule Daily Data Fields

Accumulated Delivery Till Now

ADvendio__AccumulatedDeliveryTillNow__c

Number(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.

Amount

ADvendio__Amount__c

Currency(16, 2)

This value will be filled automatically by a script. It displays the amount of the of the assigned campaign item.

Amount net/net

ADvendio__Amount_net_net__c

Currency(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 Item

ADvendio__Campaign_Item__c

Master-Detail(Campaign Item)

The connection to the campaign item will be assigned automatically when a new campaign item is created.

Days

ADvendio__Days__c

Number(18, 0)

This field shows the number of days of the current month (RS) / day (RSD).

Delivered AIs

ADvendio__Delivered_AIs__c

Number(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__c

Number(18, 0)

This value will be filled automatically by a script when using a 3rd Party Reporting System like Ad-Juster. It displays the delivered AIs from a external Source of the assigned campaign item.

Delivered AIs (manual)

ADvendio__DeliveredAIsManual__c

Number(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 Clicks

ADvendio__Delivered_Clicks__c

Number(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__c

Number(18, 0)

This value will be filled automatically by a script when using a 3rd Party Reporting System like Ad-Juster. It displays the delivered Clicks from a external Source of the assigned campaign item.

Delivered Clicks (manual)

ADvendio__DeliveredClicksManual__c

Number(18, 0)

This field can be used to correct the Delivered Clicks manually.

End Date

ADvendio__EndDate__c

Formula (Date) 

This field displays the end date of the month.

Gross amount (RS)

ADvendio__Gross_amount_RS__c

Formula (Currency) 

This field displays the Gross amount.

Invoice Amount (B1)

ADvendio__InvoiceAmountB1__c

Formula (Currency) 

This field displays the Invoice Amount (B1).

Invoice Amount (B2)

ADvendio__InvoiceAmountB2__c

Formula (Currency) 

This field displays the Invoice Amount (B2).

Invoice Amount (B3)

ADvendio__InvoiceAmountB3__c

Formula (Currency) 

This field displays the Invoice Amount (B3).

Invoice Amount (N1)

ADvendio__InvoiceAmountN1__c

Formula (Currency) 

This field displays the Invoice Amount (N1).

Invoice Amount (N2)

ADvendio__InvoiceAmountN2__c

Formula (Currency) 

This field displays the Invoice Amount (N2).

Invoice Amount (N3)

ADvendio__InvoiceAmountN3__c

Formula (Currency) 

This field displays the Invoice Amount (N3).

Invoice Amount Forecast

ADvendio__InvoiceAmountForecast__c

Formula (Currency) 

This field calculates the invoice amount forecast depending on linear distribution, start of the campaign item and month.

Invoice Quantity (manual)

ADvendio__InvoiceQuantityManual__c

Number(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__c

Formula (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 Forecast

ADvendio__InvoiceQuantityForecast__c

Formula (Number) 

This field calculates the invoice quantity forecast depending on linear distribution, start of the campaign item and month.

Month

ADvendio__Month__c

Date

This value will be filled automatically by a script. It displays the month in which the revenue was made.

Quantity Manual (Formula)

ADvendio__QuantityManualFormula__c

Formula (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 Date

ADvendio__StartDate__c

Formula (Date) 

This field displays the start date of the month.

UniqueKey

ADvendio__UniqueKey__c

Text(255) (External ID)

The UniqueKey will be filled automatically by a script.

Video Metric

ADvendio__VideoMetric__c

Number(18, 0)

Displays completed views (video views 100%) for CPCV items.

Video Metric (manual)

ADvendio__VideoMetricManual__c

Number(18, 0)

Overwrites the completed views (video views 100%) for CPCV items.

Video Metric (3rd Party)

ADvendio__VideoMetric3rdParty__c

Number(18, 0)

This value will be filled automatically by a script when using a 3rd Party Reporting System. It displays the 100% viewed video count from an external Source of the assigned campaign item.

Viewed AIs

ADvendio__ViewedAIs__c

Number(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__c

Number(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_c

Number(18, 0)

This value will be filled automatically by a script when using a 3rd Party Reporting System. It displays the viewed AIs from an external Source of the assigned campaign item.

Year

ADvendio__Year__c

Formula (Date)

This value will be filled automatically by a script. It displays the year in which the revenue was made.