High Buyback Customers Agent (Reference)

The High Buyback Customers Agent continuously scans transactional data (with returns captured as negative quantities) over a rolling time window to compute return rate per customer and identify those with abnormally high buyback behavior or return rates that negatively impact profitability.

List of Required Fields

The following table lists the set of transaction fields required for the High Buyback Customers 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.

GrossMargin

Gross Margin

The absolute margin in value terms (Revenue minus Cost of Goods Sold), before overhead allocation.

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.

Quantity

Quantity

The number of units sold or transacted in the given period.

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] Standard Sales Data (Standard_Sales_Data)

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

Customer Id

Level 1

Customer Name

Level 2

Product Group

Level 3

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

Revenue used to quantify returned sales value in the analyzed period.

Quantity

Quantity

Quantity

Quantity of transacted units, including returns recorded as negative quantity.

Quantity

Return %

{ }

ReturnRate

Percentage of returned or buyback quantity versus total sold quantity for a customer.

Invoice Price

Potential Revenue

{ }

PotentialRevenue

Estimated revenue exposure linked to returned or buyback transactions for a customer.

Gross Margin

Potential Profit

{ }

PotentialProfit

Estimated profit exposure linked to returned or buyback transactions for a customer..

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

Evaluate transactions from the last three months up to today, with returns and buybacks recorded as negative quantities.

Pricing Date between (inclusive) custom N months ago 3 (1/20/2026) AND custom Today (4/20/2026)

Summary Table

Customer Id

Customer Name

Product Group

Revenue

Quantity

Return %

Potential Revenue

Potential Profit

CID-0001

Stanley Linda CPA US Global customer CA

Electrical Protection and Control

120133.593

911

0

0

0

CID-0002

Stanley Linda CPA US Sold-to CA

Electrical Protection and Control

98753.447

970

0

0

0

  • Customer ID – The top-level grouping dimension selected in the Group By definition. Rows are organized by Customer ID.

  • Customer Name – The Customer Name used as the next grouping level within the table hierarchy.

  • Product Group – Optional grouping level that narrows the analysis to specific product families, as referenced in the action description.

  • Revenue – Total invoiced value of transactions in the analysis period, including the effect of returns and buybacks recorded as negative amounts.

  • Quantity – Net invoiced quantity over the analysis period, with returns and buybacks stored as negative quantities.

  • Return % – The calculated return or buyback rate per customer (and product group) over the selected three-month horizon.

  • Potential Revenue – Estimated additional revenue that could be achieved if the identified high-buyback behavior is corrected according to the agent’s methodology.

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.

info Default thresholds are flexible, adjust as necessary.

Example

This rule flags customers whose realized return / buyback rate is higher than 1%, marking them as high‑buyback customers.

Series

Rules

Series 1 (Transactions)

Return % > 0.01

Schedule

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

Example

Start Date

Period

Interval

4/20/2026 1:53 PM

Month

1

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

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

High Buyback Customer Agent

Listing customers that have a high buyback for specific product groups

in 1 Month

First Name Last Name

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.

Item

Value

Period

Month

Interval

3

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

Measure

Impact Type

Realization Rate (%)

Order

Potential Revenue

Revenue

50

1

Potential Profit

Profit

50

2

  • Potential Revenue – Estimated additional revenue that could be realized if the high buyback behavior is corrected, with a 50% realization rate used to keep expectations conservative.

  • Potential Profit – Estimated profit improvement from reduced returns and buybacks, also modeled with a 50% realization rate.

  • Order – Defines the display order of these impact metrics when summarizing the actions created by the agent.

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.