In this article, we’ll explore the main data tables that you can import from Spree into your Magento BI account, including links to additional documentation about Spree data.
|Users||The users table includes the account details for registered customers, including the individual’s email, name, and registration date. This allows you to analyze different customer segments and their buying behaviors.|
|Orders||The orders table serves as the foundation for all of your order-level metrics. Recorded here are all order details of purchases from your Spree store, including completed_at (the timestamp of the order), user_id (id of registered user who placed the order). If the order was made by a registered user, the user_id will link back to the users table to allow analysis on user buying behavior.|
|Line items||The line_items table is a child of either the orders table or subscriptions. It records an order’s or a subscription’s line item details. For orders with multiple products, each product will have its own data row in this table, including a product_id that allows you to tie it to the products table.|
|Products||The products table records all product details for a saleable item in your Spree catalog. This allows you to segment your line item-level metrics by product attributes.|
|Subscriptions||If you have a Spree subscriptions extension, the subscriptions table holds each individual subscription’s information, including created_at (the start date), cancelled_at (the date a subscription was cancelled), and the interval of the subscription.|