Magento for B2B Commerce

Metrics

Each report includes at least one query that defines the set of data, or “metrics” for the report. The metrics statement describes the data that is to be retrieved, and consists of an operator, column, table, and sorting order. Magento BI includes a set of default, “out of the box” metrics that can be easily customized. You can create an unlimited number of custom metrics.

To access the available metrics:

1. On the menu, choose Manage Data.
2. In the sidebar, choose Metrics.

Metrics
3. Click the name of any metric to display detailed information.  To show the Metric Options, click the Settings ( ) icon on the right.

Metric Detail
4. Click Details to display more information about the metric.

Metrics
  • Default Metrics by Table

    Field

    Description

    customer_entity

    Avg first 30 day revenue

    Average on the Customer’s first 30 day revenue column in the customer_entity table (Change) ordered by the created_at (use) column

    Filter A

    Seconds since customer’s first order date >=2592000

    Filter B

    Registered accounts we count (Saved Filter Set)

    Avg lifetime coupons

    Average on the Customer’s lifetime number of coupons column in the customer_entity table (Change) ordered by the created_at (use) column

    Filter A

    Registered accounts we count (Saved Filter Set)

    Avg lifetime orders

    Average on the Customer’s lifetime number of orders column in the customer_entity table (Change) ordered by the created_at (use) column

    Filter A

    Registered accounts we count (Saved Filter Set)

    Avg Lifetime revenue

    Average on the Customer’s lifetime number of orders column in the customer_entity table (Change) ordered by the created_at (use) column

    Filter A

    Registered accounts we count (Saved Filter Set)

    New Customers

    Count on the entity_id column in the customer_entity table (Change) ordered by the created_at (use) column

    Filter A

    Registered accounts we count (Saved Filter Set)

    Registered accounts

    Count on the entity_id column in the customer_entity table (Change) ordered by the created_at (use) column

    Filter A

    Registered accounts we count (Saved Filter Set)

    customer_group

    New Metric

    Count on the customer_group_id column in the customer_group table (Change) ordered by the [NONE] column

    sales_flat_order

    Avg order value

    Average on the base_grand_total column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Avg time between orders

    Average on the Seconds since previous order column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Median time between orders

    Median on the Seconds since previous order column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    New Metric 2

    (Number of orders)

    Count on the entity_id column in the sales_flat_order table (Change) ordered by the [input] created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Orders

    Count on the entity_id column in the sales_flat_order table (Change) ordered by the [input] created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Revenue

    Sum on the base_grand_total column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Shipping

    Sum on the base_shipping_amount column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Tax

    Sum on the base_tax_amount column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    Unique Customers

    Count Distinct Values on the customer_email column in the sales_flat_order table (Change) ordered by the created_at (use) column

    Filter A

    Orders we count (Saved Filter Set)

    sales_flat_order_item

    Products Ordered

    Sum on the qty_ordered column in the sales_flat_order_item table (Change) ordered by the created_at (use) column

    Filter A

    Ordered products we count (Saved Filter Set)

    Revenue by products ordered

    Sum on the Order item total value (quantity * price) column in the sales_flat_order_item table (Change) ordered by the created_at (use) column

    Filter A

    Ordered products we count (Saved Filter Set)

  • Metric Options

    Field

    Description

    Operator

    Average

    Count

    Sum

    Average

    Maximum Value

    Minimum Value

    Count Distinct Values

    Median

    First Quartile

    Third Quartile

    Tenth Percentile

    Ninetieth Percentile

    Table

    addresses

    categories

    customer_entity

    customer_group

    sales_flat_order

    sales_flat_order_address

    sales_flat_order_item

    Target Column by Table

    customer_entity

    Customer’s first 30 day revenue

    Customer’s lifetime number of coupons

    Customer’s lifetime number of orders

    Customer’s lifetime revenue

    entity_id

    group_id

    Seconds since customer’s first order date

    customer_group

    customer_group_id

    sales_flat_order

    base_grand_total

    base_shipping amount

    base_tax_amount

    billing_address_id

    Customer’s lifetime number of coupons

    Customer’s lifetime number of orders

    Customer’s lifetime revenue

    customer_id

    entity_id

    Number of items in order

    Seconds between customer’s first order date and this order

    Seconds since previous order

    shipping_address_id

    store_id

    sales_flat_order_item

    base_price

    Customer’s lifetime number of orders

    Customer’s lifetime revenue

    item_id

    Order item total value (quantity * price)

    order_id

    product_id

    qty_ordered

    Order Column

    [NONE]

    created_at (use)

    updated_at

    [input] created at