Magento BI Essentials vs. Pro

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

  MBI Essentials MBI Pro
Pre-Defined Reports Up to 100 Custom
Pre-Defined Dashboards 5-6 Custom
New Custom Report Creation Yes Yes
Magento Commerce Tables 4-6* Unlimited
Log-ins/User Accounts 10 20
User Permissions Yes Yes
Data Warehouse Manager Unavailable Available
Email Reports Yes Yes
Cohort Report Builder Yes Yes
Google Analytics Live Integration Yes Unlimited
3rd Party Integrations Unavailable Available
Full API Access No Yes
Access to CS, AM, or Analysts No Yes
Professional Services Available Available

*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.