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%





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

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

The Actualization tab contains the following elements:


Item

Description

1Campaign Header

Include A Shared Block
shared-block-keyCampaign-Header-Reference
page

About Media Campaigns

Overview Tab UI Reference

2Standard and Margin selection

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

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

Cost Lines within the campaign.

4

Search bar

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

Search for a

committed schedule line

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

5

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
will be
  • 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
.Image Removed
6

Anchor
Apply-Source-button
Apply-Source-button
Apply Source button

Image Removed

Info

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


Click the Apply Source button to

override

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

Actualize button


If no Actualization

Grid

grid lines are selected, the Actualize button is inactive.


If one or more Actualization

Grid

grid lines are selected, the Actualize button is active.

Click the Actualize button to actualize the selected lines.

8

Anchor
Billing-Periods-filter
Billing-Periods-filter
Billing Period(s) filter

By default, only one billing period (month)

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

Anchor
Actualization-Grid
Actualization-Grid

9

Actualization grid

A list of a campaign's committed

schedule lines,

Cost Lines, grouped by order and broken down into selected billing periods

and grouped by Order

.

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 Schedule grid lines, Cost Lines, grouped by order and broken down into the 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:

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,,,,
hidelabelsfalse
sparkNameSparkline
hidePaneFiltration panel
limitHeight1
sparklinefalse
isFirstTimeEntertrue
cell-width250
hideColumnsfalse
customNoTableMsgfalse
disabledfalse
Table Filter
totalrow,,,
hidelabelsfalse
ddSeparator‚,
sparkNameSparkline
hidePaneFiltration panel
sparklinefalse
default,,
isFirstTimeEntertrue
cell-width250,250,250
hideColumnsfalse
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id17117359287831720018778270_-177235684982719799
order0,1,2
hideControlsfalsetrue
inversefalse,false,falsecolumnInfo Type,Actualization Grid Type
disableSavefalsetrue
separatorPoint (.)
labelsInfo Type‚Actualization Grid Type‚Column Column Name
ddOperatorAND,OR
userfilterColumn userfilterColumn Name
datepatterndd M yy
heightValue600
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND
Table Filter
totalrow,,,,,,
hidelabelsfalse
ddSeparator,
sparkNameSparkline
hidePaneFiltration panel
sparklinefalse
defaultStandard,Actualization Grid Type
isFirstTimeEntertrue
cell-width250,250
hideColumnstrue
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id1718900088657_1324654404
order0,1
hideControlstrue
inversefalse,false
columnActualization Grid Type
disableSavefalse
separatorPoint (.)
labelsActualization Grid Type‚Hide columns
ddOperatorOR
datepatterndd M yy
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND

Include A Shared Block
shared-block-keyActualization-Grid-Reference
pageActualization 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:

Status (Actualization Status)
Table Filter
totalrow,,,,
hidelabelsfalse
sparkNameSparkline
hidePaneFiltration panel
limitHeight1
sparklinefalse
isFirstTimeEntertrue
cell-width250
hideColumnsfalse
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id1720018769479_1351349498
order0
hideControlsfalse
inversefalse
disableSavefalse
separatorPoint (.)
labelsColumn Name
userfilterColumn Name
datepatterndd M yy
heightValue600
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND
Table Filter
totalrow,,,,,
hidelabelsfalse
ddSeparator,
sparkNameSparkline
hidePaneFiltration panel
sparklinefalse
defaultMargin,Actualization Grid Type
isFirstTimeEntertrue
cell-width250,250
hideColumnstrue
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id1719595249140_-1072266076
order0,1
hideControlstrue
inversefalse,false
columnActualization Grid Type
disableSavefalse
separatorPoint (.)
labelsActualization Grid Type‚Hide columns
ddOperatorOR
datepatterndd M yy
heightValue600
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND
Actualization Grid TypeColumn NameDescription

Standard,

Margin

CheckboxClick 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

