Use * syntax for faster search

Table of Contents



Overview

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.


Fees and Rates Terms and Concepts

This section contains information about terms and concepts related to fees and tech rates in OneStrata

Fee Types

There are three ways that a fee or tech rate can be added to a schedule:

Fee TypeDescription

Assigned Fee

The fee is assigned to a specific Placement line.

A pre-existing Assigned Fee record defines how the cost of the Assigned fee is calculated, and the calculated fee cost cannot be changed by the user within the schedule.

Central Fee

The fee is added to a media schedule, with some pre-defined values.

A pre-existing Central Fee record defines how the cost of the Central fee is calculated. Depending on an additional setting, the calculated fee cost can or cannot be changed by the user within the schedule.

Entered Fee

The fee is completely manually added to a media schedule, and has no pre-defined values.

There is no pre-existing Fee record, and all values of the Entered fee are specified by the user within the schedule.


Fee Record Uniqueness Requirements

A Fee record must have a unique combination of the following values, otherwise it cannot be saved:

  • The Name of the record
  • The Valid From date of the record
  • The Rate Type of the record
  • Applicable To details: The Apply at Enterprise level checkbox is selected OR the values of the Agency and Business Unit fields
  • Client Rate details: The values of the Client, Commission, Client Net Rate, and Valid To fields

Only one of the values listed above needs to be different. For example, two Fee records that have different Agency values can be otherwise completely identical.

Client Rate Availability

A client rate defines, for a given Fee record, which client(s) are charged at which rate(s).

A Fee record can only be applied to a campaign (assigned to a specific Placement as an Assigned fee or added to the schedule as a Central fee) if there is at least one available client rate within the Fee record.

If multiple client rates are available, the user can choose which rate to apply:

  • For an Assigned fee, only one client rate can be assigned to a single Placement, but different client rates can be assigned to different Placements in the same campaign.
  • For a Central fee with multiple eligible client rates, only one client rate can be added to the schedule.

A client rate is available if:

  • The client rate is valid (the dates of the client rate overlap the dates of the campaign by at least one day).
  • The client rate is eligible:
    • The level of the client rate includes or matches the client of the campaign.
    • There is no other client rate (within the same Fee record) at a more specific level that also includes or matches the client of the campaign.

For examples, see Client Rate Availability Examples.

Client Rate Levels

Client rates can be created at multiple levels, such that the same fee rate is used for all clients or a specific fee rate is used for specific client(s).

There are three client rate levels:

Client Rate LevelDescription

All Clients

(least specific)

The fee rate can be applied to campaigns for all clients.
Client Group

The fee rate can only be applied to campaigns for clients that are part of the specified Client Group entity/entities.

Client

(most specific)

The fee rate can only be applied to campaigns for the specified Client entity/entities.

Client Rate Dates

A client rate is valid for a campaign if the valid from/to dates of the client rate and the dates of the campaign overlap by at least one day.

The dates of a client rate must fall within the dates of the containing Fee record:

  • The valid-from date of the client rate cannot be earlier than the valid-from date of the Fee record. By default, the valid-from date of the client rate is the same as the valid-from fate of the Fee record.
  • The valid-to date of the client rate cannot be later than the valid-to date of the Fee record.

A Fee record can have multiple client rates for the same client, as long as the valid from/to dates do not overlap. For example, the Client Rate Details section of a Fee record could look like the table below:

ClientCommissionClient Net RateValid FromValid To
All ClientsNone$3.00January 1, 2024June 30, 2024
All ClientsNone$3.25July 1, 2024-
Client Group ANone$2.00January 1, 2024-
Client A1None$1.00January 1, 2024June 30, 2024
Client A1None$1.25July 1, 2024December 31, 2024

Client Rate Availability Examples

As mentioned above:

A Fee record can only be applied to a campaign (assigned to a specific Placement as an Assigned fee or added to the schedule as a Central fee) if there is at least one available client rate within the Fee record.

If multiple client rates are available, the user can choose which rate to apply:

  • For an Assigned fee, only one client rate can be assigned to a single Placement, but different client rates can be assigned to different Placements in the same campaign.
  • For a Central fee with multiple eligible client rates, only one client rate can be added to the schedule.

A client rate is available if:

  • The client rate is valid (the dates of the client rate overlap the dates of the campaign by at least one day).
  • The client rate is eligible:
    • The level of the client rate includes or matches the client of the campaign.
    • There is no other client rate (within the same Fee record) at a more specific level that also includes or matches the client of the campaign.

For example, imagine a Fee record that has the following Client Rate Details section:

ClientCommissionClient Net RateValid FromValid To
All ClientsNone$3.00January 1, 2024June 30, 2024
All ClientsNone$3.25July 1, 2024-
Client Group ANone$2.00January 1, 2024-
Client A1None$1.00January 1, 2024June 30, 2024
Client A1None$1.25July 1, 2024December 31, 2024

 In the following scenarios:

  • Client A1 and Client A2 are part of Client Group A
  • Client B is not part of Client Group A
Campaign ScenarioOutcome
  • Client: A1
  • Dates: June 1, 2024 to December 31, 2024

Both of the Client A1 rates are available, and the user can choose whether to apply the $1.00 rate or $1.25 rate.

  • Client: A2
  • Dates: June 1, 2024 to December 31, 2024

Only the Client Group A rate ($2.00) is available.

The All Clients rate is not available/eligible, because the Fee record contains a more specific client rate (the Client Group A rate), and the most specific rate must be applied.

  • Client: B
  • Dates: June 1, 2024 to December 31, 2024

Both of the All Clients rates are available, and the user can choose whether to apply the $3.00 or $3.25 rate.

  • Client: A1
  • Dates: January 1, 2025 to June 1, 2025

No rates are available, and the Fee record cannot be applied to this campaign:

  • The two Client A1 rates are not available/valid because their dates do not overlap with the campaign dates.
  • The Client Group A and All Clients rates are valid (their dates overlap with the campaign dates by at least one day) but they are not eligible, because the Fee record contains more specific client rates (the Client A1 rates), and the most specific rate(s) must be applied.

    Although the most specific rate is not valid, the Fee record does not "fall back" to a less specific (but valid) rate.


  • No labels
Provide feedback on this article