Use * syntax for faster search

Versions Compared

Old Version 1

changes.mady.by.user Hub Admin

Saved on

compared with

New Version 2

changes.mady.by.user Hub Admin

Saved on

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

Actualization Methods

This section contains information about terms and concepts related to actualization in OneStrata.

Types of Actualization

In OneStrata, there are two ways that committed schedule lines can be actualizedtype of actualization:

  • Standard Actualizationactualization
  • Margin actualization
Actualization TypeDescription

Anchor
Standard-Actualization
Standard-Actualization
Standard

ActualizationUse Standard Actualization to

actualization


A Shared Block
shared-block-keyStandard-Actualization

The actualization of

actualize

committed standard schedule lines, which are

committed

media and non-media lines in the Schedule Gridthat have been committed and that have a Cost Method value of Standard.

Image Removed

For more information on the Standard Cost Method

:
  • Vendor Gross Cost = Client Gross Cost
  • The Vendor costs and Client costs are connected. If one set of Vendor or Client costs (a combination of Unit and Rate, Unit and Total Cost, or Rate and Total Cost) are defined, all other Cost Types, like Client Commission or Vendor Discount, can be calculated from that set.

option, see Cost Methods.

Image Added

Anchor
Margin-Actualization
Margin-Actualization

Margin actualization

Info

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



A Shared Block
shared-block-keyMargin-Actualization

The actualization of

AnchorMargin-ActualizationMargin-ActualizationMargin Actualization
Info

Depending on Enterprise settings, Margin Actualization may not be available as an actualization option.

Use Margin Actualization to actualize

committed margin schedule lines, which are

committed

media and non-media lines in the Schedule Gridthat have been committed and that have a Cost

Method value of Margin.

Image Removed

Margin Cost Method:

  • Vendor Net Cost =/= Client Net Cost
  • The difference between the Vendor Net Cost and the Client Net Cost creates a "margin", which is income to the Agency.
  • The Vendor and Client costs are calculated separately from each other. If one set of Vendor costs are defined, the other Vendor Cost Types can be calculated from that set but the Client Cost Types cannot, and vice versa.

    • Method value of Margin.

    For more information on the Margin Cost Method option, see Cost Methods.

    Image Added

    However, the Vendor and Client costs are connected by the Margin Percentage value. For example, Vendor Net Cost = Client Net Cost - (Client Net Cost x Margin Percentage) 


    Media Campaigns > (Specific Campaign) > Actualization Tab UI Reference

    The Actualization tab displays a list of a campaign's committed schedule lines, by selected months (billing periods)information related to actualizing committed Schedule Grid lines.

    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

    actualizing standard schedule lines (

    Standard Actualization

    Grid)

    and

    actualizing margin schedule lines (

    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.

    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

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

    Image Modified

    6

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

    Inactive

    Image Added

    Active

    Image Added

    Click the Apply Source button to override the Schedule Grid Actual Cost for Period, Actual Rate, and Actual Units column values:

    • Committed: The values of the Actual
    values
    • columns are reset to the media schedule values.
    • Site: The values of the Actual
    values
    • columns are updated to match the values of the Site columns.
    • 3rd Party: The values of the Actual
    values
    • columns are updated to match the values of the 3rd Party columns.
    Only


    Info

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


    7

    Actualize button

    Inactive

    Image Removed

    Active

    Image Removed


    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

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

    Click to select the months, or billing periods, that are displayed in

    By default, only one Billing Period (month) is selected and displayed on the Actualization Grid.

    • If the campaign is in-flight,
    by default the billing period
    • the default selected Billing Period is the previous month of the campaign.
    • If the campaign has not started yet,
    by default the billing period
    • the default selected Billing Period is the first month of the campaign.
    • If the campaign has already finished,
    by default the billing period
    • 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,

    by

    broken down into selected billing

    period(s)

    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, 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
    id17087204660261711735928783_1790770476-1772356849
    order0,11,2
    hideControlsfalse
    inversefalse,false,false
    columnInfo Type,Actualization Grid Type
    disableSavefalse
    separatorPoint (.)
    labelsInfo Type‚Actualization TypeGrid 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 NameDescription
    N/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

    Anchor
    Actualization-Status
    Actualization-Status
    Status (Actualization Status)


    A Shared Block
    shared-block-keyActualization-Statuses

    Image Modified

    Image Modified

    Image Modified


    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

    Anchor
    Invoice-Status
    Invoice-Status
    Invoice Status

    Image Modified

    Image Modified

    Image Modified

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

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

    A Shared Block
    shared-block-keyVendor-triangulation

    The Vendor Net Cost, Margin %, and Client Net Cost columns are linked, and their values are triangulated off each other.

    Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost

    By default, the Margin % value is locked (not editable), and the Vendor Net Cost and Client Net Cost values are unlocked (editable). Click a lock icon to change whether the column is locked or unlocked.


    Billing PeriodMarginMargin %

    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)

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

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