Use * syntax for faster search

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Section

Column

width	50%

Panel

borderColor	#c8c8c8
borderWidth	1
borderStyle	solid

Table of Contents

maxLevel	2
indent	20px
style	none

Column

width	50%

Anchor
Actualization-Tab-UI-Elements
Actualization-Tab-UI-Elements
Actualization Tab UI Elements

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

The Actualization tab contains the following elements:

Item

Description

Campaign Header

Include A Shared Block

shared-block-key	Campaign-Header-Reference
page	Overview Tab UI Reference

Standard and Margin selection

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

Filters icon

Include A Shared Block

shared-block-key	Filters-icon
page	About Schedules

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

Search bar

Include A Shared Block

shared-block-key	Search-icon
page	About Orders

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

Anchor

	Roll-settings
	Roll-settings

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

See: Types of Delivery Balance Roll

Anchor

	Apply-Source-button
	Apply-Source-button

Apply Source button

Info
The Apply Source button is only available on the Standard Actualization grid.

Click the Apply Source button to overwrite 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

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.

Anchor

	Billing-Periods-filter
	Billing-Periods-filter

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

Anchor

	Actualization-Grid
	Actualization-Grid

Actualization grid

A list of a campaign's committed Cost Lines, grouped by order and broken down into selected billing periods.

For more information, see Actualization Grid Reference.

Anchor
Actualization-Grid-Reference
Actualization-Grid-Reference
Actualization Grid Reference

The Actualization grid is a list of a campaign's committed Cost Lines, grouped by order and broken down into the selected 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

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

Anchor
Standard-Actualization-Grid-Reference
Standard-Actualization-Grid-Reference
Standard Actualization Grid Reference

The Standard Actualization grid is used to actualize standard Cost Lines, Cost Lines that have a Cost Method value of Standard.

The table below describes the Standard Actualization grid columns:

Table Filter

totalrow	,,,,
hidelabels	false
sparkName	Sparkline
hidePane	Filtration panel
limitHeight	1
sparkline	false
isFirstTimeEnter	true
cell-width	250
hideColumns	false
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	1720018778270_-82719799
order	0
hideControls	true
inverse	false
disableSave	true
separator	Point (.)
labels	Column Name
userfilter	Column Name
datepattern	dd M yy
heightValue	600
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

Table Filter

totalrow	,,,,,,
hidelabels	false
ddSeparator	,
sparkName	Sparkline
hidePane	Filtration panel
sparkline	false
default	Standard,Actualization Grid Type
isFirstTimeEnter	true
cell-width	250,250
hideColumns	true
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	1718900088657_1324654404
order	0,1
hideControls	true
inverse	false,false
column	Actualization Grid Type
disableSave	false
separator	Point (.)
labels	Actualization Grid Type‚Hide columns
ddOperator	OR
datepattern	dd M yy
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

Include A Shared Block

shared-block-key	Actualization-Grid-Reference
page	Actualization Tab UI Reference

Anchor
Margin-Actualization-Grid-Reference
Margin-Actualization-Grid-Reference
Margin Actualization Grid Reference

The Margin Actualization grid is used to actualize margin Cost Lines, Cost Lines that have a Cost Method value of Margin.

The table below describes the Margin Actualization grid columns:

Table Filter

totalrow	,,,,
hidelabels	false
sparkName	Sparkline
hidePane	Filtration panel
limitHeight	1
sparkline	false
isFirstTimeEnter	true
cell-width	250
hideColumns	false
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	1720018769479_1351349498
order	0
hideControls	false
inverse	false
disableSave	false
separator	Point (.)
labels	Column Name
userfilter	Column Name
datepattern	dd M yy
heightValue	600
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

Table Filter

totalrow	,,,,,
hidelabels	false
ddSeparator	,
sparkName	Sparkline
hidePane	Filtration panel
sparkline	false
default	Margin,Actualization Grid Type
isFirstTimeEnter	true
cell-width	250,250
hideColumns	true
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	1719595249140_-1072266076
order	0,1
hideControls	true
inverse	false,false
column	Actualization Grid Type
disableSave	false
separator	Point (.)
labels	Actualization Grid Type‚Hide columns
ddOperator	OR
datepattern	dd M yy
heightValue	600
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

Include A Shared Block

shared-block-key	Actualization-Grid-Reference
page	Actualization Tab UI Reference

Actualization Grid Reference

UI Expand

title	Expand for full Actualization grid reference documentation

Table Filter

totalrow	,,,,,
hidelabels	false
ddSeparator	,
sparkName	Sparkline
hidePane	Filtration panel
limitHeight	1
sparkline	false
default	,
isFirstTimeEnter	true
cell-width	250,250
hideColumns	false
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	17200187586431721676505021_-1095155304641568618
order	0,1
hideControls	false
inverse	false,false
column	Actualization Grid Type
disableSave	false
separator	Point (.)
labels	Actualization Grid Type‚Column Name
ddOperator	OR
userfilter	Column Name
datepattern	dd M yy
heightValue	600
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

A Shared Block

shared-block-key	Actualization-Grid-Reference

Actualization Grid Type

Column Name

Description

Line Type: Order

Line Type: Cost Line

Line Type: Billing Period

Standard,

Margin

Line Type

The type of the Actualization grid line, according to the following hierarchy:

Media
- Order
  - Cost Line (Cost Package, Media Package, Placement)
    - Billing Period
Non-Media
- Order
  - Cost Line (Fee)
    - Billing Period

N/A

Standard,

Margin

Anchor

	Actualization-Status
	Actualization-Status

Status (Actualization Status)

The actualization status of the Actualization grid line.

The possible actualization statuses are:

Not Actualized: None of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata
Partially Actualized: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata
Actualized: All of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata

The possible actualization statuses are:

Not Actualized: The Billing Period line is not actualized in OneStrata
Actualized: The Billing Period line is actualized in OneStrata

Standard,

Margin

Anchor

	Invoice-Status
	Invoice-Status

Invoice Status

The invoice status of the Actualization Grid line.

The possible invoice statuses are:

Not Invoiced: None of the Billing Period lines displayed under the Order line or Cost Line are invoiced
Partially Invoiced: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are invoiced
Invoiced: All of the Billing Period lines displayed under the Order line or Cost Line are invoiced

The possible invoice 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)

Standard,

Margin

Entity Name

The name and identification number of the entity associated with the Actualization grid line.

The displayed values are:

Order Partner: The name of the Order Partner of the order. Click the Entity Name link to open the Order Details page of the order.
Order ID: The OneStrata-generated identification number of the order

The displayed values are:

Supplier: The Supplier entity assigned to the Cost Line
Cost Line ID: The OneStrata-generated identification number of the Cost Line

This displayed values are:

Month & Year: The calendar month and year of the Billing Period line
Billing Period ID: The OneStrata-generated identification number of the Billing Period line

Standard,

Margin

Line Name

The name of the Actualization grid line.

N/A

The name of the Cost Line.

Copied from the media schedule.

N/A

Standard,

Margin

External ID

The external identification number of the Actualization grid line.

N/A

The identification number used by the external financial system to reference the Billing Period line.

Only available 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 Actualization grid line.

N/A

The start and end dates of the Cost Line.

Copied from the media schedule.

The start and end dates of the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Contract Total

The total committed vendor cost of the Actualization grid line.

A Shared Block

shared-block-key	Actualization-Cost-Types

Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate).

Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page.
Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)

The total committed vendor cost of the entire order.

Copied from the order.

The total committed vendor cost of the Cost Line.

Copied from the media schedule.

The committed vendor cost of the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Rate Type

The Rate Type of the Actualization grid line.

N/A

The Rate Type of the Cost Line.

Copied from the media schedule.

N/A

Standard,

Margin

Rate

A Shared Block

shared-block-key	Triangulated-Value

Info

This value is part of a triangulation set.

For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.

The committed vendor rate of the Actualization grid line.

Include A Shared Block

shared-block-key	Actualization-Cost-Types
page	Actualization Tab UI Reference

N/A

The committed vendor rate of the Cost Line.

Copied from the media schedule.

The committed vendor rate of the Billing Period line.

Copied from the media schedule.

Margin

Client Net Rate (VC)

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

TheClient Net Rate (VC) of the Actualization grid line.

N/A

The client net rate of the Cost Line.

Copied from the media schedule.

The client net rate of the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Units

The total number of committed units for the Actualization grid line.

The total number of committed units for the entire order.

The total number of committed units for the Cost Line.

Copied from the media schedule.

The number of committed units for the Billing Period line.

Copied from the media schedule.

Standard,

Margin

Current for Period

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

Include A Shared Block

shared-block-key	Actualization-Cost-Types
page	Actualization Tab UI Reference

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

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

The committed vendor cost of the Billing Period line

Standard,

Margin

Pre-Actualized

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

If the line has never been actualized, the Pre-Actualized value is equal to the 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 (which is copied from the media schedule) 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:

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.

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

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

The pre-actualization vendor cost of the Billing Period line.

Standard,

Margin

Balance

The cost balance of the Actualization grid line, for the selected billing period(s).

The cost balance is the difference between the Actual Cost for Period (the actualized value) and the Current for Period (the committed value).

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

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

The cost balance of the Billing Period line.

Standard

Actual Source

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

The possible values are:

Committed: The values are copied from the media schedule
Site: The values are copied from the Site columns
3rd Party: The values are copied from the 3rd Party columns
Manual: The user has manually changed one or more values

The source(s) of the actual values of the order.

The source(s) of the actual values of the Cost Line.

The source(s) of the actual values of the Billing Period line.

Standard

Actual Cost for Period

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

The actual vendor cost of the Actualization grid line, for the selected billing periods(s).

When a Billing Period line is actualized, this value is sent to the external finance system.

Include A Shared Block

shared-block-key	Actualization-Cost-Types
page	Actualization Tab UI Reference

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

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

The actual vendor cost of the Billing Period line.

Standard

Actual Rate

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

The actual vendor rate of the Actualization grid line.

When a Billing Period line is actualized, this value is sent to the external finance system.

Include A Shared Block

