Magento Business Intelligence Help Center

Magento BI Essentials vs. Pro

The table below breaks out 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 (1) 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

*Items in blue 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
Was this article helpful?
0 out of 0 found this helpful

Comments

  • Avatar
    Muneeb Siddiqui

     *Number of tables depends on guest checkout.

     

    Can you please give some more clarity on this? We have recently integrated Magento BI essentials, and cannot see more than 2 tables. 

     

  • Avatar
    Khalil Manns

    Hi Muneeb, 

    To clarify, if a merchant does not accept guest orders, Magento BI will bring in data from an additional Magento table. For a specific answer to your situation, you can file a Support request from inside the Magento BI platform so our support team can investigate this particular situation. 

Powered by Zendesk