Use * syntax for faster search


Overview

The Actualization tab provides a way to easily compare a media schedule plan to actual campaign delivery metrics. Users can pull in delivery metrics from external integrations with a single click, validate the metrics, and then send the actualized and approved payment amounts to the Agency's financial system.


Access the Actualization Tab of a Campaign

To go to the Actualization tab of a campaign, do the following:

  1. Go to the Media Campaigns page (Campaign Management > Campaigns).

  2. In the Media Campaigns grid, click on the name of the campaign to open it.

  3. By default, the campaign opens on its Overview tab.

  4. Click on Actualization to open the Actualization tab.

Actualization Tab UI Elements

The Actualization tab displays information related to actualizing committed Cost Lines.


The Actualization tab contains the following elements:


Item

Description

1Campaign Header

The page Schedule Tab (merged) was not found  -- Please check/update the page name used in the MultiExcerpt-Include macro

2Standard and Margin selection

Click to switch between the Standard Actualization grid and the Margin Actualization grid.

3

Filters icon

Click the Filters icon to open the filter pane and filter through the list of all committed Cost Lines within the campaign.

4

Column icon

Click the Columns icon to open the Actualization grid column picker and customize the columns displayed within the Actualization grid.

5

Search bar

Search for a Cost Line by Entity (Supplier or Order Partner) or ID.

6

Roll settings

Click the Roll settings to select how any under- or over-delivery balance is carried over to future months:

  • None: The balance is not distributed. Instead, the overall totals on the Schedule Grid line are updated
  • Proportionally: The balance is evenly distributed over the remaining months of the campaign
  • Next Month: The entire balance is carried over to the next month of the campaign
  • Last Month: The entire balance is carried over to the final month of the campaign

For more information, see Types of Delivery Balance Roll.

7

Apply Source button

 

On the Standard Actualization grid, click the Apply Source button to update the values in the Actual Cost for Period, Actual Units, and Actual Rate columns.

Source options:

  • Committed
  • Site
  • 3rd Party
  • Media (only applies to Assigned fees)

For more information, see Types of Actual Value Sources.


On the Margin Actualization grid, click the Apply Source button to update the values in the Vendor Net Cost (VC), Client Net Cost (VC), Actual Units, and Margin % columns.

Source option:

  • Committed
  • Site
  • 3rd Party
  • Media (only applies to Assigned fees)

For more information, see Types of Actual Value Sources.

8

Actualize button


If no Actualization grid lines are selected, the Actualize button is inactive.


If one or more Actualization grid lines are selected, the Actualize button is active.

Click the Actualize button to actualize the selected lines.

9

Billing Period(s) filter

Click the Billing Period(s) filter to select the billing periods that are displayed in the Actualization grid.

By default, only one billing period (month) is selected and displayed on the Actualization grid.

  • If the campaign is in-flight, the default billing period is the previous month of the campaign
  • If the campaign has not started yet, the default billing period is the first month of the campaign
  • If the campaign has already finished, the default billing period is the last month of the campaign
10

Actualization grid

A list of a campaign's committed Cost Lines, grouped by order and broken down into the displayed billing period(s). By default, only one billing period (month) is selected:

  • If the campaign is in-flight, the default billing period is the previous month of the campaign
  • If the campaign has not started yet, the default billing period is the first month of the campaign
  • If the campaign has already finished, the default billing period is the last month of the campaign

For more information, see Actualization Grid Reference.


Actualization Grid Reference

There are two types of Actualization grids:

  • Standard Actualization grid: Used to actualize standard Cost Lines
  • Margin Actualization grid: Used to actualize margin Cost Lines

The following table describes the default columns and column order of the Actualization grids:

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Actualization Grid TypeColumn NameLevelDescription

Standard,

Margin

Read-only

Line Type

General

The level of the Actualization grid line:

  • Order: The line represents an order.

  • Placement, Media Package, Cost Package, or Fee: The line represents a Cost Line.

  • Billing Period: The line represents a billing period.

Standard,

Margin


Read-only

Status

General

The actualization status of the Actualization grid line.

Order

The possible actualization statuses are:

  • Not Actualized: None of the billing periods currently displayed under this order are actualized.

  • Partially Actualized: At least one, but not all, of the billing periods currently displayed under this order are actualized.

  • Actualized: All of the billing periods currently displayed under this order are actualized.
