This topic explores the main data tables that you can import from Spree into your Commerce Intelligence account, including links to additional documentation about Spree data.
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 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 links back to the
users table to allow analysis on user buying behavior.
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 has its own data row in this table, including a
product\_id that allows you to tie it to 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.
|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.