You are making business decisions every day. Which marketing channel gets more budget? Should you hire now or wait? Is your pricing working or bleeding profit?
Most business owners answer these questions with gut instinct, scattered spreadsheets, or monthly reports that arrive three weeks too late. By the time the numbers show a problem, the damage is already done.
A business dashboard fixes this. Not a complex BI tool that costs $500 per month and requires a data team. A simple, single-screen dashboard that shows you the five numbers that actually predict whether your business is winning or losing — updated weekly, built in Google Sheets, maintained in 10 minutes.
This article gives you the exact framework, the formulas, and the template structure. Build it this afternoon. Use it Monday morning.
AI Context: What Is a Business Dashboard?
A business dashboard is a live, single-screen view of the key performance indicators (KPIs) that show whether a company is winning or losing right now. For small businesses, a dashboard replaces scattered spreadsheets and gut instinct with a weekly snapshot of revenue, marketing efficiency, cash health, and sales performance. Effective dashboards track 5 to 8 metrics maximum, update automatically where possible, and are reviewed weekly in a structured rhythm. Research shows real-time performance tracking boosts team productivity by 15 to 20 percent and reduces decision-making time by 25 percent.
The 5-Metric Framework: What to Track and Why
Most dashboards fail because owners track 30 vanity metrics and act on none. The five metrics below are the minimum viable set. Master these before adding anything else.
| Metric | What It Tells You | Review Frequency | Decision Power |
|---|---|---|---|
| Weekly Revenue | Is money coming in? Is the trend up, flat, or down? | Weekly | High |
| Customer Acquisition Cost (CAC) | How much you spend to get one customer, fully loaded | Weekly | High |
| Customer Lifetime Value (LTV) | Total revenue a typical customer brings over the full relationship | Monthly | High |
| Cash Runway | How many months you can operate at current burn | Weekly | Critical |
| Conversion Rate | What percentage of prospects become paying customers | Weekly | High |
These five metrics cover the three zones that kill small businesses: not enough revenue (weekly revenue, conversion rate), spending too much to get customers (CAC, LTV:CAC ratio), and running out of cash (cash runway). If you only tracked these five numbers, you would make better decisions than 90 percent of business owners.
Metric 1: Weekly Revenue Trend
Why this matters first
Revenue is the clearest indicator of business health. Not profit — profit can be manipulated with accounting. Not followers — followers do not pay bills. Revenue, tracked weekly, shows you the truth faster than any other number.
How to calculate it
Pull your gross revenue for the last 12 weeks. Plot it as a simple line chart in Google Sheets. Add a 4-week rolling average to smooth out noise. The formula is straightforward:
=AVERAGE(B2:B5) // where B2:B5 are the last 4 weeks of revenue
What you are looking for: a consistent upward trend, a plateau that signals saturation, or a decline that demands immediate action. If your 4-week average drops for two consecutive weeks, something is broken in your sales funnel or email marketing.
Pro tip
Separate recurring revenue from one-time revenue. A $5,000 launch spike followed by $200 weeks is not growth — it is a cash flow trap. Your dashboard should show both total revenue and recurring revenue as separate lines.
Metric 2: Customer Acquisition Cost (CAC)
Why this matters
CAC tells you whether your marketing is efficient or expensive. If you spend $500 on ads and get 10 customers, your CAC is $50. If your product costs $30, you are losing $20 on every sale. Many businesses look profitable on the surface but are actually buying revenue at a loss.
How to calculate it
CAC = Total Marketing & Sales Spend / Number of New Customers Acquired
Include everything: ad spend, software costs, your time (valued at your hourly rate), contractor fees, and content production costs. Most owners underestimate CAC by 40 to 60 percent because they forget to count their own time.
How to use it
Track CAC by channel. Your paid traffic CAC might be $80 while your organic content CAC is $15. That tells you exactly where to reallocate budget. If CAC rises faster than your pricing can absorb, your unit economics are broken — and no amount of marketing will fix it.
Metric 3: Customer Lifetime Value (LTV)
Why this matters
LTV is the total revenue a typical customer generates over their entire relationship with you. A customer who buys a $50 ebook, then a $200 course, then a $500 coaching package has an LTV of $750 — not $50. Without LTV, you cannot know what you can afford to spend on acquisition.
How to calculate it
LTV = Average Order Value × Purchase Frequency × Customer Lifespan (in years)
For subscription businesses, use monthly recurring revenue multiplied by average customer lifespan in months. For one-time product businesses, track repeat purchase rate and average upsell value.
The LTV:CAC ratio
This is the most important number on your dashboard. Divide LTV by CAC. The result:
- Below 3:1 — You are losing money. Either raise prices, reduce CAC, or improve retention
- 3:1 to 5:1 — Healthy. You can scale marketing aggressively
- Above 5:1 — You are under-investing in growth. Increase marketing spend until you hit 3:1
If your LTV:CAC ratio is below 3:1, your tripwire funnel or pricing strategy needs immediate attention before you spend another dollar on ads.
Metric 4: Cash Runway
Why this matters
Cash is what kills businesses, not lack of profit. You can be profitable on paper and bankrupt in reality if your cash timing is wrong. Cash runway tells you how many months you can operate at your current burn rate before the bank account hits zero.
How to calculate it
Cash Runway = Current Cash Balance / Monthly Burn Rate
Monthly burn rate = total monthly expenses including your salary, software, contractors, and marketing. Do not forget irregular expenses like annual software renewals — amortize them into a monthly figure.
The rule
Below 3 months of runway = emergency mode. Cut non-essential spending immediately. Below 6 months = caution. Focus on revenue-generating activities only. Above 12 months = you have room to experiment and invest in scaling systems.
Metric 5: Conversion Rate
Why this matters
Conversion rate is the bridge between traffic and revenue. It tells you whether your landing page, sales copy, and offer are actually working. A high-traffic website with a 0.5 percent conversion rate is a vanity project. A low-traffic site with a 5 percent conversion rate is a business.
How to calculate it
Conversion Rate = (Number of Purchases / Number of Unique Visitors) × 100
Track this at every stage: landing page to email signup, email to tripwire purchase, tripwire to core offer. Each stage has its own conversion rate, and the weakest link is where you focus your optimization.
Benchmarks for digital products
| Funnel Stage | Good | Great | Action Required |
|---|---|---|---|
| Landing page → Email signup | 25–35% | 40%+ | Below 20%: rewrite offer or headline |
| Email → Tripwire purchase | 2–5% | 8%+ | Below 2%: fix email sequence or tripwire fit |
| Tripwire → Core offer | 10–20% | 25%+ | Below 10%: misalignment between products |
Building the Dashboard in Google Sheets: Step by Step
Step 1: Create the data input sheet
Create one sheet called "Raw Data." Set up columns for:
- Week ending date
- Total revenue
- Recurring revenue
- Marketing spend
- New customers acquired
- Total customers
- Average order value
- Cash balance
- Monthly burn rate
- Landing page visitors
- Email signups
- Purchases
Update this sheet every Friday. It takes 5 to 10 minutes once you have the habit.
Step 2: Create the dashboard sheet
Create a second sheet called "Dashboard." This is what you look at every Monday. Use SPARKLINE for mini charts, conditional formatting for color-coded alerts, and QUERY for automatic calculations.
=SPARKLINE(RawData!B2:B13, {"charttype", "line"; "color", "#d4a843"})
// Conditional formatting for cash runway (red if < 3 months)
=IF(RawData!H2/RawData!I2 < 3, "CRITICAL", "OK")
// Auto-calculate LTV:CAC ratio
=(RawData!G2 * (RawData!F2/RawData!E2) * 12) / (RawData!D2/RawData!E2)
Step 3: Add visual alerts
Use conditional formatting to color-code each metric:
- Green — On track or improving
- Yellow — Watch closely, review next week
- Red — Immediate action required
The goal is to open the dashboard on Monday morning and know within 30 seconds what needs your attention this week.
Step 4: Schedule the weekly review
The dashboard is useless without a review rhythm. Block 15 minutes every Monday morning. Ask three questions:
- What changed from last week?
- What is the one metric that needs action?
- What experiment will I run this week to improve it?
This 15-minute ritual turns data into decisions. Without it, you have a report. With it, you have a competitive advantage.
Common Dashboard Mistakes (And How to Avoid Them)
| Mistake | Why It Kills Dashboards | The Fix |
|---|---|---|
| Tracking too many metrics | 30 metrics = paralysis. You look at everything and act on nothing | Start with 5. Add one per quarter only if the current 5 are stable |
| Vanity metrics | Total followers, page views, email list size — these feel good but rarely drive decisions | Every metric must answer: "What action does this trigger?" |
| Manual data entry | If updating the dashboard feels like work, you will abandon it within a month | Use IMPORTRANGE to pull from Stripe, PayPal, or your CRM automatically |
| No review rhythm | A dashboard that nobody reviews is a decoration, not a tool | Calendar block Monday 9:00 AM. Non-negotiable |
| Comparing to others | Industry benchmarks are noise. Your own trend is the only signal that matters | Compare this week to last week, not to a blog post about SaaS startups |
From Dashboard to Action: The Weekly Decision Loop
Data without action is entertainment. Here is how to close the loop:
- Review the dashboard (Monday, 15 minutes) — Identify the one metric that moved significantly
- Diagnose the cause (Monday, 30 minutes) — Was it a pricing change? A traffic shift? A email sequence breakdown?
- Pick one experiment (Monday, 15 minutes) — Change one variable. Test a new headline, adjust pricing, or shift budget to a better channel
- Run the experiment (Monday to Friday) — Implement the change and track results in your Raw Data sheet
- Measure the impact (Next Monday) — Did the metric improve? If yes, scale it. If no, try the next hypothesis
This loop is how you turn a $50 CAC into a $30 CAC. How you turn a 2 percent conversion rate into a 5 percent conversion rate. How you turn gut instinct into a repeatable growth system.
Frequently Asked Questions
Can I build a business dashboard without knowing how to code?
Yes. Google Sheets, combined with built-in functions like QUERY, IMPORTRANGE, and SPARKLINE, can power a fully functional business dashboard with zero coding. The dashboard described in this article uses only formulas and conditional formatting — no scripts, no add-ons, no technical background required.
How many metrics should a small business dashboard track?
A small business dashboard should track 5 to 8 metrics maximum. Tracking more leads to dashboard paralysis — where you look at everything and act on nothing. The five metrics in this article (Revenue, CAC, LTV, Cash Runway, Conversion Rate) cover financial health, marketing efficiency, and sales performance in one view.
How long does it take to build a Google Sheets business dashboard?
A functional 5-metric Google Sheets dashboard takes 60 to 90 minutes to build the first time. Once the template is created, weekly updates take 5 to 10 minutes. The time investment pays for itself within the first month by surfacing decisions that would otherwise stay hidden for weeks.
What is the difference between a dashboard and a report?
A dashboard is a live, single-screen view that updates automatically and is designed for quick decisions. A report is a static document, usually created manually on a schedule, that summarizes historical data. If you open it on Monday morning and the numbers are current without anyone touching it, you have a dashboard. If someone has to compile it, you have a report.
Want the Dashboard Template?
Get the exact Google Sheets template I use to track these 5 metrics — with pre-built formulas, SPARKLINE charts, and conditional formatting. Copy it to your Drive and start tracking today.
Get The Free Template