Use * syntax for faster search
Page History
Section | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
Scheduling refers to the process of adding a schedule to a campaign in OneStrata. This is where specific details for a campaign are defined, using validated data and automated calculations. The information entered is used throughout the lifecycle of the campaign, from schedule entry to buying, campaign execution and actualization.
Media buyers can use the Schedule grid to define the tactical details of a campaign and quickly build out different media schedule options. The Schedule grid is a spreadsheet-like interface that combines user-entered data with pre-defined reference data records and formulas, and is located on the Schedule tab.
Once an agency is ready to move forward with a particular schedule option, they can commit lines on the Schedule grid and start the next step of the OneStrata campaign management workflow.
This page contains information about terms and concepts related to schedules in OneStrata.
Types of Schedule Grid Lines
There are six types of lines that can be added to the Schedule grid:
Buy Type | Schedule Grid Line Type | Description | Graphic |
---|---|---|---|
Media | Placement |
OneStrata Schedule Terms and Concepts
Schedule Grid Line Types
When a new line is added to the Schedule Grid, there are five options:
- Placement
- Media Package
- Cost Package
- Entered Fee
- Central Fee
|
|
|
|
A Shared Block | ||
---|---|---|
| ||
A collection of Placements, grouped by Supplier, with the same rate or cost per unit. |
| |||||||
Media | Media Package |
|
|
Include A Shared Block | ||||
---|---|---|---|---|
|
|
| ||||||||
Media | Cost Package |
|
|
"Commit" vs. "Send"
Committing is the process of indicating in OneStrata that lines in the media schedule are ready to move from a draft stage to real state with financial implications. Once Committed, a line is available throughout the rest of the platform.
Sending is the process of sending a committed order to an Order Partner contact for Confirmation and updating the Order Status accordingly in OneStrata.
Media Campaigns > (Specific Campaign) > Schedule Tab UI Reference
The Schedule tab displays a list of a campaign's media placements.
Schedule Tab UI Elements
| |||||||||
Non-Media | Entered Fee |
| |||||||
Non-Media | Central Fee |
Item
Description
|
|
|
Schedule Option Status
The status of the selected schedule:
- Draft: The initial schedule status upon campaign creation and of any new schedule option created prior to commit.
- Active: When a Schedule has committed lines. A campaign has at most one Active schedule.
- Archived: The Schedule is read-only.
For more information, see Manage Schedule Drafts.
Schedule Option List
A list of the campaign's schedule options, if multiple options exist.
Click to select which schedule is displayed in the Schedule Grid.
Grouping Options
Click to select how Schedule Grid lines are grouped:
- No Grouping (Default): Schedule Grid lines are not grouped and are displayed in a flat view
- Group by Order ID: Schedule Grid lines are grouped by Order ID (the unique, OneStrata identification number of an Order).
Filters icon
A Shared Block | ||
---|---|---|
| ||
Click to open the filter pane and filter through the list of schedule lines for the selected schedule.
Columns icon
A Shared Block | ||
---|---|---|
| ||
Click to customize the columns displayed within the Schedule Grid.
Schedule Summary icon
A Shared Block | ||
---|---|---|
| ||
Click to open the Schedule Summary pane, which displays any required approvals and spend information.
- Approvals: The status of any required Approvals
- Budget and Cost: A summary of planned spend and committed spend, in Client Currency:
- Planned: The sum of all schedule lines with a status of Committed or Draft
- Committed: The sum of schedule lines with a status of Committed
- Remaining: The difference between the campaign budget and the Planned or Committed sums
Undo / Redo buttons
A Shared Block | ||
---|---|---|
| ||
Click to undo or redo any changes to the Schedule Grid that have not been saved yet.
Advertiser View button
Click to access Advertiser View, an advertiser-friendly view of the schedule where Agency and Advertiser approvals can be set.
Click to import or export the schedule, using the OneStrata Excel template.
Only available if the Enterprise or Agency has enabled the Import/Export Allowed setting: Administration > Application Settings > Media Schedule > (Specific Application Setting record)
Save Changes button
Click to save any changes made to the Schedule Grid.
Schedule Grid
A list of the selected schedule's media and non-media buys.
For more information, see Schedule Grid Reference.
Add Row icon
Click to add a new Schedule Grid line:
- If Line Type is Media, click to add a Cost Package, Media Package, Placement, Entered Fee, or Central Fee line.
- If Line Type is Cost Package, click to add a Media Package or Placement line.
- If Line Type is Media Package, click to add a Placement line.
- If Line Type is Non-Media, click to add an Entered Fee or Central Fee line.
Discard Draft button
Inactive
Active
If no Draft - X Schedule Grid lines are selected, the Discard Draft button is inactive.
If one or more Draft - X Schedule Grid lines are selected, the Discard Draft button is active. Click to discard changes to the selected draft Schedule Grid line(s):
- If Status is Draft - New, the line is removed from the Schedule Grid.
- If Status is Draft - Revised, any uncommitted changes are removed from the line.
- If Status is Draft - Cancelled, the line status reverts to Committed and its pending cancellation flag is removed.
Cancel button
Inactive
Active
If no Committed Schedule Grid lines are selected, the Cancel button is inactive.
If one or more Committed Schedule Grid lines are selected, the Cancel button is active. Click to flag the selected line(s) for cancellation:
- The status of the selected line(s) changes from Committed to Draft - Cancelled.
- If a Draft - Cancelled line is selected and committed, its status becomes Cancelled.
- If a Draft - Cancelled line is selected and discarded, its status reverts to Committed and its pending cancellation flag is removed.
Duplicate button
Click to duplicate the selected Schedule Grid line(s).
Duplicated lines are created at the top of the Schedule Grid, and have the status Draft - New.
Commit button
Inactive
Active
If no Schedule Grid lines are selected, the Commit button is inactive.
If one or more Schedule Grid lines are selected, the Commit button is active. Click to commit the selected Schedule Grid line(s).
Info |
---|
Note: Data and functionality available in Schedule will vary based on Agency user access/permissions, Agency Administration settings, and OneStrata environment configuration. |
List of Schedule Field Types
Field Type
Description
| |||||||||
Non-Media | Assigned Fee |
|
Anchor | ||||
---|---|---|---|---|
|
A Shared Block | ||
---|---|---|
| ||
The phrase "Cost Line" is the general term for a Schedule grid line that has associated costs. Not all Schedule grid lines are Cost Lines, because not all types of Schedule grid lines have costs. For example, a child Placement that is purchased as part of a Media Package is not a Cost Line, because the Media Package (which is a Cost Line) is paid for as a single item, and the individual children Placements are not paid for separately. Within a cost package or a standalone media package, the top-most line (the Cost Package line or the Media Package line) is always a Cost Line. |
The costs of a Cost Line are divided into monthly intervals called billing periods. Cost Lines and their billing periods are the level at which costs are actualized, clients are billed, and vendors are invoiced.
Other important actions in OneStrata also occur at the Cost Line level:
- Committing: Costs Lines are committed
- DSP integrations: Cost Lines are linked to DSP insertion orders
The following table describes which types of Schedule grid lines are Cost Lines:
Schedule Grid Line Type | Cost Line? |
---|---|
Standalone Placement | Yes |
Child Placement | No |
Secondary Placement | No |
Standalone Media Package | Yes |
Secondary Media Package | No |
Cost Package | Yes |
Entered / Assigned / Central Fee | Yes |
Cost Line Cost Methods
The cost method of a Cost Line defines what type of cost-related fields are available or editable within the Cost Line, and how they are calculated. Each Cost Line can have a different cost method, depending on what cost methods are enabled within the OneStrata enterprise.
Cost Line Cost Method Type | Description | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| |||||||||||
|
| |||||||||||
|
|
About Flight Periods, Billing Periods, and the Unit Calendar
Schedule grid lines can be divided into flight periods and/or billing periods, which are managed through the Unit Calendar.
About Flight Periods and Billing Periods
The following table describes flight periods and billing periods in OneStrata:
Term | Description | Notes | Example | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
| Imagine a standalone Placement that runs from March 15th to May 22nd, with 300 units. By default, this Placement has three flight periods:
If the default cost distribution setting of the campaign is Pro Rata:
If the default cost distribution setting of the campaign is Even:
For more information on cost distribution settings, see: | |||||||||||
|
|
| Imagine a standalone Placement that runs from March 15th to June 30th, with the following flight periods:
This Placement, and any fees assigned to the Placement, has three billing periods, one for each month with at least one flight period:
There is no billing period for April, because there are no flight periods in April. |
Anchor | ||||
---|---|---|---|---|
|
A Shared Block | ||
---|---|---|
| ||
The flight periods and billing periods of a Schedule grid line can be viewed and managed through the Unit Calendar. The Unit Calendar has two parts:
|
Unit Calendar Part | Description | Notes | ||||||
---|---|---|---|---|---|---|---|---|
| A high-level summary of a Schedule grid line's flight periods or billing periods. If the Schedule grid line is a standalone / secondary Placement, Media Package, or Cost Package:
If the Schedule grid line is a Fee:
The cost of the flight period or billing period is displayed in the primary cost type, which is either Vendor Net or Vendor Gross. Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. | Hover over a Unit Calendar bar to view more information:
| ||||||
| A detailed list of a Schedule grid line's flight periods and/or billing periods. If the Schedule grid line is a standalone / secondary Placement or Media Package:
If the Schedule grid line is a Cost Package or Fee:
For more information about the Flight Periods grid or Billing Periods grid, see Unit Calendar Widget Reference. | Open the Unit Calendar widget for a specific Schedule grid line by double-clicking its Unit Calendar bars, on the Schedule grid. Make flight-level adjustments through the Unit Calendar widget: |
Anchor | ||||
---|---|---|---|---|
|
Once a Schedule grid line has been filled out and customized as desired, the line can be committed.
Committing a Schedule grid line indicates that the line is ready to move from a draft state to a "real" state, with financial implications. Once a Schedule grid line is committed, it becomes available throughout the rest of the OneStrata platform:
Include A Shared Block | ||||
---|---|---|---|---|
|
Info |
---|
See also: |
About Soft Locks and Hard Locks
Once a Schedule grid line has been committed, its flight periods are automatically soft locked, as each flight period begins.
In OneStrata, there are two types of locks, soft locks and hard locks. Items that are soft locked or hard locked must be unlocked before they can be edited, ensuring that any changes with potential financial impacts are done carefully.
Lock-related term | Description | Items That Can Be Locked | ||||||
---|---|---|---|---|---|---|---|---|
| Once a flight period that is part of a committed Schedule grid line begins (its start date is in the past), the flight period is automatically soft locked. Flight periods that are part of a Schedule grid line that has not been committed are not automatically soft locked, because non-committed lines are considered drafts that can be freely edited without financial impact. However, flight periods can be manually soft locked at any time, whether they are part of a committed Schedule grid line or not. Schedule grid lines can also be manually soft locked. Soft locked items are indicated by a dark grey lock icon, and can be unlocked within OneStrata. To unlock a soft locked item, click the lock icon. | Schedule grid
| ||||||
Invoice lock | Once a billing period has been invoiced (by actualizing the corresponding Billing Period line and matching or clearing its invoice in the external financial system), the billing period, any paired flight periods, and the corresponding Billing Period line are automatically hard locked. Hard locked items are indicated by a light gray lock icon, and cannot be unlocked within OneStrata. To unlock a hard locked item, unlock its corresponding invoice within the external financial system. | Schedule grid
Actualization grid
|
The following table describes the impact of soft locking or hard locking an item:
Item | UI Location | Lock Status | Impact |
---|---|---|---|
Flight period | Flight Periods grid | Locked (soft locked or hard locked) | A locked flight period cannot be manually changed by the user or indirectly changed by a unit or cost redistribution. In other words, the units or cost values of a locked flight period do not change, even if the units or cost of the entire Schedule grid line changes. |
Schedule grid line | Schedule grid | Soft locked If every flight period in a Schedule grid line is locked, the Schedule grid line is soft locked. | The following values of a soft locked Schedule grid line cannot be changed, on the Schedule grid:
|
Schedule grid line | Schedule grid | Partially soft locked If at least one flight period, but not all, in the Schedule grid line is soft locked, the Schedule grid line is partially soft locked. | The following values of a partially soft locked Schedule grid line cannot be changed, on the Schedule grid:
The number of units or vendor cost of a partially locked Schedule grid line can be changed. However, since locked flight periods are protected from unit or cost redistribution, the new units or cost value of the Schedule grid line cannot be less than the lowest minimum value, the sum of the units or cost of any locked flight periods. The difference in units or cost is redistributed among the unlocked flight periods, according to the default cost distribution setting (Pro Rata or Even) of the media campaign. |
Billing period | Billing Periods grid | Hard locked If the Invoice Status of a billing period is Matched or Cleared, the billing period is hard locked. | When a billing period is hard locked, the following items are also hard locked:
A Schedule grid line that has one or more hard locked billing periods cannot be canceled. |
Billing Period line | Standard Actualization grid, Margin Actualization grid | Hard locked If the Invoice Status of a Billing Period line is Invoiced, the Billing Period line is hard locked. | A hard locked Billing Period line cannot be edited. |
About Rate Types and Secondary Units
Schedule grid lines are required to have a rate type, which indicates the primary ad metric being tracked or purchased and its cost per unit. Schedule grid lines can also track other ad metrics, referred to as secondary units.
Term | Description | Notes | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Examples of unit types include:
| |||||||||||
|
For a Schedule grid line, its Rate Type value indicates what type of unit is represented in the Units value, and is required before entering rate, units, or cost information. For a list of available rate types, see Rate Type Reference. |
| |||||||||||
Secondary Unit Type |
For example, the primary unit type of a placement might be impressions, but the agency might also want to track clicks, views, or acquisitions. Secondary units have no effect on the (net) cost of a media purchase, but can affect any fees assigned to the purchase:
|
|
Anchor About-Schedule-Options About-Schedule-Options
About Schedule Options
About-Schedule-Options | |
About-Schedule-Options |
A campaign can have multiple schedule drafts, in order to map out and consider different budgets and tactics during the planning process. These different options can be shared and reviewed with clients, and iterated on until a specific option is approved.
When one or more lines on a specific schedule option are committed, that schedule option becomes "active". Any other schedule options are immediately archived and become read-only.
Moving forward, any changes to the campaign's media schedule can only be done on the active schedule option, now referred to simply as "the schedule". A campaign that has an active schedule cannot create new schedule draft options.
There are three schedule option types/statuses:
Schedule Option Status | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
| When a media campaign is first created, the campaign automatically has a single draft schedule option. During the initial planning phase, draft schedule options can be freely created, deleted, and renamed within the media campaign. However, as soon as one or more lines on a specific draft are committed, any other draft schedule options within the campaign become archived, and no new draft schedule options can be created.
| ||||||||
| An active schedule has one or more committed lines, and any number of uncommitted lines. A media campaign has at most one active schedule. | ||||||||
| During the initial planning phase, a media campaign may have multiple draft schedule options. When a specific draft is chosen and moved forward, and one or more lines on that draft is committed, any other draft schedule options become archived. Archived schedules are read-only and cannot be edited or deleted |
OneStrata calculates and populates several fields with a variety of formulas and rules to increase efficiency, reduce errors, and handle complex pricing scenarios. These include:
- Fields based on formulas and rules to determine value such as total costs that include tax and commissions and payable/billable amounts in a different currency.
Editable fields with triangulation rules such as rate, unit cost, and cost where changing one value updates the others.
Concatenated fields auto-populate with data from other fields according in the format defined by a formula. Often used to apply naming conventions quickly and easily, these fields auto-populate based on other field values according to a formula.
The formula and ability to manually edit or reapply the formula depends on Agency configurations.
Automatically generated by OneStrata.
Text
Text fields can be typed in manually with a few variations:
- No format: Alphanumeric text can be entered manually in no particular format. There may be a character limit.
- Number fields accept numerical characters
- Enter flight dates by typing or double clicking the cell for the calendar widget.
- Currency type (e.g., USD, EUR, GBP) is enforced in columns with financial data.
- Percentages in percentage format
Selected
Data is entered by selecting from a pre-defined list, typically in a drop-down menu.
List of Schedule Grid Columns
A non-exhaustive list of the most common Schedule Grid columns. Depending on how an Agency or Enterprise has been configured, the Schedule Grid may contain additional columns, in a different order.
totalrow | ,,, |
---|---|
hidelabels | false |
ddSeparator | /‚ |
sparkName | Sparkline |
hidePane | Filtration panel |
sparkline | false |
default | , |
isFirstTimeEnter | true |
cell-width | 250,250 |
hideColumns | false |
customNoTableMsg | false |
disabled | false |
enabledInEditor | false |
globalFilter | false |
id | 1709104228082_-1271790644 |
order | 0,1 |
hideControls | false |
inverse | false,false |
column | Column Type,Required by OneStrata |
disableSave | false |
separator | Point (.) |
labels | Column Type‚Required by OneStrata |
ddOperator | AND,OR |
datepattern | dd M yy |
updateSelectOptions | false |
worklog | 365|5|8|y w d h m|y w d h m |
isOR | AND |
Click to select one or more Schedule Grid lines.
The type of Schedule Grid line:
- Placement
- Media Package
- Cost Package
- Fee
N/A
Generated
Status (Schedule Line Status)
The status of the Schedule Grid line:
- Draft - New: The line is not committed.
- Committed: The line is committed.
- Draft - Revised: The line was previously committed, but now has uncommitted changes.
- Draft - Cancelled: The line was previously committed and is now pending cancellation. The line will be fully cancelled once it is committed again.
- Cancelled: The line was previously committed, was flagged for cancellation, and was committed again to complete its cancellation.
N/A
Generated
ID
The unique, OneStrata identification number of the Schedule Grid line.
Yes
Selected
Start Date
The start date of the Schedule Grid line.
By default, the Start Date value of a newly created Schedule Grid Line is the start date of the campaign.
Yes
Selected
End Date
The end date of the Schedule Grid line.
By default, the End Date value of a newly created Schedule Grid Line is the end date of the campaign.
The Supplier assigned to the Schedule Grid line.
Yes
Selected
Order Partner
The Order Partner assigned to the Schedule Grid line.
Yes
Selected
Payee
The Payee assigned to the Schedule Grid line.
The unique, OneStrata identification number of the Estimate associated with the Schedule Grid line.
The user-given name of the Schedule Grid line.
Yes
Selected
Format
The Format assigned to the Schedule Grid line.
No
Selected
Format Dimension
The Format Dimensions assigned to the Schedule Grid line. Automatically fills out, based on the Format value, but can be customized.
Yes
Selected
Cost Category
The Cost Category assigned to the Schedule Grid line.
No
Selected
Cost Method
The Cost Method assigned to the Schedule Grid line:
- Standard
- Margin
- Allocated
Pricing model by which the Schedule Grid line is being purchased, such as CPM (Impressions), CPC (Clicks), Fixed, etc.
The Rate Type value determines the type of Unit represented in the Units value. Rate Type is required before entering rate/units/cost information in a line.
Triangulated
Three fields with number of units, unit cost or rate, and cost are linked by a triangulation rule. When two values are entered, OneStrata automatically calculates the third.
The default rules for Units/Rate/Cost are:
- If Rate is being edited, soft-lock Cost and calculate Units.
- If Units is being edited, soft-lock Rate and calculate Cost.
- If Cost is being edited, soft-lock Rate and calculate Units.
However, the rules and relationships between Units/Rate/Cost may vary depending on Agency or Enterprise settings.
A Shared Block | ||
---|---|---|
| ||
Calculated and displayed in Vendor Currency (VC). |
Vendor Net Rate (VC)
Yes
Selected
Unit Calendar
The Flights Periods and Billing Periods of the Schedule Grid line.
For more information, see Unit Calendar.
No
Selected
Fee Assignments
The Fees assigned to the Schedule Grid line.
For more information, see Assign a Fee to a Placement.
No
Selected
Technology Assignments
The ad server assigned to the Schedule Grid line.
For more information, see Assign an Ad Server to a Placement.
No
Calculated
Client Commission Rule
Valid commission rules are made available in the picklist or automatically assigned to a default rule based on client Master Data set up and previous selections such as Cost Category.
No
Calculated
Client Commission Cost (CC)
Include A Shared Block | ||||
---|---|---|---|---|
|
A Shared Block | ||
---|---|---|
| ||
Calculated and displayed in Client Currency (CC). |
No
Client Total Cost (CC)
Include A Shared Block | ||||
---|---|---|---|---|
|
Include A Shared Block | ||||
---|---|---|---|---|
|
No
Calculated
Client Net Cost (CC)
Include A Shared Block | ||||
---|---|---|---|---|
|
Include A Shared Block shared-block-key In-Client-Currency page About Schedules
No
Calculated
Margin Percentage
Include A Shared Block | ||||
---|---|---|---|---|
|
No
Calculated
Other Income Cost (VC)
The difference between Vendor Net Cost (VC) and Client Net Cost (VC) for margin lines.
Include A Shared Block shared-block-key In-Vendor-Currency page About Schedules
No
Calculated
Allocated Amount (CC)
Client budget allocated to a cost line in the schedule which includes both the media cost and the fee costs.
Include A Shared Block shared-block-key In-Client-Currency page About Schedules
No
Calculated
Allocated Fee Cost (CC)
Client net cost of any fees applied to the media line which are based on the Allocated amount. If the fee is applied to more than one line, this is the portion of the fee in relation to this media line.
Include A Shared Block shared-block-key In-Client-Currency page About Schedules
Advertiser View provides a separate view of a schedule that Agency users can share with a Client for review and sign off.
Use Advertiser View to export campaign information in a client-friendly format and handle Advertiser approvals as required in the schedule. Agencies can customize Advertiser View via templates set up in Administration to suit different advertiser or agency needs.
Access the Advertiser View of a Schedule
To access the Advertiser View of a particular schedule, do the following:
Navigate to the Schedule tab of the campaign that contains the schedule: Campaigns > Media Campaigns > (Specific Campaign) > Schedule.Optional: If the campaign has more than one schedule, change the schedule that is displayed in the schedule grid by selecting it in the Schedule List dropdown.
Schedule Tab > (Specific Schedule) > Advertiser View UI Reference
Advertiser View summarizes essential campaign information to facilitate review and approvals with the client. It provides the following sections and functions depending on agency customization.
Item
Description
Any required Advertiser Approvals and Agency Approvals.
Use this widget to action these approvals and download approval documentation. Approval requirements are enabled via Application Settings in Administration.
. |