Cost Line

The possible actualization statuses are:

  • Not Actualized: None of the billing periods currently displayed under this Cost Line are actualized.

  • Partially Actualized: At least one, but not all, of the billing periods currently displayed under this Cost Line are actualized.

  • Actualized: All of the billing periods currently displayed under this Cost Line are actualized.
Billing Period

The possible actualization statuses are:

  • Not Actualized: The billing period is not actualized.

  • Actualized: The billing period is actualized.

Standard,

Margin

Read-only

Invoice Status

GeneralThe invoice status of the Actualization grid line.
Order

The possible invoice statuses are:

  • Not Invoiced: None of the billing periods currently displayed under this order are invoiced.

  • Partially Invoiced: At least one, but not all, of the billing periods currently displayed under this order are invoiced.

  • Invoiced: All of the billing periods currently displayed under this order are invoiced.
Cost Line

The possible invoice statuses are:

  • Not Invoiced: None of the billing periods currently displayed under this Cost Line are invoiced.

  • Partially Invoiced: At least one, but not all, of the billing periods currently displayed under this Cost Line are invoiced.

  • Invoiced: All of the billing periods currently displayed under this Cost Line are invoiced.
Billing Period

The possible invoice statuses are:

  • Not Invoiced: No invoice has been created for the billing period.

  • Invoiced: An invoice has been created for the billing period.

Standard,

Margin

Read-only

Entity Name

GeneralThe name and identifier of the entity or entities associated with the Actualization grid line.
Order

The displayed values are:

  • (Name): The Order Partner of this order, as a link. Click the link to open the Order Details page of the order.

  • ID (Order ID): The OneStrata identifier of the order.
Cost Line

The displayed values are:

  • (Name): The Supplier assigned to this Cost Line.

  • ID (Cost Line ID): The OneStrata identifier of the Cost Line.
Billing Period

This displayed values are:

  • (Month Year): The calendar month and year of this billing period.

  • ID (Billing Period ID): The OneStrata identifier of the billing period.

Standard,

Margin

Read-only

Line Name

GeneralThe name of the Actualization grid line.
Order

-

Cost Line

The name of the Cost Line, as defined by the schedule.

Billing PeriodN/A (billing periods do not have names)

Standard,

Margin

Read-only

External ID

GeneralThe external identifier of the external entity linked to the Actualization grid line.
Order-
Cost Line-
Billing Period

The identifier of the billing period in an external, non-OneStrata system.

Only available if the Billing Period line has been exported to an external financial system.

Standard,

Margin

Read-only

Start and End Date

GeneralThe start and end dates of the Actualization grid line.
Order

-

Cost Line

The start and end dates of the Cost Line, as defined by the schedule.

Billing Period

The start and end dates of the billing period, as defined by the schedule.

Standard,

Margin

Read-only

Contract Total

General

The total committed vendor cost of the Actualization grid line.


Order

The total committed vendor cost of the order.

Cost Line

The total committed vendor cost of the Cost Line.

Billing Period

The committed vendor cost of the billing period.

Standard,

Margin

Read-only

Rate Type

GeneralThe rate type of the Actualization grid line.
Order-
Cost Line

The rate type of the Cost Line, as defined by the schedule.

Billing Period-

Standard,

Margin

Read-only

Rate

General

The committed vendor rate of the Actualization grid line.


Order-
Cost Line

The committed vendor rate of the Cost Line, as defined by the schedule.

Billing Period

The committed vendor rate of the billing period, as defined by the schedule.

Margin

Read-only

Client Net Rate (VC)

GeneralThe committed Client Net Rate (VC) of the Margin Actualization grid line.
Order-
Cost Line

The committed Client Net Rate (VC) of the Cost Line, as defined by the schedule.

Billing Period

The committed Client Net Rate (VC) of the billing period.

Standard,

Margin

Read-only

Units

GeneralThe total number of units committed for the Actualization grid line.
Order

The total number of units committed for the order.

Calculated by summing the number of units committed for all Cost Lines in this order.

Cost Line

The total number of units committed for the Cost Line, as defined by the schedule.

Billing Period

The number of units committed for the billing period, as defined by the schedule.

Standard,

Margin

Read-only

Current For Period

General

The current committed vendor cost of the Actualization grid line, for the displayed billing period(s).

Order

The current committed vendor cost of the order, for the displayed billing period(s).

