Magento Business Intelligence Help Center

Expected Spree data

BROUGHT TO YOU BY

Avatar

After you’ve connected your Spree store, you can use the Data Warehouse Manager to easily track relevant data fields from your Spree platform for analysis.

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.

Table name Description
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.

Related:

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk