Actualization Tab UI Elements

The Actualization tab displays information related to actualizing committed Schedule Grid lines.

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: None: The balance is not distributed. Instead, the overall totals on the Schedule Grid line will be 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.
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: 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.
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. 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.
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.

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: Media Order Cost Package, Media Package, Placement Billing Period Non-Media Order Fee Billing Period
Standard, Margin	Status (Actualization Status)	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.
Standard, Margin	Invoice Status	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.
Standard, Margin	Entity Name	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 Details page of the order. ID: Order ID - The unique, OneStrata identification number of the associated 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. 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). On the Margin Actualization grid, the Contract Total value is equal to 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	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: 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.
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). 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). On the Margin Actualization Grid, the Current for Period value is equal to the Vendor Net Cost (VC). 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: 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	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). 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). On the Margin Actualization grid, the Balance value is equal to the Vendor Net Cost (VC).
Standard	Actual Source	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
Standard	Actual Cost for Period	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). On the Margin Actualization grid, the Actual Cost for Period value is equal to the Vendor Net Cost (VC). 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)

Content

Space Tools

Table of Contents

Actualization Tab UI Elements

Actualization Grid Reference

Provide feedback on this article

Content

Space Tools

Actualization Tab UI Reference

Table of Contents

Actualization Tab UI Elements

Actualization Grid Reference

Provide feedback on this article