Last Updated: Tue May 17 2022

Businesses often require the processing of usage event data from a number of different data sources. These sources typically are their own distinct usage format and may contain one or more types of usage (e.g. APIs, Instance counts, CPU time utilization, Data, Voice, SMS …). Mediation is the process of interpreting these usage fields and mapping them to internal constructs that the rating engine can then rate and charge.

Usage files that are to be mediated are uploaded to the system via SFTP or by API. Mediation is essentially an exercise in data mapping. LogiSense provides a visual user interface driven mechanism for mapping feed data and transforming it into entities that the core rating engine can interpret.

Feed Filtering and Exclusions

One or more filters can be applied for any of the sources of data. Filters that can be used to determine if a row in the source data set (File or API body) should be processed through mediation or ignored. As an example, a given source of data may contain a field called Record Type (First Ordinal position on the line) that indicated a “Record Type”. A filter can be setup such that Only lines with a Record Type value of “6” are to be processed. All other lines are ignored.

Conditional Mapping

Many Data Sources have variable mappings of data elements to a Usage record. The mediation process can be set up to account for this. For example, if the line is identified as an "API-GET" record the system may use field 5 for the Usage Identifier where a line identified as API-POST may use field 6. It is also possible to have different source fields mappings based on Conditional statements.

For example, a usage feed may provide twenty fields. When field 5 has a value of "API" the mediation process would use fields 1-6, 10,14,19 ignore the rest and when it has a value of "CPU" it would use 1-6, 9, 11, 13-16. Determination of a usage class is usually a function based on conditions specific to data in the source. LogiSense provides options for managing this thereby allowing reuse of rules and consistency in setting Usage Class values.


One or more "normalization" functions can be created to format things like phone numbers, IP addresses into common inputs. The following types of normalization can be performed on the feed:

Normalization Function Type


Phone Number

Normalize the Phone Number


Normalize Country and Country Code


Normalize Wireless Carrier Source


Normalize the network


Normalize the date and or time

Usage Identifiers

Normalize usage identifiers

Units of Time

Normalize units of measure (time, data etc.)

Mathematical functions like Sum or Multiplication can also be performed on feeds in order to prepare them for rating. For example, a source that sends data usage in Upload and Download will have to have a sum process applied as well as possible normalization on the whole or parts to a standard unit (e.g. KB).

The mediation process may generate exceptions if the incoming feed does not match the mediation rules that were set up for processing the feed. Mediation exceptions are logged in the system and can be viewed on the Setup / Mediation / Import History screen.