Calculated by summing the committed vendor cost of all billing periods currently displayed under this order.

Cost Line

The current committed vendor cost of the Cost Line, for the displayed billing period(s).

Calculated by summing the committed vendor cost of all billing periods currently displayed under this Cost Line.

Billing Period

The committed vendor cost of the billing period, as defined by the schedule.

At the billing period level, Current For Period is always the same as Contract Total.

Standard,

Margin

Read-only

Pre-Actualized

General

The pre-actualization vendor cost of the Actualization grid line, for the displayed billing period(s).


If the line has never been actualized, the Pre-Actualized value is equal to its Current for Period value.

Once the line is actualized, the Pre-Actualized value becomes locked and no longer changes, even if the Current for Period value changes.

For example, imagine a Cost Line that has never been actualized:

  • Its Current for Period value is $100.
  • Its Pre-Actualized value is set to the Current for Period value is, which is $100.
  • If the Cost line's Current for Period value changes, its Pre-Actualized value also changes.

Then, the Cost line is actualized:

  • At the time of actualization, its Current for Period value is $100.
  • The Pre-Actualized value is locked to $100.
  • Afterwards, if the Cost Line's Current for Period value changes (for example, it increases to $125), its Pre-Actualized value does not change.
Order

The pre-actualization vendor cost of the order, for the displayed billing period(s).

Calculated by summing the pre-actualization vendor cost of all billing periods currently displayed under this order.

Cost Line

The pre-actualization vendor cost of the Cost Line, for the displayed billing period(s).

Calculated by summing the pre-actualization vendor cost of all billing periods currently displayed under this Cost Line.

Billing PeriodThe pre-actualization vendor cost of the billing period.

Standard,

Margin

 




Read-only

Balance

General

The cost balance (the difference between the actualized and committed values) of the Actualization grid line, for the displayed billing period(s).


This value is calculated according to the following formula:

Balance = Actual Cost for Period - Current for Period

Order

The cost balance of the order, for the displayed billing period(s).

Calculated by summing the cost balance of all billing periods currently displayed under this order.

Cost Line

The cost balance of the Cost Line, for the displayed billing period(s).

Calculated by summing the cost balance of all billing periods currently displayed under this Cost Line.

Billing PeriodThe cost balance of the billing period.

Standard,

Margin

 




Read-only

Actual Source

General

The source of the Actualization grid line's Actual Cost for Period, Actual Rate, and Actual Units values:

  • Manual
  • Committed
  • Site
  • 3rd Party
  • Media

For more information, see Types of Actual Value Sources.

OrderThe source(s) of the actual values of the order.
Cost LineThe source(s) of the actual values of the Cost Line.
Billing PeriodThe source(s) of the actual values of the billing period.

Standard

Actual Cost For Period

This value is part of a triangulation set.

For more information, see Apply a Triangulation Set.

General

The actual vendor cost of the Actualization grid line, for the displayed billing periods(s). When a billing period is actualized, this value is sent to the external finance system.


If the Actual Source value is Site, 3rd Party, or Media, the value of Actual Rate is calculated according to the following formula:

Actual Rate = Actual Cost / Actual Units

Order

The actual vendor cost of the order, for the displayed billing period(s).

Calculated by summing the actual vendor cost of all billing periods currently displayed under this order.

Cost Line

The actual vendor cost of the Cost Line, for the displayed billing period(s).

Calculated by summing the actual vendor cost of all billing periods currently displayed under this Cost Line.

Billing PeriodThe actual vendor cost of the billing period.

Standard

Actual Rate

This value is part of a triangulation set.

For more information, see Apply a Triangulation Set.

General

The actual vendor rate of the Actualization grid line. When a billing period is actualized, this value is sent to the external finance system.


If the Actual Source value is Site3rd Party, or Mediathe value of Actual Rate is calculated according to the following formula:

Actual Rate = Actual Cost / Actual Units

Order

-

Cost LineThe actual vendor rate of the Cost Line.
Billing PeriodThe actual vendor rate of the billing period.

Standard,

Margin

Actual Units

This value is part of a triangulation set.

For more information, see Apply a Triangulation Set.

General

The number of actual units for the Actualization grid line, for the displayed billing periods(s). When a billing period is actualized, this value is sent to the external finance system.

Order-
Cost Line

The number of actual units for the Cost Line, for the displayed billing period(s).

