Versions Compared

Version Old Version 1 New Version Current
Changes made by

Anne Krieg

Phu Nguyen (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

Only a few details are required to create a new placement option:

Field (with example)

Explanation

Image Modified

The availability (lookup relationship) refers to this placement

Image Modified

The availability (lookup relationship) refers to this publication

Image Modified

The availability (lookup relationship) refers to this issue

Image Modified

Physical limit, number of allowed prints
In the case of digital placements, the maximum number of ad impressions must be specified here (if necessary).

Image Modified

Number of permitted bookings, this may differ from the print limit.
In the case of digital placements, the maximum number of ad impressions must be specified here if necessary.

Most of the other field values on the availability record are automatically created and updated using lookup and calculation fields, providing a general picture of initial quantity, reservations, bookings and remaining availability.

...

Note

The Ad Position Placement object has the central function in the MediaVelox AdSales process. It has a master-detail relationship to the two detail objects Booking (f42_dispo__DispoBook__c) and Blocked Position (f42_dispo__DispoBlockedItems__c) and brings together all current valid Placement availability in the field Availability (f42_dispo__countAvailable__c)

API Name

Label EN

f42_dispo__AdPosCatalog__c *

Ad Position Placement

Name

Label EN

Typ

Type

Kommentar

Note

Name

Ad Position Placement Number

Auto Number

The name of the Ad Position Placement is determined generically as an auto number.

f42_dispo__isActive__c

Is Active

Checkbox

Only placement options marked as "active" are considered in the quotation process.

f42_dispo__f42_AdFormatName__c *

Ad Format

Formula (Text)

Determines the ad format of the affected placement using a formula.

f42_dispo__Issue__c *

Issue

Lookup(Issue)

Mandatory field. References the relationship to the corresponding issue.

f42_dispo__IssueName__c

Issue Name

Formula (Text)

Optional. Displays the name of the issue.

f42_dispo__IssuePubDate__c

Publication Date

Formula (Date)

Publication date of the mentioned issue, is determined via formula.

f42_dispo__AdPosition__c *

Ad Position

Lookup (Ad Position)

The availability is related to this placement / ad position.

f42_dispo__Publication__c

Publication

Lookup (Publication)

Mandatory field. References the relationship to the corresponding publication.

f42_dispo__countAvailable__c *

Availability

Formula (Number)

Formula that indicates the actual availability of the placement by deducting the booked, blocked positions, accepted and reserved bookings from the print limit.

Tip

Core statement of the formula: Physical limit of an availability - blocked positions in status reserved/posted - Booking entries in status reserved/posted.

  • For digital publications (time-perid-based on period time), availability is recorded via the reserved/booked/blocked volume within a Booking entry.

  • For print publications (date-based), only the number of Booking/block positions.

f42_dispo__bookingLimit__c *

Limit Booking

Number (10, 0)

Defines a limit for the number of possible bookings.

Tip

If no limit is specified, entering a very high number (e.g. 9999) is recommended in order the booking process in appero quote to be displayed correctly.

f42_dispo__physicalLimit__c

Limit Print

Number (10, 0)

Physical limit. The calculation of the remaining availability f42_dispo__countAvailable__c refers to this value.

Tip

The quotation process with appero quote Lightning currently refers to the print limit. The booking limit is ignored here. It is therefore recommended that you enter the same value for both fields.

f42_dispo__reservedCountRollup__c *

Sum Reserved

Roll-Up Summary (COUNT Booking)

Number of all reserved bookings (Booking entries with status “reserved”).

f42_dispo__confirmedCountRollup__c *

Sum Confirmed

Roll-Up Summary (COUNT Booking)

Number of all confirmed bookings (Booking entries with status “confirmed”).

f42_dispo__DispoBookSumVolumeReserved__c

Sum Reserved Volume

Roll-Up Summary (SUM Booking)

Refers to digital products that are booked over a certain term. Here, availability is not only reflected by the number of booking entries but also by volume (e.g. booked ad impressions, clicks, etc.)

The booking status is "reserved".

f42_dispo__DispoBookSumVolumeConfirmed__c

Sum Confirmed Volume

Roll-Up Summary (SUM Booking)

Refers to digital products that are booked over a certain term. Here, availability is not only reflected by the number of booking entries but also by volume (e.g. booked ad impressions, clicks, etc.)

The booking status is "confirmed".

f42_dispo__AmountBooked__c

Amount Booked

Roll-Up Summary (SUM Booking)

Specifies the net sales of confirmed bookings.

f42_dispo__AmountReserved__c

Amount Reserved

Roll-Up Summary (SUM Booking)

Indicates the expected turnover of the reserved bookings.

f42_dispo__sumMovableReserved__c

Sum movable reserved

Roll-Up Summary (COUNT Booking)

Number of all booking entries with status "reserved" that can be moved to another issue.

Tip

At the individual Booking (object f42_dispo__DispoBook__c), you have the option of manually marking a booking as "Movable", for example, if the customer is not committed to a particular issue.

f42_dispo__sumMovableBooked__c

Sum movable booked

Roll-Up Summary (COUNT Booking)

Number of all booking entries with status "reserved" that can be moved to another issue.

f42_dispo__blockedCount__c *

Sum Blocked Positions

Roll-Up Summary (COUNT Blocked Position)

Number of existing blocked positions with booking status "reserved". These are also deducted from the availability.

Tip

Blocked positions are generated if one booking blocks the booking of another placement, e.g. the booking of a 1/1 ad on the U4 prevents the booking of a 1/2 ad on the U4 of the same issue.

f42_dispo__blockedCountBooked__c

Sum Blocked Bookings

Roll-Up Summary (COUNT Blocked Position)

Number of existing blocked positions with booking status "confirmed". These are also deducted from the availability.

f42_dispo__blockedSumReserved__c

Volume of Block Positions Reserved

Roll-Up Summary (SUM Blocked Position)

Refers to digital products whose availability is also measured in volume.
Indicates the volume of blocked by reservations in relation to this availability.

f42_dispo__blockedSumBooked__c

Volume of Block Positions Booked

Roll-Up Summary (SUM Blocked Position)

Refers to digital products whose availability is also measured in volume.
Indicates the volume blocked by confirmed bookings in relation to this availability.

f42_dispo__Theme__c

Topic

Text (255)

Optional specification of a subject area

f42_dispo__Description__c

Description

Long Text Area(32000)

Optionally, a description can be entered here.

f42_dispo__PublicationName__c

Publ. Description

Formula (Text)

If required, this field gives the description of the publication the issue is assigned to.

f42_dispo__TransactionLimit__c

Transaction Limit

Number (18,0)

Regarding digital publications: With the transaction limit you can optionally restrict the bookable quantity to a value smaller than the actual availability.

f42_dispo__PreventOverbooking__c

Prevent Overbooking

Checkbox

Verhindert das Überbuchen der Verfügbarkeit bei digitalen Publikationen.

f42_dispo__AllowOverbooking__c

Allow Overbooking

Checkbox

Regarding digital publications: With the transaction limit you can optionally restrict the bookable quantity to a value smaller than the actual availability.

Note, the fields marked with * are included in the availability /wiki/spaces/OFB/pages/1708327327 check calculation in the quotation process.

...

For example, over the duration of the January issue of a digital magazine, I can reserve a subset of 30,000 AdImpressions from the maximum availability of 100,000 AdImpressions for a customer. In this case, of course, no 30,000 individual bookings are generated. Instead, a single booking with a volume of 30,000 AdImpressions. This value is then stored in the corresponding fields Sum Reserved Volume or Sum Confirmed Volume when the quote is marked as reserved or confirmed.

Related Topics

Availability check:/wiki/spaces/OFB/pages/1708327327Real-time query of available placements in the quotation process

...