Versions Compared

Old Version 21

changes.mady.by.user Former user

Saved on

compared with

New Version 22

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


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
32.1    x (1 + Sales Price Surcharge %)
ADvendio__SurchargeSalesPricePct__cVersion 2.106 and up - Percentage gets applied first!
42.2    + CPM / Sales Price Surcharge
ADvendio__SurchargeSalesPrice__cMight be used to set a premium for targeting e.g. country, region, city
53x Quantity


64x Frequency


75= Gross Amount (B3)ADvendio__Gross_amount_B3__cADvendio__Amount_B3__c
86x (1 + Surcharge B2 Abs. %)
ADvendio__SurchargeB3__cPercentage gets applied first!
97+ Surcharge B3 Abs.

ADvendio__SurchargeB3Abs__c



108= Gross Amount (B2)ADvendio__Gross_amount_B2__cADvendio__Amount_B2__c
11

9

x (1 + Surcharge B2  %)
ADvendio__SurchargeB2__cPercentage gets applied first!
1210+ Surcharge B2 Abs.

ADvendio__SurchargeB2Abs__c



1311= Gross Amount (B1)ADvendio__Gross_amount__cADvendio__Amount__c
1412- Quantity Discount Abs. Custom
ADvendio__RateDiscount1AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount1Abs__c which is a automatically calculating the absolute amount for you. 

1513- Customer Discount Abs. Custom
ADvendio__RateDiscount2AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount2Abs__c which is a automatically calculating the absolute amount for you. 

1614- Agency Discount Abs. Custom
ADvendio__RateDiscount3AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount3Abs__c which is a automatically calculating the absolute amount for you.

1715- Special Discount Abs. Custom
ADvendio__RateDiscount4AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount4Abs__c which is a automatically calculating the absolute amount for you. 

1816

x (1 - Quantity Discount (%))

ADvendio__Rate_Discount_1__cADvendio__Rate_Discount_1__c
1917

x (1 - Customer Discount (%))

ADvendio__Rate_Discount_2__cADvendio__Rate_Discount_2__c
2018

x (1 - Agency Discount (%))

ADvendio__Rate_Discount_3__cADvendio__Rate_Discount_3__c
2119

x (1 -  Special Discount (%))

ADvendio__Rate_Discount_4__cADvendio__Rate_Discount_4__c
2220= Customer Net (N1)ADvendio__Discounted_Amount__cADvendio__Amount_net__c
2321x (1 - Agency Commission (%))
ADvendio__AgencyEarnings__c/
ADvendio__Agency_Commission__c
  • AE will only be part of calculation if AE checkbox is set to TRUE
  • You can either use the picklist or the number field to enter a AE%, the number field always wins if both are filled
  • The Media Configuration automatically sets AE Checkbox, if the Media Campaign has an Agency
2422= Agency Net (N2)ADvendio__Amount_net_net__cADvendio__Amount_net_net__c
2523x (1- Third Party Commission (%))ADvendio__Third_party_commission__cADvendio__ThirdPartyCommissionCustom__c
  • TPC will only be shown if the checkbox "show third party commissioning" is TRUE
  • TPC is always part of item calculation (Amount N3) even if the checkbox is false
2624= Amount Net3 (N3)ADvendio__Amount_net3__cADvendio__Amount_net3__c
2725(+ Non Media Costs)


2826= Taxable Amount (total)ADvendio__TaxableAmountTotal__c
You can either use Agency Net (N2) or Amount Net3 (N3) as taxable amount, depending on the configuration.

...