Brass and steel cords joining cleanly into a single blank framed panel

How to Build an SEO Dashboard in Google Data Studio (Formerly Looker Studio)

SEO Analytics & Reporting

Google renamed Looker Studio back to Data Studio in April 2026. The bigger reporting problem did not change: Search Console and GA4 measure different parts of the search journey, and combining them badly can produce a dashboard that looks polished while telling the wrong story.

This guide shows how to build a reliable SEO dashboard with Google Search Console and GA4, which metrics should stay separate, when a blend is actually useful, how to avoid query-level attribution mistakes, and how to validate every important chart before a client or executive sees it.

By Rahul S., Search Counsel Co. Last updated August 2026.

Quick answer: How do you build an SEO dashboard in Data Studio?

Connect Search Console and GA4 as separate data sources, choose the correct Search Console table for each report, build executive, search, outcome and diagnostic views around real decisions, and blend GSC with GA4 only when you need page-level relationships. Before sharing the dashboard, verify its data grain, filters, URL joins, privacy limitations, credentials and date handling.

Core principle: a dashboard is not trustworthy because the charts look right. Every chart needs a known source, grain, metric, filter, limitation and decision.

Current name

Data Studio

Formerly Looker Studio. Both terms still appear in search behavior.

Search truth

Search Console

Impressions, clicks, queries and Google Search visibility.

Post-click truth

GA4

Sessions, engagement, key events and revenue after arrival.

Safe default

Blend sparingly

Join sources only where the reporting question requires it.

Is Looker Studio Now Data Studio?

Yes. Google renamed Looker Studio back to Data Studio in April 2026.

Existing reports did not suddenly stop working, but the official product name changed. Many SEO tutorials, templates and searches still use “Looker Studio,” so you will continue to encounter both terms.

For this guide: “Data Studio” means Google’s current reporting product. “Looker Studio” is retained where it helps people find instructions or understand older templates and documentation.

Google explains the 2026 naming change in its
official Data Studio announcement.

What Should an SEO Dashboard Actually Answer?

The purpose of an SEO report is not to demonstrate how many charts you can build.

A useful dashboard should answer a small set of decisions quickly:

  1. Is organic visibility growing or shrinking?
  2. Is organic traffic producing meaningful outcomes?
  3. Which pages and query groups explain the movement?
  4. What should the SEO team investigate or change next?
  5. Can we trust the data behind those conclusions?

Choose the underlying KPIs before building the report. SearchCounselCo’s SEO KPI framework goes deeper into that decision.

Search Console vs GA4: Which Source Owns Each Metric?

Search Console and GA4 are complementary systems. They are not interchangeable databases.

Question Best source Why
How often did Google show our site? Search Console Impressions are a Google Search result metric
How many Google Search clicks occurred? Search Console GSC records Search-result clicks
Which queries triggered visibility? Search Console GA4 does not provide organic Google query reporting
What happened after arrival? GA4 Sessions, engagement and events are post-click analytics
Did organic users convert? GA4 / CRM Conversion and revenue measurement happens after the search click
Did an AI assistant send referral traffic? GA4 GA4 now has an AI Assistant channel for qualifying external AI referrals
Did an AI engine cite us without sending a click? Separate AI visibility tracking Neither GA4 nor standard GSC reports every citation event

For broader measurement architecture, see SEO analytics and reporting.

Connect Google Search Console to Data Studio

Add Search Console as a native Data Studio source and select the verified property you want to report.

The important choice is the Search Console table.

Site Impression vs URL Impression

Reporting need Recommended GSC table
Property/query visibility Site Impression
Landing-page reporting URL Impression
Page-level GSC + GA4 blend URL Impression
Need both property and page reporting Add the Search Console connector twice

Google documents the connector and the two table options in its
Search Console connector documentation.

Do not force one GSC source to do every job. Query reporting and page-level diagnostics have different grains and often deserve separate sources and charts.

Connect GA4 to Data Studio

Add the native Google Analytics connector and choose the correct GA4 property.

Useful SEO dimensions and metrics often include:

  • Landing page,
  • Session default channel group,
  • Session source / medium,
  • Sessions,
  • Engaged sessions,
  • Engagement rate,
  • Key events,
  • Revenue or another business-value metric where configured.

The Data Studio GA4 connector uses the Analytics Data API and is therefore subject to API quotas and connector limitations.

Google’s current connector documentation is available in
Connect to Google Analytics.

For GA4 setup and SEO analysis beyond the dashboard itself, use the GA4 for SEO guide.

Choose the Dashboard Grain Before You Add Charts

Grain means what one row in a dataset represents.

This is one of the most important concepts in a reliable SEO dashboard because two sources can both contain “landing page” while representing completely different row structures.