Calculated by summing the actual units of all billing periods currently displayed under this Cost Line.

Billing PeriodThe number of actual units for the billing period.

Margin

Vendor Net Cost (VC)

This value is part of a triangulation set.

For more information, see Apply a Triangulation Set.

General

The Vendor Net Cost (VC) of the Actualization grid line, for the displayed billing period(s).

Order

The total Vendor Net Cost (VC) of the order, for the displayed billing period(s).

Calculated by summing the vendor net cost of all billing periods currently displayed under this order.

Cost Line

The total Vendor Net Cost (VC) of the Cost Line, for the displayed billing period(s).

Calculated by summing the vendor net cost of all billing periods currently displayed under this Cost Line.

Billing PeriodThe Vendor Net Cost (VC) of the billing period.

Margin

Margin %

This value is part of a triangulation set.

For more information, see Apply a Triangulation Set.

General

The Margin % of the Actualization grid line, for the displayed billing period(s).

Order-
Cost Line

The margin percentage of the Cost Line, for the displayed billing period(s).

Calculated by averaging the margin percentage of all billing periods currently displayed under this Cost Line.

Billing PeriodThe margin percentage of the billing period.

Margin

Client Net Cost (VC)

This value is part of a triangulation set.

For more information, see Apply a Triangulation Set.

General

The Client Net Cost (VC) of the Actualization grid line, for the displayed billing periods(s).

Order-
Cost Line

The Client Net Cost (VC) of the Cost Line, for the displayed billing period(s).

Calculated by summing the client net cost of all billing periods currently displayed under this Cost Line.

Billing PeriodThe Client Net Cost (VC) of the billing period.

Standard

Calculated Fee Cost

This value only applies to Assigned fees. For more information, see Media (Source).

General

The system-calculated vendor cost (Vendor Net Cost or Vendor Gross Cost, depending on the cost type of the campaign) of the Assigned fee, for the displayed billing period(s).

Order

The system-calculated vendor cost of the order, for the displayed billing period(s).

Calculated by summing the system-calculated vendor cost of all billing periods currently displayed under this order.

Cost Line

The system-calculated vendor cost of the Cost Line / Assigned fee, for the displayed billing period(s).

Calculated by summing the system-calculated vendor cost of all billing periods currently displayed under this Assigned fee.

Billing PeriodThe system-calculated vendor cost of the Assigned fee billing period.

Margin

Fee Calculated Vendor Cost

This value only applies to Assigned fees. For more information, see Media (Source).

General

The system-calculated Vendor Net Cost (VC) of the Assigned fee, for the displayed billing period(s).

Order

The system-calculated Vendor Net Cost (VC) of the order, for the displayed billing period(s).

Calculated by summing the system-calculated vendor net cost of all billing periods currently displayed under this order.

Cost Line

The system-calculated Vendor Net Cost (VC) of the Cost Line / Assigned fee, for the displayed billing period(s).

Calculated by summing the system-calculated vendor net cost of all billing periods currently displayed under this Assigned fee.

Billing PeriodThe system-calculated Vendor Net Cost (VC) of the Assigned fee billing period.

Margin

Fee Calculated Client Cost

This value only applies to Assigned fees. For more information, see Media (Source).



General

The system-calculated Client Net Cost (VC) of the Assigned fee, for the displayed billing period(s).

OrderThe system-calculated Client Net Cost (VC) of the order, for the displayed billing period(s).
Cost Line

The system-calculated Client Net Cost (VC) of the Cost Line /  Assigned fee, for the displayed billing period(s).

Calculated by summing the system-calculated client net cost of all billing periods currently displayed under this Assigned fee.

Billing PeriodThe system-calculated Client Net Cost (VC) of the Assigned fee billing period.

Standard

Fee Calculated Units

This value only applies to Assigned fees. For more information, see Media (Source).

General

The system-calculated number of units of the Assigned fee, for the displayed billing period(s).

OrderThe system-calculated number of units of the order, for the displayed billing period(s).
Cost LineThe system-calculated number of units of the Cost Line / Assigned fee, for the displayed billing period(s).
Billing PeriodThe system-calculated number of units for the Assigned fee billing period.

Standard,

Margin

 

Site CostGeneral

The vendor delivery cost of the Actualization grid line for the displayed billing period(s), as retrieved from the Site source (if any).

