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, 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, 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 actual values (the values in the following columns) are sent to the external financial system:

Cost Line Type / Actualization GridActual Value 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 actual values can be entered manually or sourced externally:

Actual Value Source TypeDescriptionStandard Actualization GridMargin Actualization Grid

Manual

The cost/units/rate as entered by the user.

Enter actual cost/units/rate:

  • Actual Cost for Period: Entered by the user or triangulated.

  • Actual Units: Entered by the user or triangulated.

  • Actual Rate: Entered by the user or triangulated.

For more information, see Apply Standard Actualization Triangulation.


Option 1: Enter actual costs/margin

  • Actual Units: Locked by the user.

  • Vendor Net Cost (VC): Entered by the user or triangulated.

  • Client Net Cost (VC): Entered by the user or triangulated.

  • Margin %: Entered by the user or triangulated.

For more information, see Apply Margin Actualization Triangulation.


Option 2: Enter actual units

  • Actual Units: Entered by the user.

  • Vendor Net Cost (VC): Recalculated by the system.

  • Client Net Cost (VC): Recalculated by the system.

  • Margin %: Recalculated by the system.

For more information, see Apply Margin Actualization Triangulation.


Committed

The cost/units/rate committed on the media schedule.

Applying the Committed source has the following impacts on the actual value columns:

  • Actual Cost for Period: Updated/reverted to the committed vendor cost (the value of the Vendor Net Cost column in the Schedule or Billing Periods grid).

  • Actual Units: Updated/reverted to the committed number of units (the value of the Units column in the Schedule or Billing Periods grid).

  • Actual Rate: Updated/reverted to the committed vendor rate (the value of the Rate column in the Schedule or Billing Periods grid).

Applying the Committed source has the following impacts on the actual value columns:

  • Actual Units: Updated/reverted to the committed number of units (the value of the Units column in the Schedule or Billing Periods grid).

  • Vendor Net Cost (VC): Updated/reverted to the committed vendor cost (the value of the Vendor Net Cost (VC) column in the Schedule or Billing Periods grid).

  • Client Net Cost (VC): Updated/reverted to the committed client cost (the value of the Client Net Cost (VC) column in the Schedule or Billing Periods grid).

  • Margin %: Updated/reverted to the committed margin percentage (the value of the Margin Percentage column in the Schedule or Billing Periods grid).

Site

For Cost Lines linked to an external entity, the delivered cost/units as provided by the external integration provider.

Depending on the provider, only delivered costs, only delivered units, or delivered costs and units may be provided.

Possible Site sources:

  • Vendor Inbox: For Cost Lines sent to an in-system Order Partner.

  • FreeWheel DSP (DSP provider): For Cost Lines linked to a FreeWheel DSP campaign.

  • DV360 (DSP provider): For Cost Lines linked to a DV360 insertion order.

  • The Trade Desk (DSP provider): For Cost Lines linked to a campaign in The Trade Desk.

  • Google Ads (Search provider): For Cost Lines linked to a Google Ads campaign.

  • Meta (Social provider): For Cost Lines linked to a Meta campaign.

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

For data retrieval frequency, see Delivery Data.

Option 1a: Apply actual delivered units, recalculate cost based on committed rate

Applying the Site source has the following impacts on the actual value columns:

  • Actual Cost for Period: Recalculated by the system.

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

  • Actual Rate: Locked by the user.

Option 1b: Apply actual delivered units, recalculate rate based on committed cost

Applying the Site source has the following impacts on the actual value columns:

  • Actual Cost for Period: Locked by the user.

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

  • Actual Rate: Recalculated by the system.

Option 2: Apply actual delivered units and cost

Applying the Site source has the following impacts on the actual value columns:

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

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

  • Actual Rate: Locked by the user but recalculated by the system if needed.

Option 3a: Apply actual delivered costs, recalculate units based on committed rate

Applying the Site source has the following impacts on the actual value columns:

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

  • Actual Units: Recalculated by the system.

  • Actual Rate: Locked by the user.

Option 3b: Apply actual delivered costs, recalculate rate based on committed units

Applying the Site source has the following impacts on the actual value columns:

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

  • Actual Units: Locked by the user.

  • Actual Rate: Recalculated by the system.



Option 1: Apply actual delivered units, recalculate vendor cost based on committed vendor rate, recalculate client cost based on committed margin percentage.

