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 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 appropriate media campaign.
- 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 period months 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 roll option: None, Proportionally, Next Month, or Last Month.
- 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 a third-party 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. When one column is manually updated, the second locked column does not change and the third unlocked column is recalculated accordingly. For more information, see Standard Actualization Triangulation Rules.
- Apply values from a third-party 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 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 appropriate media campaign.
- 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 period months 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 roll option: None, Proportionally, Next Month, or Last Month.
- 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. When one column is manually updated, the second locked column does not change and the third unlocked column is recalculated accordingly. For more information, see Margin Actualization Triangulation Rules.
- Update actual delivered units: Unlock and manually update the Actual Units column. For more information, see Margin Actualization Triangulation Rules.
- Update Vendor Net Cost (VC), Margin %, or Client Net Cost (VC): These three columns are linked, and their values are triangulated off each other. When one column is manually updated, the second locked column does not change and the third unlocked column is recalculated accordingly. For more information, see Margin Actualization Triangulation Rules.
- Click the Actualize button.