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 Standard Media Cost Line
Standard Cost Lines use the Standard cost method. In the Standard cost method option, vendor costs and client costs are directly connected and can be easily calculated from each other.
To actualize a standard Cost Line, do the following:
- Open the campaign that contains the Cost Line to be actualized.
- Navigate to the campaign's Actualization tab.
- Select the Standard Actualization grid, if it is not already selected.
- Optional: Click the Billing Period(s) filter (see Actualization Tab UI Elements, item 8) and select the desired billing periods to actualize. By default, only one billing period is displayed.
- Select the desired Cost Line.
- Review the delivery balance Roll setting (see Actualization Tab UI Elements, item 5) and make sure that the appropriate option is selected. If desired, change the delivery balance roll option.
- Adjust the Actual Cost for Period, Actual Rate, and Actual Units columns to the values that will be actualized. There are two options:
- Apply values from another source: Click the Apply Source button and select a source. The options are Committed, Site, and 3rd Party.
- Manually adjust values: 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.
- Apply values from another source: Click the Apply Source button and select a source. The options are Committed, Site, and 3rd Party.
- Click the Actualize button.
Actualize a Margin Media Cost Line
Margin Cost Lines use the Margin cost method. In the Margin cost method option, vendor costs and client costs are not directly connected. Instead, they are connected through a third value, Margin Percentage, which indicates the percentage difference between what the vendor charges and what the client is billed.
To actualize a margin Cost Line, do the following:
- Open the campaign that contains the Cost Line to be actualized.
- Navigate to the campaign's Actualization tab.
- Select the Margin Actualization grid, if it is not already selected.
- Optional: Click the Billing Period(s) filter (see Actualization Tab UI Elements, item 8) and select the desired billing periods to actualize. By default, only one billing period is displayed.
- Select the desired Cost Line.
- Review the delivery balance Roll setting (see Actualization Tab UI Elements, item 5) and make sure that the appropriate option is selected. If desired, change the delivery balance roll option.
- Manually adjust the values that will be actualized. There are two options:
- 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.
- 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.
- Click the Actualize button.
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 Step | Standard Actualization Grid | Margin Actualization Grid | |
|---|---|---|---|
| 1 | Open the campaign that contains the Assigned fee to be actualized. | - | - |
| 2 | Navigate to the campaign's Actualization tab. | - | - |
| 3 | Actualize the media Cost Line that the fee is assigned to. | If the media Cost Line is a standard Cost Line, follow the instructions for actualizing a standard media Cost Line. | If the media Cost Line is a margin Cost Line, follow the instructions for actualizing a margin media Cost Line. |
| 4 | Navigate to the appropriate Actualization grid. | If the Assigned fee is a standard fee, navigate to the Standard Actualization grid. | If the Assigned fee is a margin fee, navigate 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:
For more information, see Standard Actualization Grid Reference. | System-calculated fields:
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:
| The following fields are updated:
| The following fields are updated:
|
| 7 | Optional: Manually adjust the actual values of the Assigned fee, if desired. | 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:
|
| 8 | Actualize the Assigned fee:
| ||