Commerce Fields

Commerce fields are product fields that are automatically generated and populated with revenue and sales data by Bronto.

When accounts that use order service store product data in Bronto, Bronto collects and stores order data for each active product in special commerce fields. These fields cannot be manually edited, but can be used to view:

  • the number of units sold during a set period of time.
  • the revenue for a product during a set period of time. The revenue based fields do not take currency into account, so if your store uses multiple currencies they are all added together without conversion.
  • trends in the popularity of products. Trends can be based on the either number of units sold or the product revenue. Trends can be viewed as short trends (a comparison to the last 30 days) or long trends (a comparison to the last year). A one means there is no change in the trend, a number greater than one means the product has increased in units sold or revenue, and a number less than one means the product has decreased in units sold or revenue.

Use the Product Search page to view these fields for individuals products. Bronto updates these values once per day with the sales from the previous day. Therefore these fields will not reflect the most recent sales but will never be off by more than 48 hours. This data is not collected for archived products and all commerce fields will display a zero for these products.

For customers who use Recommendations, these fields can be used as criteria and/or priorities when building recommendations and several recommendation templates have been built using these commerce fields. When using these fields for criteria, keep in mind that new products may have a skewed positive or negative result due to brand awareness. To avoid over-promoting these products you might want to use a filter to eliminate newer products from consideration. See Create A Standard Recommendation or Create A Premium Recommendation for more details.

The available commerce fields are listed in the following table.

Field Name Description
units_sold_7 Number of units that have been sold in the last 7 days.
units_sold_30 Number of units that have been sold in the last 30 days.
units_sold_90 Number of units that have been sold in the last 90 days.
units_sold_365 Number of units that have been sold in the last 365 days.
revenue_7 Total sales amount for the last 7 days.
revenue_30 Total sales amount for the last 30 days.
revenue_90 Total sales amount for the last 90 days.
revenue_365 Total sales amount for the last 365 days.
units_sold_7_short_trend A comparison of the number of units sold in the last 7 days versus the number of units sold in the last 30 days.
  • One means unit sales are flat.
  • Greater than one means unit sales comparatively increased.
  • Less than one means unit sales have comparatively decreased.
units_sold_7_long_trend A comparison of the number of units sold in the last 7 days versus the number of units sold in the last 365 days.
  • One means unit sales are flat.
  • Greater than one means unit sales comparatively increased.
  • Less than one means unit sales have comparatively decreased.
units_sold_30_long_trend A comparison of the number of units sold in the last 30 days versus the number of units sold in the last 365 days.
  • One means unit sales are flat.
  • Greater than one means unit sales comparatively increased.
  • Less than one means unit sales have comparatively decreased.
revenue_sold_7_short_trend A comparison of the product revenue for the last 7 days versus the product revenue for the last 30 days.
  • One means revenue is flat.
  • Greater than one means revenue comparatively increased.
  • Less than one means revenue comparatively decreased.
revenue_sold_7_long_trend A comparison of the product revenue for the last 7 days versus the product revenue for the last 365 days.
  • One means revenue is flat.
  • Greater than one means revenue comparatively increased.
  • Less than one means revenue comparatively decreased.
revenue_sold_30_long_trend A comparison of the product revenue for the last 30 days versus the product revenue for the last 365 days.
  • One means revenue is flat.
  • Greater than one means revenue comparatively increased.
  • Less than one means revenue comparatively decreased.