SEO Keyword Dashboard: Building One From Search Console Data

An SEO keyword dashboard does not need a subscription. If your site is verified in Search Console, you already have the data: queries, pages, clicks, impressions, click-through rate and average position. What you lack is a view that groups that data the way your business thinks, and that someone other than you can open on a Monday morning without learning Search Console first.

I have worked in SEO and digital marketing for more than 16 years, and the dashboards I trust are small. This guide walks through building one in Google’s free reporting tool with the official Search Console connector. You may know the tool as Looker Studio: Google’s release notes for 16 April 2026 say “We’ve rebranded Looker Studio as Data Studio.” I use the new name below. It covers the setup, the five views I would build first, and the limits of the data, because a dashboard that hides its limits leads to bad decisions.

If you want the monthly report rather than a live dashboard, our guide to a basic SEO report covers what to send and what to leave out.

What an SEO keyword dashboard should answer

First write down the questions the dashboard must answer, or you end up with twenty charts and no conclusions. For most businesses I would start with these:

1. Is search traffic growing, flat or falling, and since when?
2. Which groups of keywords (services, products, locations, questions) bring the clicks?
3. How much of the traffic comes from people who already know the brand?
4. Which pages earn clicks, and which pages earn impressions but few clicks?
5. What changed compared with the previous period?

Search Console’s own Performance report can answer each of these one at a time, with filters and date comparisons. A dashboard adds three things: the views stay saved, you can group queries your own way, and you can share the result with people who do not have, or do not want, Search Console access.

A dashboard is worth building when it saves someone a decision’s worth of digging every week, and not before.

Step 1: Connect Search Console to Data Studio (Looker Studio)

Google documents the connector on its Connect to Search Console help page. Google’s product page says “Data Studio is available at no charge for creators and report viewers”, with a paid Pro version you do not need for this. The steps are short: create a data source, choose the Search Console connector, authorise access if asked, pick the site, pick a table and a default search type, then connect.

The choice that confuses people is the table. In Google’s words, “Google Search Console uses two different aggregation methods for reporting on search performance: site impressions and URL impressions.” The connector gives you both, “however a single data source can only use one of these.” To see them side by side, Google says to “create two data sources and add both to a single report.”

Three setup details save trouble later:

• Access. The help page says to use the same Google Account in Data Studio and Search Console, and that account needs at least view permission on the property.
• Credentials. “OWNER’S CREDENTIALS let other people view or create reports that use this data without requiring them to have their own access to the dataset.” “VIEWER’S CREDENTIALS” require each viewer to sign in with their own access. For a client or a manager without Search Console access, owner’s credentials are the practical choice; decide consciously, because anyone with the report link sees the data.
• Search type. Data sources from this connector come with a Search type parameter, so you can add a drop-down that lets viewers switch between web, image and other search types without a second dashboard.

Step 2: Build the five views that matter

Once both data sources are connected, I build the same five views for almost every site. Each one answers one of the questions above, and nothing else goes on the first page.

1. The trend

A time series of clicks and impressions from the Site Impression source, with a date range control and a comparison to the previous period. Keep CTR and average position off this chart; they move for reasons that need explaining, and a busy chart invites wrong conclusions.

2. Query groups

This is where a dashboard beats the standard report. Create a calculated field that sorts each query into a group by the words it contains: a group per service or product line, one for location words, one for question words (“how”, “cost”, “near me”), and “other” for the rest. Data Studio lets you add calculated fields in the data source’s fields panel, the same place where you rename fields and change data types. Then show clicks and impressions per group in a bar chart and a table. The groups will not be perfect on day one. Review the “other” bucket monthly and move recurring terms into proper groups.

3. Branded versus non-branded

Traffic from people who type your name is valuable, but it tells you little about SEO progress. Search Console now has its own filter for this. Its dimensions help page says the filter lets you “separate data based on whether or not the search term included your brand name”, that “Some queries might be incorrectly identified as branded or non-branded”, and that “This filter isn’t available for sites with a low number of impressions.”

