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.
OneStrata
Actualization Terms and Concepts
Actualization MethodsThis section contains information about terms and concepts related to actualization in OneStrata.
Types of Actualization
In OneStrata, there are two ways that committed schedule lines can be actualizedtypes of actualization:
- Standard Actualizationactualization
- Margin actualization
Actualization Type | Description | |||||
---|---|---|---|---|---|---|
|
actualization |
|
|
|
|
- Vendor Gross Cost = Client Gross Cost
- The Vendor costs and Client costs are connected. If one set of Vendor or Client costs (a combination of Unit and Rate, Unit and Total Cost, or Rate and Total Cost) are defined, all other Cost Types, like Client Commission or Vendor Discount, can be calculated from that set.
| ||||||
Margin |
actualization
|
Depending on Enterprise settings, Margin Actualization may not be available as an actualization option.
|
|
|
|
|
- Vendor Net Cost =/= Client Net Cost
- The difference between the Vendor Net Cost and the Client Net Cost creates a "margin", which is income to the Agency.
- The Vendor and Client costs are calculated separately from each other. If one set of Vendor costs are defined, the other Vendor Cost Types can be calculated from that set but the Client Cost Types cannot, and vice versa.
- However, the Vendor and Client costs are connected by the Margin Percentage value. For example, Vendor Net Cost = Client Net Cost - (Client Net Cost x Margin Percentage)
Media Campaigns > (Specific Campaign) > Actualization Tab UI Reference
The Actualization tab displays a list of a campaign's committed schedule lines, by selected months (billing periods).
Actualization Tab UI Elements
Description
Include A Shared Block | ||||
---|---|---|---|---|
|
Click to switch between actualizing standard schedule lines (Standard Actualization Grid) and actualizing margin schedule lines (Margin Actualization Grid).
Filters icon
Include A Shared Block | ||||
---|---|---|---|---|
|
Click 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.
|
Anchor | ||||
---|---|---|---|---|
|
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. |
Anchor |
---|
|
|
|
|
When a standard Cost Line is actualized, the values in the Actual Cost for Period, Actual Rate,
andand Actual Units
values:- Committed: The Actual values are reset to the media schedule values.
- Site: The Actual values are updated to match the values of the Site columns.
- 3rd Party: The Actual values are updated to match the values of the 3rd Party columns.
Only available on the Standard Actualization Grid.
Actualize button
Inactive
Active
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 to actualize selected lines.
Click to select the months, or billing periods, that are displayed in the Actualization Grid.
- If the campaign is in-flight, by default the billing period is the previous month of the campaign.
- If the campaign has not started yet, by default the billing period is the first month of the campaign.
- If the campaign has already finished, by default the billing period is the last month of the campaign.
A list of a campaign's committed schedule lines, by selected billing period(s).
For more information, see Actualization Grid Reference.
totalrow | ,,, |
---|---|
hidelabels | false |
ddSeparator | ‚/ |
sparkName | Sparkline |
hidePane | Filtration panel |
sparkline | false |
default | , |
isFirstTimeEnter | true |
cell-width | 250,250 |
hideColumns | false |
customNoTableMsg | false |
disabled | false |
enabledInEditor | false |
globalFilter | false |
id | 1708720466026_1790770476 |
order | 0,1 |
hideControls | false |
inverse | false,false |
column | Info Type,Actualization Type |
disableSave | false |
separator | Point (.) |
labels | Info Type‚Actualization Type |
ddOperator | AND,OR |
datepattern | dd M yy |
updateSelectOptions | false |
worklog | 365|5|8|y w d h m|y w d h m |
isOR | AND |
Standard / Margin
The type of the Actualization Grid line:
- Media or Non-Media
- Order
- Cost Package, Media Package, Placement, or Fee
- Billing Period
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.
- Actualized: All of the Billing Period lines filtered under the line are actualized.
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.
- Invoiced: All of the Billing Period lines filtered under the line are invoiced.
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 period
- ID: 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 Supplier
- ID: 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 screen of the Order.
- ID: Order ID - The unique, OneStrata identification number of the associated Order.
The name of a Cost line.
A read-only value that is automatically populated from the media schedule.
The External ID of a Billing Period line.
A read-only value that is only populated if the Billing Period line has been exported to an external financial system.
Start and End Date
The start and end dates of a Cost orBilling Period line.A read-only value that is automatically populated from the media schedule.
The total Vendor Cost (in Vendor Currency) of the Actualization Grid 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 or the Vendor Net Cost.
- On the Margin Actualization Grid, the Contract Total value is equal to the Vendor Net Cost.
A read-only value that is automatically populated from the media schedule.
Rate Type
The Rate Type of aCost or Fee line.A read-only value that is automatically populated from the media schedule.
The Vendor Net Rate of a Cost or Billing Period line.
A read-only value that is automatically populated from the media schedule.
The number of units of the Actualization Grid line, for its entire flight.
A read-only value that is automatically populated from the media schedule.
The total Vendor Cost (in Vendor Currency) of the Actualization Grid 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 or the Vendor Net Cost.
- On the Margin Actualization Grid, the Current for Period value is equal to the Vendor Net Cost.
A read-only value that is automatically populated from the media schedule.
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).
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 or the Vendor Net Cost.
- On the Margin Actualization Grid, the Balance value is equal to the Vendor Net Cost.
The source(s) of the Actual Cost for Period, Actual Rate, and Actual Units values:
- Committed: The media schedule
- Site: The Actualization Grid's Site columns
- 3rd Party: The Actualization Grid's 3rd Party columns
- Manual: The user has manually changed one or more values
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 or the Vendor Net Cost.
- On the Margin Actualization Grid, the Actual Cost for Period value is equal to the Vendor Net Cost.
shared-block-key | Actual-triangulation |
---|
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:
The Actual Cost for Period, Actual Rate, and Actual Units columns are linked, and their values are triangulated off each other.
Actual Rate = Actual Cost for Period / Actual Units
By default, the Actual Rate value is locked (not editable), and the Actual Cost for Period and Actual Units values are unlocked (editable). Click a lock icon to change whether the column is locked or unlocked.
The Rate to be actualized or that is actualized.
Include A Shared Block | ||||
---|---|---|---|---|
|
The amount of Units to be actualized or that is actualized.
Include A Shared Block | ||||
---|---|---|---|---|
|
The amount of delivered Units of the Actualization Grid line, for the filtered billing period(s), as provided by the Vendor/Order Partner within Vendor Inbox.
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 Actualization Grid line, for the filtered billing period(s), as provided by the Vendor/Order Partner within Vendor Inbox.
Only available if the Order was sent to an In-System Order Partner, and the Order Partner sent delivery metrics through Vendor Inbox.
The delivery cost of the Actualization Grid line, for the filtered billing period(s), as provided by the external integration Provider.
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 Actualization Grid line, for the filtered billing period(s), as provided by the external integration Provider.
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.
Actualization Triangulation Set | Description |
---|---|
Standard Actualization Triangulation |
|
|
|
|
shared-block-key | Vendor-triangulation |
---|
The Vendor Net Cost, Margin %, and Client Net Cost columns are linked, and their values are triangulated off each other.
Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost
By default, the Margin % value is locked (not editable), and the Vendor Net Cost and Client Net Cost values are unlocked (editable). Click a lock icon to change whether the column is locked or unlocked.
| ||
|
|
|
Actual Units Triangulation |
|
|
|
|
|
For more information, see the following pages: