...
1.2.1. Net Amounts Examples
Customer Net (N1) - Agency earning or Agency Commission (AC)
Agency Net (N2) - Third-Party Commission
Agency Net (N3) (+ ProductCosts - not yet implemented )
1.3. Abbreviations Explained
Abs: Absolute Amount - Represents the specific value without considering any percentage or relative changes
AE: Agency Earnings - Refers to the earnings or commission received by the agency involved in the campaign
AC: Agency Commission - Represents the commission amount paid to the agency for their services
TPC: Third Party Commission - Indicates the commission amount paid to a third-party entity involved in the campaign
PCT: Percentage - Represents a value expressed as a proportion of the whole, often shown as a percentage
To summarize:
B1, B2, and B3 represent gross amounts.
N1, N2, and N3 represent net amounts.
The different fields and calculations ensure accurate tracking and calculation of gross and net values in ADvendio:
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 B3 %) | 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 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 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/ |
| |
| 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. |
...