A spreadsheet that you update by hand every Monday is not a dashboard — it's a chore you'll abandon by week three. The point of a real SEO dashboard is that it refreshes itself. Looker Studio (formerly Google Data Studio) does this for free, pulls directly from Search Console and GA4, and produces something you can share with a client or a CEO without exporting a single CSV. Here's how to build one that's actually worth opening.
What you need before you start
Three things: a Search Console property, a GA4 property, and a Google account with access to both. That's it. Looker Studio is free, the connectors are first-party, and nothing needs installing. If you manage SEO for someone else, get viewer access to their GSC and GA4 rather than asking them to build it — the dashboard will live in your Looker Studio and update from their data.
Step 1: Connect the data sources
Open lookerstudio.google.com, create a Blank report, and when prompted, add a data source. Add Search Console first. The connector asks you to choose the property and then a table type: Site impression (aggregated by query/date) or URL impression (aggregated by page). You'll want both eventually, so add the source twice — once as each table type. Then add a Google Analytics source and pick your GA4 property.
A common mistake is wiring every chart to GA4 because it feels more powerful. Don't. Search Console is the better source for rankings, impressions, CTR and queries; GA4 is the better source for engagement and conversions. Use each for what it's good at.
Step 2: The top row — scorecards that answer "are we up or down?"
The first thing anyone looks at is the trend. Build a row of four Scorecards across the top, each with a comparison set to previous period:
- Total clicks (Search Console)
- Total impressions (Search Console)
- Average CTR (Search Console)
- Average position (Search Console — and remember, down is good here)
The previous-period comparison turns each scorecard into a green/red delta. For average position, flip your interpretation: a red "−3%" means you moved from position 12 to 11.6, which is an improvement. It's the one metric where the colour lies, so add a short text note next to it.
Step 3: The trend chart — clicks and impressions over time
Add a Time series chart below the scorecards, source = Search Console, dimension = Date, metrics = Clicks and Impressions on two axes. Set the default date range to Last 28 days and enable a date-range control at the top of the page so viewers can widen it. This single chart tells the growth story; everything below it is diagnosis.
Step 4: The diagnosis tables
Two tables do most of the analytical work.
Top queries. A table from the Site-impression source: dimension = Query, metrics = Clicks, Impressions, CTR, Position. Sort by impressions. Add a filter to hide branded queries if you want to see only the discovery traffic. The gold is queries with thousands of impressions but a position of 8–20 — page-two rankings one good edit can lift.
Top landing pages. A table from the URL-impression source joined with GA4: dimension = Landing page, metrics = Clicks (GSC) and Engagement rate / Conversions (GA4). This is where SEO meets outcome. A page with rising clicks but a collapsing engagement rate is a ranking you're about to lose.
Step 5: Controls and filters
Add three controls to the report header: a date-range control, a drop-down filter on country (most sites have one or two markets that matter and a long tail that distorts averages), and a drop-down filter on device. With these, a single dashboard answers a dozen questions without you building a dozen pages.
Step 6: Make it shareable and self-updating
Click Share and either grant view access to specific emails or schedule an email delivery — Looker Studio can mail a PDF snapshot every Monday at 8am, which is often all a stakeholder wants. Because the connectors are live, the report reflects the latest data every time it's opened; there is no manual refresh.
The honest limitations
Looker Studio is generous but not unlimited. Search Console data is capped at 16 months and the API returns at most a few thousand rows per query, so very large sites will see sampling or truncation on the biggest tables. The GSC connector also lags by 2–3 days, same as Search Console itself, so "today" will always look empty. And joining GSC pages to GA4 landing pages relies on the URLs matching exactly — trailing slashes, parameters and protocol differences will silently split a page into two rows. Normalise your URLs or add a calculated field to strip parameters if this bites you.
None of that undermines the core value: ten minutes of setup replaces an hour of weekly CSV wrangling, and the result is a living dashboard you can hand to anyone. Start with the four scorecards and one trend chart, ship it, and add tables as questions come up. A dashboard that exists and gets opened beats the perfect one you never finish.
Once the dashboard is live, the complete GA4 for SEO guide covers how to read the underlying reports and turn them into weekly action.