Why customer needs this
- Having a keen and frequent view of item/modifier sales allows the ability to refine the offering to customers ensuring that focus is on item/modifier that are both profitable and popular.
- Monitoring uptake of new item/modifier sales enable customers to identify issues where outlets may not be pushing the new item/modifier or validate the popularity of the new item/modifier launched.
Difficulty customer faces before engaging us
- Reports on items/modifiers in Point of Sale (POS) systems are often limited, due to the large number of Stock Keeping Units (SKUs) sold in a restaurant. This often hinders detailed analysis.
- POS reporting is typically available across SKUs, like top-selling products, but often lacks a breakdown into categories.
- The existing POS system used by many of our customers lacks the flexibility of drilling down. Compiling this information outside of the POS requires significant manual effort, introducing potential errors.
- Often, our customers operate not just a single POS, but several POS and Ecommerce platforms. They must manually combine these to gain a holistic view, which again invites manual effort and potential errors.
- Comparative analysis across multiple periods is not found in many of the POS systems we have worked with.
- As data volume increases, manually processing it through Excel becomes increasingly slow and inefficient, eventually rendering it unfeasible.
Systems we extract data from
If your systems is not in here we will extract data from it. We either collect the data via API, direct database, system ftp or scraping downloaded system reports.
Available Dimensions
Category
Brand-Category
Brand-Outlet-Category
Brand-Outlet-Category-Product
Brand-Modifier Group
Brand-Outlet-Modifier Group
Brand-Outlet-Category-Modifier Group-Modifier
Brand-Outlet-Modifier Group-Modifier
Brand-Outlet-Product-Hour
Available Metrics
Gross Sales
Product Sales
Service Charge
Delivery Fee
Platform Fee
Merchant Fee
Discounts
Platform Discount
Merchant Discount
Surcharge
Refunds
Tax
Net Sales
Order Count
Average Order Value (Gross Sales)
Average Order Value (Net Sales)
Discount to Gross Sales Ratio
Merchant Discount to Gross Sales Ratio
Platform Discount to Gross Sales Ratio
Merchant Discount to Discount Ratio
Platform Discount to Discount Ratio
Delivery Fee to Gross Sales Ratio
Platform Delivery Fee to Gross Sales Ratio
Merchant Delivery Fee to Gross Sales Ratio
Platform Delivery Fee to Delivery Fee Ratio
Merchant Delivery Fee to Delivery Fee Ratio
Surcharge to Gross Sales Ratio
Refunds to Gross Sales Ratio
Item Sales
Unit price before tax
Unit Price
Qty
Item Discounts
Item Tax
Sold in # Distinct Orders
# Items in Order
Item Service Charge
The dimensions and metrics are subjected to those available in the system you use