Sales Mix Report - How do I view what is being sold online?
YUMBI Reports offers an itemized report that allows the user to view a breakdown of what items are being purchased through Website and App Channels as well as the Call Centre Platform. This is the Sales Mix report and gives the user great insight into the popularity of specific menu items as well as the quantity of these items being sold.
Watch this short video to help you get familiarized with the Sales Mix report.
This report can be found on the left-hand Panel on the YUMBI Reports page. Under the Sales Tab, you can find this report named “Sales Mix” or by following this link to the report itself.
There are several filters that can be used when navigating this report. The four drop downs displayed below show these options. Type at the end refers to the Menu type you wish to view, such as Menu Items, Options or Both.
When filtering this report, the Brand you wish to view must be selected first before the report can populate. (See Figure 1)
Figure 1
Viewing this report without any additional filters included, the table of data will display an overview of all Items and/or Options that are available and offered by the store being filtered.
Below, we will break down each column of this table and what additional information can be found when navigating this report. (See Figure 2)
Figure 2
Column Explanations
Menu Item:
This would be the specific item on the menu that can be selected, whether it is an item or an option. This column has additional information that can be accessed by selecting the Menu Item. You can click on the menu item name to find out more details. (Example A)
Type:
The Type column displays whether the item in the Menu Item column is a “Menu Item” E.g. Chips or an “Option“ E.g. Basting Type.
Category:
This column represents the menu category the Menu Item or Option falls into. E.g. If an item is a burger and falls into the burger category.
This column has additional information that can be accessed by selecting the Category listed.
This column has additional information that can be accessed by selecting the Category listed.
Menu:
This would be the title and type of menu the Menu Item or Option is a part of. E.g. Halaal or Generic. This column has additional information that can be accessed by selecting the Menu listed.
(Example B & C will be discussed Further)
(Example B & C will be discussed Further)
Quantity:
This refers to the number of times this Item or Option was selected in the total sales.
% Quantity:
This would be the overall percentage of the specific menu items selection when sales were made.
Total Revenue:
This is the total revenue generated by the specific menu item and includes any extra items / upsells ordered with it.
% Revenue:
This would be the percentage of revenue the menu item generated.
Viewing Individual Menu Item Reports:
As shown in Figure 2, A marks the Menu Item column where the user can select individual menu items to populate a report dedicated to that specific menu item.
This report displays the performance of the selected menu item as well as an additional table of data showing what Options are selected with this item, the Volume of Sales and the Item Revenue generated. (See Figure 3)
As shown in Figure 2, A marks the Menu Item column where the user can select individual menu items to populate a report dedicated to that specific menu item.
This report displays the performance of the selected menu item as well as an additional table of data showing what Options are selected with this item, the Volume of Sales and the Item Revenue generated. (See Figure 3)
Figure 3
Viewing Specific Menus or Categories:
As shown in Figure 2, B & C mark the Category and Menu column respectively. Selecting either of these columns’ contents will populate a new report with condensed data depending on the option selected.
B - Selecting the Categories column will display a Sales Mix report of all Menu Items that fall into the selected category.
C - Selecting the Menu Type Column will display all Menu Items that belong to that specific menu.
When selecting these columns, additional filter tags will be displayed at the top of this report displaying what and how the report is being filtered. Selecting the “X” next to these will remove the filter and the report will display unfiltered information.
(See Figure 4)
B - Selecting the Categories column will display a Sales Mix report of all Menu Items that fall into the selected category.
C - Selecting the Menu Type Column will display all Menu Items that belong to that specific menu.
When selecting these columns, additional filter tags will be displayed at the top of this report displaying what and how the report is being filtered. Selecting the “X” next to these will remove the filter and the report will display unfiltered information.
(See Figure 4)
Figure 4
The Grid Information can be exported for all of the varying data analysis and provides additional categories of information using the CSV Option.
Related Articles
How can I view my Agent Sales?
The Agent Sales Report provides the store with an overview of each agent's performance in terms of their upselling expenditures. This information is accessible to those with YUMBI Report Access and the Call Centre Manager. Users gain insights into ...How do I view my Order Summary Report?
The Order Summary Report offers a detailed analysis including the Restaurant's Sales Breakdown, Transaction Types, Payment Methods, and Tender Types for orders placed at your store. Additionally, this report features a link labeled “View Failed Order ...What is the Online Payment Refund Report?
The Online Payment Refund Report provides insights into order refunds processed by the restaurant on the YUMBI Dashboard for customers who made online payments. This report details the refund transactions, allowing for better tracking and management ...How do I view my Restaurant’s Sales on Switchboard?
The Restaurant Sales Report delivers detailed insights into your restaurant's sales by outlining transactions processed through the Call Centre. This report includes key financial metrics such as turnover excluding VAT, average spend including VAT, ...How do I view the Uptime of my restaurant for Online Ordering?
Monitoring the uptime of your restaurant's online ordering system is crucial to ensure you don't miss any sales opportunities. By keeping a regular check, you can quickly identify and address any issues that arise. The Uptime Report provides insight ...