Use * syntax for faster search

Versions Compared

Key

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


Section


Column
width50%


Panel
borderColor#c8c8c8
borderWidth1
borderStylesolid

Table of Contents

Table of Contents
maxLevel2
indent20px
stylenone



Column
width50%





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

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 TypeDescription

Anchor
Standard-Actualization
Standard-Actualization
Standard actualization


A Shared Block
shared-block-keyStandard-Actualization

The actualization of committed standard schedule lines, which are media and non-media lines in the Schedule Grid that 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.

Anchor
Margin-Actualization
Margin-Actualization

Margin actualization

Info

Depending on Enterprise settings, margin actualization might not be available.

The Margin workflow is a gated feature and not enabled by default. If the Margin workflow is not enabled, the Margin Actualization grid is not available.

To enable this feature, contact your OneStrata representative.



A Shared Block
shared-block-keyMargin-Actualization

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.

Image Removed

Actualization Tab UI Elements

The Actualization tab contains the following elements:

Item

Description

1Campaign Header

Include A Shared Block
shared-block-keyCampaign-Header-Reference
pageAbout Media Campaigns

2Standard and Margin selection

Click to switch between Standard Actualization and Margin Actualization.

3

Filters icon

Include A Shared Block
shared-block-keyFilters-icon
pageAbout Schedules

Click the Filters icon to open the filter pane and filter through the list of all committed schedule lines.

4

Search bar

Include A Shared Block
shared-block-keySearch-icon
pageAbout Orders

Search for a committed schedule line by Entity (Supplier or Order Partner) or ID.

5 AnchorRoll-settingsRoll-settingsRoll settingsClick the Roll settings to select how

Anchor
Delivery-Roll-Types
Delivery-Roll-Types
Types of Delivery Balance Roll

When actualizing, there are four ways that any under- or over-delivery balance

is carried

can be distributed over

to

future months:

Rollover TypeDescriptionVisualization
None
: The

The under- or over-delivery balance is not distributed.

Instead, the

overall totals

values on the original Schedule

Grid

grid line

will be

are updated.

Image Added


Proportionally
: The
The under- or over-delivery balance is evenly distributed over the remaining months of the campaign.

Image Added

Next Month
:
The entire under- or over-delivery balance is carried over to the next month of the campaign.

Image Added

Last Month
:
The entire under- or over-delivery balance is carried over to the final month of the campaign.
Image Removed

Image Added

6

Anchor

Apply

Actual-Columns-Source-

button

Types

Apply

Actual-Columns-Source-

buttonApply Source button

Inactive

Image Removed

Active

Image Removed

Click the Apply Source button to override the Schedule Grid

Types
Types of Actual Column Sources

When a standard Cost Line is actualized, the values in the Actual Cost for Period, Actual Rate,

and

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.
Info

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

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 AnchorBiling-Periods-filterBiling-Periods-filterBilling 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.

9Actualization 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.

AnchorActualization-Grid-ReferenceActualization-Grid-ReferenceActualization 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.

The following table contains information about the Actualization Grid columns:

Table Filter
totalrow,,,
hidelabelsfalse
ddSeparator‚,
sparkNameSparkline
hidePaneFiltration panel
sparklinefalse
default,,
isFirstTimeEntertrue
cell-width250,250,250
hideColumnsfalse
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id1711735928783_-1772356849
order0,1,2
hideControlsfalse
inversefalse,false,false
columnInfo Type,Actualization Grid Type
disableSavefalse
separatorPoint (.)
labelsInfo Type‚Actualization Grid Type‚Column Name
ddOperatorAND,OR
userfilterColumn Name
datepatterndd M yy
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND
Info TypeActualization Grid TypeColumn NameDescriptionN/A

Standard,

Margin

CheckboxClick to select one or more Actualization Grid lines.N/A

Standard,

Margin

Line Type

The type of the Actualization Grid line:

  • Media or Non-Media
  • Order
  • Cost Package, Media Package, Placement, or Fee
  • Billing Period
Flight

Standard,

Margin

AnchorActualization-StatusActualization-StatusStatus (Actualization Status)
A Shared Block
shared-block-keyActualization-Statuses

Image Removed

Image Removed

Image Removed

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.
Flight

Standard,

Margin

AnchorInvoice-StatusInvoice-StatusInvoice Status

Image Removed

Image Removed

Image Removed

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.
Flight

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 screen of the Order.
  • ID: Order ID - The unique, OneStrata identification number of the associated Order.
Flight

Standard,

Margin

Line Name

The name of a Cost line.

A read-only value that is automatically populated from the media schedule.

Flight

Standard,

Margin

External ID

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.

Flight

Standard,

Margin

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.

Flight

Standard,

Margin

Contract Total

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.

Flight

Standard,

Margin

Rate Type

The Rate Type of aCost or Fee line.

A read-only value that is automatically populated from the media schedule.

Flight

Standard,

Margin

Rate

The Vendor Net Rate of a Cost or Billing Period line.

A read-only value that is automatically populated from the media schedule.

Flight

Standard,

Margin

Units

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.

Billing Period

Standard,

Margin

Current for Period

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.

Billing Period

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).

 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

Anchor
Committed-Source
Committed-Source
Committed

The values are copied from the committed Cost Line's values, on the Schedule grid

Anchor
Site-Source
Site-Source
Site

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.

The possible Site sources:

If a Cost Line has delivery data from multiple Site sources, the Site Cost and Site Units columns display the Vendor Inbox values, not the external integration provider values.

Anchor
3rd-Party-Source
3rd-Party-Source
3rd Party

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:

Anchor
Manual-Source
Manual-Source
Manual

The values are manually changed by the user.


Types of Actualization Triangulation

There are three sets of triangulation rules related to actualization:

Billing Period

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 or the Vendor Net Cost.
  • On the Margin Actualization Grid, the Balance value is equal to the Vendor Net Cost.
Billing PeriodStandardActual 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
Billing PeriodStandardActual 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 or the Vendor Net Cost.
  • On the Margin Actualization Grid, the Actual Cost for Period value is equal to the Vendor Net Cost.
A Shared Block
shared-block-keyActual-triangulation

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.

Billing PeriodStandardActual Rate

The Rate to be actualized or that is actualized.

Include A Shared Block
shared-block-keyActual-triangulation
pageAbout Actualization

Billing PeriodStandardActual Units

The amount of Units to be actualized or that is actualized.

Include A Shared Block
shared-block-keyActual-triangulation
pageAbout Actualization

DeliveryStandardSite Cost

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.

DeliveryStandardSite Units

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.

DeliveryStandard3rd Party Cost

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.

DeliveryStandard3rd Party Units

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.

Billing PeriodMarginVendor Net Cost (VC)
Actualization Triangulation SetDescription
Standard Actualization Triangulation

Include A Shared Block
shared-block-key

Vendor

Standard-

Net

Actualization-

Cost

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.

Billing PeriodMarginMargin %

Triangulation
page

Costs and Calculations A Shared Block
shared-block-keyVendor-triangulation

Include A Shared Block
shared-block-keyMargin-Percentage

pageCosts and Calculations
Include A Shared Block
shared-block-keyVendor-triangulation
pageAbout Actualization
Billing PeriodMarginClient Net Cost (VC)

-Triangulation
pageTriangulation

Margin Actual Units Triangulation

Include A Shared Block
shared-block-key

Client

Margin-Actual-

Net

Units-

Cost

Triangulation
page

Costs and Calculations

Triangulation

For more information, see the following pages:

Include A Shared Blockshared-block-keyVendor-triangulationpageAbout Actualization