Shops table

Shops contains basic information about your stores. Most tables in the data warehouse have a foreign key reference to the shop_id column in this table, which means you can join this table with other tables to compare metrics across your stores. This table contains one row per store.

Column Data type Description
shop_id numeric Unique identifier for the store. This column is the primary key for the shops table.
name varchar Name of your store.
domain varchar Primary domain specified for your online store. Your primary domain is the one that your customers and search engines see. For example,

The following example returns the total sales by stores: