A dashboard is only useful if it gets read, which means it has to be short enough to scan and specific enough to prompt a decision. Five numbers with last year alongside beats twenty with no comparison.

Why most dashboards go unread

Not because the numbers are wrong. Because reading them takes longer than the value they return.

A screen of twenty figures with no comparison requires the reader to remember what each was last month, work out whether the change matters, and decide what to do. That is work, and it gets postponed until it stops happening.

The dashboards that survive are short, comparative, and answer a question the owner already has.

The five that earn their place

For most small businesses, in this order.

  1. Enquiries, counted the way you would count them rather than as configured conversions.
  2. Enquiries by source, which tells you where to put effort.
  3. Jobs booked, which is the outcome and only you can supply it.
  4. Spend, on advertising or anything else being tested.
  5. Cost per enquiry, which is the fourth divided by the first.

Notice that two of those do not come from any analytics tool. The most important figures in a small business dashboard are entered by hand, and a dashboard containing only what a platform can produce automatically is missing the outcome.

Comparison is what makes a number mean something

A figure on its own is unreadable. The same figure beside two others is immediately interpretable.

What to put beside it: the same month last year, which removes seasonality, and a rolling three-month average, which removes noise.

Last month is the least useful comparison and the one most dashboards default to, because for a seasonal business it mostly measures the season.

Adding those two columns is the single change that turns a list of numbers into something you can act on.

What to keep off it

That last one is worth applying honestly. A metric you have watched for a year without ever changing anything in response is decoration, and removing it makes the remaining numbers easier to see.

The cadence

Monthly for most of it, and quarterly for the conclusions.

Monthly recording keeps the history accurate, since figures are easier to capture close to the period. Quarterly reading is when decisions get made, because a month is rarely enough to distinguish a change from variation.

The exception is spend, which is worth watching more often, since a campaign misbehaving costs money continuously.

Writing the note beside the numbers

The habit that makes historical data useful, and it takes two minutes.

A line each month recording what changed: a campaign started, a page published, a price increased, a competitor opened, unusual weather, a period away.

A year later that column is what explains the figures. Without it, a dip in a spreadsheet is a mystery, and with it the answer is usually sitting in the note.

This is the single most valuable column on a small business dashboard and it contains no numbers at all.

Where it should live

Somewhere you already go rather than in a tool you have to remember.

A spreadsheet is sufficient and frequently better than a built dashboard, because it holds the hand-entered figures, the notes, and the history in one place that outlives whichever platform you use.

Automated dashboards look better and generally cannot include jobs booked or the notes, which are the two most useful things on it.

The four-minute test

Open it and time how long before you know whether anything needs attention.

If that takes more than a few minutes, it is too long, and the fix is removing rows rather than adding explanation. A dashboard is a check rather than a report.

The deeper investigation happens when something on it looks wrong, and that is where the segments become useful, as described in splitting your data in ways that help.

Frequently asked questions

Why do dashboards go unread?

Because reading them takes longer than the value returned. Twenty figures with no comparison require the reader to remember last month and work out whether the change matters.

What five numbers matter most?

Enquiries counted your own way, enquiries by source, jobs booked, spend, and cost per enquiry. Two of those must be entered by hand.

What comparison should sit beside each figure?

The same month last year, which removes seasonality, and a rolling three-month average, which removes noise. Last month is the least useful comparison.

What should be left off?

Impressions, followers and likes, bounce rate, rankings, and anything you have watched for a year without ever acting on.

What is the most valuable column?

The note recording what changed that month: a campaign started, a page published, a competitor opened. A year later it is what explains the numbers.

Where should the dashboard live?

A spreadsheet is usually better than a built dashboard, because it holds hand-entered figures, notes, and history in one place that outlives the platform.

West Coast Media Solutions Inc. provides web design, web development, hosting, digital marketing, and business consulting to organisations across Canada, drawing on more than twenty-five years in the field.

Dashboard you stopped opening in March?

We cut it to five numbers with last year beside them, which is the version that actually gets read.

Start a Conversation