Magento BI Essentials vs. Pro

This is archived documentation for Magento BI.

The following table describes what is included with Essentials and Pro.

*Number of tables depends on guest checkout.

Included tables

• sales\_order
• sales\_order\_item
• sales\_order\_address
• customer\_entity
• customer\_group
• store

Columns Included in Essentials

Items in italics are calculated fields.

• sales_order table
  • entity_id
  • base_grand_total
  • customer_id
  • status
  • customer_email
  • store_id
  • base_currency_code
  • billing_address_id
  • shipping_address_id
  • base_shipping_amount
  • base_tax_amount
  • coupon_code
  • created_at
  • updated_at
  • base_subtotal
  • customer_group_id
  • base_discount_amount
  • base_discount_invoiced
  • increment_id
  • Customer’s order number
  • Customer’s first order date
  • Customer’s lifetime number of orders
  • Is customer’s last order?
  • Billing address region
  • Shipping address country
  • Customer’s lifetime revenue
  • Seconds between customer’s first order date and this order
  • Seconds since previous order
  • _Store name*
  • Customer’s lifetime number of coupons
  • Customer’s order number (previous-current)
  • Shipping address region
  • _Number of items in order
  • Billing address city
  • Shipping address city
  • Customer’s group code
  • Customer’s first order’s billing region
  • Customer’s first order’s coupon_code
  • Customer’s creation date
  • Billing address country
• sales_order_item table
  • item_id
  • qty_ordered
  • base_price
  • name
  • order_id
  • sku
  • product_type
  • product_id
  • created_at
  • updated_at
  • parent_item_id
  • store_id
  • base_discount_amount
  • base_discount_invoiced
  • Order’s coupon_code
  • Order item total value (quantity * price)
  • Order’s increment_id
  • Customer’s email
  • Customer’s lifetime number of orders
  • Store name
  • Customer’s order number
  • Order’s status
  • Customer’s lifetime revenue
• sales_order_address table
  • entity_id
  • city
  • region
  • country_id
• customer_entity table
  • entity_id
  • email
  • group_id
  • created_at
  • updated_at
  • store_id
  • Customer’s lifetime revenue
  • Customer’s lifetime number of coupons
  • Customer’s first order date
  • Customer’s lifetime number of orders
  • Seconds since customer’s first order date
  • Customer’s first 30 day revenue
  • Customer’s first order’s billing region
  • Customer’s first order’s coupon_code
  • Customer’s group code
  • Store name
• customer_group table
  • customer_group_id
  • customer_group_code
• store table
  • store_id
  • name

Refer to the following video series to learn more about the differences between Magento BI Essentials and Magento BI Pro.

• Essentials
• Pro