Have you ever wondered how the net and gross values in ADvendio are calculated, here is a brief overview of how the different amount fields in your media campaign and campaign items are working together:
| Label | Field API Media Campaign | Field API Campaign Item | Comment | |
|---|---|---|---|---|
| 1 | List Price | |||
| 2 | = Sales Price | ADvendio__Sales_Price__c | = List Price if not manually changed | |
| 3 | x (1 + Sales Price Surcharge %) | ADvendio__SurchargeSalesPricePct__c | Version 2.106 and up - Percentage gets applied first! | |
| 4 | + CPM / Sales Price Surcharge | ADvendio__SurchargeSalesPrice__c | Might be used to set a premium for targeting e.g. country, region, city | |
| 5 | x Quantity | |||
| 6 | x Frequency | |||
| 7 | = Gross Amount (B3) | ADvendio__Gross_amount_B3__c | ADvendio__Amount_B3__c | |
| 8 | x (1 + Surcharge B2 Abs. %) | ADvendio__SurchargeB3__c | Percentage gets applied first! | |
| 9 | + Surcharge B3 Abs. | ADvendio__SurchargeB3Abs__c | ||
| 10 | = Gross Amount (B2) | ADvendio__Gross_amount_B2__c | ADvendio__Amount_B2__c | |
| 11 | x (1 + Surcharge B2 %) | ADvendio__SurchargeB2__c | Percentage gets applied first! | |
| 12 | + Surcharge B2 Abs. | ADvendio__SurchargeB2Abs__c | ||
| 13 | = Gross Amount (B1) | ADvendio__Gross_amount__c | ADvendio__Amount__c | |
| 14 | - Quantity Discount Abs. Custom | ADvendio__RateDiscount1AbsCustom__c | Version 2.105 and up Don't mix those up with ADvendio__RateDiscount1Abs__c which is a automatically calculating the absolute amount for you. | |
| 15 | - Customer Discount Abs. Custom | ADvendio__RateDiscount2AbsCustom__c | Version 2.105 and up Don't mix those up with ADvendio__RateDiscount2Abs__c which is a automatically calculating the absolute amount for you. | |
| 16 | - Agency Discount Abs. Custom | ADvendio__RateDiscount3AbsCustom__c | Version 2.105 and up Don't mix those up with ADvendio__RateDiscount3Abs__c which is a automatically calculating the absolute amount for you. | |
| 17 | - Special Discount Abs. Custom | ADvendio__RateDiscount4AbsCustom__c | Version 2.105 and up Don't mix those up with ADvendio__RateDiscount4Abs__c which is a automatically calculating the absolute amount for you. | |
| 18 | x (1 - Quantity Discount (%)) | ADvendio__Rate_Discount_1__c | ADvendio__Rate_Discount_1__c | |
| 19 | x (1 - Customer Discount (%)) | ADvendio__Rate_Discount_2__c | ADvendio__Rate_Discount_2__c | |
| 20 | x (1 - Agency Discount (%)) | ADvendio__Rate_Discount_3__c | ADvendio__Rate_Discount_3__c | |
| 21 | x (1 - Special Discount (%)) | ADvendio__Rate_Discount_4__c | ADvendio__Rate_Discount_4__c | |
| 22 | = Customer Net (N1) | ADvendio__Discounted_Amount__c | ADvendio__Amount_net__c | |
| 23 | x (1 - Agency Commission (%)) | ADvendio__AgencyEarnings__c/ ADvendio__Agency_Commission__c |
| |
| 24 | = Agency Net (N2) | ADvendio__Amount_net_net__c | ADvendio__Amount_net_net__c | |
| 25 | x (1- Third Party Commission (%)) | ADvendio__Third_party_commission__c | ADvendio__ThirdPartyCommissionCustom__c |
|
| 26 | = Amount Net3 (N3) | ADvendio__Amount_net3__c | ADvendio__Amount_net3__c | |
| 27 | (+ Non Media Costs) | |||
| 28 | = Taxable Amount (total) | ADvendio__TaxableAmountTotal__c | You can either use Agency Net (N2) or Amount Net3 (N3) as taxable amount, depending on the configuration. |