Anchor
Actualization-StatusActualization-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.
  • 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.
  • 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 orBilling 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.

    A Shared Block
    shared-block-keyMargin-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
    shared-block-key

    Margin

    Actualization-

    Actualization

    Grid-

    Triangulation

    Reference
    pageActualization Tab UI Reference


    Actualization Grid Reference

    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.

    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.

    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 (VC) or the Vendor Net Cost (VC).
  • On the Margin Actualization grid, the Balance value is equal to the Vendor Net Cost (VC).
  • 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 (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.

    Site Cost

    UI Expand
    titleExpand for full Actualization grid reference documentation

    Standard,

    Margin

    Units

    Standard,

    Margin

    Current for Period

    Standard,

    Margin

    Pre-Actualized

    Standard,

    Margin

    BalanceStandardActual SourceStandardActual Cost for Period
    A Shared Block
    shared-block-keyStandard-Actualization-Triangulation
    StandardActual Rate

    The rate to be actualized or that is actualized.

    Include A Shared Block
    shared-block-keyStandard-Actualization-Triangulation
    pageActualization Tab UI Reference

    Standard

    Actual Units (standard actualization)

    The amount of delivered units to be actualized or that is actualized.

    Include A Shared Block
    shared-block-keyStandard-Actualization-Triangulation
    pageActualization Tab UI Reference

    Margin

    Actual Units (margin actualization)

    The amount of delivered units to be actualized or that is actualized.

    Include A Shared Block
    shared-block-keyMargin-Actualization-Triangulation
    pageActualization Tab UI Reference

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

    Standard

    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.

    Standard

    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.

    Standard

    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.

    MarginVendor Net Cost (VC)

    Include A Shared Block
    shared-block-keyVendor-Net-Cost
    pageCosts and Calculations

    Include A Shared Block
    shared-block-keyMargin-Actualization-Triangulation
    pageActualization Tab UI Reference

    MarginMargin %

    Include A Shared Block
    shared-block-keyMargin-Percentage
    pageCosts and Calculations

    include-
    Table Filter
    totalrow,,,,,
    hidelabelsfalse
    ddSeparator,
    sparkNameSparkline
    hidePaneFiltration panel
    limitHeight1
    sparklinefalse
    default,
    isFirstTimeEntertrue
    cell-width250,250
    hideColumnsfalse
    customNoTableMsgfalse
    disabledfalse
    enabledInEditorfalse
    globalFilterfalse
    id1721676505021_-641568618
    order0,1
    hideControlsfalse
    inversefalse,false
    columnActualization Grid Type
    disableSavefalse
    separatorPoint (.)
    labelsActualization Grid Type‚Column Name
    ddOperatorOR
    userfilterColumn Name
    datepatterndd M yy
    heightValue600
    updateSelectOptionsfalse
    worklog365|5|8|y w d h m|y w d h m
    isORAND
    A Shared Block
    shared-block-keyActualization-Grid-Reference


    Actualization Grid TypeColumn NameDescriptionLine Type: OrderLine Type: Cost LineLine 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

    N/A

    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

    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-keyActualization-Cost-Types


    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
    Margin
    Triangulated-
    Actualization-Triangulation
    Value
    pageActualization Tab UI ReferenceMarginClient Net Cost (VC)

    Include A Shared Block
    shared-block-keyClient-Net-Cost
    pageCosts and Calculations

    Include A Shared Block
    shared-block-keyMargin-Actualization-Triangulation
    pageActualization Tab UI Reference


    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-keyActualization-Cost-Types
    pageActualization 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-keyTriangulated-Value
    pageActualization 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-keyActualization-Cost-Types
    pageActualization 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.

    StandardActual 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-keyTriangulated-Value
    pageActualization 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-keyActualization-Cost-Types
    pageActualization 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-keyTriangulated-Value
    pageActualization 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-keyActualization-Cost-Types
    pageActualization 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-keyTriangulated-Value
    pageActualization 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.

    • Google Ads: If the Cost Line is linked to a Google Ads campaign, delivery data is automatically retrieved from Google Ads once per day, at around midnight local time.

    • Meta Ad Manager: If the Cost Line is linked to a Meta Ads Manager campaign, delivery data is automatically retriever from Meta Ads Manager 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 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-keyTriangulated-Value
    pageActualization 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-keyTriangulated-Value
    pageActualization 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-keyTriangulated-Value
    pageActualization 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-keyTriangulated-Value
    pageActualization 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-keyTriangulated-Value
    pageActualization 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.

    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)