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, www.mycompany.com. |
The following example returns the total sales by stores: