Back to blog
April 28, 20267 min read

Building an SEO dashboard my clients actually read

Google gives you a ton of data. Most small business owners can't read any of it. Here's how I built an SEO dashboard that translates Search Console into plain English — and uses AI to suggest the next blog post you should write.

There's a quiet problem most small businesses have with their websites. They've got one. They paid for it. They're vaguely aware Google decides whether anyone finds it. And then they open Google Search Console for the first time, see a wall of charts and acronyms and queries that include random JSON snippets, and close the tab.

I see this with every client. They don't need a worse SEO platform. They need someone to translate.

So I built one.

What it actually does

The clients I build sites for now get an SEO dashboard that lives at their own domain. They log in once, then it runs in the background. Every morning it checks how their site is doing in Google search and writes them a short, readable summary.

What it shows: the headline numbers up top — clicks, impressions, click-through rate, average rank — with week-over-week deltas so you can see whether things are improving or sliding. Below that, your top queries and pages: what people search for that finds you, and which of your pages actually get the click. A panel for biggest movers, queries that climbed or slipped this week, useful when something changes and you want to know why. And small sparkline charts on every metric so a trend reads as a shape instead of a number you have to squint at.

None of this is new. Search Console already has most of this data. The point is presenting it in a way that doesn't require a course in SEO to read.

The two things that make it different

Two features turn the dashboard from "Search Console with a haircut" into something I think clients will actually use.

The first is blog topic suggestions. Search Console tells you what people search for that finds you, and at what position you ranked. If you're already on page one for something, writing another post about it is wasted effort. If you've never ranked for something, it's a moonshot. The interesting opportunities are queries where you're at position 14 — Google trusts your domain enough to put you in the results, but not high enough that anyone clicks. A focused new post can usually push that to page one.

So the dashboard takes those near-miss queries and runs them through an AI. The AI looks at what you've already written, what queries you're almost ranking for, and suggests five blog posts that would capture more traffic. Each suggestion has an estimated number of monthly clicks you'd gain if the post landed at position five. That estimate uses a standard click-through-rate curve, not a guess. The list is sorted high to low, so the best ideas surface first.

The second is page audits. The dashboard crawls your top pages and grades each one on three things: the title tag, the meta description, and the structured data. Each grade comes with a one-sentence assessment ("title is 79 chars and gets cut off in search results") and a specific suggested rewrite. If a page is graded C and you click "Copy fix prompt," you get a markdown block ready to paste into a developer's hands — current state, the issue, the fix. Closes the loop from "your page has a problem" to "here's the patch."

The two features talk to each other. If a blog suggestion is targeting a query that one of your existing pages already ranks for, the dashboard tells you. "You already have a page at /blog/foo for this query — improve that instead of writing a new post." If a page audit's top query is also covered by a blog suggestion, you get the inverse note. The decision becomes "improve this page, or write a sibling," not just "do these five things."

How AI fits in

I want to be specific about this because the word "AI" gets used loosely.

The AI doesn't run the dashboard. The dashboard pulls real data from Google. The AI's job is narrow: it reads the data and explains it in human language. It suggests rewrites. It picks which queries are worth writing about. It grades pages against rules a human SEO consultant would use anyway.

Two reasons to involve AI here at all. First, generic SEO tools spit out checklists. "Title is 47 chars." Okay. Should it be? Is that good or bad for this page? An AI-driven grader can take the page's actual content and search context into account, and tell you something more useful than a number. Second, suggestions have to be specific to your site. Generic content ideas are worthless. The same five blog topics a tool would have suggested in 2018 are still being suggested today. AI can look at your near-miss queries and your existing posts and produce ideas that are actually unique to you.

It also makes some mistakes. Sometimes the grader gets confused and recommends a fix for the wrong page, or invents a problem that isn't there. So the dashboard pairs the AI grader with a deterministic, rules-based check that runs locally — same rules every time, no judgment calls. When the two disagree, I trust the deterministic one and treat the AI as a second opinion.

Why it's part of every site I build now

For most clients, SEO isn't a project. It's a slow grind that requires somebody paying attention every week. The build is the easy part. Six months in, when nobody's looked at Search Console, is when the work actually shows.

Bundling the dashboard into every site I build means the client has a reason to come back. They get an email or a glance at the dashboard and see what's working. If they want me to fix something, the dashboard tells them exactly what to ask for. The boring grind has a face.

It also gives me a reason to stay involved. SEO improvements compound. A site that goes from grade C to grade A across a dozen pages is a site that does more business this time next year. I'd rather build something that keeps producing returns than ship a brochure and walk away.

What's next

The version live today does what I just described — Search Console pull, page audit, blog suggestions, week-over-week trends, projected click upside, cross-linking. There's a list of features I want to add next. A Google Analytics panel so I can see which queries actually convert. Core Web Vitals on every page. A weekly email that summarizes the week's wins and losses. A way for clients to click "fix this" on a graded page and have the request show up in my queue.

For now, the goal is a dashboard a small business owner can read on a Monday morning, in two minutes, and walk away knowing whether the site they paid me to build is actually doing its job.

That's the bar.

Keep reading

More on SEO and AI.

Need help with your Shopify store?

I build custom Shopify solutions, AI automations, and integrations that save real time and drive revenue. Let's talk about your project.

Get in touch