Use * syntax for faster search
Page History
Section | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
OneStrata has a large number of fields and terms related to costs and cost calculations, in order to effectively handle complex pricing scenarios that may involve multiple types of currencies.
- Cost Methods
- Currencies
- Cost Types
- methods: The cost method defines what types of cost-related fields interact in which types of ways, in order to determine what is billed to the client, what is paid to the vendor, and what is income to the agency
- Agency, Client, and Vendor Currencies: What type of currency or currencies the agency, client, and vendor transact in.
- Cost Types: Cost- and rate-related fields
- Rate Types: The primary unit type and rate being purchased
Anchor | ||||
---|---|---|---|---|
|
The cost method of a Schedule grid line defines what type of cost-related fields are available or editable, and how they are calculated. Each top-level line on the Schedule grid (a Cost Package, a standalone Media Package, or a standalone Placement) can have a different cost method.
There are three cost methods:
- Standard (default)
Margin
- Allocated
Cost Method | Description | |||||
---|---|---|---|---|---|---|
|
Cost Methods are like pricing models; they define which Schedule Grid fields accept user-inputted values and which formulas are applied to those fields in order to calculate what is paid to the Vendor or billed to the Client. Each top-level line on a Schedule Grid (a Cost Package, a Media Package that is not part of a Cost Package, or a Placement that is not part of a Media or Cost Package) can apply a different Cost Method.
OneStrata has three Cost Method options:
- Standard Cost Method
- Margin Cost Method
- Allocated Cost Method
Depending on Enterprise or Agency settings, the Margin Cost Method and Allocated Cost Method options might not be available.
|
In the Standard cost method, vendor costs and |
clients are directly connected:
|
|
|
|
|
| ||||
|
|
Vendor costs and Client costs are calculated separately: Vendor Net Cost =/= Client Net Cost
- The difference between the Vendor Net Cost and the Client Net Cost creates a "margin", which is income to the Agency.
- If one set of Vendor costs are defined, the other Vendor Cost Types can be calculated from that set but the Client Cost Types cannot, and vice versa.
- Vendor and Client costs are connected by the Margin Percentage value. For example, Vendor Net Cost = Client Net Cost - (Client Net Cost x Margin Percentage)
Used for when the agency is charging the client a fee, which is a % of the cost of the media plus that allocated fee. So user enters the Allocated amount for the line, applies and allocated fee, then the client net cost of that line = the allocated amount less any of the allocated fees. Then all other costs and rates are calculated form the client net cost using the standard set of formulas
- Used when the Agency is charging the client a fee that is a % of the cost of the media plus that allocated fee.
- Add media budget including a Percentage of Media fee into the Allocated Amount (CC).
Margin Cost Method
| In the Margin cost method, vendor costs and client costs are not directly connected:
Vendor costs and client costs are connected by a third value, the Margin Percentage value:
| ||||||||
| In the Allocated cost method, a fixed amount of money has been "allocated", or set aside, to cover both the cost of the media purchase and any related fees. Costs are calculated in the following order:
|
Anchor | ||||
---|---|---|---|---|
|
OneStrata provides support for up to three different currencies within a single transaction:
- Agency Currency, or AC for short
- Client Currency, or CC for short
- Vendor Currency, or VC for short
Costs and rates are shown in one or more of these currencies, with AC, CC, orVC appended to indicate which currency type the value is in.
Currency Type | Description | Origin | ||
---|---|---|---|---|
|
OneStrata provides support for up to three different currencies within a single transaction:
- Vendor Currency, or VC for short
- Agency Currency, or AC for short
- Client Currency, or CC for short
Costs and rates are shown in one or more of these currencies, with VC, AC, or CC appended to indicate which currency type the value is in.
VC
Payable Currency
A Shared Block | ||
---|---|---|
| ||
The currency in which the Agency pays the Vendor. Each cost line in a campaign can be in a different Vendor Currency. |
Vendor Currency is defined in the Vendor Contract: Administration > Entity Management > Contracts > (Specific Contract)
A contract may have one or more Vendor Currencies.
AC Base Currency Local Currency |
| Agency Currency is defined |
on the Agency record |
, on the Administration > Entity Management > Agencies > (Specific Agency) > Details tab. Each Agency has only one Agency Currency. | |||||||||||||
CC Billing Currency |
| Client Currency is defined |
on the Client record |
, on the Administration > Entity Management > Clients > (Specific Client) > Details tab. Each Client has only one Client Currency. | |
|
|
|
|
|
Vendor Currency VC Payable Currency |
| Vendor Currency is defined on the Contract record, on the Administration > Entity Management > Contracts > (Specific Contract) tab. A Contract may have one or more Vendor Currencies. |
Anchor | ||||
---|---|---|---|---|
|
In OneStrata, cost types—fields related to calculating costs—are broadly grouped into three types:
- Client costs: Costs between the agency and the client
- Vendor costs: Costs between the agency and the vendor
- Other costs: Non-client-related and non-vendor-related costs
When a cost type is displayed or used, it specifies which type of currency the cost type is in:
- Example: Vendor Net Cost (VC) refers to the vendor net cost, displayed in the Vendor Currency
- Example: Vendor Net Cost (CC)refers to the vendor net cost, displayed in the Client Currency
Table Filter | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In OneStrata, Cost Types—fields related to calculating costs—are broadly grouped into three types:
- Client costs
- Vendor costs
- Other costs
When a Cost Type is displayed or used, it specifies which Currency Type the Cost Type is in. For example, Vendor Net Cost (VC) or Vendor Net Cost (CC).
Table Filter | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cost Type Group | Cost Type | Description | Origin | Calculation (Cost Model Standard With 1 Tax) | Client | Anchor | Client-Commission | Client-Commission | Client Commission
Calculated | Client Commission = Client Commission Percentage x Client Commission Basis
Client Commission % Commission Percent
The Cost Type that the Client Commission Percentage is applied to:
N/A | Client | Anchor | Client-Discount | Client-Discount | Client DiscountClient Passback The amount of the Vendor Discount that the Agency passes on to the Client. Calculated | Client Discount = Vendor Discount x Client Passback Percentage | Client | Anchor | Client-Discount-Percentage | Client-Discount-Percentage | Client Discount PercentageClient Discount Rule Client Discount % The percentage of Vendor Net Cost or Vendor Gross Cost that the Agency passes on the Client as a discount. Calculated | Client Discount Percentage = Vendor Discount Percentage x Client Passback Percentage | Client | Client Gross Cost Anchor | Client-Gross-Cost | Client-Gross-Cost | Client Gross
Client Gross = Vendor Gross Client | Client Net Cost Anchor | Client-Net-Cost | Client-Net-Cost | Client Net
Client Net = Client Gross - Client Discount Client | Anchor | Client-Passback-Percentage | Client-Passback-Percentage | Client Passback PercentageClient Passback Rule Client Passback % The percentage of the Vendor Discount that the Agency passes on to the Client. | Defined in Administration > Entity Management > Client > (Specific Client) > PassbacksN/A | Client | Anchor | Client-Rate | Client-Rate | Client Rate
N/A Client | Anchor | Client-Tax | Client-Tax | Client TaxThe tax on activity that the Agency charges the Client, not including any commission. | Calculated | Depending on Client Tax Rule settings:
Client | Anchor | Client-Tax-on-Commission | Client-Tax-on-Commission | Client Tax on Commission
Calculated | Client Tax on Commission = Client Tax Rule x Client Commission | Client | Client Total Cost Anchor | Client-Total-Cost | Client-Total-Cost | Client Total
Client Total = Client Net + Client Commission | Client | Client Total Cost with Tax Anchor | Client-Total-Cost-with-Tax | Client-Total-Cost-with-Tax | Client Total with Tax
Calculated | Client Total Cost with Tax = Client Total + Client Tax on Cost + Client Tax on Commission | Vendor | Anchor | Vendor-Discount-Percentage | Vendor-Discount-Percentage | Vendor Discount PercentageVendor Discount Rule Vendor Discount % The percentage of Vendor Net Cost or Vendor Gross Cost that the Vendor gives to the Agency as a discount. Defined in Administration > Entity Management > Contracts > (Specific Contract) | N/A | Vendor | Anchor | Vendor-Discount | Vendor-Discount | Vendor DiscountVendor Discount Cost
Calculated | Depending on the Vendor contract:
Vendor | Anchor | Vendor-Gross-Cost | Vendor-Gross-Cost | Vendor Gross CostVendor Gross
Vendor Gross = Vendor Net + Vendor Discount | Vendor | Anchor | Vendor-Net-Cost | Vendor-Net-Cost | Vendor Net
Vendor Net = Vendor Gross - Vendor Discount | Vendor | Anchor | Vendor-Rate | Vendor-Rate | Vendor Rate
N/A Vendor | Anchor | Vendor-Tax-Cost | Vendor-Tax-Cost | Vendor Tax CostVendor Tax
Calculated | Depending on Vendor Tax Rule settings:
Vendor | Anchor | Vendor-Total-Cost | Vendor-Total-Cost | Vendor Total CostVendor Total
Other | Margin Percentage Anchor | Margin-Percentage | Margin-Percentage | Margin Rule Margin %
Margin Percentage = (Client Net Cost - Vendor Net Cost) / Client Net Cost | Other | Anchor | Allocated-Amount | Allocated-Amount | Allocated Amount
Entered in schedule | N/A Other | Anchor | Allocated-Fee-Cost | Allocated-Fee-Cost | Allocated Fee Cost
|
Anchor | ||||
---|---|---|---|---|
|
A rate type indicates the primary unit type and cost per unit negotiated between an agency buyer and a vendor for a media purchase.
The following table is a list of available rate types:
- Rate Divider: A number by which the rate is divided, when calculating costs
- If the Rate Divider is 1000, this means that the unit type is purchased at a cost per mille/thousand (CPM/CPT) rate.
- For example, if the rate type is CPM (Impressions), the Units value is 100,000, and the Vendor Net Rate is $1.00, this means that:
- Units: 100,000 impressions are purchased
- Rate (Vendor Net Rate): $1.00 per 1,000 impressions
- Cost (Vendor Net Cost): $100.00 (= 100,000 units x ($1.00 / 1,000 units))
- Available For Schedule Lines: Whether or not the rate type can be added to a Schedule grid line
- Available for Fee Records: Whether or not the rate type can be added to a Fee record
Table Filter | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|