Use * syntax for faster search

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Table of Contents


Overview

This page contains a description of the OneStrata system default templates.

Input Types

This section describes the possible ways that cells receive their values in OneStrata:

Editable By UserInput TypeDescription
SometimesApplied

The value is automatically assigned, or "applied" to the cell, based on the value of one or more related cells.

For example, there may be a Commission record that is automatically assigned to any Schedule grid line associated with a specific Supplier entity,

NoCalculated

The numeric value is automatically calculated by OneStrata, according to a pre-defined system default formula or according to a user-defined formula.

SometimesConcatenated

The text value is automatically created by OneStrata, according to a user-defined concatenation formula.

The concatenation formula specifies which other field values are concatenated, in what order, and by which delimiter.

NoCopied

The value is a read-only copy of another cell. The original cell is possibly located on another grid or page.

YesEnteredThe value is entered by the user.
NoGeneratedThe value is automatically generated by OneStrata.
YesSelected

The  value is selected by the user, from a list of pre-defined options.

SometimesTriangulated

The value is part of a triangulation set.

System Default Advertiser View Template

This section describes the default Advertiser View Schedule grid columns. If a OneStrata enterprise has created their own custom Advertiser View template, the Advertiser View Schedule grid may contain fewer or more columns, in a different order.

The values in the Advertiser View Schedule grid are copied from columns of the same name in the Schedule grid.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Input Type

Column Name

Description

Copied

Line Type

The type of Schedule Grid line.

Copied

Status

The status of the Schedule grid line.

Copied

Start Date

The start date of the Schedule grid line.

Copied

End Date

The end date of the Schedule grid line.

Copied

Supplier

The Supplier entity assigned to the Schedule grid line.

Copied

Name

The name of the Schedule grid line.

Copied

Format

The format type of the Schedule grid line.

Copied

Format Dimension

The dimensions of the Schedule grid line.

  • If Format is a display type like Square or Banner, the Format Dimension value is in pixel dimensions
  • If Format is a video type like Preroll or Midroll, the Format Dimension value is in seconds

Copied

Cost Category

The Cost Category assigned to the Schedule grid line.

Copied

Rate Type

The pricing model by which the Schedule Grid line is purchased, such as CPM (Impressions), CPC (Clicks), or Fixed.

The Rate Type value determines the type of unit represented in the Units value, and is required before entering rate, units, or cost information.

Copied

Client Net Rate (CC)

The cost per unit that the client is charged.

Copied

Units

The number of units being purchased.

Copied

Client Net Cost (CC)

The amount that the client is charged for the media purchases, after any discounts are applied but before any commission or taxes are added.

Copied

Unit Calendar bars

A high-level summary and visual representation of a Schedule grid line's flight periods or billing periods

For more information, see Unit Calendar Bars.

Copied

Client Commission Rule

The Commission record applied to the Schedule grid line, if any.

Depending on Commission record settings, campaign settings, and Schedule grid line values, a default Commission record may be automatically applied.

Copied

Client Commission Cost (CC)

The amount of commission that the client is charged.

Copied

Client Total Cost (CC)

The amount that the client is charged, after any discounts are applied and commission is added, but before any taxes are added.

System Default External Integrations Template

This section describes the default Traffic grid columns. If a OneStrata enterprise has created their own custom External Integrations template, the Traffic grid may contain fewer or more columns, in a different order.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Input Type

Column Name

Description

Generated

Item Type

The type of the Traffic grid line:

  • Package
  • Ad Placement

Generated

Status

The status of the Ad Placement:

  • Not Uploaded: The Ad Placement is not linked to an ad server placement.

  • Canceled (gray): The Ad Placement was canceled in OneStrata before being linked to an ad server placement.

  • Uploaded: The Ad Placement is linked to an ad server placement.

  • Edited: The Ad Placement is linked to an ad server placement, but has since been edited. Re-upload the Ad Placement to update the ad server placement.

  • Upload Failed: The Ad Placement failed to be linked to an ad server placement. Hover over the status to see an error message.

  • Canceled (yellow): The Ad Placement was linked to an ad server placement and then canceled in OneStrata. However, the linked ad server placement has not been canceled in the ad server campaign yet.

    Re-upload the Ad Placement to cancel the ad server placement in the ad server campaign.

  • Archived: The Ad Placement is canceled in OneStrata and the linked ad server placement is canceled in the ad server campaign.

Concatenated,

Generated,

Copied

Name / ID 


The name and identification number of the Traffic grid line.

If Item Type is Ad Placement:

  • Name (Ad Placement Name): The name of the Ad Placement
  • ID (Ad Placement ID): The OneStrata-generated identification number of the Ad Placement
  • EID (Ad Placement External ID): The identification number used by the Ad Server provider for the Ad Placement. An Ad Placement does not have an EID value until it has been uploaded to a linked ad server campaign

If Item Type is Package:

  • Name (Ad Placement Package Name): The name of the Package
  • ID (Media Line ID): The OneStrata-generated identification number of the Media Line that generated the Package
Copied

Cost Line ID

The OneStrata-generated identification number of the Cost Line that generated the Traffic grid line.

The Cost Line ID value is copied from the Schedule grid.

Copied

Start Date

The start date of the Traffic grid line.

The Start Date value is copied from the Schedule grid line that generated the Traffic grid line.

Copied

End Date

The end date of the Traffic grid line.

The End Date value is copied from the Schedule grid line that generated the Traffic grid line.

Copied

Rate Type

The Rate Type of the Ad Placement.

