How do you make the most of a festive season, like Christmas, using promotions?
How do you make the most of a festive season, like Christmas, using promotions?
Since Christmas Day fell on a Friday last year, we will include Saturday to run an analysis.
By setting the dinner time period from 18:00 to 00:00, and choosing only dine-in customers, all the subsequent data analysis will be automatically tabulated and analyzed for this particular period.
Groups of two are making up 70% of your business over the Christmas period, which is twice as much as usual. Since most groups of two are couples, you should put up posters to promote couple sets during Christmas!
Using Intelligent Date Filter, under “Advanced Options”, select 2 people under “Number of People”, and run a customer analysis.
According to the report, the "Wear red to get half price on red wine" promotion was 3 times more popular than the "Kiss to get a free dessert" promotion – so go with the first promotion this year!
At Christmas the “two-person” customer group ordered cake with their meal 3 times more than at any other time of the year, so choosing cake instead of ice cream for the “Couple Set” dessert is a better choice.
There’s a long queue on Friday night, and customers are getting impatient. Can we increase the table turnover rate of customers dining currently?
There’s a long queue on Friday night, and customers are getting impatient. Can we increase the table turnover rate of customers dining currently?
Select the time period 17:00 to 22:00, click dine-in and then choose all the Fridays you want to analyze.
60% of your customers on Friday nights are a “two-person” group. On other days, they only account for 40%.
Thus, on Friday, you should separate the tables of four to two-person tables. When a group of four comes in, you can simply join up the tables for them.
The order rate for two dishes, Fish & Chips and Pork Chop is over 30%, so they should stay on the menu as main dishes.
Since hiring more kitchen staff, the waiting time after placing an order has been reduced from 15 minutes to 10 minutes and customers are staying 4 minutes less in the restaurant. Fantastic!
Which should be the main for your holiday menu? Should you change the drinks menu? Should you promote a lighter menu during hot weather?
Which should be the main for your holiday menu? Should you change the drinks menu? Should you promote a lighter menu during hot weather?
Select the school holiday period (June) last year, choose lunch time, and run the analysis. Remember to exclude groups that were over 6 people because those were probably customers celebrating Father's Day, which falls in June.
During the school holidays, the sale of tofu dishes were 30% higher than usual and they also sold more than any other dish. Matching a tofu dish with iced green tea to make a special holiday set would be a good idea.
You can see from your analysis that 6 out of 10 customers did not want ice with their cold brew coffee, but there were a few customers who asked for ice. It would still be better to ask the customer for their ice preference before serving the drink.
Student discounted sales at lunchtime increased by 100% during the school holidays.
You should remove the student discount during the school holidays so that you would not incentivise the student crowd. More seats will be created for office workers who have higher spending power and pay the full price for their meals in order to increase your revenue.
How much manpower should you arrange for Chinese New Year? How many of them should be in charge of dine-in and take-out?
How much manpower should you arrange for Chinese New Year? How many of them should be in charge of dine-in and take-out?
Last year’s Chinese New Year Eve was February the 7th. Let’s choose February 6th to the 14th and run the analysis.
The number of customers dropped by 50% after the third day of New Year, so additional staff will not be needed after that!
Last year on Chinese New Year Eve, 80% of your restaurant's business was takeaways. Thus, it is advisable that you focus on takeaways this year.
Last year, you sold 200 BBQ whole chickens on those two days, with half of them being takeaways. Thus, this year you can prepare around 230 whole chickens, half for eating in and half for taking away.
How to review with the team? How to review the sales decline in quarter results?
How to review with the team? How to review the sales decline in quarter results?
Dinner sales seems to be declining and you suspect this is because it’s the Seventh Month and people tend to stay in at night. To find out if this is an annual trend, select the duration of the Seventh Month according to the lunar calendar and compare it to the previous year’s.
Your customer count has actually gone up by 5% but they are spending 30% less per visit. The drop in average spending per customer has a huge effect on your business! ”
Although your discounts added up to $20,000, this was in fact only 3% higher than last quarter, so discounts are not the reason for your reduction in sales revenue.
Your cold dish sales dropped by $40,000, while your hot soup sales have gone up $20,000 to help cushion the drop in revenue. Hence, you should work on a way to promote more soup!