Use * syntax for faster search

Table of Contents



Overview 

Actualization is the process where actual delivery metrics of a campaign are received from a Supplier or a third party and compared to the original schedule. Once these delivery metrics are reviewed by the Agency, the schedule is actualized, and that information is shared with finance for approved amounts to be paid to Suppliers.


Actualization Terms and Concepts

This section contains information about terms and concepts related to actualization in OneStrata.

Types of Actualization

In OneStrata, there are two types of actualization:

  • Standard actualization
  • Margin actualization
Actualization TypeDescription

Standard actualization

The actualization of committed standard schedule lines, which are media and non-media lines in the Schedule Grid that have been committed and that have a Cost Method value of Standard.

For more information on the Standard Cost Method option, see Cost Methods.

Margin actualization

The Margin workflow is a gated feature and not enabled by default. If the Margin workflow is not enabled, the Margin Actualization grid is not available.

To enable this feature, contact your OneStrata representative.

The actualization of committed margin schedule lines, which are media and non-media lines in the Schedule Grid that have been committed and that have a Cost Method value of Margin.

For more information on the Margin Cost Method option, see Cost Methods.

Types of Delivery Balance Roll

When actualizing, there are four ways that any under- or over-delivery balance can be distributed over future months:

Rollover TypeDescriptionVisualization
None

The under- or over-delivery balance is not distributed.

Instead, the values on the original Schedule grid line are updated.


ProportionallyThe under- or over-delivery balance is evenly distributed over the remaining months of the campaign.

Next MonthThe entire under- or over-delivery balance is carried over to the next month of the campaign.

Last MonthThe entire under- or over-delivery balance is carried over to the final month of the campaign.

Types of Actual Value Sources

When a Cost Line is actualized, the values in the actual columns are sent to the external financial system:

Cost Line Type / Actualization GridActual Columns
Standard / Standard Actualization grid
  • Actual Cost for Period
  • Actual Rate
  • Actual Units
Margin / Margin Actualization grid
  • Vendor Net Cost (VC)
  • Margin %
  • Client Net Cost (VC)
  • Actual Units

The values in the actual columns can be entered manually or copied from other columns on the Standard Actualization or Margin Actualization grid:

Actual Source TypeStandard Actualization GridMargin Actualization Grid

Manual

The actual values are manually changed by the user.


The Actual Cost for PeriodActual Rate, and Actual Units columns are linked, and their values are triangulated off each other.

For more information, see Apply Standard Actualization Triangulation.

The actual values are manually changed by the user.


There are two ways to manually adjust actual values:

  • Update Vendor Net Cost (VC)Margin %, or Client Net Cost (VC): These three columns are linked, and their values are triangulated off each other.

    For more information, see Apply Margin Actualization Triangulation and the Margin Percentage Triangulation set.

  • Update actual delivered units: Unlock and manually update the Actual Units column.

    For more information, see Apply Margin Actualization Triangulation and the Margin Actual Units Triangulation set.

Committed

The actual values are copied from the Cost Line's values on the Schedule grid, for the selected billing period(s):

N/A

Site

The actual values are copied from the Site columns:

  • Actual Cost for Period: Updated to match the value of Site Cost.

  • Actual Units: Updated to match the value of Site Units.

  • Actual Rate: Calculated according to the following formula:

    Actual Rate = Actual Cost / Actual Units


The Site Cost and Site Units columns are populated by data retrieved from the Site source, if any.

The possible Site sources:

If a Cost Line has delivery data from multiple Site sources, the Site Cost and Site Units columns display the Vendor Inbox values, not the external integration provider values.

N/A

3rd Party

The actual values are copied from the 3rd Party columns:

  • Actual Cost for Period: Updated to match the value of 3rd Party Cost.

  • Actual Units: Updated to match the value of 3rd Party Units.

  • Actual Rate: Calculated according to the following formula:

    Actual Rate = Actual Cost / Actual Units


The 3rd Party Cost and 3rd Party Units columns are populated by data retrieved from the Ad Server provider, if any.

If the two conditions below are met, delivery data is automatically retrieved from the Ad Server provider once per day, at around midnight local time:

N/A

Media

The Media source is only available for Assigned fees.

The actual values are copied from the Calculated columns:

  • Actual Cost for Period: Updated to match the value of Calculated Fee Cost.

  • Actual Units: Updated to match the value of Fee Calculated Units.

  • Actual Rate: Calculated according to the following formula:

    Actual Rate = Actual Cost / Actual Units


The cost and units of an Assigned fee depend on the cost and units of the media Cost Line that the fee is assigned to.

Therefore, the media Cost Line that the fee is assigned to should be actualized before the Assigned fee is actualized.

For more information, see Actualize an Assigned Fee Cost Line.

The actual values are copied from the Calculated columns.

There are two options:

  • Vendor Net Cost (VC): Updated to match the value of Fee Calculated Vendor Cost.

  • Client Net Cost (VC): Updated to match the value of Fee Calculated Client Cost.

  • Margin %: Calculated according to the following formula:

    Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost

  • Actual Units: Unchanged

For more information, see Margin Percentage Triangulation.

OR

  • Actual Units: Updated to match the value of Fee Calculated Units.

  • Vendor Net Cost (VC): Calculated according to the following formula:

    Vendor Net Cost = Vendor Net Rate x (Actual Units / Rate Divider)

  • Client Net Cost (VC): Calculated according to the following formula:

    Client Net Cost = Client Net Rate x (Actual Units / Rate Divider)

  • Margin %: Calculated according to the following formula:

    Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost

For more information, see Margin Actual Units Triangulation.


The costs and units of an Assigned fee depend on the costs and units of the media Cost Line that the fee is assigned to.

Therefore, the media Cost Line that the fee is assigned to should be actualized before the Assigned fee is actualized.

For more information, see Actualize an Assigned Fee Cost Line.

Types of Actualization Triangulation

There are three sets of triangulation rules related to actualization:

Actualization Triangulation SetDescription
Standard Actualization Triangulation

The relationship between the Actual Cost for Period, Actual Rate, and Actual Units values, on the Standard Actualization grid

Margin Percentage Triangulation

The relationship between the Vendor Net Cost, Margin Percentage, and Client Net Cost values, on the Margin Actualization grid

Margin Actual Units Triangulation

The relationships between the Vendor Net Rate, Actual Units, and Vendor Net Cost values and between the Client Net Rate, Actual Units, and Client Net Cost values, on the Margin Actualization grid

For more information, see the following pages:

  • No labels
Provide feedback on this article
You are evaluating Refined.