Challenge

How to Explore how Campaign Item Surcharges, Discounts, Agency Earnings, and Commissions affect the financial aspects of your media campaigns in ADvendio?

Solution

Discover Campaign Item Surcharges, Discounts, Agency Earnings, and Commissions functionality and impact to gain a deeper understanding of the net and gross values calculation process.

For a more detailed overview of net and gross values take a look at this page 4.2.6.2 Amount Calculation and Discounts.

1. Surcharges

Each Campaign Item can add up to three surcharges to your list price:

...

You can use Surcharge Sales Price and Surcharge Sales Price % in combination. The same applies to B2 and B3 surcharges. In this case, the percentage will be calculated into the total amount first. Then the absolute value will be added.

Percentage

...

2. Discounts

For each campaign item, you have the option to set up to four discounts (if enabled by your administrator):

...

You can choose how to input your discount values, either as an absolute amount or a percentage.

Percentage

...

Absolute Discounts

Version 2.105 and up

Make sure to not mix up the fields with the automatically calculated abs values for your percentage. 

...

3. Agency Earnings / Agency Commission

ADvendio offers you two fields for your Agency Earnings. The Agency Commission is a picklist field and the Agency Earnings is a percentage field. 

• AE will only be part of the calculation if the AC checkbox is set to TRUE

• You can either use the picklist or the number field to enter an AE%, the number field always wins if both are filled

• The Media Configuration automatically sets AC Checkbox, if the Media Campaign has an Agency

4. Third Party Commission

Each Campaign item allows you to enter a Third Party commission which can be different from the Media Campaigns Third Party Commission. Similar to the discounts the commission values also get inherited to all campaign line items but can be overwritten. Alternatively, the Third Party Commissions can be automatically set if you are using Commitments. 

...

• TPC will only be shown if the checkbox "show third party commissioning" on the Media Campaign is TRUE

• TPC is always part of item calculation (Amount N3) even if the checkbox is false

TPC Amount

_{As of version  2.117, N3 used in this formula field is rounded to two decimal places}

...