Item Sales by Hour / Hourly PMIX Report

Avero's Item Sales by Hour Report

Available in: Professional subscriptions only

Avero's Item Sales by Hour Report can help you to identify periods of low-volume. This will enable you to track volume throughout the day and get a better sense of what items are selling during specific times. During these periods, your businesses can benefit by offering item-specific promotions or other incentives to drive traffic.

• Identifying popular items: Item sales by hour reports can help operators identify which products or menu items are most popular during different times of day or week. This information can be used to adjust inventory levels, pricing strategies, and promotional activities to maximize revenue from these popular items.

• Adjusting menu offerings: Item sales by hour reports can also help operators identify which products or menu items are not selling well during certain times of day or week. This information can be used to adjust menu offerings, modify recipes, or remove items that are not selling well, ultimately improving profitability.

• Optimizing promotions: Item sales by hour reports can provide insights into which promotions or discounts are most effective for specific products or menu items during different times of day or week. By analyzing the performance of promotional activities over time, operators can optimize their promotional strategies and drive revenue.

In this article, the following topics will be discussed:

• Running an Item Sales by Hour Report 
• Viewing the Item Sales by Hour Report
• How are sales by hour calculated?

Running an Item Sales by Hour Report 

If your business is utilizing our Professional subscription, the Item Sales by Hour report is located under the Revenue Management tab in Avero.

Every Avero report has a unique Report Generator to help you define your results using a range of filter options.  This includes your business, date range, revenue centers, order types, category, time interval, and your preferred metric. Popular metrics for this report range from item quantity, Avg Gross Sales, Item/Cover%, and Net Avg Check (Covers). We have defined all of the metric options on the Metrics page. Once you have made your choices, hit Go.

Viewing the Item Sales by Hour Report

The Item Sales by Hour Visualization will be displayed as a bar graph. When viewing the bar graph, keep the following in mind:

• To isolate categories, click on the colored bubbles next to ones you would like to remove.
• Use the Speedometer Icon to pin this graph to your Dashboard. 
• Hover over the bar to see the category breakdown by your selected metric during that hour interval. 

The Item Sales by Hour Table will give you a breakdown off all of your items by your pre-defined metric during each time interval. When viewing the table, keep the following in mind:

• Click the +/- next to the category to view the list of items 
• Sort the data by selecting column headers 
• Export your data or create an automated email to continue tracking your initiatives

Hourly Item Sales Trend Reports

Trend Reporting is a helpful way to analyze averages or see incremental changes over time. In Summary or Detail reports (such as Group Sales Summary or Item Sales Detail) each day is displayed side by side. In Hourly complex reports (such as this report or Hourly Labor Report) the columns are used to display the activity for each hour or incremental portion of the day, so the average for the trend is displayed. 

This means that running an Hourly Item Trend for the last 15 Mondays will show you the average labor over the last 15 Mondays for each hour of the day (or down to 15-minute increments). This is a great tool for making decisions and tracking trends based on recent trends and your actual performance: 

This report shows an average across 7 recent Mondays, with the average total items sold for each hour of the day. 

You can use the average Covers or average Checks to see customer volume - and Item Qty or Gross Sales to see how much items are contributing to your daily sales on average. 

How are sales by hour calculated? 

For our hourly sales information, item transaction time is used to provide real-time reporting and to sidestep any operational challenges such as checks being kept open until the end of service.

Please note however, Avero is limited to displaying times based on what is provided by your Point of Sale system.

The following POS systems only provide the Check Open Time for item transactions, so sales will only be listed at the time the check was opened:

Aldelo, Infogenesis (on-premise and cloud), Lightspeed, Micros Simphony On-Premise, PosiTouch, Squirrel POS. 

Get this report in your inbox every week:

Set up an Email Schedule...

Click the Envelope to set up an email schedule. 

...or Pin it to your Dashboard.

Click the Speedometer to add to your Dashboard.  (hint: make sure you've chosen a trended or dynamic date type)