Versions Compared

Old Version 16

changes.mady.by.user Former user

Saved on

compared with

New Version 17

changes.mady.by.user Nicole Jünger

Saved on

Key

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

...

The last row underneath all of your other items is a summary row which will show the total of all rows for each column.

Info

* Only CPM (N2) relevant values included means: That the Total for the Booked Quantity is displaying the sum of all CPM items

whereas the 

.

The Total of the

eCMP -

eCPM / CPM (N2

is calculated out of all CPM and FixPrice/CPD/CPW/CPMo campaign items. Requirement: If the guaranteed AIs > 0, we take the sum of the (Price Gross/Amount__c) and divide it by (the sum of the guaranteed AIs *1000).

) is calculated like this:

  • if there are only CPM items the values from the column are summed up
  • if there are CPM items mixed with other Billing Categories that have Guaranteed AIs the calculation will be:
    (N2 amounts of the CPM + N2 amounts of the Guaranteed AI items) / (quantity of CPM items + Guaranteed AIs of other items)