Magento BI Essentials vs. Pro

This is archived documentation for Magento BI.

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.

• Essentials
• Pro