The Rate Type value is copied from the Schedule grid line that generated the Traffic grid line.

Copied

Supplier

The Supplier entity associated with the Ad Placement or Package.

The Supplier value is copied from the Schedule grid line that generated the Traffic grid line.

Copied

Format

The format of the Ad Placement.

The Format value is copied from the Schedule grid line that generated the Traffic grid line.

Copied

Format Dimension

The dimensions of the Ad Placement.

The Format Dimension value is copied from the Schedule grid line that generated the Traffic grid line.

Copied

Service Type

The Service Type of the Ad Placement:

  • AdServing: The Ad Placement is served by the Ad Server provider
  • Tracking: The Ad Placement is tracked by the Ad Server provider

Selected

Placement Type

How the Ad Placement is placed.

The possible Placement Type values depend on the selected Ad Server provider and Service Type.

By default, the value of Placement Type is set to the value of Default External Placement Type, which is part of the Technology Assignments column on the Schedule grid.

System Default Media Schedule Template

This section describes the default Schedule grid columns. If a OneStrata enterprise has created their own custom Media Schedule template, the Schedule grid may contain fewer or more columns, in a different order.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Input TypeColumn NameDescription
SelectedLine Type

The type of the Schedule Grid line:

  • Placement
  • Media Package
  • Cost Package
  • Fee
GeneratedStatus

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 new, 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.
GeneratedIDThe OneStrata-generated identification number of the Schedule grid line.
SelectedStart 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.

SelectedEnd Date

The end date of the Schedule grid line.

By default, the End Date value of a newly created Schedule grid line is the start date of the campaign.

SelectedSupplierThe Supplier entity assigned to the Schedule grid line.
SelectedEstimate IDThe OneStrata-generated identification number of the estimate associated with the Schedule grid line.

Entered,

Concatenated

NameThe name of the Schedule grid line
SelectedFormatThe format type of the Schedule grid line.
SelectedFormat Dimension

The dimensions of the Schedule grid line.

  • If Format is a display type like Square or Banner, the Format Dimension value is in pixel dimensions
  • If Format is a video type like Preroll or Midroll, the Format Dimension value is in seconds
SelectedCost CategoryThe Cost Category assigned to the Schedule grid line.
SelectedRate Type

The pricing model by which the Schedule Grid line is purchased, such as CPM (Impressions), CPC (Clicks), or Fixed.

The Rate Type value determines the type of unit represented in the Units value, and is required before entering rate, units, or cost information.

TriangulatedVendor Net Rate (VC)

The cost per unit that the vendor charges, after any discounts are applied but before any taxes are added.

TriangulatedUnitsThe number of units being purchased.
TriangulatedVendor Net Cost (VC)

The amount that the vendor charges for the media purchase(s), after any discounts are applied but before any taxes are added.

SelectedUnit Calendar

A visual representation of how many units are scheduled to run per Flight Period, grouped by calendar month.

For more information, see Unit Calendar.

SelectedFee Assignments

Any fee(s) assigned to the Schedule grid line.

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

SelectedTechnology Assignments

Any Ad Server provider(s) assigned to the Schedule grid line.

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

CalculatedTotal Fee Cost (CC)The total cost of the fee(s) assigned to the Schedule grid line.

Applied,

Selected

Client Commission Rule

The Commission record applied to the Schedule grid line, if any.

Depending on Commission record settings, campaign settings, and Schedule grid line values, a default Commission record may be automatically applied.

CalculatedClient Commission Cost (CC)

The amount of commission that the client is charged.

TriangulatedClient Total Rate (CC)

The cost per unit that the client is charged, after any discounts are applied and commission is added, but before any taxes are added.

Triangulated

Client Total Cost (CC)

The amount that the client is charged, after any discounts are applied and commission is added, but before any taxes are added.

System Default Order Details Template

This section describes the default Order Details grid columns. If a OneStrata enterprise has created their own custom Order Details template, the Schedule grid may contain fewer or more columns, in a different order.

The values in the Order Details grid are copied from columns of the same name in the Schedule grid.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Input Type

Column Name

Description

Copied

Line Type

The type of Schedule Grid line.

Copied

Status

The status of the Schedule grid line.
Copied

ID

The OneStrata-generated identification number of the Schedule grid line.

Copied

Start Date

The start date of the Schedule grid line.

Copied

End Date

The end date of the Schedule grid line.

Copied

Supplier

The Supplier entity assigned to the Schedule grid line.

Copied

Name

The name of the Schedule grid line.

Copied

Format

The format type of the Schedule grid line.

Copied

Format Dimension

The dimensions of the Schedule grid line.

  • If Format is a display type like Square or Banner, the Format Dimension value is in pixel dimensions
  • If Format is a video type like Preroll or Midroll, the Format Dimension value is in seconds

Copied

Rate Type

The pricing model by which the Schedule Grid line is purchased, such as CPM (Impressions), CPC (Clicks), or Fixed.

The Rate Type value determines the type of unit represented in the Units value, and is required before entering rate, units, or cost information.

Copied

Vendor Net Rate (VC)

The cost per unit that the vendor charges, after any discounts are applied but before any taxes are added.

Copied

Units

The number of units being purchased.

Copied

Vendor Net Cost (VC)

The amount that the vendor charges for the media purchase(s), after any discounts are applied but before any taxes are added.

Copied

Unit Calendar

A visual representation of how many units are scheduled to run per Flight Period, grouped by calendar month.

For more information, see Unit Calendar.

  • No labels
Provide feedback on this article