Connect Google Search Console to Data Studio

Windsor.ai sends Google Search Console to Data Studio (formerly Looker Studio) as one data source: clicks, impressions, CTR and position by query, page, search type, country, device and date, plus sitemaps and fields Windsor adds.

The same account connects GA4, Google Ads and 350+ other sources, so one report can show organic search next to paid and site traffic.

No code. Free forever plan for one data source.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Google Search Console to Data Studio connector

What one Windsor.ai data source gives your Data Studio report

Data Studio’s own Search Console connector splits the data into a Site table and a URL table and shows one search type at a time. The Windsor.ai connector puts it in one data source.

Every search type in one table

Search type is a dimension, so web, image, video and news come back as rows in one table. Search appearance is a dimension too.

Fields Windsor adds

Page path levels group pages into site sections, the branded field flags queries with your domain name, and the results page number shows which queries reach page one.

Next to your other data

GA4, Google Ads, Meta Ads and your CRM go through the same Windsor.ai account, so a report can put organic clicks next to sessions, spend and leads.

Windsor.ai or Data Studio's own connector?

Supported fields: 10 metrics43 dimensions

Google’s Search Console connector is free and enough for a report about Search Console alone. Use Windsor.ai when the report needs more than that:

One data source instead of two. Google’s connector uses one table per data source, Site Impression or URL Impression, and a parameter for the search type.
Sitemaps and URL sections. Sitemap status and page path levels are not in Google’s connector.
Other sources. Data Studio blends up to five data sources; Windsor.ai connects 350+ sources in one account.
History. Both read the 16 months Search Console keeps. Windsor.ai can also send the data to BigQuery or another warehouse, which can keep it longer.

Windsor.ai Search Console data source in Data Studio with 50 fields

With Search Console in Data Studio you can:

Track clicks, impressions and position by site section using page path levels.
Compare web, image and video search in one table.
Split branded and non-branded queries with a regex field built on the query.
Put organic clicks next to GA4 sessions and Google Ads spend in the same report.
Start from the SEO report template for Data Studio or another Search Console dashboard template.

Join over 19,000+ businesses that trust Windsor.ai to streamline Google Search Console to Data Studio integration

How to connect Google Search Console to Data Studio with Windsor.ai

You need:

A Google account with at least view access to the Search Console property.
A Windsor.ai account (free forever plan, no credit card).

Sign in to Windsor.ai

Create your Windsor.ai account or log in.

Connect Search Console

Choose Google Search Console, sign in with a Google account that has access to the property and select the properties. Use the domain property for every subdomain in one data source.

Connect your Search Console account in Windsor.ai

Choose Data Studio as the destination

Pick the fields, then choose Data Studio. It opens the Windsor.ai connector: click Authorize for Data Studio, then sign in to Windsor.ai in the second popup.

Select the property and create the report

Select the Search Console property, click Connect and then Create report.

Windsor.ai Search Console connector in Data Studio with sc-domain:windsor.ai selected

Using Data Studio's own Search Console connector

Data Studio has a free Search Console connector built by Google. Click Create, then Data source, choose Search Console, select the site and pick a table. Domain properties appear as sc-domain:example.com.

	Site Impression	URL Impression
Totals counted by	property	page
Landing Page field	no	yes
Search types	web, image, video, news	also Discover and Google News
Use it for	site totals and query reports	page reports

A data source uses one table, so create two to show both. When two of your pages appear in the same result, the Site Impression table counts one impression and the URL Impression table counts two, so URL totals are higher.

For each request, Google returns only the rows it ranks highest by clicks, so a table with only Query does not list every query. On windsor.ai it listed 21,228 queries for 2 to 28 September 2026, the same count one request to the Search Console API returns. Adding Device Category to the table returned 73,252 query-and-device rows, so add it when you need the smaller queries.

Our September report on Google’s connector started from the SEO report template for Data Studio: scorecards from the Site Impression table, a daily chart of clicks and average position, and a device split.

Data Studio Search Console dashboard for windsor.ai, September 2026: 74.8K clicks, 4.6M impressions, average position 8.6, 1.62% CTR

FAQs

Is Data Studio the same as Looker Studio?

Yes. Google renamed Looker Studio back to Data Studio on 11 April 2026, and lookerstudio.google.com now redirects to datastudio.google.com. The Windsor.ai connector works the same under both names.

Do I need Windsor.ai to connect Search Console to Data Studio?

No. Data Studio has a free Search Console connector built by Google, and the steps are on this page. Windsor.ai adds search type, sitemaps and URL sections in one data source, other sources in the same account, and warehouse destinations.

Does Data Studio show more than 1,000 Search Console queries?

Yes. The 1,000-row limit belongs to the Performance report. In Data Studio, one query table returned 21,228 queries for windsor.ai over four weeks, and adding device returned 73,252 query-and-device rows.

Why do Data Studio numbers not match Search Console?

There are usually three reasons. Site Impression counts by property and URL Impression by page, so the two tables give different totals. Search Console data is 2 to 3 days behind, and Data Studio refreshes it every 12 hours. Google also withholds rare queries, which Data Studio may show as one row with an empty query; filter out Query is null.

Why does the Windsor.ai connector ask me to authorize twice?

The first authorization lets Data Studio run the connector; the second signs you in to Windsor.ai. Each opens a popup. If the page still shows Authorize, finish the popup that is still open, and sign in to only one Google account in the browser.

Can I keep Search Console data for more than 16 months?

Yes, in a warehouse. Data Studio shows the 16 months Search Console keeps. Search Console’s bulk export to BigQuery stores data from the day you set it up, and Windsor.ai can load the 16 months Search Console still holds into BigQuery or another warehouse on a schedule. Data Studio can read either.

How much does it cost?

Google’s connector is free. Windsor.ai’s free forever plan covers one data source, with no credit card. Search Console with GA4 or ad data needs a paid plan from $19 a month for three sources or $99 a month for seven. See pricing.

Where are the field list and templates?

The Search Console field reference lists every field. Start from the SEO report template for Data Studio, or browse the Search Console template gallery.

Build your Search Console report in Data Studio. Try Windsor.ai free

Free forever plan, no credit card. Paid plans from $19 a month.

Start for Free Book a Demo