Free GSC Report Template for Marketers in Looker Studio

I created a simple, practical Google Search Console (GSC) dashboard for Looker Studio that helps marketers and analysts get fast answers about search performance. In this article, I walk you through how I built the dashboard, why I included three connector options, and how you can use the free template to get started quickly.

Watch the full video tutorial here and follow along:

Step 1: Decide which connector to use (Native, Windsor, or Supermetrics)

The first decision I make when building a GSC dashboard in Looker Studio is which connector I will use. Looker Studio includes a free native Google Search Console connector (I call it the direct connector). It connects instantly and pulls the basics: impressions, clicks, CTR, and average position. Use it when you need a fast, no-cost solution.

However, the native connector has limitations. It offers two separate modes (site and URL), which means you often need to add two data sources to cover everything. It also limits how much historical data you can pull and which dimensions you can combine in a single data source.

To overcome those limits, I tested two paid connectors I often use in practice: Windsor and Supermetrics. Both let me pull more fields in one place, combine queries and landing page analytics in a single data source, and enable richer tables and drill-downs.

Step 2: Connect Google Search Console using the native connector

If you choose the native connector, connect twice: once as Site and once as URL, because each mode exposes slightly different metrics and dimensions. After connecting, you can add device breakdowns (desktop, mobile, tablet) and the typical metrics — impressions, clicks, CTR, and average position.

Set up filters so viewers can switch between properties if you manage multiple sites. Add a simple date range control and allow users to drill down by year, month, week, and day. This setup is quick and works well if you only need top-level search performance metrics.

Step 3: Try Windsor for extended GSC fields

Windsor provides more fields than the native connector, and that extra flexibility matters when you want to combine search queries and landing page analytics in one table. In my dashboard, I used Windsor to show impressions, clicks, CTR, number of search queries, and a count of warnings. I also built multi-level drill-downs (12 months → weeks → days) so you can analyze seasonality and short-term drops.

Windsor takes a bit longer to load than the native connector, but the payoff is being able to use a single data source for richer analytics. I added site and landing page filters so I can switch between properties and analyze specific entry pages quickly.

Step 4: Use Supermetrics for maximum query-level detail

Supermetrics is another excellent connector for GSC. Its field set mirrors Windsor for most use cases, and it exposes extra dimensions like the number of words in a query and other useful query attributes. With Supermetrics I copy-paste the Windsor page layout and keep the same structure: top-level KPIs, time series with drill-down, top keywords, search type by clicks, and device breakdowns.

My favorite part of Supermetrics is being able to build both query analytics and landing page analytics from the same data source. That saves time and reduces the number of separate connectors you must maintain.

Step 5: Build the core visualizations

Whether you use the native connector, Windsor, or Supermetrics, I recommend the same set of widgets to get a fast, actionable GSC dashboard:

• Top KPIs — impressions, clicks, CTR, average position.
• Time series with drill-down — year → month → week → day to analyze trends and spikes.
• Top queries by clicks — show the top five or top ten queries and include clicks, impressions, CTR, and position.
• Search type breakdown — separate web, image, and video searches if relevant to your site.
• Device breakdown — mobile vs desktop vs tablet to catch device-specific issues.
• Landing page analytics — combine queries and landing pages to understand which pages attract clicks and which query types land on them.

I arranged these elements on two pages: one built with the native connector and the other with the paid connectors. This gives me three working approaches and lets stakeholders pick the one that best fits their access and budget.

Step 6: Connect filters and controls

Filters make the dashboard interactive. I add:

• A site/property filter to switch between properties.
• A landing page filter to analyze specific URLs.
• A date range control, and I enable drill-down on the date series.

With Windsor and Supermetrics I can keep both queries and landing page analytics in one data source, and the filters work across the board. With the native connector, I sometimes need to combine two data sources — one for queries and one for pages—so I make sure the filters are synchronized across pages.

Step 7: When to use BigQuery

If you need more historical depth or more granular control, export GSC data to BigQuery. I strongly recommend this when:

• You need long-term retention beyond the limits of native GSC exports.
• You want to join search data to other sources (e.g., GA4 or internal CRM) using SQL.
• You need to transform query text, group similar queries, or compute advanced metrics at scale.

Once data sits in BigQuery, you can write SQL to shape it exactly how you need and then connect Looker Studio to the BigQuery dataset. This approach increases flexibility and reliability for enterprise-level reporting.

Step 8: Small design and UX tips

Keep the dashboard focused and avoid overloading viewers. I follow three simple rules:

1. Lead with the question: What does the user want to know in the first 5 seconds? (e.g., is organic traffic up or down?)
2. Make KPIs prominent and color-code any alerts or warnings.
3. Preserve drill-down controls and filters near the top so users can quickly slice the data.

Also, include a short note or tooltip explaining the connector type used on each page (native vs Windsor vs Supermetrics). This helps users understand why some metrics might appear on one page and not another.

Step 9: Share and maintain the dashboard

When you share the dashboard, provide the following to viewers:

• Which connector was used (and why)?
• How often the data refreshes and any known limitations (for example, GSC sampling or historical limits).
• Links to the raw GSC property and to BigQuery datasets if relevant.

Maintain the dashboard by checking connector permissions periodically and validating that the date ranges and filters still match stakeholder needs.

Step 10: Use the free template to get started fast

I created a free Looker Studio template that implements the layout and logic I described here. Use it as a starting point and customize it for your site. You can download the template from my site:

Free template link

Promotions and connector codes

If you use paid connectors, I have promo codes that help you test them affordably. Use my code gaillereports on the vendor site for discounts. These offers make it easier to try connectors and see if they fit your workflow.

Final thoughts and quick recap

Building a Google Search Console dashboard in Looker Studio doesn’t have to be complicated. If you want a free, fast solution, use the native GSC connector and set up site and URL sources. If you need richer dimensions and the ability to combine queries and landing pages in one data source, try Windsor or Supermetrics. And if you require historical depth or data joins, export GSC to BigQuery and visualize from there.

My template covers the main needs and gives you three implementation options on separate pages, so you can choose the approach that fits your access and budget. Download the template and adapt the layout to your brand and specific KPI needs.

Recommended further reading on the blog

Explore related articles and tutorials on my site to deepen your Looker Studio and BigQuery skills:

• How to Use Looker Studio: Beginner Guide (2025)
• Send Ad Data to BigQuery with Supermetrics – Easy Setup
• Top Facebook Ads Connectors for Looker Studio – How to Choose the Right Looker Studio Connector
• How to Use SQL with GA4 in BigQuery: 10 Real Examples for Marketers

Thanks — and where to get the template

If you want to try the dashboard now, grab the free template here.

Subscribe to my newsletter for tips, updates, and templates.