After you have connected your Adobe Commerce store, you can use the Data Warehouse Manager to easily track relevant data fields from your Commerce database for analysis.
This topic explores the main data tables that Commerce users import into Commerce Intelligence.
customer\_entity and related tables describe the information associated with each registered customer in your database, like their email address and registration date. With this information, you can begin segmenting by customer-level attributes and cohorts.
sales\_flat\_order table records all orders, including the
created\_at timestamp that the order was placed and the
base\_grand\_total field that sums up revenue. These fields are the basis for your order-level metrics. If the order was made by a registered customer, the
customer\_id field links back to the
customer\_entity table to allow analysis on customer buying behavior.
sales\_flat\_order\_item table records each item belonging to an order. This includes the
qty\_ordered fields, and the
order\_id field which connects to the
sales\_flat\_order table. This table is the foundation for metrics like
Item sold, and allows you to segment by
catalog\_product\_entity table stores information on product-level attributes, like category, size, and color.
|Your products belong to one or many different
product categories, depending on how your Commerce build is set up. The
catalog\_category\_entity table stores the hierarchy of these categories (Apparel > Tops > T-Shirts, for example), and the
catalog\_category\_product table logs the connections between your products and those categories.