Why customer needs this
- Having a daily view of sales at these granularity allows the ability to react upon identifying trends that are not consistent with expectation.
- Often this gets used as a reference point for forecasting, helping them get a baseline quickly.
Difficulty customer faces before engaging us
- 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
Brand
Outlet
Brand-Outlet-Day of Week
Brand-Outlet-Day of Week-Hour
Brand-Day of Week
Brand-Outlet-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
The dimensions and metrics are subjected to those available in the system you use