...
| Column No | Value | Comment | Type |
|---|---|---|---|
| 1 | PositionNumber__c + PositionNumberAppendix__c | static | |
| 2 | Site__r.External_Name__c | Alternatively the OR
OR can be used. | static |
| 3 | Placement__r.External_Name__c OR Placement__r.Name | static | |
| 4 | Ad_Type__r.External_Name__c OR Ad_Type__r.Name | static | |
| 4.1 | Ad_Price__r.RateCriterion__c | additional | |
| 5 | from_Date__c | static | |
| 6 | until_Date__c | static | |
| 7 | Sales_Price__c | static | |
| 7.1 | SurchargeSalesPrice__c | additional | |
| 8 | Billing_category__c | static | |
| 9 | Amount__c - Amount_B3__c | additional | |
| 10 | Quantity__c | static | |
| 10.1 | Guaranteed_AI__c | additional | |
| 11 | Amount__c | static | |
| 12* | Rate_Discount_1__c | additional | |
| 13* | Rate_Discount_2__c | additional | |
| 14* | Rate_Discount_3__c | additional | |
| 15* | Rate_Discount_4__c | additional | |
| 12 + 13 + 14 + 15 | TotalDiscountAbs__c | additional instead of line 13, 14 ,15, 16 | |
| 16 | Amount_net__c | N1 | static |
| 17 | Agency_Commission__c | additional | |
| 18 | Amount_net_net__c | N2 | additional |
| 19 | eCPM__c | This column will only show where sales price per item ≠ CPM CPM (N2) You can change the label if needed. | additional |
| - | eCPC__c | This column will only show where sales price per item ≠ CPC CPC (N2) You can change the label if needed. | |
| 20 | Third_party_commission__c | TPC | additional |
| 21 | Amount_net3__c | N3 | additional |
...
| Info |
|---|
* Only CPM relevant values included means: That the Total for the Booked Quantity is displaying the sum of all CPM items. The Total of the eCPM / CPM (N2) is calculated like this:
|
