Free Data Studio SEO Report Template for Google Search Console

The Windsor.ai SEO report template is a free one-page Data Studio report built on Google’s own Search Console connector. Copy it, point it at your Search Console property, and it shows clicks, impressions, CTR and average position over time, by device, by query and by landing page.

Google renamed Looker Studio back to Data Studio on 11 April 2026. The template, the connector and the menus are the same under both names.

What the template shows

The screenshot above is the template on windsor.ai’s own Search Console property for September 2026. The report has:

• Filters for country, landing page, device, query and date range.
• Scorecards for clicks, impressions, average position and site CTR; the first three show the change against the previous period.
• A daily chart of clicks and average position.
• A device split for desktop, mobile and tablet.
• A landing page and query table with impressions, clicks and CTR, and the change against the previous period.
• A query table with clicks, impressions, site CTR and average position.

It uses two Search Console data sources, because Google’s connector reads one table per data source. The scorecards, chart and query table come from the Site Impression table, which counts totals by property. The landing page table comes from the URL Impression table, which counts by page.

How to copy the template

1. Open the SEO report template in Data Studio. It loads empty, because the sample data belongs to the template’s owner.
2. Click the three-dot menu at the top right and choose Make a copy.
3. Data Studio asks for two new data sources. In the first drop-down choose Create data source, then Search Console, your site, the Site Impression table and the web search type. Click Connect and Add to report.
4. Repeat for the second drop-down with the URL Impression table.
5. Click Copy report. The copy opens with your data.

Domain properties appear as sc-domain:example.com and cover every subdomain and protocol. If the CTR scorecard shows “Invalid sort” in your copy, click Edit, delete that scorecard and add a new one with Site CTR as the metric. That is what we did in ours.

Questions the report answers

• Are clicks and impressions going up or down against the previous period, and on which days did they move?
• Which queries bring the most clicks, and which get impressions without clicks?
• Which landing pages earn organic traffic, and for which queries?
• How do desktop and mobile compare?
• How does one country, landing page or query perform on its own, using the filters?

Make the report more useful

• Exclude the blank query row. Google withholds rare queries, and Data Studio may group them into one row with an empty query. Add a filter that excludes Query is null.
• Add Device Category to the query table for the smaller queries. For each request Google returns only the rows it ranks highest by clicks. On windsor.ai a query table listed 21,228 queries for 2 to 28 September 2026; with Device Category added it returned 73,252 query-and-device rows.
• Compute CTR from the totals. In tables and blends, create a field with SUM(Clicks)/SUM(Impressions) instead of averaging a CTR column.
• Split branded queries with a regex. Create a field such as CASE WHEN REGEXP_MATCH(Query, "(?i).*(yourbrand|your brand|yourbrnd).*") THEN "Branded" ELSE "Non-branded" END and add misspellings from your own query list.
• Read the latest days with care. Search Console data is usually 2 to 3 days behind, and Data Studio refreshes Search Console data every 12 hours.

Add GA4, ad, Semrush or Ahrefs data

The template reads Search Console only. To put organic search next to sessions, ad spend or keyword research, you have two routes:

• Blend in Data Studio. A blend joins up to five data sources, for example Search Console and GA4 on date and landing page. Search Console reports full URLs and GA4 reports page paths, so make a page path field on one side first.
• Connect the sources through Windsor.ai. From the same Windsor.ai account as Search Console, connect GA4, Google Ads, Semrush, Ahrefs or any of 350+ other sources to Data Studio. Windsor.ai can also send them to BigQuery or another warehouse, which can keep Search Console data beyond its 16 months.

The Search Console to Data Studio connector page compares Google’s connector with Windsor.ai’s.

Build your own SEO dashboard

To start from a blank report instead, click Create, then Report, and add the Search Console data source. Then add charts from Add a chart:

• Table with Query or Landing Page as the dimension and clicks, impressions and CTR as metrics.
• Time series with Date as the dimension for clicks and impressions, or average position on its own axis.
• Bar chart with Country as the dimension and average position as the metric.
• Pie chart with Device Category for the device split.
• Geo chart with Country for a map of impressions or CTR.

Add a Date range control, and set the scorecards to compare with the previous period.

Limits to know

• 16 months of data. A report on the Search Console connector shows the 16 months Search Console keeps.
• One table per data source. Site totals and page totals need two data sources, and their totals differ.
• Top rows only. A table with only Query does not list every query; add Device Category for the smaller ones.
• 12-hour refresh. Search Console data sources refresh every 12 hours, and that cannot be changed.
• Five sources per blend. A blend joins up to five data sources.

Conclusion

Copy the template, connect the Site Impression and URL Impression tables, and you have a working Search Console report in a few minutes. Add the blank-query filter and the device split for long-tail work. When the report needs GA4, ad, Semrush or Ahrefs data next to Search Console, connect them through Windsor.ai’s Search Console connector, or send the same data to Claude for questions in plain language.