A dashboard is not a screen full of charts. It is the answer to three questions you ask every week: are we doing well, what changed, and what should I do today.
If the screen does not answer those, it is not a management tool. It is decoration in colour.
Want your own scorecard?
Tell us what systems you run and we will propose the eight metrics you need.
The eight metrics every business needs
Not forty. Eight, in three groups.
| Group | Metric | What it tells you |
|---|---|---|
| Money | Revenue vs target | Where you stand |
| Gross margin | Whether the revenue leaves a profit | |
| Cash position and receivables | Whether you will make the month | |
| Customers | New customers | Whether you are growing |
| Repeat customers | Whether they stay | |
| Acquisition cost | Whether growth is sustainable | |
| Operations | Response time to enquiries | Where opportunities leak |
| Backlog or delays | Where the work jams |
The third row is the most important and the least tracked. Businesses with growing turnover close for lack of cash, not for lack of sales.
The three customer metrics are worked out with the method in digital marketing ROI.
Where the data comes from
The real obstacle is not the tool. It is that the numbers live in five different places.
| Metric | Usual source |
|---|---|
| Revenue, receivables | Accounting or ERP |
| Orders, average value | E-shop or till |
| New customers, enquiries | CRM or site form |
| Marketing spend | Ad platforms |
| Stock | Warehouse system |
The rule that saves months: one source of truth per metric. If revenue is calculated one way in the e-shop and another in the accounts, nobody trusts the dashboard and everyone reverts to their own files.
When systems do not talk to each other, the bridge is either an automation tool — see Zapier & Make — or the ERP itself, if you already have one.
Which tool fits
| Level | What it is | Cost | Suits |
|---|---|---|---|
| 1 | A spreadsheet connected to sources | €0 – €15/month | Up to 5 people |
| 2 | An off-the-shelf dashboard tool | €20 – €80/month | 5–20 people |
| 3 | The ERP’s reporting module | Included or +€50 | Businesses already on an ERP |
| 4 | A business intelligence platform | €150+/month | Many sources, many users |
Start at level 1. A spreadsheet refreshing automatically once a day covers most small businesses for years — and it teaches you which metrics you actually want before you pay for a platform.
The costly mistake: buying a platform before deciding what gets measured. The tool does not solve the “what matters” problem.
Want a tool recommendation based on your systems?
Send us the list and we will name the cheapest one that covers your needs.
How often to look at what
Too frequent is as bad as never.
| Cadence | What you look at | Why |
|---|---|---|
| Daily | Orders, backlog, errors | Operational, needs action now |
| Weekly | Sales, enquiries, spend | Course corrections |
| Monthly | Margin, acquisition cost, cash | Decisions |
| Quarterly | Trends, customer mix, pricing | Strategy |
Monthly metrics are not checked daily. Three-day fluctuations lead to decisions that get reversed the following week.
What makes a dashboard useless
Five mistakes we see constantly:
- Too many numbers. More than ten on one screen means none of them gets noticed.
- No point of comparison. “€12,400” says nothing. “€12,400, +8% on last month” does.
- Stale data. A manually updated board stops being updated within three weeks.
- No owner per metric. A number belonging to everybody gets looked at by nobody.
- Metrics that lead to no action. If nothing changes when it drops, it does not need to be there.
The test before adding a metric: “if this number doubled or hit zero, what would I do differently?” No answer means it stays out.
The one-page monthly scorecard
The simplest thing that works: one table, four columns, ten rows.
| Metric | This month | Last month | Target |
|---|---|---|---|
| Revenue | |||
| Gross margin | |||
| New customers | |||
| Acquisition cost | |||
| Repeat customers | |||
| Average order value | |||
| Receivables | |||
| Response time |
Fifteen minutes a month to fill in, and it replaces most “how are we doing?” conversations with a shared picture.
If you hold stock, add stock turnover — because that is where tied-up capital hides, as set out in inventory management.
Frequently asked questions
Do I need a developer?
For levels 1 and 2, no. For connections to an ERP or specialist sources, usually yes.
How long does setup take?
An auto-refreshing spreadsheet: 1–2 days. A full dashboard across many sources: 2–6 weeks.
Who should see it?
Whatever concerns somebody’s work, they see. Full financials, only whoever decides.
What if numbers disagree between systems?
Define which source is official for each metric, and write it beside the table.
Is it worth it for a two-person business?
Yes, but as a spreadsheet. The benefit is not automation — it is looking at the same numbers every month.
The first step
Open a spreadsheet and write down the eight metrics. Fill them in for last month, by hand.
If you struggle with any of them, you have already found your first data problem — and it matters more than any tool you might have bought.
Next step
Book a free 30-minute call with the team at The Dev Alley. We will look at your sources and build the scorecard you need.