4.16.5 Monitor Commitments
Unit Count (Revenue Information)
Scheduled Apex Job
Please note that the revenue and unit count data is not shown immediately in the commitment conditions. An apex job has to be scheduled for the calculation and typically is running once a day. For further information ask your system administrator or read chapter 7.2.9 Setup Commitments.
Once you have created media campaigns which match the Commitment and Commitment Conditions ADvendio will calculate the actual revenue or unit count data for you. Do not manually edit these fields! Package headers will be ignored as the package components will be counted towards the conditions. Read more about the handling of packages here: 4.16.6 Packages in Commitments (version 2.96.3 and higher).
Overview of calculated fields
Field | Description | Record Type |
|---|---|---|
Total Unit count | Total amount of units of all campaign items which meet the relevant criteria of this rule. | Rebate in Kind, Rebate in Kind % |
Total Unit count applied | Counts all units for all campaign items where discounts with this condition were applied. | Rebate in Kind, Rebate in Kind % |
Total Revenue | Total amount of revenue of all campaign items which meet the relevant criteria of this rule. | Scaled Discount, Special Revenue Scale, Special Discount, Third Party Commission, Agency Earning |
Total Revenue applied | Total amount of revenue for all campaign items where discounts with this condition were applied. | Scaled Discount, Special Revenue Scale, Special Discount, Third Party Commission, Agency Earning |
Total Rebate in Kind units earned | For Rebate in Kind only, shows you the total amount of 'free' units already earned with this condtion. | Rebate in Kind, Rebate in Kind % |
Rebate in Kind units available | Shows you how many Rebate in Kind units are still available for the Advertiser/Agency to spend, considering the units earned by this condition and the unit count already spent | Rebate in Kind, Rebate in Kind % |
Total Revenue vs. Total Revenue applied
Here an example to explain what the "applied" field is for: If you set up a revenue goal 10.000 € and 20% discount then each matching campaign items would be counted towards the total revenue. But the total revenue applied will still be 0 € until you have reached your 10.000 € revenue goal. After you have passed the total revenue goal >10.000 €, the revenue of that matching item will be counted in total revenue applied.
Total Unit count vs. Total Unit count applied
Here an example to explain the different unit fields: If you set up a rebate in kind condition to give out 1 page for free when 3 have been bought all matching campaign items of sold pages would be counted towards the Total unit count. If the customer has bought 7 pages and already gotten one page for free the results would show the following:
Total Unit count = 7
Total Rebate in Kind units earned = 2
Total Unit count applied = 1
Rebate in Kind units available = 1 (Total Rebate in Kind units earned - Total Unit count applied)
Degree of Fulfillment
Starting with Version 2.87 we have added a field "Degree of Fulfillment" to the Commitment Condition. This you can add to your List views and reports to manage and monitor your commitments.
You will have this formula in every record and it is calculated the percentage. The maximum value is 100% which means if you overfulfill it will still be 100%.
For "ScaledDiscount":
Total Revenue divided by the amount you have entered in the Scaled Discount To field
For "RebateInKind" and "RebateInKindPercent":
Total Unit Count divided by the number of units you have entered in Base Quantity Rebate In Kind field
For "Third Party Commission":
Total Revenue divided by the amount you have entered in the Revenue Goal field.
For "SpecialDiscount" , "Agency Earning"
it will always be ZERO.
Warning
If you are using hierachical scaled discounts 4.16.7 Commitment Matching Criteria Hierarchy or packages where campaign items match two or more commitment conditions the total revenue will be calculated towards both commitment conditions. The same issue occurs if you have two similar conditions where one has made the package header matching relevant whereas the other doesn't. Both can then count towards your revenue count.
We recommend to avoid any of these "overlaps" when creating commitment.