The Freight Margin Agent helps identify hidden margin erosion by comparing freight charges with actual freight costs across customers, countries, and product groups, showing where shipping costs are not fully recovered.
List of Required Fields
The following table lists the set of transaction fields required for the Freight Margin Agent to compute its metrics and detection rules. Ensure these fields or equivalent are available and consistently populated in your source Transaction Datamart before deploying the Agent. Those exact field names are not required, but a similar fields with that data is required.
|
Name |
Label |
Description |
|---|---|---|
|
CustomerId |
Customer Id |
A unique identifier for the customer account. |
|
CustomerName |
Customer Name |
The display name of the customer account. |
|
Freight_Charge |
Freight Charge |
The freight amount billed to the customer on the invoice. |
|
Freight_Cost |
Freight Cost |
The actual internal cost incurred to ship the product. A gap between this and Freight Charge indicates freight subsidy or overcharge. |
|
InvoicePrice |
Invoice Price |
The price actually charged to the customer on the invoice. The realized transaction price. |
|
PricingDate |
Pricing Date |
The date on which the transaction or pricing event occurred. |
|
ProductGroup |
Product Group |
A category grouping products by type, business line, or market segment. |
Definition
Series 1 (Transactions)
|
Item |
Value |
Description |
|---|---|---|
|
Data Label |
Transactions |
Sets a label (name) of the Series1 data series (data set). Data label can be freely customized and renamed according to your preferences. |
|
Data Source |
[DM] Transactions (Transactions) |
Selected Transaction Datamart. For more information see Required Customer Data. |
|
Currency |
USD |
Defines which currency the money data will be converted into. |
Group By
|
Group By |
Level |
|---|---|
|
Product Id |
Level 1 |
|
Product Name |
Level 2 |
|
Product Group |
Level 3 |
|
Country |
Level 4 |
The specific field names may vary depending on the set of fields in your source Transaction Datamart. The selected fields will be utilized to establish the grouping hierarchy in the Summary Table of the Current Period Series. For additional information about grouping, see the Group section
Measures
|
Measure |
Label |
Aggregation |
Name |
Description |
|---|---|---|---|---|
|
Invoice Price |
Revenue |
∑ |
Revenue |
The aggregated sum of invoice price for all included transactions. |
|
Freight Charge |
Freight Cost Recovery % |
{ } |
FreightCostRecoveryRate |
The percentage of freight cost recovered through freight charges over the filtered scope. |
|
Freight Charge |
Freight Recovery Missed Opportunity |
{ } |
FreightRecoveryMissedOpportunity |
The unrecovered freight amount in value terms: the gap between freight cost and freight charge when freight cost is higher, used to quantify missed freight recovery. |
|
Freight Charge |
Freight Charge To Revenue |
{ } |
FreightChargeToRevenue |
The share of revenue represented by freight charges, i.e. freight charge divided by invoice price / revenue. |
|
Freight Cost |
Freight Cost To Revenue |
{ } |
FreightCostToRevenue |
The share of revenue consumed by freight cost, i.e. freight cost divided by invoice price / revenue. |
|
Freight Charge |
Opportunity % |
{ } |
OpportunityRate |
The net freight recovery gap relative to revenue. |
The specific measures may vary depending on the set of fields in your source Transaction Datamart.
Filters
Filters are criteria applied to transactional data to ensure only valid records are analyzed, commonly excluding zero-value transactions and constraining invoice dates using relative ranges computed from a configurable anchor date, specified as N months ago.
Example
Pricing Date between(inclusive) custom N nonths ago 3 (1/8/2026) AND custom Today (4/8/2026)
Summary Table
|
Product Id |
Product Name |
Product Group |
Country |
Revenue |
Freight Cost Recovery % |
Freight Recovery Missed Opportunity |
Freight Charge To Revenue |
Freight Cost To Revenue |
Opportunity % |
|
A9N17518 |
iDPN - circuit breaker - iDPN N - 1P + N - 13A - B curve |
Electrical Protection and Control |
Austria |
1042.86287 |
0.079561665 |
6.5271492 |
0.084925855 |
0.078666979 |
0.006258876 |
|
A9N17518 |
iDPN - circuit breaker - iDPN N - 1P + N - 13A - B curve |
Electrical Protection and Control |
Belgium |
650.514527 |
0.075007076 |
3.9962 |
0.088043906 |
0.081900769 |
0.006143137 |
-
Product Id – The top-level grouping dimension selected in the Group By definition. Rows are organized by Product Id.
-
Product Name – The Product Name used as the next grouping level within the table hierarchy.
-
Product Group – The higher‑level product categorization corresponding to the Level 3 group in Group By.
-
Country – The country level that further specifies each grouped row.
-
Revenue – The aggregated sum of invoice price for the grouped rows (same as Revenue measure).
-
Freight Cost Recovery % – Percentage of freight cost recovered via freight charges over the filtered scope.
-
Freight Recovery Missed Opportunity – The unrecovered freight amount where freight cost exceeds freight charge.
-
Freight Charge To Revenue – Share of revenue represented by freight charges (freight charge / revenue).
-
Freight Cost To Revenue – Share of revenue consumed by freight cost (freight cost / revenue).
-
Opportunity % – Net freight recovery gap relative to revenue.
Detection Rules
Detection Rules defines the Agent’s alert conditions and includes scheduling. When conditions are met, actions are triggered during the next Agent run.
This rule focuses on situations where Freight Recovery Missed Opportunity is below zero, which generally suggests a negative freight recovery outcome or a shortfall against the expected freight recovery level.
Example
|
Series |
Rules |
|---|---|
|
Series 1 (Transactions) |
|
Schedule
Set the preferred start date and frequency that you want the Agent to run.
Example
|
Start Date |
Period |
Interval |
|---|---|---|
|
04/08/2026 12:56 |
Month |
1 |
Action Definition
Notifications assigned to specific users (The assignment must be made to a genuine system user). For more information see Action Definition.
Example
|
Summary |
Description |
Due Date |
Assign to |
|---|---|---|---|
|
Product Freight Agent |
Listing products where freight costs are not fully recovered for a specific country |
in 1 month |
|
Summary
Review the setup of the Agent, here you can see all the set parameters in one place.
If you are happy with the setup, click Submit for Approval. Once the Agent is approved, it becomes active and starts monitoring your data based on the schedule.
Review the final results in the Summary step.