In the dashboard, I build my own branded group with the brand name, common misspellings and product names, then compare its totals with Search Console’s filter once a month. If the two disagree a lot, my list is missing variants.

4. Pages

A table from the URL Impression source: page, clicks, impressions, CTR and average position, sorted by impressions. Pages with many impressions and few clicks are the first candidates for better titles and snippets. Pages with neither are candidates for a content review. If you have a lot of pages, add a calculated field that groups URLs by folder (services, blog, locations) so the table reads like your site structure.

5. What changed

Two tables, queries and pages, comparing the selected period with the previous one, sorted by the change in clicks. This replaces most of the “why did traffic drop?” emails. It shows where to look, not why something changed.

Limits of a Search Console keyword dashboard

A good SEO keyword dashboard is honest about what the data cannot do. These are the limits I explain to every team that will read one.

Anonymised queries. Google’s dimensions page says “Some queries are omitted from the report to protect user privacy” and that they are “included in chart totals, unless a query filter is applied.” The connector help page adds that Google may not show queries “made a small number of times” or “those that contain personal or sensitive information”, and that Data Studio “may aggregate these queries into a single row with a blank value.” You can exclude null values from the Query dimension with a filter, but the clicks behind them do not disappear from the totals. So never present the sum of query rows as total traffic.

Not every row is stored. The same page says “Due to internal limitations, Search Console stores and shows only the most important data rows” and that “The most complete list of queries can be exported using bulk data exports.” On a large site, the dashboard shows the head of the data, not all of it.

Property versus page totals. “Choosing the Pages dimension aggregates table data by page rather than by property”, while “The graph data is always aggregated by property.” That is the same split as the two connector tables, and it is why a page table and a site chart can show different totals for the same period.

Average position is an average of topmost positions. Google’s help page on impressions, position and clicks gives the example: if one query shows your site at positions 2, 4 and 6, it counts as 2; another at 3, 5 and 9 counts as 3; “The average position across these two queries is (2 + 3)/2 = 2.5.” The figure mixes devices, countries and days. It is a trend line, not a ranking. I explain the difference in more detail in Search Console average position vs a rank tracker.

When a dashboard is not enough

A Search Console dashboard is the right tool for trends, groups and pages. It is the wrong tool for three jobs.

Exact positions for a fixed keyword list. If a client or a director asks “where are we for these 50 keywords today?”, the dashboard can only show averages, and only for queries that earned impressions. A rank check answers that question directly, including keywords where you do not rank at all.

Keywords you do not rank for yet. Search Console only reports queries where your site appeared. New target keywords and competitor terms will not show up until you earn impressions for them.

A report that explains itself. A dashboard shows numbers; it does not say what they mean or what to do next. If the audience is a client or a board, pair it with a short written summary. Our monthly SEO report template shows a format that works for agencies and freelancers.

In audits I often find dashboards that nobody opens because they try to answer every question at once. If yours has more than one page of charts before the first conclusion, cut it back to the five views above.

FAQ

Is a Looker Studio (Data Studio) keyword dashboard free?

Google’s product page says Data Studio “is available at no charge for creators and report viewers”, and the Search Console connector is part of it. A paid Pro version exists, but a keyword dashboard does not need it. You need a verified Search Console property and a Google Account with at least view permission on it.

Why do my query rows add up to less than total clicks?

Search Console omits some queries to protect user privacy, and they remain in the chart totals. In Data Studio they may appear as a single row with a blank query, which you can filter out but should not ignore.

Should I use the Site Impression or URL Impression table?

Both. Use Site Impression for trends, query groups and the branded split, and URL Impression for page tables. Google’s documentation says one data source can use only one table, so create two and add both to the same report.

Can a keyword dashboard replace a rank tracker?

Not fully. A Search Console dashboard shows clicks, impressions and an average of topmost positions for queries where you already appear. A rank check shows the position of a fixed keyword list on a given date, including keywords you do not yet rank for.