A dashboard for the owner who does not want to open Analytics

There is a common tension between marketing agencies and many of their clients: the agency wants to show full dashboards with dozens of metrics, and the business owner, who has a shop, a workshop or a clinic to run, simply wants to know whether things are going well or badly, without having to learn to read a Google Analytics report. Neither side is wrong, but the solution is not forcing the owner to become an analyst, it is designing a dashboard specifically for someone who does not want (or need) to open any tool.

The starting principle: fewer metrics, not more

The natural temptation when building a dashboard is to include everything that can be measured, "just in case it is needed". For a business owner with no time or interest in going deep, that backfires: the more numbers shown, the harder it is to tell which ones truly matter. The goal of this kind of dashboard is not thoroughness, it is immediate clarity: five or six numbers at most, answering the real question that owner asks, which is almost always a version of "is the business doing well this month?"

Which five or six numbers are usually the right ones

Although it varies by business, a reasonable starting point for most SMEs includes: the number of leads or sales achieved (the bottom line, what actually matters), where those leads came from (to know which channel is working), how much it cost to get each one (if there is ad spend involved), a comparison against the same period last month or last year (to give context, because a single number with no comparison says little), and, where applicable, a simple visual alert (green, yellow, red) that signals at a glance whether something needs attention.

Format matters as much as content

A busy business owner is not going to open an interactive dashboard and explore data on their own, however well designed it is. What they will read is a weekly or monthly automated email, with the key figures already summarised in the body of the email itself (not behind a link that has to be clicked and waited on to load), in direct language ("this month you got 34 leads, up 12% from last month") instead of technical marketing terminology.

How to automate it without relying on someone preparing it by hand every time

Tools like Looker Studio let you schedule an automatic email report at whatever frequency you choose, removing the need for someone to manually gather and send the figures every week or month. Setting it up properly once, with the right metrics and the right format, eliminates ongoing maintenance friction entirely.

The value of time comparison over an isolated number

Saying "you had 200 visits this month" says almost nothing without context: it could be 200 excellent visits or 200 terrible ones, depending on what came before. Any dashboard designed for a non-analyst should always include the comparison (against the previous period, against the same period last year if the business has meaningful seasonality) alongside each figure, not as a separate data point you have to go looking for.

Avoiding the trap of metrics that sound good but say nothing

It is tempting to include impressive-"sounding" numbers in this kind of summary (total visits, social media impressions) even if they have no direct relation to the business's bottom line. For an owner who is only going to glance at the dashboard, including those numbers with no connection to real results creates a false sense of success or failure that does not match what actually matters: how many new customers and how many sales the marketing effort generated.

When it is worth going deeper than the summary

The simplified dashboard does not replace detailed analysis, it complements it: it serves routine monitoring and spotting at a glance whether something is off, but when the summary flags a problem (a noticeable drop, a channel that stops working), that is when someone on the marketing team should dig into the full detail to diagnose the cause, rather than waiting for the owner to do it themselves.

An example of a well-written summary versus a poorly written one

Compare "CTR: 3.2%, sessions: 1,847, bounce rate: 54%, conversions: 12" with "12 new people got in touch this month interested in your services, up 20% from last month. Most of them found you by searching directly on Google. Everything is moving in the right direction." The underlying information can be practically the same, but only the second version will be read and understood by a business owner with no digital marketing training, and only the second version genuinely answers the question that person was asking when they opened the email.

When the simplified summary starts falling short

As a business grows and starts managing several marketing channels with very different budgets and business intent, the five-figure summary can start hiding important nuances (for instance, that one channel is improving while another is worsening, even though the total result stays stable). At that stage of maturity, it is usually worth introducing a brief, periodic meeting, on top of the automated summary, where someone from the team explains in two minutes what is behind the figures, instead of trying to make the report format itself carry all that complexity.

Involving the owner in choosing which five figures matter

A common mistake is letting the agency or marketing team decide alone which five figures go into the summary, without directly asking the owner what they actually care about knowing each week. A brief conversation at the start ("if you could only see one number every Monday, what would it be?") usually reveals the owner's real priority does not always match what the marketing team would have chosen by default, and adjusting the summary to that real priority is what guarantees it actually gets read, not just sent.

Step by step: building the automated report in Looker Studio

First, connect Looker Studio (free) to the relevant data sources: Google Analytics, Google Ads if there is ad spend, and the offline conversions spreadsheet if using the manual method described in other articles in this category. Second, create a new report with a deliberately simple design: no complex line charts or twenty-column tables, just the five or six figures agreed with the owner, each with its comparison against the previous period. Third, write above each figure a plain-language sentence explaining what it means, not just the technical label ("New enquiries" instead of "Conversions"). Fourth, in the report settings, enable scheduled email delivery, choosing the agreed frequency (weekly or monthly) and the day and time the owner usually has time to read calmly. Fifth, send a first test version and ask for direct feedback: is it understandable without help? Is anything important missing? Is anything unnecessary? Sixth, adjust the design based on that feedback before leaving it running automatically. Once set up, the report requires no manual maintenance beyond occasional reviews when the business's goals change.

Frequently asked questions