Why customer needs this
- Having a daily view of how much sales have been transacted through which channel allows customer to react quickly on identifying trends that are not consistent with expectation. Allowing our customer to make decisions on any reallocation of channel spent.
Difficulty customer faces before engaging us
- Channel information is usually derived from the payment method and requires mapping and grouping for accurate interpretation. Carrying out this process in Excel can be labor-intensive and increase the manual workload.
- 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
3P
Brand-3P
Brand-Outlet-3P
Brand-Channel
Brand-Outlet-Channel
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