Dashboard view Source Safe grain Blend?
Query performance GSC Query + date No GA4 blend needed
Search landing pages GSC URL Impression Page + date Optional
Post-click outcomes GA4 Landing page + compatible date grain Optional
Page SEO + outcomes GSC URL + GA4 Normalized page + compatible time grain Yes, carefully
Executive totals GSC + GA4 Separate source totals Usually no

SearchCounselCo dashboard rule: every chart should have a known source, grain, metric, filter, limitation and decision. If you cannot describe those six things, do not trust the chart yet.

Build the Dashboard Around Decisions

One giant page is rarely the best reporting interface.

A cleaner architecture separates the questions.

1. Executive view

Question: Is SEO contributing to meaningful business outcomes?

Possible scorecards:

  • Organic sessions,
  • Organic key events,
  • Revenue or qualified leads,
  • Search Console clicks,
  • Non-brand visibility.

2. Search visibility

Question: Is Google visibility expanding or shrinking?

  • Clicks,
  • Impressions,
  • CTR,
  • Average position,
  • Top queries,
  • Top pages,
  • Device and country segmentation where useful.

3. Outcomes

Question: What happens after organic users land?

  • Landing-page sessions,
  • Engagement,
  • Key events,
  • Revenue/value.

4. Opportunities

Question: What should the SEO team work on next?

Examples include high-impression/low-CTR pages, URLs close to page one, declining pages, and pages that attract search demand but fail to convert.

See how to diagnose low-CTR pages for the CTR workflow.

5. AI referral traffic

Question: Are external AI assistants sending measurable visits and outcomes?

6. QA & data dictionary

Question: Can another analyst understand and trust how the report was built?

This final page is one of the most valuable additions you can make to a client or internal dashboard.

When Should You Blend Search Console and GA4?

Blend them only when the reporting question genuinely needs data from both systems in the same row.

Good use case

Which landing pages receive strong Google visibility but weak post-click outcomes?

That can justify a page-level GSC URL Impression + GA4 landing-page blend.

No blend needed

If you only need:

  • query trends,
  • site-wide clicks,
  • organic sessions,
  • organic revenue,

keep the native sources separate.

Google explains that blend tables are aggregated before they are joined, which is one reason dimensions and join keys must be chosen carefully:
How blends work in Data Studio.

Do Not Turn a Landing-Page Blend Into Query-Level Conversion Attribution

This is one of the easiest ways to build a dashboard that is mathematically misleading.

Imagine Search Console contains:

Page Query Clicks
/seo/ seo dashboard 50
/seo/ reporting dashboard 30
/seo/ data studio seo 20

GA4 might contain:

Landing page Sessions Leads
/seo/ 85 5

Joining those datasets on the page can make the same 85 sessions and five leads appear beside multiple query rows.

The five leads belong to the landing page-level GA4 row. The blend does not prove that each individual Search Console query generated those five leads.

Use landing-page blends for page-level diagnosis, not invented query-level conversion attribution.

Normalize URLs Before You Join GSC and GA4

Search Console and GA4 often represent the same page differently.

Possible differences include:

  • full URL vs path only,
  • protocol,
  • hostname,
  • trailing slash,
  • query parameters,
  • case differences.

Normalize both sources to the same comparable key before joining.

Example target join key

/services/seo/

Test the normalization on real URLs before applying it to the whole report. Do not strip parameters automatically if parameters distinguish genuinely different pages in your reporting model.

Why Search Console Clicks and GA4 Sessions Do Not Match

They measure different things.

Difference Effect
Click vs session A Google Search click and a GA4 session are different events
Analytics tracking GA4 depends on analytics collection after the page loads
Consent / browser behavior Some visits may not produce the same observable GA4 session data
Attribution GA4 classifies traffic using analytics attribution rules
Daily boundaries Reporting-day definitions can differ between systems

Do not create a dashboard objective that says:

“Make GSC clicks equal GA4 sessions.”

The useful question is whether an unexpected gap reveals a tracking, attribution or implementation issue.

Search Console Data Limitations Your Dashboard Should Disclose

One common reporting mistake is treating the visible Search Console query table as if it were a complete list of every query behind the headline metrics.

Google documents several reasons that can make query-level tables incomplete or make totals look different:

  • anonymized queries are omitted for privacy;
  • stored table rows can be truncated;
  • aggregation can change with dimensions and filters;
  • page-level and property-level aggregation can produce different totals.

SearchCounselCo observation: in real page-level exports, we have seen the headline impression total materially exceed the sum of the visible query rows. That is why a dashboard should use the appropriate headline metric rather than reconstructing a “total” by summing disclosed query rows.

Google’s current explanation of Search Console performance-data aggregation and privacy is available in its
Search Console data documentation.