For more information, see Site (Source).

Order

The vendor delivery cost of the order for the displayed billing period(s), as retrieved from the Site source.

Calculated by summing the Site Cost of all billing periods currently displayed under this order.

Cost Line

The vendor delivery cost of the Cost Line for the displayed billing period(s), as retrieved from the Site source.

Calculated by summing the Site Cost of all billing periods currently displayed under this Cost Line.

Billing PeriodThe vendor delivery cost of the billing period, as retrieved from the Site Source.

Standard,

Margin

 

Site UnitsGeneral

The number of delivered units for the Actualization grid line for the displayed billing periods(s), as retrieved from the Site source (if any).

For more information, see Site (Source).

Order

The number of delivered units for the order, for the displayed billing period(s), as retrieved from the Site source.

Calculated by summing the Site Units of all billing periods currently displayed under this order.

Cost Line

The number of delivered units for the Cost Line, for the displayed billing period(s), as retrieved from the Site source.

Calculated by summing the Site Units of all billing periods currently displayed under this Cost Line.

Billing PeriodThe number of delivered units for the billing period, as retrieved from the Site source

Standard,

Margin

 

3rd Party CostGeneral

The vendor delivery cost of the Actualization grid line for the displayed billing period(s), as retrieved from the 3rd Party provider (if any).

For more information, see 3rd Party (Source).

Order

The vendor delivery cost of the order for the displayed billing period(s), as retrieved from the 3rd Party source.

Calculated by summing the 3rd Party Cost of all billing periods currently displayed under this order.

Cost Line

The vendor delivery cost of the Cost Line for the displayed billing period(s), as retrieved from the 3rd Party source.

Calculated by summing the 3rd Party Cost of all billing periods currently displayed under this Cost Line.

Billing PeriodThe vendor delivery cost of the billing period, as retrieved from the 3rd Party Source.

Standard,

Margin

 

3rd Party UnitsGeneral

The number of delivered units for the Actualization grid line for the displayed billing periods(s), as retrieved from the 3rd Party provider (if any).

For more information, see 3rd Party (Source).

Order

The number of delivered units for the order, for the displayed billing period(s), as retrieved from the 3rd Party source.

Calculated by summing the 3rd Party Units of all billing periods currently displayed under this order.

Cost Line

The number of delivered units for the Cost Line, for the displayed billing period(s), as retrieved from the 3rd Party source.

Calculated by summing the 3rd Party Units of all billing periods currently displayed under this Cost Line.

Billing PeriodThe number of delivered units for the billing period, as retrieved from the 3rd Party source

Margin

 

 

 

Other Income (VC)



General

The margin amount (the difference between the Client Net Cost (VC) and Vendor Net Cost (VC) values) of the Actualization grid line, for the displayed billing period(s).


This value is calculated according to the following formula:

Other Income (VC) = Client Net Cost (VC) - Vendor Net Cost (VC)

Order

The margin amount of the order, for the displayed billing period(s).

Calculated by summing the margin amount of all billing periods currently displayed under this order.

Cost Line

The margin amount of the Cost Line, for the displayed billing period(s).

Calculated by summing the margin amount of all billing periods currently displayed under this Cost Line.

Billing PeriodThe margin amount of the billing period.

Standard,

Margin

Invoiced AmountGeneralThe sum of all invoices that have been matched or cleared against the Actualization grid line, for the displayed billing period(s).
Order

The invoiced amount of the order, for the displayed billing period(s).

Calculated by summing the invoiced amount of all billing periods currently displayed under this order.

Cost Line

The invoiced amount of the Cost Line, for the displayed billing period(s).

Calculated by summing the invoiced amount of all billing periods currently displayed under this Cost Line.

Billing PeriodThe invoiced amount of the billing period.

Standard,

Margin

Cleared Invoiced AmountGeneralThe sum of all invoices that have been cleared against the Actualization grid line, for the displayed billing period(s).
Order

The cleared invoiced amount of the order, for the displayed billing period(s).

Calculated by summing the cleared invoiced amount of all billing periods currently displayed under this order.

Cost Line

The cleared invoiced amount of the Cost Line, for the displayed billing period(s).

Calculated by summing the cleared invoiced amount of all billing periods currently displayed under this Cost Line.

Billing Period

The cleared invoiced amount of the billing period.



Actualization Terms and Concepts

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.

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.
Back to Top