Forcked
📖 Guide10 min readBy Lin6

Restaurant Analytics Dashboards: Which Metrics Actually Matter?

Restaurant Analytics Dashboards: Which Metrics Actually Matter?

Most restaurant POS systems generate hundreds of reports — but 90% of that data goes unused. The key isn't more data; it's tracking the right metrics and making them easy to act on.

Here's how to build a restaurant analytics dashboard that actually improves your business.

Why Most Restaurant Analytics Fail

Cluttered restaurant dashboard with too many metrics Too many metrics = analysis paralysis. Focus on the KPIs that drive decisions

Common mistakes:

  • Data overload — 50+ metrics, unclear priorities
  • Vanity metrics — tracking "likes" instead of sales
  • Lagging indicators — finding out problems after they've cost you money
  • No action plan — data without decisions is useless
  • Wrong frequency — checking weekly metrics daily (noise) or daily metrics weekly (too late)

What works: 5-10 core KPIs that you check daily + deeper metrics reviewed weekly/monthly.

The 7 Essential Restaurant Metrics (Daily Dashboard)

1. Revenue vs. Target (The North Star)

What it is: Today's sales compared to goal (budget/forecast)

Why it matters: If you're tracking only one metric, this is it. Everything else explains why revenue is up or down.

How to calculate:

