Use * syntax for faster search
Page History
Section | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
Reference Data records store additional information about entities, and are used in calculations, building schedules, and sending orders.
Types of Reference Data Records
In OneStrata, there are seven types of Reference Data records:
Record Type | Description | Location within the OneStrata UI | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Fee & Tech Rate | Non-media fee that can be added to a media schedule Placement. | The Administration > Reference Data > Fees & Tech Rates page | |||||||||||
Tax | Tax rules and requirements. | The Administration > Reference Data > Taxes page | |||||||||||
Commission | An amount that an Ageny charges a Client for the services provided. | The Administration > Reference Data > Commissions page | |||||||||||
|
| The Administration > Reference Data > Exchange Rates page | |||||||||||
Terms & Conditions |
| The Administration > Reference Data > Terms & Conditions page | |||||||||||
Media Type Media |
| The Administration > Reference Data > Media page | |||||||||||
|
| The Administration > Reference Data > Cost Categories page |
About Fees and Tech Rates
Fees and tech rates are added to individual Placements within a media schedule, but are generally pre-defined as a Reference Data Fee record. This improves consistency and reduces human error when applying fees, because OneStrata automatically calculates and applies the appropriate fees and costs.
AnchorFee-Types Fee-Types
Fee Types
Fee-Types | |
Fee-Types |
There are three ways that a fee or tech rate can be added to a schedule:
Fee Type | Description | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| |||||||||||
|
| |||||||||||
|
|
AnchorRate-Types Rate-Types
Rate Types
Rate-Types | |
Rate-Types |
A Shared Block | ||
---|---|---|
| ||
A Rate Type is the pricing model by which ad units are purchased. There are three categories of Rate Types:
|
Rate Types | Description | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Fixed |
Example: A Fixed fee of $5,000. | |||||||||||
|
Example: A POM fee that is 1% of the Vendor Net Cost. | |||||||||||
|
Example: A volume-based fee that is $0.30 per impression, with a 10% buffer. |
About Commissions
An Agency may charge a Client a commission for their services: Client Commission = Client Commission Percentage x Client Commission Basis.
Client Commission values are followed by (CC) or (AC), indicating in Client Currency or in Agency Currency. For more information, see Currencies.
A Commission record defines the Client Commission Percentage and Client Commission Basis:
Term | Description | ||||||
---|---|---|---|---|---|---|---|
Client Commission |
| ||||||
Client Commission Percentage |
| ||||||
Client Commission Basis |
|
Reference Data Page UI Reference
Reference Data > Fees & Tech Rates Tab UI Reference
Column Name | Description | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ID | The OneStrata identification number of the Fee record. | ||||||||||||||||||
Name | The unique name of the Fee record. | ||||||||||||||||||
Fee Type | How the Fee record will be entered on a media schedule.
| ||||||||||||||||||
Media Type | The Media Type that the Fee record can be applied to. | ||||||||||||||||||
Rate Type | The Rate Type of the Fee record.
| ||||||||||||||||||
Vendor Rate |
| ||||||||||||||||||
Cost Type | The Cost Type of the Fee record:
| ||||||||||||||||||
Cost Category | The Cost Category of the Fee record. | ||||||||||||||||||
Agency | The Agency associated with the Fee record. | ||||||||||||||||||
Business Unit | The Business Unit associated with the Fee record. | ||||||||||||||||||
Client Group | The Client Group associated with the Fee record, if any. | ||||||||||||||||||
Client | The Client associated with the Fee record, if any. | ||||||||||||||||||
Payee | The Payee associated with the Fee record. | ||||||||||||||||||
Order Partner | The Order Partner associated with the Fee record. | ||||||||||||||||||
Supplier | The Supplier associated with the Fee record. | ||||||||||||||||||
Currency | The currency in which the Fee record is applied. | ||||||||||||||||||
Valid From / Valid To | The date range that the fee or rate is valid for. | ||||||||||||||||||
Last Modified | Which OneStrata user last modified Fee record, and when. |
Reference Data > Commission Tab UI Reference
Column name | Description | ||||||
---|---|---|---|---|---|---|---|
Status | The status of the Commission record:
| ||||||
ID | The OneStrata identification number of the Commission record. | ||||||
Name | The unique name of the Commission record. | ||||||
Valid From / Valid To | The date range that the Commission record is valid for. | ||||||
Commission Commission Percent Client Commission Percentage |
| ||||||
Commission Basis Client Commission Basis |
| ||||||
Agency | The Agency associated with the Commission record. | ||||||
Business Unit | The Business Unit associated with the Commission record. | ||||||
Client Group | The Client Group associated with the Commission record. | ||||||
Client | The Client associated with the Commission record. | ||||||
Product | The Product associated with the Commission record. | ||||||
Media | The Media Type of the Commission record. | ||||||
Cost Category | The Cost Category of the Commission record. | ||||||
Supplier | The Supplier associated with the commission. | ||||||
Default | Whether the Commission record is the default commission for the given level or not.
| ||||||
Last Modified | When the Commission record was last modified. |
...