B2C Commerce calculates several attributes or uses them to calculate extra metrics, including: availability, cost price, item age, SKU coverage, and TTOOS (time to out of stock).
To see the collected information, click App Launcher 
, and then select .
Each standard attribute has a specific use. Salesforce doesn’t recommend that you use attributes for other than their designated use. For example, don't use the costPrice attribute to import non-cost price data. Imported values are often used to calculate other metrics, so importing data into an attribute or not supplying information for imported attributes can affect other attributes.
To feed in more data, create custom attributes for the
ProductActiveData and CustomerActiveData business
objects.
Multiple systems can feed attribute data in different import cycles. For example, a third-party system can feed product review data daily, while a backend system can feed return rate information weekly.
Active data feeds contain the attributes listed under the Type column of the following tables as the Imported type.
Feeds can also include custom attributes added to the ProductActiveData and CustomActiveData business objects.
Near-time attribute data is updated within a day–data is collected in real time during the business day, aggregated overnight, and delivered to you the next day. Real-time attribute data can be updated on-demand from your live B2C Commerce production site.
Currently, the following fields are available and supported for Product Active Data export:
productID, revenueDay, unitsDay, ordersDay, impressionsDay, viewsDay,
avgSalesPriceDay, conversionDay, revenueWeek, unitsWeek, ordersWeek, impressionsWeek,
viewsWeek, avgSalesPriceWeek, conversionWeek, revenueMonth, unitsMonth, ordersMonth,
impressionsMonth, viewsMonth, avgSalesPriceMonth, conversionMonth, revenueYear,
unitsYear, ordersYear,impressionsYear, viewsYear, avgSalesPriceYear,
conversionYear
Active Data Product Attributes
| Attribute | Description | Type | Sample Value | Period |
|---|---|---|---|---|
| Availability | Ratio between inventory allocation and current stock level. | Real-Time | 0.59 | N/A |
| Cost Price | The cost of goods sold for the product. | Imported | 10.19 | N/A |
| SKU Coverage | Ratio between total number of variation products and their availability status. | Real-Time | 0.90 | N/A |
| Time to Out of Stock (TTOOS) | Estimated time in hours before product goes out of stock. | Real-Time | 14 | N/A |
| Return Rate | The percentage of orders that result in the product being returned. | Imported | 4.5% | N/A |
| Average Sales Price | The average sales price for the product in orders, after discounts. | Near-Time | 13.99 | Day, Week, Month, Year |
| Impressions | The number of times the product appeared on a search results page, was recommended to a customer, or appeared as a member of a product set. | Near-Time | 17774 | Day, Week, Month, Year |
| Views | The number of times the product appeared on a product details page. | Near-Time | 564 | Day, Week, Month, Year |
| Revenue | The total revenue for the product. | Near-Time | 2244.66 | Day, Week, Month, Year |
| Units | The number of units of the product ordered. | Near-Time | 456 | Day, Week, Month, Year |
| Conversion | The number of orders for the product divided by the number of visits in which a customer viewed the product. Also known as the Look To Book ratio. | Near-Time | 4.7% | Day, Week, Month, Year |
| Days Available | The number of days since the product became available, based on the imported Available Date for the product. If no available date has been imported, the system uses the date the product was created. | Real-Time | 5 | |
| Average Gross Margin Value | The average sales price minus the cost of goods sold for the product. | Near-Time | 3.80 | Day, Week, Month, Year |
| Average Gross Margin Percent | The average gross margin value divided by the average sales price for the product. | Near-Time | 27.2% | Day, Week, Month, Year |
| Look To Book Ratio | The number of orders for the product divided by the number of visits in which a customer viewed the product. | Near-Time | 5.0% | Day, Week, Month, Year |
| Sales Velocity | The number of units sold divided by the number of hours. | Near-Time | 30.8 | Day, Week, Month, Year |
Active Data Customer Attributes
| Attribute | Description | Type | Sample Value | Period |
|---|---|---|---|---|
| Visits | The number of times the customer visited the site. | Near-Time | 9 | Week, Month, Year |
| Orders | The number of orders placed by the customer. A customer is credited with all orders placed in a visit, even if they place an order before logging in. | Near-Time | 21 | Lifetime |
| Returns | The number of return orders placed by the customer. A customer receives credit for all orders returned in a visit, even if they return an order before logging in. | Near-Time | 1 | Lifetime |
| Return Value | The amount of negative revenue for the customer due to returns. | Near-Time | 9.99 | Lifetime |
| Order Value | The amount of revenue for the customer minus the return value. | Near-Time | 2387.89 | Month, Lifetime |
| Average Order Value | The amount of revenue for the customer divided by the number of orders. | Near-Time | 127.51 | Lifetime |
| Discount Value without Coupon | The discount amount on customer orders applied for implicit (that is, not coupon) promotions. | Near-Time | 188.45 | Lifetime |
| Discount Value with Coupon | The discount amount on customer orders applied for coupon promotions. | Near-Time | 90.00 | Lifetime |
| Source Code Orders | The number of customer orders with a source code applied. | Near-Time | 7 | Lifetime |
| Gift Units | The number of product units marked as "gift" on customer orders. A customer receives credit for all orders placed in a visit, including orders they place before logging in. | Near-Time | 7 | Lifetime |
| Gift Orders | The number of customer orders with one or more product units marked as gift. A customer receives credit for all orders placed in a visit, including orders they place before logging in. | Near-Time | 2 | Lifetime |
| Top Categories Ordered | The (up to) 20 categories from which the customer has purchased the most product units. | Near-Time | Video, Audio, Top Sellers | Lifetime |
| Products Ordered | The products ordered by the customer. | Near-Time | S123, S456, S789 | Lifetime |
| Base Products Ordered | The base product SKUs of all variation products ordered by the customer. This attribute has a Set-of-string data type and derives from the Ordered Products values. | Near-Time | S123, S456, S789 | Lifetime |
| Products Viewed | The products viewed by the customer. | Near-Time | S123, S456, S789, S999, S888, S777 | Month |