Data model: wide_combo_order

Description

wide_combo_order_item helps Revel Data Connector users to track combo performance. Using this data model in combination with wide_order_item would allow Revel Data Connector users to review how combo performance compares to individual items in the combo.

Revel Data Connector users using this data model can answer questions like:

How many combos are sold and what are their values?
Do combos sell more than the same individual items together?
Have I cannibalised my revenue by introducing combos?
Which employee makes the highest number of combo orders?
What sales channels are not optimised for combos?
etc.

Data Objects

Resource	Data type	Mode	Description	Example
order_id	int4	Required	Unique ID for an Order	5
order_created_at	timestamp	Required	Order creation date and time in UTC format.	2018-11-08 16:37:41
order_updated_at	timestamp	Required	Order last update date and time in UTC format	2018-11-08 16:45:36
created_by_employee_first_name	varchar	'N/A'	First name of employee who created an order. If order wasn’t created by employee, then value is `N/A`	John
created_by_employee_last_name	varchar	'N/A'	Last name of employee who created an order. If order wasn’t created by employee, then value is `N/A`	Doe
created_by_employee_is_active	bool	Nullable	Identification of whether employee is active. If order wasn’t created by employee, then value is `NULL`	TRUE
last_updated_by_employee_first_name	varchar	'N/A'	First name of last employee who updated an order. If order wasn’t updated by employee, then value is `N/A`	John
last_updated_by_employee_last_name	varchar	'N/A'	Last name of last employee who created an order. If order wasn’t created by employee, then value is `N/A`	Doe
last_updated_by_employee_is_active	bool	Nullable	Identification of whether employee is active. If order wasn’t updated by employee, then value is `NULL`	TRUE
order_source	varchar	Required ‘Unknown’	Source channel of the order or pos mode if applicable: Web Order Smart Order Table service Quick service Retail Kiosk Pizza Grocery Donation Gas station	Quick Service
order_option	varchar	Required ‘Unknown’	Identification of order option, e.g. To-Go, Eat-In, Delivery, etc. If it is custom order option, then value is `Custom`. If it is not recognised it is `Unknown`	To Go
order_status	varchar	Required	Status of the order	Closed
is_order_paid	bool	Required	Order payment status.	TRUE
combo_order_item_id	int4	Required	Unique ID of a combo order item	3
product_name_override	varchar	‘N/A’	Overriden product name	Ice Cream Gift
unit_price	numeric	Required	Unit price of the product in the order. It does not include price for modifiers or combos, monetary value.	7.000000
unit_cost	numeric	Required	Unit cost of the product	4.000000
unit_of_measure	varchar	'N/A'	Unit, weighted, etc.	Unit
quantity	int4	Required	Number of ordered products(s)	1
weight	float	Nullable	Number of weight for the product, which is weighted. unit_of_measure contains types of data, e.g. Oz.	7.0
total_price	numeric	Required	Total price for the products(s) in the Order, monetary value. Formula: unit price + modifiers_amount + combo_savings_amount * quantity	11.600000
total_cost	numeric	Required	Total costs for the item(s) in the Order, monetary value. Formula: unit cost + modifier cost * quantity	3.000000
modifiers_amount	numeric	Required	Total amount of all the modifiers of single product, monetary value.	1.600000
modifiers_cost	numeric	Required	Total cost of all the modifiers of single product, monetary value.	0.170000
combo_savings_amount	numeric	Required	Amount, which is saved by the customer using combo, monetary value.	14.200000
is_valid_record	bool	Required	Identifies, if a record is valid and should be trusted or not.	TRUE
product_id	int4	Nullable	Unique ID of the product.	102
product_sku	varchar	‘N/A’	Unique SKU of the product. At least 4 characters.	AB123
product_name	varchar	‘N/A’	Name of the product Always reflects the newest name If product_id is NULL then manually entered product name will be shown.	Beef Sandwich
is_product_active	bool	Nullable	Identification if product is active, e.g. TRUE or FALSE.	TRUE
category_name	varchar	‘N/A’	Product category	Salad
is_category_active	bool	Nullable	Identification if product’s category is active, e.g. TRUE or FALSE.	TRUE
sub_category_name	varchar	‘N/A’	Product sub-category.	Hot Salad
is_sub_category_active	bool	Nullable	Identification if product’s sub-category is active, e.g. TRUE or FALSE.	TRUE
product_class_name	varchar	‘N/A’	Product class name	Drinks
is_product_class_active	bool	Nullable	Identification if product’s class is active, e.g. TRUE or FALSE.	TRUE
combo_shell_product_id	varchar	‘N/A’	Unique ID of the combo shell product.	132
combo_shell_product_sku	varchar	‘N/A’	Unique SKU of a combo shell product. At least 4 characters.	ZC123
combo_shell_product_name	varchar	‘N/A’	Name of the combo shell product It always reflects the newest name if product_id is NULL then manually entered product name will be shown.	Sandwich + Drink
product_group_name_list	varchar	‘N/A’	List of product’s group names.	\|Product Group A\|
establishment_id	int4	Required	Establishment unique Key	1
establishment_name	varchar	Required	Establishment Name	Company-1
company_name	varchar	Required	Company name	Company
company_url	varchar	Required	Company url address	company.revelup.com
establishment_country	varchar	Required	Establishment Country	US
establishment_state	varchar	'N/A'	Establishment State.	GA
establishment_city	varchar	Required	Establishment City.	Atlanta
establishment_latitude	float	Nullable	Establishment Latitude	34.6843294
establishment_longitude	float	Nullable	Establishment Longitude	-86.4109566
establishment_post_code	varchar	Required	Establishment Post Code	30314
is_establishment_active	bool	Required	Identification if establishment is active, e.g. TRUE or FALSE.	TRUE
establishment_group_name_list	varchar	Required	List of establishment’s group names	\|Group1\|Group2
timezone	varchar	Required	The configured timezone of the establishment	US/Eastern
establishment_division	varchar	'N/A'	Establishment division. If establishment does not belong to a division, then value is `N/A`.	Division - 1
establishment_sub_division	varchar	'N/A'	Establishment sub-division. If establishment does not belong to a sub-division, then value is `N/A`.	Sub-division - 1
pos_station_name	varchar	Required	POS station name.	POS1
revenue_center_name	varchar	'N/A'	Name of a revenue center a POS station is linked to.	Bar Area