This is archived documentation for MBI.
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 |
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
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