Applying the Site source has the following impacts on the actual value columns:

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

  • Vendor Net Cost (VC): Recalculated by the system (Vendor Net Cost = Actual Units * Rate).

  • Client Net Cost (VC): Recalculated by the system according to Margin Percentage Triangulation.

  • Margin %: Unchanged.

Option 2: Apply actual delivered units and vendor cost, recalculate client cost based on committed margin percentage.

Applying the Site source has the following impacts on the actual value columns:

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

  • Vendor Net Cost (VC): Updated to match the value of the Site Cost column.

  • Client Net Cost (VC): Recalculated by the system according to Margin Percentage Triangulation.

  • Margin %: Unchanged.

Option 3: Apply actual delivered vendor cost, recalculate units based on committed vendor rate, recalculate client cost based on committed margin percentage.

Applying the Site source has the following impacts on the actual value columns:

  • Actual Units: Recalculated by the system (Actual Units = Vendor Net Cost / Rate)

  • Vendor Net Cost (VC): Updated to match the value of the Site Cost column.

  • Client Net Cost (VC): Recalculated by the system according to Margin Percentage Triangulation.

  • Margin %: Unchanged.


3rd Party


For Cost Lines with an Ad Placement linked to an Ad Server provider, the delivered units as provided by the Ad Server provider.

  • Only the value in the 3rd Party Units column is sourced from the Ad Server provider.
  • Even though there may be a value in the 3rd Party Cost column, this value is calculated by the system.

Possible 3rd Party sources:

  • CM360: For Ad Placements linked to a CM360 placement.

  • Flashtalking: For Ad Placements linked to a Flashtalking placement.

For data retrieval frequency, see Delivery Data.

Option 1a: Apply actual delivered units, recalculate cost based on committed rate

Applying the 3rd Party source has the following impacts on the actual value columns:

  • Actual Cost for Period: Recalculated by the system.

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

  • Actual Rate: Locked by the user.

 Option 1b: Apply actual delivered units, recalculate rate based on committed cost

Applying the 3rd Party source has the following impacts on the actual value columns:

  • Actual Cost for Period: Locked by the user.

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

  • Actual Rate: Recalculated by the system.


Option 1: Apply actual delivered units, recalculate vendor cost based on committed vendor rate, recalculate client cost based on committed margin percentage.

Applying the 3rd Party source has the following impacts on the actual value columns:

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

  • Vendor Net Cost (VC): Recalculated by the system (Vendor Net Cost = Actual Units * Rate).

  • Client Net Cost (VC): Recalculated by the system according to Margin Percentage Triangulation.

  • Margin %: Unchanged.

Option 2: Apply actual delivered units and vendor cost, recalculate client cost based on committed margin percentage.

Applying the 3rd Party source has the following impacts on the actual value columns:

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

  • Vendor Net Cost (VC): Updated to match the value of the 3rd Party Cost column.

  • Client Net Cost (VC): Recalculated by the system according to Margin Percentage Triangulation.

  • Margin %: Unchanged.

Option 3: Apply actual delivered vendor cost, recalculate units based on committed vendor rate, recalculate client cost based on committed margin percentage.

Applying the 3rd Party source has the following impacts on the actual value columns:

  • Actual Units: Recalculated by the system (Actual Units = Vendor Net Cost / Rate)

  • Vendor Net Cost (VC): Updated to match the value of the 3rd Party Cost column.

  • Client Net Cost (VC): Recalculated by the system according to Margin Percentage Triangulation.

  • Margin %: Unchanged.


Media

The Media source is only available for Assigned fees.

The fee costs/units are calculated by the system, using the associated media Cost Line as a base.

Since 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, the media Cost Line that the fee is assigned to should be actualized before the fee is actualized.

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

Applying the Media source has the following impacts on the actual value columns:

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

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

  • Actual Rate: Recalculated by the system.

Option 1: Apply calculated fee costs

Applying the Media source has the following impacts on the actual value columns:

  • Actual Units: Locked by user.

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

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

    Margin %: Recalculated by the system.

For more information, see Margin Percentage Triangulation.


Option 2: Apply calculated fee units

 Applying the Media source has the following impacts on the actual value columns:

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

  • Vendor Net Cost (VC): Recalculated by the system.

  • Client Net Cost (VC): Recalculated by the system.

  • Margin %: Recalculated by the system.

For more information, see Margin Actual Units Triangulation.


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 Rate (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.