Expected Spree data

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.

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 links back to the users table to allow analysis on user buying behavior.

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 has its own data row in this table, including a product\_id that allows you to tie it to the Products table.

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.