You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Insights > Demand Planning > Hourly + Day of the Week
Hourly + Day of the Week
print icon

When / How to use this dashboard

This dashboard is meant to help you analyze hourly trends within the market. Hourly data is collected from transaction data with sold hour identifying the hour in which the transaction occurred. This dashboard can help you understand consumer trends within a market and plan resources accordingly. By identifying times in which store sales are more likely or less likely, you can target consumers, plan potential vendor days, and know which days and times you need to have products available.

Use the filters on the top of this dashboard to select from the categories in your subscription. By default, the Segment and Brand filters are set to ‘All’.





Cannabis Market Sales by Sales (Units) vs. Filter Selection Sales (Units) By Hour and Day
In the image below, we’re comparing the total market on the left to the Topicals market on the right. Notice the hours of the day along the left side of the maps and the days of the week along the bottom. In this case, we see activity for Topicals earlier in the day on Friday, and brighter activity on Saturday compared to the overall market.

The darker purple areas represent times in which a lower % of sales (units) occur within a week. By comparing these tiles, you can compare the % of Sales (Units) between times to understand how demand for your filter selection differs from the total market. Use these heatmaps to understand when your filter selection products are purchased, when to ensure appropriate stock levels to meet peak weekday demand, and compare these to the total market.





Index of Hourly Sales (Units)
This graph is meant to give a highly visual picture of your Filter Selection sales compared to total market sales. The metric is [% of Filter Selection Sales]:[% of Total Market Sales].

Example: 11:00 AM on Monday, Topicals sees 1.2% of its total weekly sales vs. the rest of the Market sees .8% of its total weekly sales. The index is 144 (1.2/.8). This data is for Washington, and the date range is from January 2017 through June 2020. Notice the red arrow indicating this deep green-colored hour of the day.

Interpretation: Numbers over 100 are the days and times when your selected products see more sales than the market. These are the times when store sales are more likely to be to your Filter Selection and are colored in darker greens.

Numbers under 100 are the days and times when Filter Selection products see fewer sales than the market. These are times when store sales are less likely to be to the Filter Selection products and are colored in red hues. Use these visualizations for determining the best time to engage with your customers in stores.




% of Sales (Units) Compared to Total Market by Hour
This graph compares sales activity by the hour of the day, with the darker colored line indicating our filter selection and the lighter colored line the overall market. In this and the following graph, our selection is Topicals. We see that until 3:00 PM, Topicals are ahead of the overall market roughly 62% of our Topicals sales will be completed by this time on a typical day.







% of Sales (Units Compared to Total Market by Weekday
This graph also compares our filter selection to the rest of the market. We’ll certainly want to have our shelves fully stocked and our budtenders well prepared for customers to buy Topicals on Friday and especially Saturday. Notice the days of the week at the bottom of the graph.




 

Feedback
0 out of 0 found this helpful

scroll to top icon