Product Group Margin Variance Agent (Reference)

The Product Group Margin Variance Agent identifies SKUs whose margin rate underperforms relative to the average margin rate of their product group. It analyzes recent revenue and margin data at both product and product group level, then quantifies the margin gap and potential uplift if low‑performing SKUs were brought closer to segment norms.

List of Required Fields

The following table lists the set of transaction fields required for the Product Group Margin Variance 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.

Definition

Series 1 (Revenue and Margin by Product)

Group By

Measures

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 > custom N months ago 3 (1/21/2026)

Summary Table

• 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 third-level grouping dimension selected in the Group By definition. Product groups represent categories used to organize products.

• Revenue – The aggregated sum of invoice price (revenue) for each product within the selected period,

• Profit – The total gross margin amount for each product, calculated as the difference between realized price and cost for all transactions in the selected period.

• Avg Margin % – The average margin rate per product, computed as profit divided by revenue over the selected period

Series 2 (Avg Margin by Product Group)

Group By

Measures

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.

• Date window – Include transactions where the Invoice Date falls between the chosen anchor date, to isolate a three‑month historical window.

• Value sanity checks – Include only records, so that analyses consider meaningful, billable transactions.

• Cost-focused analyses – When evaluating cost–price alignment, it is reasonable to exclude records with missing or zero cost.

Example

Pricing Date > custom N months ago 3 (1/21/2026) AND Invoice Price > 0 AND Invoice Price is not null.

Summary Table

• Product Group – The product group level that specifies each grouped row in Series 2.

• Avg Margin % – The product group’s average margin rate, calculated as total gross margin divided by total revenue for all products in the group.

• Standard Deviation Margin % – The standard deviation of product‑level margin rates within the product group, indicating how dispersed margins are around the group average.

• IQR Margin % – The interquartile range of product‑level margin rates, capturing the spread of the middle 50 % of margin values within the group.

• Quartile 1 Margin% – The first quartile (Q1) margin rate, below which 25 % of product margin rates in the group fall.

• Quartile 3 Margin% – The third quartile (Q3) margin rate, below which 75 % of product margin rates in the group fall.

Join Series (Join Series)

Definition

Set up the relationship between the series by mapping the matching data columns/dimensions that you would like to include in the definition.

Measures

Summary Table

• MarginVarianceToMinimum – The difference between an account's margin rate and the relevant benchmark (e.g., segment or portfolio average), quantifying the degree of underperformance.

• Margin Uplift – The potential profit uplift for a customer if their margin rate were increased to the average of their own margin rate and the segment average.

• Revenue – The aggregated sum of invoice price for all included transactions.

• MarginLiftPotentialPct – The potential profit uplift (percentage) per product if their margin rate were raised to the relevant benchmark.

• Revenue Uplift – The estimated additional profit that could be realized if the subject’s margin rate were improved to the average of its current margin rate and the relevant benchmark (such as a segment average).

• Current Margin % – The weighted gross margin percentage for the current period, computed as total margin divided by total revenue (invoice price).

• Suggested Margin % – The recommended interim margin rate set at the midpoint between the current margin rate and the benchmark/target margin rate (e.g., segment average).

• Segment Average Margin % – The weighted average gross margin rate for a given segment over the selected period, computed as total margin divided by total revenue across all entities in that group. This is used as a benchmark in variance and uplift analyses.

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.
Default thresholds are flexible, adjust as necessary.

Example

SKUs with no improvement potential are ignored.

MarginVarianceToMinimum > 0

Schedule

Set the preferred start date and frequency that you want the Agent to run.

Example

The agent runs monthly, recomputing series, margin variance, and uplift metrics over the last N months of data and evaluating the detection rule each time.

Start Date – The date when the scheduled task will run for the first time.
Period – Period which represents the offset between each run.
Interval – Interval which represents the number of repetitions in a selected period. Allowed characters are 0-9. 0 means one-off run.

Action Definition

Example

Similar Case Handling

• Period – Defines the time period between potential similar action. Similar case will not be recreated before the defined period. Time unit for the duplicate-prevention window.

• Interval – Number of periods between similar actions. Similar case will not be recreated before the defined interval. Prevents creating a very similar case for the same context within the defined interval.

Example

Prevents creating a very similar case for the same context within a 3-month period.

Impact Calculation

You can define specific metrics to compute the foreseen impact of the actions. Please only use total absolute value (and not relative values) as those metrics will be aggregated.

Impact Definition

• Revenue Uplift – Expected realized portion (50 %) of the theoretical revenue uplift estimated by the Join Series.

• Margin Uplift – Expected realized portion (40 %) of the theoretical margin uplift estimated by the Join Series.

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.