For a deeper diagnostic workflow, see the GSC Performance report guide.

An Auto-Updating Dashboard Is Not the Same as Real-Time Data

Data Studio can refresh connected reports automatically, but each source has its own processing and freshness limits.

Source What to remember
Search Console Performance data has processing delay and the newest data can be preliminary
GA4 Connector behavior depends on GA4 Data API access, quotas and caching
BigQuery Freshness depends on the export and warehouse pipeline

Label the reporting period clearly and avoid presenting the newest partial day as if it were comparable with a completed day.

Data Studio Says “GA4 Quota Exceeded”: What Should You Do?

GA4-backed dashboards can hit Analytics Data API quotas, especially when many charts, filters or concurrent viewers repeatedly query the same property.

Google documents quota-related errors such as exhausted concurrent requests.

Practical responses can include:

  • remove charts that answer no real decision;
  • consolidate duplicate GA4 data sources;
  • reduce unnecessarily complex report interactions;
  • consider extracted data where appropriate;
  • move heavier workloads to BigQuery when the use case justifies it.

Google’s current troubleshooting guidance is available in the
Data Studio troubleshooting guide.

Add AI Assistant Traffic to the SEO Reporting System

GA4 introduced an AI Assistant default channel in 2026 for qualifying traffic from external AI-assistant platforms.

That creates a clean additional dashboard line for:

  • AI Assistant sessions,
  • AI Assistant landing pages,
  • key events,
  • revenue/value where applicable,
  • individual session sources.

Important: Google AI Overviews and AI Mode clicks are not external AI Assistant referrals. Google’s own AI Search traffic is part of Google Search and is treated under Organic Search rather than the external AI Assistant channel.

Start with the native channel. Then inspect Session source / medium before creating custom classification rules.

For the complete workflow, use how to track ChatGPT and Perplexity referrals in GA4.

Which Data Credentials Should a Client SEO Dashboard Use?

Dashboard sharing is also a data-access decision.

Credential mode Typical use
Owner’s Credentials Viewers can see report data through the owner’s authorized data access
Viewer’s Credentials Each viewer must have access to the underlying source
Service Account Supported enterprise/BigQuery scenarios

Agency warning: always test a copied dashboard with a clean account or client viewer before sharing it. A template should never expose another client’s underlying data simply because the report design was copied.

Review Google’s
data credentials documentation
before choosing the sharing model.

Native Connectors, Search Console API or BigQuery?

Option Best for Trade-off
Native connectors Most normal SEO dashboards Source-specific history/API limits
Search Console API Custom automation and larger query extraction workflows Requires engineering or scripting
BigQuery Durable history, large-scale joins and warehouse workflows More setup, governance and cost considerations

Configure durable exports before you desperately need the history. Enabling a warehouse later should not be treated as a promise that every old row you never exported will suddenly reappear.

SearchCounselCo SEO Dashboard Pre-Launch QA Checklist

Source checks

  • Correct Search Console property?
  • Correct GA4 property?
  • Correct Search type?
  • Correct Site Impression or URL Impression table?

Grain checks

  • Can you describe what one row represents?
  • Does the blend contain a many-to-many relationship?
  • Are GA4 metrics being duplicated across GSC query rows?
  • Are date grains compatible?

Filter checks

  • Organic Search filters confirmed?
  • Branded/non-branded logic documented?
  • Report date controls applied consistently?
  • Country/device filters doing what the labels say?

URL checks

  • Protocol normalized?
  • Hostname normalized?
  • Trailing slash handled consistently?
  • Query parameters treated intentionally?
  • Case handled intentionally?

Data-quality checks

  • Does anyone incorrectly sum visible GSC query rows as a full property total?
  • Is preliminary/newest Search Console data clearly handled?
  • Are GA4 key events defined and current?
  • Have null/unknown rows been reviewed?
  • Do scorecards have the correct comparison period?

Sharing checks

  • Owner vs Viewer credentials confirmed?
  • Client permissions tested?
  • No unrelated client data visible?
  • Report works in view mode, not just edit mode?

Do not send the dashboard because it is finished visually. Send it when it has passed data QA.

SEO Reporting: Metric → Pattern → Action

A useful report should help the viewer decide what to inspect next.

Pattern Possible interpretation Next check
Impressions ↑, clicks flat Visibility may be expanding at weak positions or CTR may be underperforming Query + position distribution
Clicks ↑, GA4 sessions flat Possible tracking, consent or classification issue GA4 collection and landing pages
Organic sessions ↑, key events flat Traffic quality or page-intent problem Landing pages, intent and conversion paths
Brand ↑, non-brand ↓ Total organic may look healthy while discovery weakens Non-brand query clusters
Positions stable, impressions ↓ Demand or query mix may have changed Query trends and seasonality
AI Assistant sessions ↑ External AI referrals are becoming measurable Sources, landing pages and conversion quality
GSC total ≠ visible query sum Privacy/aggregation limitations Do not reconstruct totals from disclosed query rows

