Use * syntax for faster search
Page History
Section | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 types of actualization:
- Standard actualization
- Margin actualization
Actualization Type | Description | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| |||||||||||||
Margin actualization
|
|
The Actualization tab displays information related to actualizing committed Schedule Grid lines.
Anchor |
---|
|
|
|
|
|
The Actualization tab contains the following elements:
Description
Include A Shared Block | ||||
---|---|---|---|---|
|
Click to switch between the Standard Actualization grid and the Margin Actualization grid.
Filters icon
Include A Shared Block | ||||
---|---|---|---|---|
|
Click the Filters icon to open the filter pane and filter through the list of all committed schedule lines.
Search bar
Include A Shared Block | ||||
---|---|---|---|---|
|
Search for a committed schedule line by Entity (Supplier or Order Partner) or ID.
|
When actualizing, there are four ways that
any under- or over-delivery balance
is carriedcan be distributed over
tofuture months:
Rollover Type | Description | Visualization |
---|---|---|
None |
The under- or over-delivery balance is not distributed. Instead, the |
values on the original Schedule |
grid line |
are updated. | |
Proportionally |
The under- or over-delivery balance is evenly distributed over the remaining months of the campaign. | ||
Next Month |
The entire under- or over-delivery balance is carried over to the next month of the campaign. | ||
Last Month |
The entire under- or over-delivery balance is carried over to the final month of the campaign. |
6
Anchor |
---|
|
|
|
Info |
---|
The Apply Source button is only available on the Standard Actualization grid. |
|
When a standard Cost Line is actualized, the values in the Actual Cost for Period, Actual Rate,
andand Actual Units
column values:- Committed: The values of the Actual columns are reset to the media schedule values.
- Site: The values of the Actual columns are updated to match the values of the Site columns.
- 3rd Party: The values of the Actual columns are updated to match the values of the 3rd Party columns.
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.
By default, only one billing period (month) is selected and displayed on the Actualization grid.
- If the campaign is in-flight, the default selected billing period is the previous month of the campaign.
- If the campaign has not started yet, the default selected billing period is the first month of the campaign.
- If the campaign has already finished, the default selected billing period is the last month of the campaign.
Click the Billing Period(s) filter to select the Billing Periods that are displayed in the 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.
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:
totalrow | ,,, |
---|---|
hidelabels | false |
ddSeparator | ‚, |
sparkName | Sparkline |
hidePane | Filtration panel |
sparkline | false |
default | ,, |
isFirstTimeEnter | true |
cell-width | 250,250,250 |
hideColumns | false |
customNoTableMsg | false |
disabled | false |
enabledInEditor | false |
globalFilter | false |
id | 1711735928783_-1772356849 |
order | 0,1,2 |
hideControls | false |
inverse | false,false,false |
column | Info Type,Actualization Grid Type |
disableSave | false |
separator | Point (.) |
labels | Info Type‚Actualization Grid Type‚Column Name |
ddOperator | AND,OR |
userfilter | Column Name |
datepattern | dd M yy |
updateSelectOptions | false |
worklog | 365|5|8|y w d h m|y w d h m |
isOR | AND |
Standard,
Margin
Standard,
Margin
The type of the Actualization grid line, according to the following hierarchy:
- Media
- Order
- Cost Package, Media Package, Placement
- Billing Period
- Cost Package, Media Package, Placement
- Order
- Non-Media
- Order
- Fee
- Billing Period
- Fee
- Order
Standard,
Margin
A Shared Block | ||
---|---|---|
| ||
The actualization status of the Actualization grid line.
If Line Type is Billing Period, the possible statuses are:
Not Actualized: The Billing Period line is not actualized in OneStrata.Actualized: The Billing Period line is actualized in OneStrata.
If Line Type is Placement, Media Package, Cost Package, Fee, or Order, the possible statuses are:
Not Actualized: None of the Billing Period lines filtered under the line are actualized.Partially Actualized: At least one, but not all, of the Billing Period lines filtered under the line are actualized.
Standard,
Margin
The invoice status of the Actualization Grid line.
If Line Type is Billing Period, the possible statuses are:
Not Invoiced: The Billing period line is not invoiced (no invoice has been created for the billing period).Invoiced: The Billing Period line is invoiced (an invoice has been created for the billing period).
If Line Type is Placement, Media Package, Cost Package, Fee, or Order, the possible statuses are:
Not Invoiced: None of the Billing Period lines filtered under the line are invoiced.Partially Invoiced: At least one, but not all, of the Billing Period lines filtered under the line are invoiced.
Standard,
Margin
The name of the entity associated with the Actualization Grid line.
If Line Type is Billing Period:
Entity Name: The month and year of the billing periodID: Billing Period ID - The unique, OneStrata identification number of the Billing Period line.
If Line Type is Placement, Media Package, Cost Package, or Fee:
Entity Name: The name of the SupplierID: Cost Line ID - The unique, OneStrata identification number of the associated schedule line.
If Line Type is Order:
Entity Name: The name of the Order Partner. Click the Entity Name link to open the Order Details page of the order.Standard,
Margin
The name of the Cost Line.
A read-only value that is automatically populated from the media schedule.
Standard,
Margin
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 orBilling Period line.A read-only value that is automatically populated from the media schedule.
Standard,
Margin
The total vendor cost of the Cost Line or Billing Period line, for its entire flight.
On the Standard Actualization grid, depending on the primary Cost Type of the campaign, the Contract Total value is equal to the Vendor Gross Cost (VC) or the Vendor Net Cost (VC).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
The Vendor Net Rate (VC) of the Cost Line or Billing Period line.
shared-block-key | Margin-Actualization-Triangulation |
---|
Depending on which set of margin actualization triangulated values are active:
- The Vendor Net Cost, Margin %, and Client Net Cost columns triangulate off each other
- The Rate, Actual Units, and Vendor Net Cost (VC) columns triangulate off each other
- The Client Net Rate (VC), Actual Units, and Client Net Cost (VC) columns triangulate off each other
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.
Include A Shared Block | ||||
---|---|---|---|---|
|
Standard,
Margin
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
The total vendor cost of the Cost Line or Billing Period line, for the filtered billing periods(s).
On the Standard Actualization grid, depending on the primary Cost Type of the campaign, the Current for Period value is equal to the Vendor Gross Cost (VC) or the Vendor Net Cost (VC).A read-only value that is automatically populated from the media schedule.
fields are sent to the external financial system.
There are four possible sources for the values of these Actual columns:
- Committed
- Site
- 3rd Party
- Manual
To apply a Committed, Site, or 3rd Party source, use the Apply Source button on the Standard Actualization grid.
Actual Source | Description | ||||||
---|---|---|---|---|---|---|---|
| The values are copied from the committed Cost Line's values, on the Schedule grid | ||||||
| The values are copied from the Site columns, on the Standard Actualization grid. The Site Cost and Site Units columns are populated by data retrieved from the Site source, if any. There are two possible Site sources:
If a Cost Line has delivery data from both Site sources, the Site Cost and Site Units columns display the Vendor Inbox values, not the DV360 values. | ||||||
| The values are copied from the 3rd Party columns, on the Standard Actualization grid. 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:
| ||||||
| The values are manually changed by the user. |
Types of Actualization Triangulation
There are three sets of triangulation rules related to actualization:
Actualization Triangulation Set | Description |
---|---|
Standard Actualization Triangulation |
Standard,
Margin
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:
- Its Current for Period value is $100.
- Its Pre-Actualized value is set to whatever 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 in OneStrata:
- At the time of actualization, its Current for Period value is $100.
- At the time of actualization, its Pre-Actualized value is also $100, and becomes locked.
- Afterwards, if the Cost line's Current for Period value changes (for example, it increases to $125), its Pre-Actualized value does not change (it remains $100).
Standard,
Margin
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).
On the Standard Actualization grid, depending on the primary Cost Type of the campaign, the Balance value is equal to the Vendor Gross Cost (VC) or the Vendor Net Cost (VC).The source(s) of the Actual Cost for Period, Actual Rate, and Actual Units values:
Committed: The media scheduleSite: The Actualization Grid's Site columns
The vendor cost to be actualized or that is actualized, for the filtered billing period(s).
On the Standard Actualization grid, depending on the primary Cost Type of the campaign, the Actual Cost for Period value is equal to the Vendor Gross Cost (VC) or the Vendor Net Cost (VC).shared-block-key | Standard-Actualization-Triangulation |
---|
The Actual Cost for Period, Actual Rate, and Actual Units columns triangulate off each other.
For more information, see Standard Actualization Triangulation Rules.
The rate to be actualized or that is actualized.
Include A Shared Block | ||||
---|---|---|---|---|
|
Standard
Actual Units (standard actualization)
|
Margin
Actual Units (margin actualization)
The amount of delivered units to be actualized or that is actualized.
|
Site Cost
Info |
---|
Only available if the Order was sent to an In-System Order Partner, and the Order Partner sent delivery metrics through Vendor Inbox. |
3rd Party Units
Info |
---|
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.
Include A Shared Block | ||||
---|---|---|---|---|
|
Include A Shared Block | ||||
---|---|---|---|---|
|
Site Units
Info |
---|
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.
3rd Party Cost
Info |
---|
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.
|
|
| ||
Margin |
Actual Units Triangulation |
|
|
Include A Shared Block | ||||
---|---|---|---|---|
|
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
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.
|
For more information, see the following pages:
There is one set of standard actualization triangulated values:
By default:
- Unlocked
- Editable
Can be locked
By default:
- Locked
- Read-only
Can be unlocked
By default:
- Unlocked
- Editable
Can be locked
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.
Entered by user or calculated according to this formula:
Vendor Net Cost = Client Net Cost - (Margin Percentage * Client Net Cost)
By default:
- Unlocked
- Editable
Can be locked
When the Margin Percentage triangulation set is active:
- The value of Actual Units is locked
- The values of the Rate (Vendor Net Rate (VC)) and Client Net Rate (VC) columns are recalculated by OneStrata
Entered by user or calculated according to this formula:
Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost
By default:
- Locked
- Read-only
Can be unlocked
Entered by user or calculated according to this formula:
Client Net Cost = -1 * (Vendor Net Cost / Margin Percentage - 1)
By default:
- Unlocked
- Editable
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.
Always:
- Locked
- Read-only
When the Margin Rate, Actual Units, and Cost triangulation set is active:
- The values of the Rate (Vendor Net Rate (VC)) and Client Net Rate (VC) columns are locked
- The value of Margin % is automatically recalculated by OneStrata
If the Margin Rate, Actual Units, and Cost triangulation set is active:
- Unlocked
- Editable
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:
- Unlocked
- Read-only
Always:
- Locked
- Read-only
If the Margin Rate, Actual Units, and Cost triangulation set is active:
- Locked
- Read-only
Can be unlocked
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: