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 type of actualization:
- Standard actualization
- Margin actualization
| Actualization Type | Description |
|---|---|
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 Depending on Enterprise settings, margin actualization might not be available. | 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.
|
Media Campaigns > (Specific Campaign) > Actualization Tab UI Reference
The Actualization tab displays information related to actualizing committed Schedule Grid lines.
Actualization Tab UI Elements
The Actualization tab contains the following elements:
| Item | Description | |
|---|---|---|
| 1 | Campaign Header | |
| 2 | Standard 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 schedule lines. |
| 4 | Search bar | Search for a committed schedule line by Entity (Supplier or Order Partner) or ID. |
| 5 | Roll settings | Click the Roll settings to select how any under- or over-delivery balance is carried over to future months:
|
| 6 | Apply Source button
The Apply Source button is only available on the Standard Actualization grid. | Click the Apply Source button to override the Schedule grid's Actual Cost for Period, Actual Rate, and Actual Units column values:
|
| 7 | 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 selected lines. |
| 8 | Billing Period(s) filter | By default, only one billing period (month) is selected and displayed on the Actualization grid.
Click the Billing Period(s) filter to select the Billing Periods that are displayed in the Actualization grid. |
| 9 | Actualization grid | A list of a campaign's committed schedule lines, broken down into selected billing periods and grouped by Order. For more information, see Actualization Grid Reference. |
Actualization Grid Reference
The Actualization grid is a list of a campaign's committed Schedule grid lines, broken down into selected billing periods and grouped by order.
There are two Actualization grids, the Standard Actualization grid and the Margin Actualization grid, used for actualizing standard Schedule grid lines and margin Schedule grid lines, respectively.
The following table contains information about the Standard and Margin Actualization grid columns:
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 Type | Column Name | Description |
|---|---|---|
Standard, Margin | Checkbox | Click to select one or more Actualization grid lines. |
Standard, Margin | Line Type | The type of the Actualization grid line, according to the following hierarchy:
|
Standard, Margin | Status (Actualization Status)
| The actualization status of the Actualization grid line. If Line Type is Billing Period, the possible statuses are:
If Line Type is Placement, Media Package, Cost Package, Fee, or Order, the possible statuses are:
|
Standard, Margin | Invoice Status
| The invoice status of the Actualization Grid line. If Line Type is Billing Period, the possible statuses are:
If Line Type is Placement, Media Package, Cost Package, Fee, or Order, the possible statuses are:
|
Standard, Margin | Entity Name | The name of the entity associated with the Actualization Grid line. If Line Type is Billing Period:
If Line Type is Placement, Media Package, Cost Package, or Fee:
If Line Type is Order:
|
Standard, Margin | Line Name | The name of the Cost Line. A read-only value that is automatically populated from the media schedule. |
Standard, Margin | External ID | The External ID of the Billing Period line. A read-only value that is only populated if the Billing Period line has been exported to an external financial system. |
Standard, Margin | Start and End Date | The start and end dates of the Cost Line or Billing Period line. A read-only value that is automatically populated from the media schedule. |
Standard, Margin | Contract Total | The total vendor cost of the Cost Line or Billing Period line, for its entire flight.
A read-only value that is automatically populated from the media schedule. |
Standard, Margin | Rate Type | The Rate Type of the Cost Line. A read-only value that is automatically populated from the media schedule. |
Standard, Margin | Rate | The Vendor Net Rate (VC) of the Cost Line or Billing Period line. Depending on which set of margin actualization triangulated values are active:
For more information, see Margin Actualization Triangulation Rules. |
Margin | Client Net Rate (VC) | The Client Net Rate (VC) of the Cost Line or Billing Period line. |
Standard, Margin | Units | The number of units of the Cost Line or Billing Period line, for its entire flight. A read-only value that is automatically populated from the media schedule. |
Standard, Margin | Current for Period | The total vendor cost of the Cost Line or Billing Period line, for the filtered billing periods(s).
A read-only value that is automatically populated from the media schedule. |
Standard, Margin | Pre-Actualized | If the line has never been actualized, the Pre-Actualized value is equal to the Current for Period value. When the line is actualized for the first time, 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:
Then, the Cost line is actualized in OneStrata:
|
Standard, Margin | Balance | The difference between the Actual Cost for Period value (the value to be actualized or that is actualized) and the Current for Period value (the value that was committed).
|
| Standard | Actual Source | The source(s) of the Actual Cost for Period, Actual Rate, and Actual Units values:
|
| Standard | Actual Cost for Period | The vendor cost to be actualized or that is actualized, for the filtered billing period(s).
The Actual Cost for Period, Actual Rate, and Actual Units columns triangulate off each other. For more information, see Standard Actualization Triangulation Rules. |
| Standard | Actual Rate | The rate to be actualized or that is actualized. |
Standard | Actual Units (standard actualization) | The amount of delivered units to be actualized or that is actualized. |
Margin | Actual Units (margin actualization) | The amount of delivered units to be actualized or that is actualized. |
| Standard | Site Cost Only available if the Order was sent to an In-System Order Partner, and the Order Partner sent delivery metrics through Vendor Inbox. | The amount of delivered units of the Billing Period line, for the filtered billing period(s), as provided by the Order Partner within Vendor Inbox. |
| Standard | Site Units Only available if the Order was sent to an In-System Order Partner, and the Order Partner sent delivery metrics through Vendor Inbox. | The amount of delivered Units of the Billing Period line, for the filtered billing period(s), as provided by the Order Partner within Vendor Inbox. |
| Standard | 3rd Party Cost Only available if the ad serving was provided by an ad server connected to OneStrata, and if the OneStrata Agency's Suppliers were linked to the external integration Provider's suppliers. For more information, see Manage External Integrations. | The delivery cost of the Billing Period line, for the filtered billing period(s), as provided by the external Ad Server provider. |
| Standard | 3rd Party Units Only available if the ad serving was provided by an ad server connected to OneStrata, and if the OneStrata Agency's Suppliers were linked to the external integration Provider's suppliers. For more information, see Manage External Integrations. | The amount of delivered units of the Billing Period line, for the filtered billing period(s), as provided by the external Ad Server provider. |
| Margin | Vendor Net Cost (VC) | The amount that the vendor charges for the media purchase(s), after any discounts are applied but before any taxes are added. |
| Margin | Margin % | The difference between the cost of a media purchase (Vendor Net Cost) and the price at which it is sold (Client Net Cost), as a percentage of the price at which it is sold (Client Net Cost). Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost |
| Margin | Client Net Cost (VC) | The amount that the client is charged for the media purchases, after any discounts are applied but before any commission or taxes are added. |
| Margin | Other Income (VC) | The difference between the Client Net Cost (VC) and Vendor Net Cost (VC) values. Other Income (VC) = Client Net Cost (VC) - Vendor Net Cost (VC) |
Actualization Triangulation Rules
A set of triangulated values contains three values that are mathematically connected; given any two values, the third value can be calculated from the first two values.
Sets of triangulated values follow this pattern:
- One fixed value
- Two non-fixed values
When one of the non-fixed values is manually changed by the user, the fixed value remains constant, but the other non-fixed value is automatically recalculated.
For example, imagine the following scenario:
- Rate: $1
- Units (fixed): 10
- Cost: $10
If the Rate value is changed to $2, the Units value remains 10 and the Cost value is automatically recalculated to $20. Similarly, if the Cost value is changed to $5, the Units value remains 10 and the Rate value is automatically recalculated to $0.50.
Locked/Unlocked vs. Editable/Read-Only
In OneStrata, triangulated values can be locked or unlocked:
- Locked (fixed): A fixed value that does not change
- Unlocked (non-fixed): A non-fixed value that can be changed, either manually by the user or recalculated by OneStrata
All values, including triangulated and non-triangulated values, can be editable or read-only:
- Editable: A value that can be directly changed by the user
- Read-only: A value that cannot be directly changed by the user
Depending on the triangulation set, the two unlocked (non-fixed) values are either both editable, or one is editable and the other is read-only:
- Both unlocked values are editable: Given a set of triangulated values X, Y, and Z (where Y is fixed), X can be manually changed by the user and Z is recalculated by OneStrata. Or, Z can be manually changed by the user and X is recalculated by OneStrata.
- One unlocked value is editable and one unlocked value is read-only: Given a set of triangulated values X, Y, and Z (where Y is fixed), only X can be manually changed by the user and Z is always recalculated by OneStrata. Z cannot be manually changed by the user.
The interactions between these two dimensions (locked/unlocked and editable/read-only) are summarized in the following table:
Editable (non-italicized text) | Read-only (italicized text) | |
|---|---|---|
Locked
| N/A | The fixed value in a triangulation set |
Unlocked
| A non-fixed value that can be manually changed by the user or recalculated by OneStrata, | A non-fixed value that cannot be manually changed by the user, and can only be recalculated by OneStrata. |
Standard Actualization Triangulation Rules
There is one set of standard actualization triangulated values:
| Column Name | Formula | Lock Rules |
|---|---|---|
| Actual Cost for Period | Actual Cost for Period = Actual Rate * Actual Units | By default:
Can be locked |
| Actual Rate | Actual Rate = Actual Cost for Period / Actual Units | By default:
Can be unlocked |
| Actual Units | Actual Units = Actual Cost for Period / Actual Rate | By default:
Can be locked |
Margin Actualization Triangulation Rules
There are two sets of margin actualization triangulated values:
- Margin Percentage Triangulation: The relationships between Vendor Net Cost, Margin Percentage, and Client Net Cost
- Margin Rate, Actual Units, and Cost Triangulation: The relationships between Vendor Net Rate, Actual Units, and Vendor Net Cost, and between Client Net Rate, Actual Units, and Client Net Cost
Only one margin actualization triangulation set can be active at a time. By default:
- The Margin Percentage triangulation set is active
- The Margin Rate, Actual Units, and Cost triangulation set is not active
Margin Percentage Triangulation
The Margin Percentage triangulation set is the default set of triangulated values.
| Column Name | Description | Lock Rules | Notes |
|---|---|---|---|
| Vendor Net Cost (VC) | Entered by user or calculated according to this formula: Vendor Net Cost = Client Net Cost - (Margin Percentage * Client Net Cost) | By default:
Can be locked | When the Margin Percentage triangulation set is active:
|
| Margin % | Entered by user or calculated according to this formula: Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost | By default:
Can be unlocked | |
| Client Net Cost (VC) | Entered by user or calculated according to this formula: Client Net Cost = -1 * (Vendor Net Cost / Margin Percentage - 1) | By default:
Can be locked |
Margin Rate, Actual Units, and Cost Triangulation
By default, the Margin Rate, Actual Units, and Cost triangulation set is not active.
Unlock the Actual Units column to deactivate the Margin Percentage triangulation set and activate the Margin Rate, Actual Units, and Cost triangulation set.
| Cost Group | Column Name | Description | Lock Rules | Notes |
|---|---|---|---|---|
| Vendor | Rate (Vendor Net Rate (VC)) | Read-only value taken from the Schedule grid | Always:
| When the Margin Rate, Actual Units, and Cost triangulation set is active:
|
| Actual Units | Entered by user | If the Margin Rate, Actual Units, and Cost triangulation set is active:
| ||
| Vendor Net Cost (VC) | Calculated according to this formula: Vendor Net Cost = Vendor Net Rate * Actual Units | If the Margin Rate, Actual Units, and Cost triangulation set is active:
| ||
| Client | Client Net Rate (VC) | Read-only value taken from the Schedule grid | Always:
| |
| Actual Units | Entered by user | If the Margin Rate, Actual Units, and Cost triangulation set is active:
Can be unlocked | ||
| Client Net Cost (VC) | Calculated according to this formula: Client Net Cost = Client Net Rate * Actual Units | If the Margin Rate, Actual Units, and Cost triangulation set is active:
|