Restaurant Analytics Dashboard: 12 KPIs That Drive Profit
Most restaurant owners make decisions based on gut feeling. The best ones make decisions based on data. A restaurant analytics dashboard transforms raw sales numbers, customer behavior, and operational metrics into actionable insights that directly impact your bottom line.
But here is the problem: too many dashboards overwhelm you with vanity metrics. You do not need 47 reports. You need the right ones. This guide breaks down the 12 KPIs that actually matter for F&B operators across APAC, explains how to track them, and shows you how to turn data into dollars.
What Is a Restaurant Analytics Dashboard?
A restaurant analytics dashboard is a centralized interface that collects and visualizes data from every part of your operation. Instead of checking your POS for sales, your delivery apps for order volume, and spreadsheets for labor costs, you see everything in one place.
A well-built dashboard answers three questions instantly:
- What happened? — Historical performance by day, week, and month
- Why did it happen? — Correlations between metrics (e.g., did a menu change cause sales to drop?)
- What should I do next? — Predictive insights that guide decisions
For restaurants in the Philippines, Indonesia, Singapore, and Japan, the dashboard must also handle multi-platform delivery data. When GrabFood, Gojek, Foodpanda, and Uber Eats all feed into the same view, you finally understand which channels actually make you money.
The 12 Essential Restaurant KPIs
1. Average Order Value (AOV)
Formula: Total Revenue ÷ Number of Orders
AOV tells you how much each customer spends per transaction. Small improvements here compound dramatically. A restaurant processing 200 orders daily that increases AOV by just ₱50 adds ₱3,000,000 in annual revenue.
How to improve it:
- Train staff on upselling (beverages, sides, premium options)
- Bundle items at a slight discount
- Set free delivery thresholds that encourage larger orders
2. Cost of Goods Sold (COGS) Percentage
Formula: (Beginning Inventory + Purchases − Ending Inventory) ÷ Total Revenue × 100
COGS percentage reveals how much of your revenue goes directly to ingredients. For full-service restaurants, 28-35% is typical. For QSR, 25-30% is the benchmark. If your COGS creeps above 40%, you have a pricing or waste problem.
Red flags to watch:
- Menu items with COGS above 45% (unless they drive traffic)
- Spoilage rates above 5% of total inventory
- Vendor price increases not reflected in menu pricing
3. Labor Cost Percentage
Formula: Total Labor Costs ÷ Total Revenue × 100
This includes wages, benefits, and payroll taxes. Industry targets vary by service model:
- Fine dining: 30-40%
- Casual dining: 25-35%
- QSR / fast food: 20-30%
- Cloud kitchens: 15-25%
The dashboard should break this down by shift, so you see whether lunch or dinner is eating your margin.
4. Table Turnover Rate
Formula: Number of Parties Served ÷ Number of Available Tables
Table turnover measures how efficiently you use your seating capacity. A full-service restaurant targeting 2.5 turns per night needs data on average dining duration, peak arrival times, and reservation patterns.
Optimization levers:
- Reduce menu complexity to speed up decision-making
- Implement QR code ordering for faster table service
- Use reservation systems with time-slot management
5. Customer Retention Rate
Formula: (Returning Customers ÷ Total Customers) × 100
Acquiring a new customer costs 5-7x more than retaining an existing one. Yet most restaurants obsess over new customer acquisition while ignoring loyalty. A retention rate above 30% indicates a healthy base of regulars.
Track this by identifying repeat phone numbers, email addresses, or loyalty program IDs. If you use a CRM or loyalty system, the dashboard should flag customers who have not returned in 30, 60, or 90 days.
6. Net Promoter Score (NPS)
Formula: Percentage of Promoters − Percentage of Detractors
NPS measures customer satisfaction and predicts word-of-mouth growth. Ask one question after each order: How likely are you to recommend us to a friend? (0-10)
Score breakdown:
- 9-10: Promoters (drive growth)
- 7-8: Passives (neutral, at risk)
- 0-6: Detractors (damage your brand)
A positive NPS (above 0) is good. Above 30 is excellent. Above 50 is world-class.
7. Order Accuracy Rate
Formula: (Accurate Orders ÷ Total Orders) × 100
Every incorrect order costs you the original item, a remake, and potentially a negative review. For delivery orders, accuracy rates below 95% indicate systemic problems in your order-to-kitchen workflow.
Track accuracy by platform. You may find that GrabFood orders have 98% accuracy while your own website orders sit at 91% — a clear signal to fix your direct ordering flow.
8. Peak Hour Analysis
This is not a single formula. It is a pattern. Your dashboard should show revenue, order volume, and labor cost by hour of day and day of week.
Most restaurants discover surprises:
- Tuesday lunch is actually more profitable than Friday dinner (lower labor costs)
- Third-party delivery peaks at 8 PM, but direct orders peak at 6:30 PM
- Sunday brunch has high revenue but brutal labor costs
Use this data to optimize staffing schedules, promotional timing, and inventory preparation.
9. Menu Item Profitability
Formula: (Item Price − Item COGS) ÷ Item Price × 100
Not every bestseller is a profit driver. Your dashboard should rank items by:
- Revenue contribution (total sales volume)
- Profit margin per unit
- Profit contribution (total profit dollars)
The item that sells the most might have a 15% margin. The item that sells moderately might have a 65% margin. Smart operators engineer menus to promote the high-margin, high-appeal items.
10. Customer Acquisition Cost (CAC)
Formula: Total Marketing Spend ÷ Number of New Customers Acquired
CAC varies wildly by channel:
- Organic social media: ₱0-50 per customer
- Paid Facebook / Instagram ads: ₱150-400 per customer
- Delivery platform promotions: ₱200-600 per customer (including commission)
- Referral programs: ₱100-250 per customer
If your CAC exceeds your average customer lifetime value (LTV), you are losing money on every new customer. The dashboard should show both metrics side by side.
11. Revenue Per Available Seat Hour (RevPASH)
Formula: Total Revenue ÷ (Available Seats × Operating Hours)
RevPASH is the gold standard for measuring seating efficiency. A 40-seat restaurant open 10 hours daily has 400 seat-hours. If daily revenue is ₱80,000, RevPASH is ₱200.
Benchmarks vary by market and concept:
- Casual dining: ₱150-300 per seat hour
- Fine dining: ₱500-1,500+ per seat hour
- QSR: ₱200-400 per seat hour
12. Platform Performance Comparison
For delivery-focused restaurants, this is critical. Your dashboard should compare:
- Revenue by platform (GrabFood, Gojek, Foodpanda, Uber Eats, direct)
- Average order value by platform
- Commission cost as percentage of platform revenue
- Customer ratings by platform
- Order accuracy by platform
This reveals which platforms actually deliver profit versus which ones just deliver volume. Many restaurants find that their lowest-volume platform has the highest profitability because of lower commissions and higher AOV.
APAC-Specific Analytics Challenges
Restaurants in Southeast Asia and Japan face unique data challenges that Western dashboards often ignore:
Multi-Currency Complexity
A restaurant group operating in Singapore (SGD), Philippines (PHP), and Indonesia (IDR) needs consolidated reporting that handles currency conversion without distorting performance comparisons.
Platform Fragmentation
Japan has Demae-can and Menu. Indonesia has GoFood and ShopeeFood. The Philippines has GrabFood and Foodpanda. Each platform exports data in different formats. A true APAC dashboard normalizes all of it.
Cash vs. Digital Payment Mix
In Indonesia and the Philippines, cash on delivery remains significant. Your dashboard must reconcile cash orders with digital payments to give accurate revenue figures.
Seasonal and Cultural Variations
Chinese New Year, Ramadan, and Golden Week all create demand spikes that break Western forecasting models. APAC-native analytics understand these patterns.
Common Analytics Mistakes Restaurants Make
Even with a dashboard, data can mislead. Avoid these traps:
- Optimizing for revenue instead of profit. A ₱500,000 revenue day with 45% COGS and 35% labor is worse than a ₱350,000 day with 28% COGS and 22% labor.
- Ignoring delivery platform true costs. Commission + promotions + packaging + delivery fees often push net delivery margins below 5%.
- Comparing this week to last week. Compare this Tuesday to the last four Tuesdays to account for seasonality.
- Tracking too many metrics. Start with five KPIs. Master them. Add more only when the first five are automatically optimized.
Building Your Analytics Habit
Data only works if you use it consistently. Here is a simple rhythm:
- Daily (5 minutes): Check yesterday's sales, AOV, and any red flags in accuracy or ratings
- Weekly (15 minutes): Review labor cost percentage, platform mix, and menu profitability trends
- Monthly (1 hour): Deep dive into COGS, retention rates, CAC vs. LTV, and RevPASH trends
The operators who check their dashboard daily make faster, better decisions. The ones who check monthly are always reacting to problems that already happened.
How Klikit's Analytics Dashboard Helps
Klikit includes a built-in analytics dashboard designed specifically for APAC restaurant operations. It unifies data from your POS, all delivery platforms, and direct ordering channels into one view.
Key capabilities:
- Real-time sales tracking — See revenue by channel, location, and hour
- Menu performance analytics — Identify your stars, plow horses, and dogs instantly
- Delivery platform comparison — Compare true profitability across GrabFood, Gojek, Foodpanda, and more
- Labor vs. sales correlation — Spot overstaffing and understaffing patterns
- Multi-location rollup — Compare performance across all outlets from one screen
- APAC-native reporting — Handles local payment methods, currencies, and tax structures
Unlike generic business intelligence tools, Klikit's dashboard speaks restaurant. It knows that a 30% labor cost on Tuesday lunch is excellent, but the same number on Saturday dinner signals a crisis.
Getting Started
You do not need a data science team to become a data-driven restaurant. You need three things:
- A single source of truth. Stop exporting CSVs from five different platforms. Get everything in one dashboard.
- The right five metrics. Start with AOV, COGS%, labor cost%, customer retention, and platform comparison. Ignore everything else for the first 30 days.
- A weekly review habit. Block 15 minutes every Monday morning to review last week's numbers and set one specific action.
Data does not replace intuition. It sharpens it. The best restaurant owners still trust their gut — but they verify it with numbers first.
Ready to see what your data is telling you? Book a Klikit demo and explore how our analytics dashboard turns your restaurant's data into competitive advantage.