---
schema_version: "1"
id: 5f38192618c65553192c7c7c7ca9bc73c83208ba91470b17857efe1c6b227be5
title: Create Calculated Insights
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/commerce/264-0-0/om_create_calculated_insights.md
canonical_url: https://help.salesforce.com/s/articleView?id=commerce.om_create_calculated_insights.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8c8822360850006c188a6126cf5f806b10ede3a3055cc2356b59f620467e4434
description: To create your return insights, go to the Calculated Insights tab in Data 360.
products:
  - Commerce
  - Salesforce Order Management
release: "264"
---
# Create Calculated Insights

To create your return insights, go to the Calculated Insights tab in Data 360.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><a href="https://help.salesforce.com/s/articleView?id=commerce.om_editions.htm&amp;language=en_US" target="_blank">View supported editions</a>.</td></tr></tbody></table>

1. Click **New**.
2. Select a data space.
3. Click **Create with SQL**, and then click **Next**.
4. For Calculated Insight Name, enter Om Return Rate By Product.
5. To use the default data space, use the API name Om\_Return\_Rate\_By\_Product\_\_cio. API names are case sensitive. To use a different data space, prefix the API name with the data space’s three character prefix.
6. Enter the SQL Query.
    1. To use the default data space, enter SELECT ssot\_\_SalesOrderProduct\_\_dlm.ssot\_\_ProductId\_\_c as product\_\_c, SUM(ssot\_\_SalesOrderProduct\_\_dlm.ssot\_\_ProductReturnQuantity\_\_c)/SUM(ssot\_\_SalesOrderProduct\_\_dlm.ssot\_\_AvailableQuantity\_\_c) as return\_rate\_\_c FROM ssot\_\_SalesOrderProduct\_\_dlm WHERE ssot\_\_SalesOrderProduct\_\_dlm.ssot\_\_SalesOrderProductSubType\_\_c = 'Product' GROUP BY ssot\_\_SalesOrderProduct\_\_dlm.ssot\_\_ProductId\_\_c
    2. To use a different data space, build the query according to your data space
7. Click **Check Syntax**. Confirm that it shows Valid Syntax.
8. Click **Activate**. Set a schedule, and then click **Enable**.
9. Click **Publish Now**. If this option doesn’t show, open the action menu.

#### See Also

- [Return Insights Overview](https://help.salesforce.com/s/articleView?id=commerce.om_return_insights.htm&release=264.0.0&type=5 "Use Einstein to identify products with high return rates and analyze the reasons that customers are retuning them.")
- [Return Insights Setup](https://help.salesforce.com/s/articleView?id=commerce.om_return_insights_setup.htm&release=264.0.0&type=5 "You can complete most of the initial Einstein configuration using the Data 360 Setup Guide.")