shared-block-key	Actualization-Cost-Types
page	Actualization Tab UI Reference

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

Actual Rate = Actual Cost / Actual Units

N/A

The actual vendor rate of the Cost Line.

The actual vendor rate of the Billing Period line.

Standard

Actual Units

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

The number of actual units for the Actualization grid line, for the selected billing periods(s).

When a Billing Period line is actualized, this value is sent to the external finance system.

N/A

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

The number of actual units for the Billing Period line.

Standard

Site Cost

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

There are two possible Site sources:

Vendor Inbox: If the Cost Line is part of an order that was sent to an In-System Order Partner, the Order Partner can send delivery data through Vendor Inbox.
DV360 : If the Cost Line is linked to a DV360 insertion order, delivery data is automatically retrieved from DV360 once per day, at around midnight local time.

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 vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Site source.

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

The vendor delivery cost of the Billing Period line, as retrieved from the Site source.

Standard

Site Units

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

See Site Cost (above) for more information about Site-sourced delivery data.

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

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

The number of delivered units for the Billing Period line, as retrieved from the Site source.

Standard

3rd Party Cost

The vendor delivery cost of the Actualization grid line for the selected billing period(s), as 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 Cost Line contains one or more Ad Placements that were uploaded to a campaign on the Ad Server provider
The Supplier of the Cost Line is mapped to an Ad Server provider site/supplier

The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Ad Server provider.

The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.

The vendor delivery cost of the Billing Period line, as retrieved from the Ad Server provider.

Standard

3rd Party Units

The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Ad Server provider (if any).

See 3rd Party Cost (above) for more information about 3rd party-sourced delivery data.

The number of delivered units for the order, for the selected billing period(s), as retrieved from the Ad Server provider.

The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.

The number of delivered units for the Billing Period line, as retrieved from the Ad Server provider.

Margin

Vendor Net Cost (VC)

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

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

The vendor net cost of the order, for the selected billing period(s).

The total vendor net cost of the Cost Line, for the selected billing period(s).

The vendor net cost of the Billing Period line.

Margin

Margin %

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

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

N/A

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

The margin percentage of the Billing Period line.

Margin

Client Net Cost (VC)

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

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

N/A

The client net cost of the Cost Line, for the selected billing period(s).

The client net cost of the Billing Period line.

Margin

Actual Units

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

The number of actual units for the Actualization grid line, for the selected billing periods(s).

N/A

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

The number of actual units for the Billing Period line.

Margin

Other Income (VC)

Include A Shared Block

shared-block-key	Triangulated-Value
page	Actualization Tab UI Reference

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

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

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

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

The margin amount of the Billing Period line.

Standard,

Margin

Invoiced Amount

The sum of all invoices that have been matched or cleared against the Actualization grid line, for the selected billing period(s).

The sum of all invoices that have been matched or cleared against the order, for the selected billing period(s).

The sum of all invoices that have been matched or cleared against the Cost Line, for the selected billing period(s).

The sum of all invoices that have been matched or cleared against the Billing Period line.

Standard,

Margin

Cleared Invoiced Amount

The sum of all invoices that have been cleared against the Actualization grid line, for the selected billing period(s).

The sum of all invoices that have been cleared against the order, for the selected billing period(s).

The sum of all invoices that have been cleared against the Cost Line, for the selected billing period(s).

The sum of all invoices that have been cleared against the Billing Period line.

Content

Space Tools

Versions Compared

Old Version 2

New Version 3

Key

Table of Contents

Anchor
Actualization-Tab-UI-Elements
Actualization-Tab-UI-Elements
Actualization Tab UI Elements

Anchor
Actualization-Grid-Reference
Actualization-Grid-Reference
Actualization Grid Reference

Anchor
Standard-Actualization-Grid-Reference
Standard-Actualization-Grid-Reference
Standard Actualization Grid Reference

Anchor
Margin-Actualization-Grid-Reference
Margin-Actualization-Grid-Reference
Margin Actualization Grid Reference

Actualization Grid Reference

Content

Space Tools

Page History

Versions Compared

Old Version 2

New Version 3

Key

Table of Contents

AnchorActualization-Tab-UI-ElementsActualization-Tab-UI-ElementsActualization Tab UI Elements

AnchorActualization-Grid-ReferenceActualization-Grid-ReferenceActualization Grid Reference

AnchorStandard-Actualization-Grid-ReferenceStandard-Actualization-Grid-ReferenceStandard Actualization Grid Reference

AnchorMargin-Actualization-Grid-ReferenceMargin-Actualization-Grid-ReferenceMargin Actualization Grid Reference

Actualization Grid Reference

Anchor
Actualization-Tab-UI-Elements
Actualization-Tab-UI-Elements
Actualization Tab UI Elements

Anchor
Actualization-Grid-Reference
Actualization-Grid-Reference
Actualization Grid Reference

Anchor
Standard-Actualization-Grid-Reference
Standard-Actualization-Grid-Reference
Standard Actualization Grid Reference

Anchor
Margin-Actualization-Grid-Reference
Margin-Actualization-Grid-Reference
Margin Actualization Grid Reference