Running a restaurant on gut feeling is a recipe for failure. In an industry where margins are razor-thin — typically 3-9% for full-service restaurants — the difference between thriving and closing often comes down to how well you understand your numbers. Yet a surprising number of restaurant owners still rely on rough estimates, end-of-month accounting summaries, and intuition to make critical business decisions.
Modern restaurant analytics can transform this situation. With the right data, you can identify exactly where revenue is being lost, discover which menu items drive the most profit (not just the most sales), understand customer behavior patterns, and make data-driven decisions that compound over time. In this guide, we'll cover the five most critical metrics every restaurant should track, practical strategies to improve each one, and how Excuseme's analytics dashboard puts this data at your fingertips.
The 5 Metrics Every Restaurant Must Track
There are dozens of metrics you could track, but these five form the foundation of restaurant financial health. Master these, and you'll have a clear picture of your business performance.
Metric 1: Average Spend Per Customer (Kyakutanka)
Average spend per customer (客単価 / kyakutanka) is the total revenue divided by the number of customers. It tells you how much each customer is worth to your business. A casual izakaya might see ¥2,500-4,000, while a fine dining restaurant might see ¥10,000-20,000+. Tracking this metric over time reveals trends — is your average spend growing or shrinking? How does it differ between lunch and dinner, weekdays and weekends, dine-in and takeout?
Metric 2: Table Turnover Rate (Kaitenritsu)
Table turnover rate (回転率 / kaitenritsu) measures how many times each table is used during a service period. A lunch service running from 11:00 to 14:00 with an average dining time of 45 minutes should theoretically achieve 4 turns per table. If you're only getting 2.5 turns, that's a significant revenue gap. Every empty seat during operating hours is lost revenue that can never be recovered.
Metric 3: Food Cost Ratio
Food cost ratio is the cost of ingredients divided by menu price. The industry target is typically 28-35% for most restaurants. Tracking this per item reveals which dishes are most profitable. A pasta dish with 25% food cost generates more profit per order than a steak with 40% food cost, even if the steak has a higher selling price. Understanding item-level profitability is essential for menu engineering.
Metric 4: Labor Cost Percentage
Labor costs typically represent 25-35% of restaurant revenue. This includes wages, benefits, training costs, and overtime. Tracking labor cost by hour reveals staffing inefficiencies — are you overstaffed during slow periods? Understaffed during rushes? The goal is to align staff levels precisely with customer demand, which requires accurate forecasting based on historical data.
Metric 5: Repeat Customer Rate
Acquiring a new customer costs 5-7x more than retaining an existing one. Your repeat customer rate shows what percentage of customers come back within a defined period (typically 30 or 90 days). Top-performing restaurants see 30-40% repeat rates. If yours is below 20%, you have a retention problem that no amount of marketing can solve.
| Metric | Target Range | Warning Level | Impact |
|---|---|---|---|
| Avg. Spend / Customer | Depends on format | Declining trend | Direct revenue |
| Table Turnover | 2.5-4x lunch, 1.5-2x dinner | Below 2x lunch | Capacity utilization |
| Food Cost Ratio | 28-35% | Above 38% | Gross profit |
| Labor Cost % | 25-35% | Above 38% | Operating profit |
| Repeat Rate | 30-40% | Below 20% | Long-term growth |
How to Increase Average Spend Per Customer
Increasing average spend doesn't mean raising prices — which often backfires. Instead, focus on strategies that encourage customers to naturally order more and choose higher-margin items.
Strategic Menu Design
Menu engineering is a science. Place high-margin items in the top-right corner of the menu (the "sweet spot" where eyes naturally land first). Use descriptive, appetizing language for items you want to promote. Group items strategically — placing a ¥3,000 item next to a ¥1,200 item makes the ¥1,800 option between them feel like a great deal. With digital menus like Excuseme, you can dynamically adjust item placement based on performance data.
Upselling Through Digital Ordering
When customers order through a digital system, they browse the menu more thoroughly than when a waiter is standing over them. They're more likely to add appetizers, sides, and desserts because there's no social pressure to hurry. Studies show digital ordering increases average order value by 15-25% compared to verbal ordering. Excuseme enhances this with smart recommendations — "customers who ordered this also liked..." suggestions based on real ordering data.
Set Menu and Course Promotions
Course menus and set combinations almost always increase average spend. A customer who might order just a main dish (¥1,500) can be guided toward a set with appetizer, main, and dessert (¥2,800). The perceived value is high for the customer, and the food cost is often lower as a percentage. Feature these prominently in your digital menu with attractive photos and clear pricing.
Restaurants using Excuseme's digital ordering report an average 18% increase in spend per customer, primarily driven by increased side orders, desserts, and drink add-ons that customers discover while browsing the digital menu.
How to Improve Table Turnover Rate
Improving turnover doesn't mean rushing customers out the door. It means eliminating wasted time in the service cycle — time when a table is empty but could be serving customers.
Reduce Wait Time Between Seating and Ordering
The traditional flow — seat customer, bring water and menu, wait for them to decide, come back to take order, walk to POS to enter it — typically takes 8-12 minutes. With QR ordering through Excuseme, customers scan and start ordering immediately after sitting down. This alone can save 5-8 minutes per table per turn, which over a full lunch service with 20 tables can recover an entire additional turn.
Streamline the Payment Process
The end of the meal is where the most time is wasted. Customers wait to catch a staff member's attention, wait for the bill to be calculated, wait for the payment to be processed, and then the table needs to be cleaned. With Excuseme's Shopify POS integration, customers can request the bill from their phone. The bill is instantly calculated and ready for payment at the register. This eliminates the "waiting for the check" dead time that can add 10-15 minutes.
Optimize Table Status Management
How quickly can you turn a table after one party leaves? If cleaning, resetting, and reseating takes 10 minutes when it could take 5, you're losing capacity. Excuseme's table management system shows real-time status (occupied → bill requested → paid → cleaning → available), ensuring the team knows exactly which tables need attention and when.
The Importance of Repeat Customer Analysis
Many restaurant owners focus obsessively on attracting new customers while neglecting the gold mine sitting in their existing customer data. Repeat customers are the lifeblood of any successful restaurant.
Why Repeaters Matter More Than New Customers
Repeat customers spend 67% more on average than first-time visitors. They require zero acquisition cost. They refer friends and family. They leave positive reviews. They forgive occasional mistakes. They order familiar favorites plus try new items. Building a base of loyal repeat customers creates stable, predictable revenue that doesn't depend on expensive marketing campaigns.
What to Track About Repeat Customers
Key data points to track include: visit frequency (weekly, monthly, quarterly), preferred items and ordering patterns, average spend per visit (and how it changes over time), preferred days and times, group size and composition, and response to promotions or new menu items. This data reveals opportunities — if a regular's visit frequency drops, it's a warning sign you can act on before they're gone.
Excuseme's Analytics Dashboard
Excuseme's analytics dashboard is built specifically for restaurant operators who need actionable data without spending hours in spreadsheets. Powered by Shopify's robust data infrastructure, it provides real-time insights across all the metrics that matter.
Real-Time Sales Overview
See today's revenue, customer count, and average spend updating in real time. Compare against yesterday, last week, and last month at a glance. The dashboard highlights anomalies — a sudden drop in afternoon revenue or an unusually high cancellation rate — so you can investigate immediately rather than discovering problems days later.
Menu Performance Analysis
Every item on your menu is ranked by three dimensions: sales volume (how often it's ordered), revenue contribution (total yen generated), and profitability (margin per item). This three-dimensional view reveals your "stars" (high volume, high profit), "puzzles" (high profit, low volume — need better promotion), "workhorses" (high volume, low profit — consider price adjustment), and "dogs" (low volume, low profit — candidates for removal). This menu engineering approach can improve overall profitability by 10-20% without changing a single recipe.
Time-Based Analytics
Understand your revenue by hour, day, and season. Identify your peak and off-peak periods with precision. Use this data to optimize staffing schedules, plan targeted promotions for slow periods, adjust menu offerings by time of day, and forecast demand for better inventory management. The system learns from historical patterns to provide increasingly accurate forecasts over time.
Data without action is just noise. Excuseme's dashboard doesn't just show you numbers — it highlights specific opportunities. "Your dessert order rate is 12% below average on Tuesdays. Consider a Tuesday dessert promotion." Actionable insights drive real results.
Putting It All Together
The five metrics we've covered — average spend, turnover rate, food cost, labor cost, and repeat rate — are interconnected. Improving one often improves others. Faster turnover means more customers, which can lower labor cost percentage. Higher average spend with the same customer count means better overall revenue without needing more seats. Better repeat rates mean lower marketing costs and more predictable revenue.
The key is to start measuring, then start improving. Excuseme gives you the measurement tools integrated directly into your daily operations — every order through the system automatically feeds your analytics. No extra data entry, no manual calculations, no waiting for month-end reports. Just real-time visibility into the health of your business, powered by Shopify's proven platform.