fct_orders
- Contains information about the orders placed by users.fct_order_items
- Contains information about the items in each order.dim_users_history
- Contains historical information about users.dim_items_history
- Contains historical information about items.dim_merchants_history
- Contains historical information about merchants.dim_promotions_history
- Contains historical information about promotions.mart_gmv_by_merchant_and_category_daily
table to have the following columns:
Column Name | Type | Description |
---|---|---|
report_date | date | Date of the transaction |
merchant_name | varchar | ID of the merchant |
category | varchar | Category of the item |
gmv | float | Gross Merchandise Value |
margin | float | Margin percentage |