Overview

The tactical details of a campaign—like selecting which placements to buy from which vendors—are defined and managed on the Schedule Grid, located on the Schedule tab.

The Schedule Grid is a spreadsheet-like interface that combines user-entered data with pre-defined reference data records and formulas, making it easy to build out a media buy and quickly calculate costs. When an Agency is ready to move forward, lines on the Schedule Grid can be committed.

Schedule Terms and Concepts

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

Types of Schedule Grid Lines

The Schedule grid is a table of media and non-media buys, for a particular schedule option. There are five types of Schedule grid lines:

Anchor
About-Committing About-Committing

About Committing 

In OneStrata, committing a schedule line is the process of indicating that a line on the media schedule is ready to move from a draft state to a "real" state with financial implications. Committing a schedule line makes it available throughout the rest of the OneStrata platform.

Anchor
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 option are committed, that schedule option becomes Active and any other schedule options immediately become read-only Archived schedules. Moving forward, any changes to the campaign's media schedule can only be done on the Active schedule option, now just referred to as "the schedule". A campaign that has an active schedule cannot create new schedule draft options.

There are three schedule option types/statuses:

Anchor
About-Flights About-Flights

About Flight Periods, Billing Periods, and Unit Calendar

Anchor
Flight-Periods Flight-Periods

Flight Periods

For example, a Placement line that runs from March 15th to May 5th is automatically divided into three flight periods:

• The first flight period runs from March 15th to March 31st
• The second flight period runs from April 1st to April 30th
• The third flight period runs from May 1st to May 22nd

That Placement line's budget is distributed among the flight periods in one of three ways:

• Pro Rata: 

  Include A Shared Block Inline
  shared-block-key Cost-Distribution-Pro-Rata page About Media Campaigns

• Even:

  Include A Shared Block Inline
  shared-block-key Cost-Distribution-Even page About Media Campaigns

• Custom: The budget for each flight period is manually entered

The default cost distribution setting is defined at the campaign level. For more information, see Cost Distribution and Change a Campaign's Cost Distribution.

Anchor
Billing-Periods Billing-Periods

Billing Periods

Although billing periods correspond to calendar months, their exact start or end dates depend on the Flight Period(s) that occur within the billing period. For example, imagine a Placement line that has the following flight periods:

• Flight period 1: March 15th to March 31st
• Flight period 2: April 1st to April 30th
• Flight period 3: May 2nd to May 10th
• Flight period 4: May 15th to May 20th
• Flight period 5: May 20th to May 22nd

This Placement line has three billing periods, one for each month:

• Billing period 1 (March): March 15th to March 31st
• Billing period 2 (April): April 1st to April 30th
• Billing period 3 (May): May 2nd to May 22nd

Anchor
Unit-Calendar Unit-Calendar

Unit Calendar

Schedule Summary icon

To open the Unit Calendar editorwidget for a specific Schedule grid line, double click the Unit Calendar column on the Schedule Grid.

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

The Schedule tab displays information about a campaign's media and non-media buys.

Image Removed

The Schedule tab contains the following elements:

Item

Description

Filters icon

Click the Filters icon to open the filter pane and filter through the selected schedule option's Schedule grid lines.

Columns icon

the Schedule

• 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

Click to import or export the schedule, using the OneStrata Excel template.

Displays any filters that have been applied to the Schedule grid.

Grid

,

A list of the selected schedule option's media and non-media buys. By default, Cancelled Schedule Grid lines are filtered out.

For more information, see Schedule Grid Reference.

Add Row icon

Image Removed

Image Removed

Click the Add Row icon to add a new Schedule grid line:

Discard Draft button

Image Removed

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 the Discard Draft button to discard changes to the selected Schedule Grid line(s):

Cancel button

Image Removed

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.

for

Image Removed

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 the Commit button to commit the selected Schedule Grid line(s).

Schedule Grid Reference

A table of the selected schedule option's media and non-media buys. By default, canceled Schedule grid lines are filtered out.

List of Schedule Column Types

Columns in the Schedule Grid are one of the following types:

Column Type

Description

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.

Click to select one or more Schedule Grid lines.

The type of Schedule Grid line:

• Placement
• Media Package
• Cost Package
• Fee

The status of the Schedule Grid line:

The unique, OneStrata identification number of the Schedule Grid line.

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.

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.

The Order Partner assigned to the Schedule Grid line.

The Payee assigned to the Schedule Grid line.

The unique, OneStrata identification number of the Estimate associated with the Schedule Grid line.

Text,

Concatenated

The user-given name of the Schedule Grid line.

The Format assigned to the Schedule Grid line.

The Format Dimensions assigned to the Schedule Grid line. Automatically fills out, based on the Format value, but can be customized.

The Cost Category assigned to the Schedule Grid line.

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.

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 visual representation of how many units are scheduled to run per Flight Period, grouped by calendar month.

For more information, see About Flight Periods, Billing Periods, and Unit Calendar.

The Fees assigned to the Schedule Grid line.

For more information, see Assign a Fee to a Placement.

The ad server assigned to the Schedule Grid line.

For more information, see Assign an Ad Server to a Placement.

The difference between Vendor Net Cost (VC) and Client Net Cost (VC) for margin lines.

Client budget allocated to a cost line in the schedule which includes both the media cost and the fee costs.

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.

the desired line. For more information, see Unit Calendar Widget Reference.