Use * syntax for faster search

Table of Contents


Overview

When schedule lines are committed on the Schedule grid, located on the Schedule tab, OneStrata automatically does the following:

  • On the Schedule tab: Enables automatic flight period soft locking
  • On the Orders tab: Groups committed lines with the same Order ID into orders on the Orders grid
  • On the External Integrations tab: For Placement lines with a Technology Assignment value, creates one or more Ad Placement lines on the Ad Server grid 
  • On the Actualization tab: Creates one or more Order, Cost Package, Media Package, Placement, Fee, and Billing Period lines on the Actualization grid

The Actualization grid lines can be adjusted as needed, like updated with actual delivery data, and actualized. The validated metrics and amounts are then pushed to the agency's financial system, where client and vendor invoices can be processed.

Actualize a Media Cost Line

To actualize a media Cost Line (standard or margin), do the following:


General StepStandard Actualization GridMargin Actualization Grid
1

Open the campaign that contains the Cost Line.



2

Go to the campaign's Actualization tab.



3Go to the appropriate Actualization grid.

If the Cost Line is a standard Cost Line, go to the Standard Actualization grid.

If the Cost Line is a standard Cost Line, go to the Margin Actualization grid.

4Review the delivery balance Roll setting and make sure that the appropriate option is selected. If desired, change the delivery balance roll option.

 



5

Optional: Click the Billing Period(s) filter and select the billing period(s) to actualize.

By default, only one billing period is displayed:

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



6

Review the actual values (the values that will be sent to the external financial system).


Actual values:

  • Actual Cost for Period
  • Actual Rate
  • Actual Units

Actual values:

  • Vendor Net Cost (VC)
  • Margin %
  • Client Net Cost (VC)
  • Actual Units
7

If needed, adjust the actual values. There are two options:

  • Option 1: Apply an external source
  • Option 2: Manually adjust values

Option 1: To apply an external source, do the following:

  1. Select the Cost Line or any of the individual billing periods under the Cost Line.
  2. Click Apply Source and then select the desired source: Committed, Site, or 3rd Party.

For information about the effects of applying an external source, see the Standard Actualization Grid column in Types of Actual Value Sources.

Option 2: To manually adjust actual values, do the following:

  • At the Cost Line or billing period level, enter the desired Actual Cost for Period, Actual Rate, or Actual Units value.

Depending on which other column is locked, the value of the third column will be automatically recalculated by the system.

For more information, see Apply Standard Actualization Triangulation, 

Option 1: To apply an external source, do the following:

  1. Select the Cost Line or any of the individual billing periods under the Cost Line.
  2. Click Apply Source and then select the desired source: Committed, Site, or 3rd Party.

For information about the effects of applying an external source, see the Margin Actualization Grid column in Types of Actual Value Sources.

Option 2: To manually adjust actual values, do one of the following:

8

Click Actualize.




Actualize an Assigned Fee Cost Line

OneStrata automatically calculates the cost(s) and units that should be actualized for each billing period of an Assigned fee. These system-calculated values are provided in the Standard Actualization and Margin Actualization grids for easy reference and application.

To actualize an Assigned fee (standard or margin) using system-calculated values, do the following:


General StepStandard Actualization GridMargin Actualization Grid
1

Open the campaign that contains the Assigned fee.



2

Go to the campaign's Actualization tab.



3Actualize the media Cost Line that the fee is assigned to, following the instructions in Actualize a Media Cost Line.



4Go to the appropriate Actualization grid.

If the Assigned fee is a standard fee, go to the Standard Actualization grid.

If the Assigned fee is a margin fee, go to the Margin Actualization grid.

5

Review the system-calculated fees for the Assigned fee, which may have changed after the media Cost Line was actualized.

This is because the cost and units of an Assigned fee depend on the (actualized) cost and units of the media Cost Line that the fee is assigned to.

System-calculated fields:

  • Calculated Fee Cost
  • Fee Calculated Units

For more information, see Standard Actualization Grid Reference.

System-calculated fields:

  • Fee Calculated Vendor Cost
  • Fee Calculated Client Cost
  • Fee Calculated Units

For more information, see Margin Actualization Grid Reference.

6

Apply the system-calculated values to the actual values (the values that are actualized) by doing the following:

  1. Select the Assigned fee.
  2. Click the Apply Source menu.
  3. Select Media.

The following fields are updated:

  • The value of Actual Cost for Period is updated with the value of Calculated Fee Cost.

  • The value of Actual Units is updated with the value of Fee Calculated Units.

The following fields are updated:

  • The value of Vendor Net Cost (VC) is updated with the value of Fee Calculated Vendor Cost.

  • The value of Client Net Cost (VC) is updated with the value of Fee Calculated Client Cost.

  • The value of Actual Units is updated with the value of Fee Calculated Units.
7Optional: Manually adjust the actual values of the Assigned fee.

The Actual Cost for Period, Actual Rate, and Actual Units columns are linked, and their values are triangulated off each other. For more information, see Apply Standard Actualization Triangulation.

There are two ways to manually adjust actual values:

  • Update Vendor Net Cost (VC), Margin %, or Client Net Cost (VC): These three columns are linked, and their values are triangulated off each other. For more information, see Apply Margin Actualization Triangulation and the Margin Percentage Triangulation set.

  • Update actual delivered units: Unlock and manually update the Actual Units column. For more information, see Apply Margin Actualization Triangulation and the Margin Actual Units Triangulation set.
8

Actualize the Assigned fee by doing the following:

  1. Select the Assigned fee.
  2. Click Actualize.




  • No labels
Provide feedback on this article
You are evaluating Refined.