Key figures system in Mydas - Glossary

The key figure glossary presents the essential key figures for marketing with the help of Mydas. It is intended to provide a common understanding of the numerical framework of Cataneo GmbH and in this way ensure smooth communication with the clients of Cataneo.

In the following, all key figures are defined and the relationships between them are presented.

Definition of terminology

Advertising space (Break)

The advertising space/break is the framework in which booking elements (see below) can be booked. The break becomes calculable using units such as seconds, frames, or pieces.

Booking element

The term booking element designates the individually bookable advertising element, e.g. the spot within an advertising frame (break). The booking element uses the capacity of the break, i.e. the capacity of the break is influenced by the sum of the booking elements.

Capacity key figures

Potential

The potential is the sum of the values of all created breaks.

 

Potential = Σ (pw *  ew)

w: break
pw: price of the advertising space
ew: number of advertising spaces

 

Example

Potential advertising frame
= planned length of the advertising space [sec.] / 30 [sec.] * 30 second price [EUR]  
= 360 / 30 *  2100  = 25200 [EUR]

Potential sponsorship
= price indicative + price abdicative + price reminder = 3600 [EUR]

Client revenue key figures

All revenue key figures are defined at the order level.

MG3

The MediaGross 3 is the price according to the price list without surcharges or discounts.

 

MG3 = list price

 

Example

MG3 = list price = 2700€

 

MG2

The MG2 is the MG3 including potential surcharges or discounts. This price also reflects a possible disproportionate price.

 

MG2 = MG1 +/- surcharges or discounts

MG2 = Σ (pbb *  ebb)

b: booking element
pbb: price of the used booking element
ebb: number of used booking elements

 

Example

A spot is 20 seconds long. The sales house has a disproportionality factor of 20 percent surcharge.

MG3 = 20 * 100€ = 2000€
MG2 = 2000€ * 1,20 = 2400€

 

Compensation

Compensation is an unpaid booking element.  Definition is done by the mediagross-flag = false in the order type. The FOC is only greater than 0 € in MG2 and MG3.

 

Free = MG1 * FOC rate (always 100%)

 

MG1

MG1 is the value of all paid booking elements. Definition is done by the mediagross-flag = true in the order type.

 

MG1 = Σ (pvb * evb)

b: booking element
pvb: price of the paid booking element
evb: number of the booking elements paid

 

Order / price list discount

An order / price list discount is a monetary discount on the MG1 granted to the customer. This is granted as a percentage.

There are two types of order / price list discounts: standard discounts and suborder cash discounts.

The standard cash discount is calculated on the basis of a client's gross sales across all discount-creating orders. There is also the option of storing a special discount in the system. This is also shown in the price list discount.

The suborder cash discount applies to individual suborders. The suborder discount is deducted before the order / price list discount.

 

Order / price list discount = Σ standard discount + Σ special discount

Special discount (order discount) = MG1 (order-related) * discount rate of the order

Standard discount = (MG1  special discount) * price list discount

 

MN1

MN1 is the amount that is actually billed to the customer.

 

MN1 = MG1 - order / price list discount

 

Agency commission

The agency commission is the percentage of MN1 that the media agency keeps as remuneration.

 

Agency commission = MN1 * agency commission rate

 

MN2

MN2 is the MN1 reduced by the agency commission rate.

 

MN2 = MN1 - agency commission

 

Early payment discount / Allowance

Percentage discount on the MN2, which is granted when paid within a certain period.

 

Cash discount = MN2 * cash discount rate

 

Value added tax (VAT)

VAT = MN2 * VAT rate

 

MN3

MN3 is the actual cash inflow from the client to the broadcaster.

 

MN3 = MN2 - Cash discount

 

Sales house commission

The sales house commission is the remuneration that the sales house receives from the broadcaster.

 

Sales house commission = (MN1 - cash discount amount) * commission rate

Cash discount amount see point 4.9.2

 

MN4 Broadcaster net

The MN4 broadcaster net is the remuneration that remains with the broadcaster after deducting the sales house commission.

 

MN4 broadcaster net = MN3 - sales house commission

 

Presentation of the correct revenue key figures system

 

Profitability key figures

Time utilization

The time utilization is the relation of the occupied units of a break to the originally planned units.

There are two utilization types: booked utilization and paid utilization. The booked utilization includes all booked booking elements. The paid utilization, on the contrary, only takes into account the paid elements and therefore no compensation.

 

Booked utilization = eb / ep

Paid utilization = ev / ep

ep: Number of planned advertising spaces
eb: Number of booked advertising spaces
ev: Number of paid advertising spaces

 

Monetary utilization  

The monetary utilization is the relation of the value of the occupied units of a break to the value of the planned units.

There are two utilization types: booked utilization and paid utilization. The booked utilization includes all booked booking elements. The paid utilization, on the contrary, only takes into account the elements actually paid and therefore no compensation.

Surcharges and discounts are not taken into account in the calculation of monetary utilization.

 

Booked utilization = eb * pb/ ep * pp

Paid utilization = ev * pv / ep* pp

pp: Price of the planned advertising spaces
pb: Price of the booked advertising spaces
pv: Price of the paid advertising spaces