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.
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) |
|
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 |
|
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.