Revenue % = (Today's Sales / Target Sales) × 100

Dashboard display:

  • Big number: "$4,283" (today's sales)
  • Comparison: "+8.2% vs target" (green if above, red if below)
  • Trend: 7-day sparkline graph

Action trigger:

  • Below target by 10%+ → Run promotion, extend happy hour, push specials
  • Above target by 20%+ → Prepare for busy period, adjust staffing

2. Labor Cost Percentage

What it is: Labor cost as a percentage of sales

Why it matters: Labor is typically 25-35% of revenue. Too high = profit loss. Too low = poor service.

How to calculate:

Labor % = (Total Labor Cost / Total Sales) × 100

Ideal range:

  • Quick service: 20-25%
  • Casual dining: 25-35%
  • Fine dining: 30-40%

Dashboard display:

  • Current: "31.2%"
  • Target zone: 25-35% (visual indicator)
  • Week-over-week trend

Action trigger:

  • Over 35% → Cut shifts, optimize schedules, review overtime
  • Under 20% → Check if you're understaffed (may hurt service)

3. Food Cost Percentage

What it is: Cost of ingredients as percentage of sales

Why it matters: Food costs typically 28-35%. High food cost = menu pricing issues or waste.

How to calculate:

Food Cost % = (Cost of Goods Sold / Food Sales) × 100

Ideal range: 28-35% (depends on concept)

Dashboard display:

  • Current: "33.1%"
  • Historical average: "31.8%"
  • Items with highest food cost (top 5)

Action trigger:

  • Over 35% → Check for waste, portion control, theft, supplier pricing
  • Sudden spike → Investigate inventory, recent menu changes

4. Table Turnover Rate

What it is: How many times each table is used per service period

Why it matters: Higher turnover = more revenue per table. Too high = rushed service.

How to calculate:

Turnover = Total Covers / Number of Tables

Benchmarks:

  • Quick service: 3-5 turns per meal period
  • Casual dining: 1.5-2.5 turns
  • Fine dining: 1-1.5 turns

Dashboard display:

  • Lunch: "2.3 turns"
  • Dinner: "1.8 turns"
  • Average wait time: "14 minutes"

Action trigger:

  • Below target → Speed up service, pre-bus tables, optimize kitchen
  • Long wait times → Implement waitlist, text notifications

5. Average Check Size

What it is: Average amount each customer spends

Why it matters: Small increases compound. Raising average check by $2 = $14,000+ annually (for 20 daily covers).

How to calculate:

Average Check = Total Sales / Number of Checks

Dashboard display:

  • Current: "$28.40"
  • Goal: "$30.00"
  • Top upsell items contributing to higher checks

Action trigger:

  • Below target → Train servers on upselling, promote appetizers/desserts
  • High performers → Identify which servers/times have highest checks

6. Order Accuracy Rate

What it is: Percentage of orders with no errors/voids

Why it matters: Errors cost money (remakes), slow service, and frustrate customers.

How to calculate:

Accuracy % = (Orders Without Voids / Total Orders) × 100

Target: 95%+ accuracy

Dashboard display:

  • Current: "94.3%"
  • Most common errors: "Wrong modifiers (32%), wrong size (18%)"
  • Error rate by server/station

Action trigger:

  • Below 90% → Retrain staff, simplify menu, fix POS setup
  • Specific servers low → Individual coaching

7. Prime Cost (The Profitability Killer)

What it is: Combined food + labor costs as percentage of sales

Why it matters: This is your biggest expense category. Keep prime cost under 60-65% to stay profitable.

How to calculate:

Prime Cost % = ((Food Cost + Labor Cost) / Total Sales) × 100

Target: Under 60-65%

Dashboard display:

  • Current: "63.4%"
  • Breakdown: Food 31.2%, Labor 32.2%
  • Trend: Last 30 days

Action trigger:

  • Over 65% → Address food waste AND labor scheduling
  • Over 70% → Urgent: raise prices, cut costs, or risk unprofitability

Weekly Deep-Dive Metrics

Menu Performance Analysis

Track for each menu item:

  • Item sales count — How many sold?
  • Revenue contribution — % of total sales
  • Food cost % — Profitability
  • Menu engineering quadrant (Stars, Plow Horses, Puzzles, Dogs)

Menu engineering matrix:

          High Profit Margin    Low Profit Margin
High Sales  ⭐ STARS           🐴 PLOW HORSES
            (promote heavily)  (increase price)

Low Sales   🧩 PUZZLES         🐕 DOGS
            (rework or remove) (remove from menu)

Action: Remove "Dogs," promote "Stars," fix pricing on "Plow Horses."

Server Performance

Per-server metrics:

  • Average check size
  • Covers per shift
  • Upsell rate (appetizers, desserts, drinks)
  • Order accuracy
  • Customer satisfaction (if you collect feedback)

Why track: Identify top performers (reward them) and training opportunities.

Peak Hour Analysis

Track by hour:

  • Sales by hour (heatmap)
  • Busiest days/times
  • Staffing vs demand

Use for: Labor scheduling, happy hour timing, staff breaks.

Customer Feedback Trends

Sources:

  • Online reviews (Google, Yelp)
  • POS feedback (if integrated)
  • Social media mentions

Track:

  • Overall sentiment (positive/negative %)
  • Common complaint themes
  • Service vs food issues

Monthly Strategic Metrics

Customer Acquisition Cost (CAC)

What it is: How much you spend to bring in one new customer

How to calculate:

CAC = (Marketing + Advertising Cost) / New Customers

Benchmark: $10-25 for restaurants

Why it matters: If CAC > average customer lifetime value, you're losing money on marketing.

Customer Lifetime Value (LTV)

What it is: Total revenue a customer generates over their relationship with you

How to calculate:

LTV = Avg Check × Visits per Year × Avg Customer Lifespan

Example: $30 check × 12 visits/year × 3 years = $1,080 LTV

Golden ratio: LTV should be 3-5x CAC

Inventory Turnover

What it is: How quickly you use and replace inventory

How to calculate:

Inventory Turnover = COGS / Average Inventory Value

Ideal: 4-8 times per month (varies by concept)

Why it matters: Low turnover = cash tied up in inventory, spoilage risk.

How to Build Your Dashboard

Step 1: Choose Your Platform

POS built-in dashboards:

  • Toast: Strong reporting, customizable
  • Square: Simple dashboards, easy to understand
  • Lightspeed: Advanced analytics, multi-location
  • TouchBistro: Good mobile app dashboards

Third-party analytics:

  • MarketMan: Inventory + analytics
  • Restaurant365: Full accounting + operations
  • 7shifts: Labor analytics
  • Avero: Enterprise-grade BI

DIY dashboards:

  • Google Data Studio (free) — connects to POS via API
  • Tableau ($$) — powerful but complex
  • Power BI ($) — Microsoft ecosystem

Step 2: Design for Glanceability

Dashboard design rules:

1. Hierarchy

  • Most important metric = biggest, top-left
  • Use size and color to show priority
  • Group related metrics

2. Color coding

  • Green = on target / good
  • Yellow = warning / attention needed
  • Red = problem / urgent
  • Use sparingly (don't overdo color)

3. Context

  • Never show a number alone
  • Always include comparison (vs target, vs yesterday, vs last year)
  • Add trend arrows (↑ ↓) or sparklines

4. Actionability

  • Each metric should suggest an action
  • Link to detailed reports when needed
  • Surface anomalies automatically

Bad dashboard example:

Sales: $4,283
Labor: $1,336
Food: $1,417

Good dashboard example:

Sales: $4,283 (↑ 8.2% vs target) ✅
Labor: 31.2% (↑ 2.1% vs last week) ⚠️
Food: 33.1% (within target range) ✅
Prime Cost: 64.3% (approaching limit) ⚠️

Step 3: Set Up Alerts and Notifications

Auto-alert triggers:

  • Labor cost exceeds 35%
  • Food cost spikes over 2% from average
  • Sales below target by 15%+
  • Inventory item running low
  • Server with multiple voids (possible theft)

Delivery method:

  • SMS for urgent (end-of-shift labor overage)
  • Email for daily summaries
  • Slack/Teams for team visibility

Step 4: Schedule Review Cadence

Daily (5-minute check):

  • Revenue vs target
  • Labor %
  • Food cost %
  • Prime cost

Weekly (30-minute review):

  • Menu performance
  • Server performance
  • Peak hour analysis
  • Customer feedback trends

Monthly (2-hour deep dive):

  • Financial statements
  • CAC/LTV analysis
  • Inventory turnover
  • Strategic adjustments

Real Dashboard Examples by Restaurant Type

Quick Service / Fast Casual

Focus: Speed, throughput, labor efficiency

Key metrics:

  1. Average service time (target: under 3 minutes)
  2. Orders per labor hour (productivity)
  3. Mobile/online order %
  4. Labor cost % (target: 20-25%)
  5. Average check size

Casual Dining

Focus: Table turnover, upselling, experience

Key metrics:

  1. Table turnover rate (target: 2-2.5x per service)
  2. Average check per person
  3. Appetizer/dessert attach rate
  4. Server performance rankings
  5. Prime cost %

Fine Dining

Focus: Per-cover revenue, wine sales, experience

Key metrics:

  1. Average check per cover (target: $80-150+)
  2. Wine sales % (target: 25-35% of revenue)
  3. Reservation conversion rate
  4. Special occasion bookings
  5. Labor cost % (target: 30-40%)

Common Analytics Mistakes to Avoid

1. Tracking Everything

Problem: 100+ metrics = no focus
Solution: Pick 7-10 core daily metrics, rest are weekly/monthly

2. No Benchmarks

Problem: "Sales are $4,000" — is that good?
Solution: Always compare to target, previous period, industry standard

3. Ignoring Trends

Problem: Seeing individual data points, missing patterns
Solution: Always show 7-day, 30-day, or year-over-year trends

4. Not Acting on Data

Problem: Checking dashboard, then doing nothing
Solution: Each metric should have a decision rule (if X, then Y)

5. Checking Wrong Frequency

Problem: Panicking over hourly sales dips (normal variance)
Solution: Daily volatility is noise; weekly trends are signal

Action Plan: Start Tracking This Week

Day 1: Audit current reporting

  • What reports does your POS generate?
  • Which do you actually look at?
  • What's missing?

Day 2: Pick your 7 core KPIs

  • Start with: Revenue, Labor %, Food %, Average Check, Prime Cost
  • Add 2 more specific to your concept

Day 3: Set up daily dashboard view

  • Use POS built-in dashboard OR Google Data Studio
  • Design for mobile viewing (check on phone)
  • Add comparison/context to each metric

Day 4: Define targets and alerts

  • Set realistic targets for each KPI
  • Configure alerts for out-of-range metrics
  • Test alert delivery (SMS/email)

Day 5: Train management team

  • Walk through dashboard together
  • Explain each metric and why it matters
  • Assign action owners (who fixes what)

Week 2+: Review and refine

  • Check dashboard daily
  • Make one data-driven decision this week
  • Adjust metrics if something isn't useful

The Bottom Line

Effective restaurant analytics isn't about tracking everything — it's about tracking the right things and acting on them.

Start with 7 core metrics:

  1. Revenue vs target
  2. Labor cost %
  3. Food cost %
  4. Table turnover
  5. Average check
  6. Order accuracy
  7. Prime cost

Make your dashboard:

  • Glanceable (understand in 30 seconds)
  • Actionable (each metric suggests a decision)
  • Accessible (mobile-friendly, always available)
  • Contextual (comparisons, trends, targets)

Most importantly: Data without decisions is just trivia. Every week, make at least one business decision based on your analytics — adjust staffing, change a price, promote a menu item, train a server.

That's when analytics becomes powerful.


Ready to level up? Open your POS reporting today, screenshot your current reports, and ask: "Which of these 7 metrics can I see clearly right now?" Start there.