> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/sales-insights/understand-calculations/understand-cross-sell-opportunity-calculations.md).

# Understand cross-sell opportunity calculations

Learn how Sales Insights identifies cross-sell opportunities, measures purchasing relationships, and estimates potential upside.

[**Cross-sell opportunities**](https://docs.phocassoftware.com/sales-insights/explore-customer-insights/review-a-customer-profile/review-cross-sell-opportunities.md) identify products a customer might be interested in buying, based on purchasing patterns across your customer base. **Cross-sell Group** opportunities identify similar opportunities across broader product groups.

Sales Insights analyzes historical sales transactions to find products and product groups that customers frequently buy together. It then compares these patterns with an individual customer's purchasing behavior to identify potential opportunities.

The recommendations and their estimated values help you prioritize opportunities and prepare for customer conversations. They're based on historical purchasing patterns, rather than predictions of what a customer will buy.

### Data used

Cross-sell opportunities are based on sales transactions from the **last 365 days**, up to the date the analysis was last run. The analysis typically runs overnight, so recent purchases might not appear until the next update.

The analysis uses the following transaction data:

* **Customer and product details:** Identify which customers purchase which products.
* **Transaction dates and order numbers:** Show when purchases occurred and which products were purchased together.
* **Quantities and sales values:** Determine the size and value of purchases.
* **Product groups:** Identify relationships between broader groups of products, when configured.

The product, product group, and quantity fields are selected during [customer profile setup](https://docs.phocassoftware.com/sales-insights/set-up-and-manage-sales-insights/set-up-a-database.md#customer-profile).

### How cross-sell opportunities are identified

The analysis identifies products or product groups that customers frequently purchase together. It then compares these patterns with an individual customer's purchases to find potential opportunities.

The process involves three steps:

1. **Identify purchasing patterns:** Find products or product groups that customers frequently buy together.
2. **Find opportunities:** Compare these patterns with the customer's recent purchases to identify products or groups they aren't buying.
3. **Estimate potential value:** Use the customer's related purchases and other customers' buying patterns to estimate the opportunity's value.

For example, suppose a customer regularly buys floor cleaner but hasn't purchased flat mop sets in the last year. If other customers who buy floor cleaner also frequently buy flat mop sets, Sales Insights might identify a cross-sell opportunity for flat mop sets.

**Similar customers** are customers who buy the related product or product group. They aren't necessarily similar in size, industry, or purchasing volume.

The analysis identifies two types of opportunities:

* **Cross-sell:** Recommends individual products based on purchasing relationships between products.
* **Cross-sell Group:** Recommends product groups based on relationships between groups. These opportunities can reveal gaps across different sizes, brands, or product variants.

Product group relationships can be identified from purchases made across a period, rather than products purchased together on the same invoice.

Unlike Reorder (Group) opportunities, which group individual reorder opportunities, **Cross-sell Group opportunities are separate recommendations**. They're calculated using purchasing patterns between product groups rather than simply combining individual product opportunities.

### Understanding purchasing relationships

Cross-sell opportunities include information about the purchasing patterns behind each recommendation. Use these figures to understand why a product or product group has been suggested.

| Information shown                                                 | What it means                                                                                                                                                                                                                                      |
| ----------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Frequently bought by customers who also buy**                   | The percentage of customers who buy the related product or group and also buy the recommendation. For example, **Outside: 81% of customers** means approximately 81% of Outside buyers also buy MV Lighting.                                       |
| **Similar customers buy** (Cross-sell Group)                      | Individual products from the recommended group purchased by customers who buy the related group. For example, **Outside buyers 1.8x more likely** means a product is about 1.8 times as common among Outside buyers compared with other buyers.    |
| **Most popular products by quantity annually** (Cross-sell Group) | The recommended group's bestsellers by quantity across customers over the last 12 months, using the quantity measure selected during customer profile setup. These are historical quantities, not predicted purchases for the individual customer. |

The percentages and comparisons describe historical purchasing patterns, not the chance that an individual customer will buy a recommended product. A product can appear in both the similar customers and popular products lists.

### Potential upside

The **potential upside** shown for each cross-sell opportunity represents its estimated additional annual revenue. It helps you compare the potential value of different recommendations.

The estimate is calculated differently for individual products and product groups:

| Opportunity                         | What the estimate uses                                                                                                                                                                                                              |
| ----------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Cross-sell (individual product)** | The customer's purchases of related products and the quantities typically purchased by customers who buy both products. Historical selling values for the recommended product provide a reference value for the estimated quantity. |
| **Cross-sell Group**                | The customer's spending in the related product group and spending patterns among customers who buy from both groups. The calculation uses spending rather than individual product quantities.                                       |

**Example: Individual product.** If a customer regularly buys floor cleaner but hasn't purchased flat mop sets, their floor-cleaner purchases and other customers' buying patterns inform the estimated quantity and value of a flat mop set opportunity. The historical reference selling value might differ from the price you quote to the customer.

**Example: Product group.** If customers who buy Electrical products also frequently purchase Lighting products, the customer's Electrical spending and other customers' spending patterns inform the estimated value of a Lighting group opportunity.

Although Cross-sell Group opportunities display popular products and their sales quantities, the group's potential upside is based on spending patterns rather than individual product quantities.

**Potential upside is an estimate, not a forecast or guarantee of future sales.** Actual revenue depends on whether the customer purchases the recommended products, the quantities ordered, and the prices paid.

### Why values might not match

If your calculations differ from the values shown in a cross-sell opportunity, consider whether:

* You're using the same 365-day period as the analysis.
* Recent transactions haven't been included in the latest overnight update.
* You're comparing individual products rather than product groups.
* You're using different selling prices or quantities to estimate the opportunity's value.
* Purchasing patterns across other customers have changed.

These differences don't necessarily indicate a problem with your data. They can result from how Sales Insights identifies purchasing relationships and estimates potential opportunities.

Cross-sell recommendations are based on purchases recorded in your database. A customer might already purchase the recommended product from another supplier.

### FAQs

Here are answers to some frequently asked questions about cross-sell opportunities in Sales Insights.

1. **Why isn't a product shown as a cross-sell opportunity?**\
   A product might not appear if the customer already purchases it, there isn't enough evidence of a repeated purchasing relationship, or the estimated opportunity value isn't meaningful.
2. **Why does a Cross-sell Group opportunity have a different potential upside from individual product opportunities?**\
   Cross-sell Group opportunities are calculated separately using spending patterns between product groups. Individual product opportunities use estimated quantities and historical selling values. As a result, their estimated values can differ.
3. **Does a high purchasing percentage mean the customer is likely to buy the product?**\
   Not necessarily. The percentage describes how frequently customers purchase both products. It doesn't predict whether an individual customer will purchase the recommended product.
4. **Why has an opportunity changed or disappeared?**\
   Opportunities are updated daily as new transactions become available. Changes in the customer's purchases or wider purchasing patterns can affect which opportunities are identified and their estimated values.
5. **Is potential upside a forecast?**\
   No. It's an estimate based on historical purchasing patterns. It helps you assess the potential value of an opportunity but doesn't predict or guarantee future revenue.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.phocassoftware.com/sales-insights/understand-calculations/understand-cross-sell-opportunity-calculations.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