Copy This Six-Tab SEO Dashboard Blueprint

If you are building from scratch, start with this structure rather than adding charts at random.

Tab Main question Core data
1. Executive Is SEO producing business impact? Organic sessions, key events, value, GSC clicks, non-brand signal
2. Search Visibility Where are we gaining or losing search exposure? Clicks, impressions, CTR, position, queries, pages
3. Landing Pages Which pages attract search demand and what happens after arrival? GSC URL Impression + GA4 page outcomes
4. Opportunities What should we work on next? CTR gaps, near-page-one queries, declining URLs, low-conversion pages
5. AI Referrals Are external AI assistants sending qualified traffic? AI Assistant channel, sources, pages, key events
6. QA & Data Dictionary Why should anyone trust these numbers? Sources, grains, filters, freshness, credentials and known limitations

Data contract for every important chart

Document: Source → Grain → Metric → Filter → Freshness → Known limitation → Decision.

SEO Dashboard & Data Studio FAQ

Is Looker Studio now called Data Studio?

Yes. Google renamed Looker Studio back to Data Studio in April 2026. Many existing tutorials and search queries still use “Looker Studio,” so both names remain useful when finding older resources.

Is Google Data Studio free for SEO reporting?

The standard Data Studio product can be used without paying for a third-party reporting connector. Additional costs can arise from paid connectors, warehouse usage or other supporting services depending on the reporting stack.

Should I use Site Impression or URL Impression for Search Console?

Use Site Impression when the main job is property/query reporting. Use URL Impression for page-level reporting and page-level GSC/GA4 analysis. If the dashboard needs both, add two Search Console data sources.

Should I blend Search Console and GA4?

Only when one chart genuinely needs a page-level relationship between Search Console visibility and GA4 outcomes. Keep native GSC and GA4 sources separate for charts that do not require the join.

Can I attribute GA4 conversions to individual Search Console queries?

Not reliably just by blending both sources on landing page. Multiple queries can lead to the same page, while GA4 conversion metrics exist at a different grain. A page-level blend does not create query-level conversion attribution.

Why does my Search Console query table not equal the total impressions?

Google omits some anonymized queries and applies storage and aggregation rules that can make visible query rows incomplete. Do not rebuild headline totals by simply summing the disclosed query table.

Why do Search Console clicks and GA4 sessions differ?

They measure different events. Search Console records Google Search-result clicks, while GA4 records analytics sessions after arrival and applies its own collection, attribution and session logic.

How do I fix GA4 quota errors in Data Studio?

Reduce unnecessary charts and interactions, consolidate duplicate GA4 sources, and consider extracted data or BigQuery for workloads that repeatedly exceed the native GA4 Data API limits.

How should I report AI traffic in GA4?

Start with GA4’s native AI Assistant channel for qualifying external AI referrals, then inspect source/medium for additional detail. Google AI Overviews and AI Mode traffic remain Google Search traffic rather than external AI Assistant referrals.

Need an SEO Reporting System You Can Trust?

SearchCounselCo combines Search Console, GA4, technical SEO and business outcomes into reporting systems designed around decisions—not dashboard decoration.


Explore SEO Consulting

The One Thing to Do Next

Before building another chart, write down the data contract for the dashboard’s five most important metrics.

For each one, document:

  • source,
  • grain,
  • metric,
  • filter,
  • freshness,
  • known limitation,
  • decision it supports.

If a chart cannot pass that test, fixing the data model is more valuable than making the chart prettier.

Sources Used

Editorial note: Google renamed Looker Studio to Data Studio in April 2026. Connector fields, quotas, channel definitions and interface labels can change. Recheck current Google documentation before implementing business-critical reporting rules. Search Console and GA4 measure different events, so differences between their totals should not automatically be treated as errors.

Final Takeaway: Build the Data Model Before the Dashboard

A useful SEO dashboard is not the one with the most charts.

It is the one where every important number has a clear owner, the row grain is understood, blends are used only when necessary, data limitations are disclosed, and the viewer knows what decision each pattern should trigger.

Use Search Console for Google Search visibility. Use GA4 for what happens after arrival. Join them carefully at page level when the reporting question genuinely needs both. Keep query attribution within the limits of the data you actually have.

Then make the dashboard easy to read.

For the broader system, continue with SEO analytics and reporting. For KPI selection, use SEO KPIs that matter. For the Search Console layer, continue with the Google Search Console guide.

Scroll to Top