---
schema_version: "1"
id: 882159346ec84ed492735886698b74a744d8c0206aa9399da24c71ee159939e5
title: Active Data Attributes
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_active_data_attributes.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_active_data_attributes.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c5b8345f167c246c3be264bfd0527e6974af1a027844457ba17e4f377f1bec44
description: "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)."
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# Active Data Attributes

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 ![App Launcher](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/cc/b2c_merchandiser_administrator/images/appLauncher.png), and then select **Merchant Tools** | **Site** | **Products and Catalogs** | **Products**.

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.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png)

Note Don't use active data attributes to import data that you want to replicate to other systems. Active data can't be replicated.

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.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png)

Note B2C Commerce collects yearly and lifetime attributes daily.

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](https://help.salesforce.com/s/articleView?id=cc.b2c_availability.htm&release=264.0.0&type=5 "Availability is the normalized ratio between the Allocation attribute and the Available To Sell (ATS) attribute of a B2C Commerce product inventory record. Special rules apply for variation products, product sets, and potentially product bundles. Availability is the same for all sites that share an Inventory list, so it's basically a site-specific value.") | Ratio between inventory allocation and current stock level. | Real-Time | 0.59 | N/A |
| [Cost Price](https://help.salesforce.com/s/articleView?id=cc.b2c_cost_price.htm&release=264.0.0&type=5 "Cost price is a fixed cost price imported into B2C Commerce for use in calculations. Cost price is a site-specific value and must be represented in the same currency used for purchases on the site.") | The cost of goods sold for the product. | Imported | 10.19 | N/A |
| [SKU Coverage](https://help.salesforce.com/s/articleView?id=cc.b2c_sku_coverage.htm&release=264.0.0&type=5 "SKU Coverage is the normalized ratio between the total number and the number of available variations of a B2C Commerce base product. SKU Coverage is the same for all sites that share an Inventory list, so it's a site-specific value.") | Ratio between total number of variation products and their availability status. | Real-Time | 0.90 | N/A |
| [Time to Out of Stock (TTOOS)](https://help.salesforce.com/s/articleView?id=cc.b2c_ttoos_time_to_out_of_stock.htm&release=264.0.0&type=5 "Time to out of Stock (TTOOS) is the estimated time before a B2C Commerce product goes out of stock.") | 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](https://help.salesforce.com/s/articleView?id=cc.b2c_days_available.htm&release=264.0.0&type=5 "Days Available is a product attribute representing the time since B2C Commerce created the item.") | 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 |