5 free SEO report templates from Supermetrics for Google Sheets or Data Studio (formerly Looker Studio). The templates pull Google Analytics 4 (GA4), Google Search Console, Semrush and Google Business Profile (formerly Google My Business) data.
Key takeaways
- The Google Analytics 4 reporting template for Looker Studio is the best pick for comparing organic traffic with other channels.
- For queries and rankings, start with the Google Search Console reporting template for Looker Studio.
- Keyword research in Google Sheets works best with the automated keyword research template (Semrush + Search Console).
- Multi-location businesses doing local SEO should use the Google My Business local SEO template.
- All 5 templates are free to copy, and running one needs Supermetrics, which has a 14-day free trial with no credit card.
- Supermetrics Starter starts at US$39/month billed yearly, or US$49 billed monthly. It includes two data sources, two accounts per source, one core destination and one user. Extra capacity costs more. Prices are in US dollars, checked October 22, 2026; see Supermetrics pricing plans for local currency options.
- Verdict: Start with GA4 for organic traffic and website behavior, or Search Console for queries and rankings. Add business outcome metrics to the GA4 report when stakeholders need revenue or lead results.
The 5 templates on this page cover common SEO reporting needs: website traffic, search performance, keyword research and local search. Sleeping Giant Media cut its monthly client reporting from seven days to a few hours with Supermetrics for Google Sheets. Read the Sleeping Giant Media case study.
Supermetrics is a marketing intelligence platform that moves data from sources like GA4, Search Console and Semrush into Google Sheets, Data Studio, Excel and Power BI. Supermetrics, used by 200,000+ brands and agencies, publishes these templates for free.
Data Studio (formerly Looker Studio) is Google's reporting and dashboard tool, with a no-cost version available. Google restored the Data Studio name in April 2026.
You can still build an SEO report from scratch, but a ready-made template from the Supermetrics template gallery skips most of the layout decisions.
Here are 5 free SEO report templates, grouped by what you need to report on:
- Website traffic and engagement
Google Analytics 4 reporting template - Rankings and keywords
Google Search Console reporting template
Semrush SEO report template
Automated keyword research template for Google Sheets - Local SEO
Google My Business local SEO template
Once you've copied a template, you can edit the structure, metrics and visualizations to match your needs.
What is an SEO report template?
An SEO report template is a prebuilt dashboard or spreadsheet that organizes search and website data into a reusable layout. Connect your accounts, choose the reporting period and configure data refreshes so you can update the report without rebuilding it each month.
What are the pros and cons of SEO report templates?
SEO report templates save setup time and keep reports consistent month to month. Sleeping Giant Media cut monthly client reporting from seven days to a few hours.
An SEO report template's trade-off is a fixed layout: each template covers its own data sources, so cross-source questions need a combined or custom report.
Build a custom report when you need more data sources than one template holds, or a client-specific layout. The guide to building an SEO report from scratch covers that process.
What are the best free SEO report templates?
The five templates below cover GA4 website performance, Search Console queries and rankings, Semrush SEO analysis, keyword research in Google Sheets and Google Business Profile reporting. All are free to copy.
The templates sort into three groups. The GA4 template covers website traffic and engagement; add key events or revenue metrics for business outcome reporting. The Search Console, Semrush SEO report and keyword research templates cover search performance and keywords, while the Google My Business template covers local reporting.
| Template | Category | Best for | Key capabilities | Pricing (as of October 2026) | Key limitation |
|---|---|---|---|---|---|
| Google Analytics 4 reporting template for Looker Studio | Website traffic and engagement | Comparing organic traffic with other channels | User, session and engagement overviews; channel-group filter; breakdowns by country and page | Free to copy; requires a Supermetrics subscription for Data Studio, or the 14-day trial | GA4 data only, no queries or rankings |
| Google Search Console reporting template for Looker Studio | Rankings and queries | Monitoring search performance | Impressions, clicks, CTR and average position by query, page and device | Free to copy; requires a Supermetrics subscription for Data Studio, or the 14-day trial | Search Console data only; add GA4 for website behavior and business outcomes |
| Semrush SEO report template for Looker Studio | Rankings and competition | Sharing domain, keyword and competitor performance with stakeholders | Keyword, traffic and competition insights | Free to copy; requires Supermetrics and a paid Semrush subscription; Supermetrics offers a 14-day trial | Requires a paid Semrush subscription; query limits depend on that subscription |
| Automated keyword research template for Google Sheets | Keyword research | SEO and paid search marketers, agencies onboarding clients | Semrush phrase-match and related keywords, auto-categorizing, Search Console queries, opportunity and seasonality tabs | Free to copy; requires Supermetrics for Google Sheets and a paid Semrush subscription; Supermetrics offers a 14-day trial | Manual keyword cleanup, business assumptions and account setup |
| Google My Business local SEO template | Local SEO | Brick-and-mortar and multi-location businesses | Switch between locations; compare searches, views, actions and reviews | Free to copy; requires a Supermetrics subscription for Data Studio, or the 14-day trial | Listing data only, no website traffic or rankings |
How do you compare organic traffic with other channels in GA4? (Data Studio template)
To compare organic traffic with other channels, use GA4's session default channel group to isolate Organic Search or compare it with paid, referral and direct traffic. The Google Analytics 4 reporting template provides channel and website performance views in a Data Studio dashboard.
The current template preview includes a session default channel grouping filter, user and engagement overviews, and breakdowns by country, channel group and page title. Select Organic Search to focus on SEO traffic. Add key events and revenue metrics when you need to connect that traffic to business outcomes.
Supermetrics' 2026 Marketing Data Report surveyed 435 marketers and found that 40% cite proving ROI across channels as their biggest challenge. To make your SEO report useful for that discussion, show the actions organic visitors take after they arrive, alongside traffic trends.
Verdict: Start here to compare organic traffic with other channels, then add your business outcome metrics. Pair it with the Search Console template for queries and rankings.
How do you track rankings by query and page? (Search Console template)
The Google Search Console reporting template shows impressions, clicks, CTR and average position by query, page and device in one Data Studio dashboard. It is free to copy; connect it using a Supermetrics subscription that includes Search Console and Data Studio, or the 14-day trial.
Google recommends combining Search Console and Google Analytics data to monitor organic search traffic, so run the Search Console and GA4 templates side by side.
The Search Console template sticks to the core performance view. For more report types, read the guide to advanced Google Search Console reports.
Verdict: Pick this one for weekly checks of clicks, impressions and average position by query, page and device. Average positionis an aggregate metric, rather than a fixed rank for every search.
How do you report on Semrush keyword and competitor data? (Semrush template)
The Semrush SEO report template brings keyword, traffic and competitor insights into a shareable Data Studio dashboard. It needs Supermetrics and a paid Semrush subscription. The current Semrush Analytics connection guide uses your Semrush login and Web Query allowance; it does not list a separate API-unit package as a requirement.
Combining GA4, Search Console and Semrush requires three data sources. Starter includes two, so add a third source or choose a package with a larger allowance.
The Semrush SEO report template suits teams that share dashboards, while the automated keyword research template for Google Sheets suits hands-on keyword research.
Verdict: Pick this one if your team already pays for Semrush and wants its data in a shared dashboard.
How can you automate keyword research in Google Sheets with Semrush and Search Console?
The automated keyword research template pulls phrase-match and related keywords from Semrush and groups them into your categories. It also brings in Search Console queries and ranking metrics. You need a copy of the Google Sheet, Supermetrics for Google Sheets and access to both data sources.
Start with a copy of the sheet and add core search terms to the Setup – Start Here tab. The template retrieves phrase-match and related keywords, then uses Search Console data to show which queries already bring your site impressions and clicks. The number of suggestions depends on your seed terms and the available data.
The keyword research template has separate tabs for each stage:
- Semrush phrase-match and related keywords, in the ph_semrush and rl_semrush tabs
- Auto-categorized keywords, grouped into your categories in the categorise tab
- Search Console queries with landing pages, impressions, CTR and average position
- An opportunity tab that estimates potential revenue using assumptions such as average order value
- A seasonality view by keyword group
The Google Sheets keyword template is useful for compiling data for an SEO report. The keyword list and ranking data refresh from Semrush and Search Console, so you don't retype them each month.
What does the keyword research template cost to run?
The keyword research template is free to copy. Supermetrics Starter starts at US$39/month billed yearly and includes two data sources and one core destination, so select Google Sheets with Semrush Analytics and Search Console. You also need a paid Semrush subscription. Supermetrics' current connection guide says Analytics queries use your Semrush Web Query allowance; a separate API-unit package is not listed as a requirement.
The workflow includes manual keyword cleanup and business inputs, including your average order value for the opportunity estimate. Copy the categorise table into the edit these keywords tab and remove irrelevant terms. This worksheet accompanies an older tutorial, so reconnect its saved queries to your own accounts and review the settings. Refresh queries from the Supermetrics sidebar's Home tab.
Verdict: Pick this one if you research keywords for new clients and want to edit the list by hand in Sheets.
What should a local SEO report track? (Google Business Profile template)
A local report should track profile visibility and actions such as call-button clicks, direction requests and website clicks. Call-button clicks do not tell you whether a call connected. Google's Business Profile performance data is available only for verified profiles and can include interactions from both organic results and Google Ads.
The Google My Business local SEO template lets you switch between locations and compare searches, views, actions and customer reviews. Brick-and-mortar and multi-location businesses get local search visibility and customer engagement in one Data Studio dashboard.
The Google My Business local SEO template covers Google Business Profile listing data only. Website traffic and organic rankings come from the GA4 and Search Console templates.
Verdict: Pick this one if you manage several locations and report on reviews alongside visibility.
Copy the Google My Business local SEO template.
What should an SEO report include?
A good SEO report covers GA4 organic traffic and business outcomes, alongside Search Console clicks, impressions, CTR and average position. Add local listing or backlink data where relevant. Search Console provides up to 16 months of performance history; export data regularly if you need to retain a longer record for historical comparisons.
Google's Search Console Help describes clicks, impressions, CTR and average position as data on how often users saw or interacted with links to your site. Those four metrics anchor the rankings section of an SEO report.
An SEO report's sections should follow your SEO analytics process: the questions you ask each month decide which metrics stay in.
An SEO report template comes with fixed charts, and the guide to data visualization for marketers helps when you swap one for a clearer format.
Add AI search visibility when it matters to your reporting goals. Google launched dedicated generative AI performance reports on June 3, 2026, showing impressions and the pages appearing in its AI features. Use those native Search Console views alongside this standard search performance template. For a broader measurement approach, see how to measure AI search visibility.
How do you build a monthly SEO report template?
To build a monthly SEO report template, copy one of the 5 templates and set the date range to the previous month. Then compare that month with the same month last year.
Refresh behavior depends on the destination. In Google Sheets, run queries manually or set a scheduled refresh in Supermetrics. In Data Studio, results may come from cached data until the data freshness threshold expires. Schedule report delivery separately, after allowing time for the source data to update.
Which SEO report template should you start with?
Start with the GA4 template for organic traffic and website behavior, then add revenue or key events to reflect your goals. Use Search Console for queries and rankings. Add the Google Sheets template for keyword research, or the Google Business Profile template for local reporting.
Pick Google Sheets for keyword work you'll filter and edit by hand; pick Data Studio for dashboards you share with stakeholders. The guide to Supermetrics for Google Sheets vs Data Studio compares the two destinations.
Supermetrics connects GA4, Search Console, Semrush and Google Business Profile data to reporting destinations such as Google Sheets and Data Studio. Browse the Supermetrics template gallery for more reporting layouts, or see SEO reporting with Supermetrics for the relevant connectors.
Frequently asked questions
-
Yes, the five templates featured here are free to copy. Keeping their Supermetrics connections running requires a subscription after the 14-day trial. Starter begins at US$39/month billed yearly, or US$49 billed monthly, with two data sources and one core destination. Semrush templates also require a paid Semrush subscription. Using both Google Sheets and Data Studio requires both destinations in your subscription.
-
An SEO report should include GA4 organic traffic and business outcomes, plus Search Console clicks, impressions, CTR and average position. Use the GA4 and Search Console templates as a starting point, and add the key events or revenue metrics relevant to your goals. Include local listing and backlink data where useful.
-
Copy a template, connect your GA4, Search Console or Semrush account through Supermetrics, set the date range and share the dashboard. The 5 templates on this page cover traffic, rankings, keyword research and local SEO, so most SEO reports can start from one of them.
-
Use a rolling previous-month date range so the reporting period updates automatically. In Google Sheets, configure a scheduled Supermetrics refresh and, if needed, email delivery. In Data Studio, check the data freshness settings and configure scheduled delivery. Review the results before sharing conclusions.
-
You can find free SEO report templates in the Supermetrics template gallery, which has free templates for Google Sheets, Data Studio, Excel and Power BI. The 5 templates on this page come from the gallery and cover GA4, Search Console, Semrush and Google Business Profile data.