The Reporting Dashboard That Writes Its Own Reports

Where Reporting Time Goes

An owner wants to know one thing. Is the money I spend on marketing working? The answer lives in three places. Calls are in the phone system. Rankings are in a search tool. Jobs are in the shop software. Nobody has time to log into all three and line them up.

So someone builds a report by hand. They pull screenshots, paste numbers into a deck, and write a paragraph. Say that takes three hours a week. That is a working week each quarter spent on copying numbers from one screen to another. And by the time the owner reads it, it is old.

What We Built

We built one dashboard that reads all three and puts them side by side. Calls, rankings and jobs, on one timeline, for each site.

Progress in marketing is slow to show up as money. A page climbs from the second page of results to the first long before the phone rings more. So the dashboard scores the steps along the way. Each campaign step has a weight in impact points. Each milestone, like reaching page one, the top three, or the map pack, is recorded once. A weekly chart shows the points climb, and a short list shows the latest moves.

Steps have plain statuses. In progress, done, on hold, or waiting on the client. When the next move is the owner's, the dashboard says so in its own box, so nobody wonders why a step has not moved.

Then it writes the reports. A daily email goes out only on days when something happened. A weekly report goes out on Mondays. A monthly report goes out on the first. Every one is stored, so you can look back at what was sent.

How It Is Wired

A scheduled worker at the edge runs the sweep. It checks rankings, reads search data, and looks for new milestones. Search data lags by a few days, so each report window ends a few days back. That way a report never shows a drop that is really just data that has not arrived yet.

Milestones live in their own table and are recorded once each. The first sweep found milestones that had already happened. Those were marked as the baseline, and they never appear in a report. A report that claims last year's win as this week's news is a report nobody trusts twice.

Every table the dashboard uses has row level security on, with public access revoked. You can read how that works on the analytics and reporting page.

What Broke and What We Changed

Logins That Could See Too Much

The first client login could read every site on the dashboard. We rebuilt access as default deny. A client login names the sites it may see, and a login with no sites is refused. Clients can only read, and only a short list of pages. Every other path and every write is refused. The site list comes from the login itself, never from the address bar, so changing a link does not show someone else's data.

Tables Open to the Public

The dashboard shares a database with other tools. Default grants had left a set of its tables readable and writable by anyone with the public key. We turned row level security on for every one and revoked public access. Every new table now starts that way.

A First Run That Would Have Bragged

On the first sweep, every rank the sites already held looked like a new milestone. Without a baseline flag, the first report would have announced a pile of wins that were not new. The baseline rule came from that.

What the Dashboard Deliberately Does Not Do

• It does not send an empty daily email. No news means no email.
• It does not report baseline wins. Only what changed since the start counts.
• It does not give out logins by default. Each client login is created on purpose, scoped to named sites.

Every one of these limits came from asking what would make an owner stop reading. An email every day with nothing in it teaches people to ignore the email. A report that counts an old win as new teaches them to doubt the report. A login that shows a little too much is the fastest way to lose trust you cannot win back.

So the dashboard stays quiet unless it has something true to say, and it only says it to the people who should hear it.

What It Means When You Switch It On

You stop building reports. You open one screen and see calls, rankings and jobs lined up. You get an email when something good happens, and a clean report every week and month without asking. When a step is waiting on you, the dashboard says so plainly.

Your team gets their Mondays back too. The hours that went into copying numbers into a deck now go into the work the numbers are about.

For the report format itself, read the guide to a weekly client report.