SEO Report Template: What to Include and How to Build One

An SEO report template is a reusable layout that turns search data into a one-page or multi-page summary of what changed, why, and what to do next. Most templates cover organic traffic, keyword performance, top pages, technical issues, backlinks and next steps, and are filled from Google Search Console and Google Analytics 4.

You probably know a report should show traffic and rankings, and most free templates will give you the same ten tabs. What they rarely say is which of those tabs you can fill without a paid tool, or that a monthly performance report and a one-page on-page report are two different documents. This guide gives you a template for each, shows where every number comes from, and covers the routes to a PDF.

What Is an SEO Report Template, and Why Are There Two Kinds?

An SEO report template is a reusable layout you fill with fresh search data each period, so the same questions get answered in the same order. The phrase covers two different documents. Mixing them up makes many templates feel too thin or too heavy.

The first is the monthly performance report. It compares this period with the last one: clicks, sessions, queries, top pages, links and what to do next. It needs Google Search Console and Google Analytics 4 (GA4), plus a rank tracker if you want to watch a fixed keyword list.

The second is the one-page on-page report. It describes a single URL the way a crawler reads it: title, headings, meta description, links and images. It needs nothing except the page itself. No traffic data, no login, no account connection.

Three of the pages that rank for this topic describe only the first kind. GeoToolbox lays out a ten-section monthly template, SEOJuice a nine-section one, and Swydo lists eight recommended sections. All three are performance sections, and none separates that job from a one-URL report.

That leaves a site owner who needs a PDF of one page with no template aimed at them. The rest of this guide gives you one template per job. Pick the job before you pick the layout: a boss asking how organic search did this month needs the first, and someone asking what one page looks like to a crawler needs the second.

What Should an SEO Report Template Include?

An SEO report template should include nine sections: an executive summary, traffic and conversions, queries and rankings, top pages, technical health, backlinks, competitors, AI search visibility and next steps. Every top page covers most of these, so we keep each one short and spend the space on where the data comes from.

1. Executive summary: three or four lines on what changed this period and why it matters.
2. Traffic and conversions: organic sessions and conversions from GA4.
3. Queries and rankings: the queries, clicks and positions Search Console reports for your site.
4. Top pages: the landing pages that earned the most organic clicks, and the ones that lost the most.
5. Technical health: Core Web Vitals (Google's page experience measures) and crawl problems.
6. Backlinks: links gained and lost since the last report.
7. Competitors: who gained or lost visibility on the keywords you share.
8. AI search visibility: how your pages appear in Google's AI features.
9. Next steps: three to five actions, each tied to a number above.

The table below maps each section to its data source and says whether you can fill it for free. Use it as the where-the-data-comes-from column of your own template.

Seven of the nine sections can be filled from free Google tools or the page itself. Only backlinks and competitors need a paid index. A reader with no budget can therefore complete most of the report, which the top-ranking pages rarely say plainly.

Which Parts of the Template Cannot Be Filled In for Free?

Two sections of the template, backlinks and competitors, need a paid index, and a fixed keyword list needs a rank tracker if you want one. Search Console shows the queries your site already appears for. A rank tracker is the tool for watching a list of keywords you chose in advance, including ones you do not appear for yet.

Paid indexes such as Ahrefs and Semrush cover the backlink and competitor rows. If you have neither, do not leave a blank tab. Write not tracked this period in the section and move on. A report that says what it cannot measure is more honest than one that pads the gap with numbers from the wrong source.

The traffic section has a quieter limit. GA4 only reports what it collected, so a site that installs it today has no history to chart. If a client asks for last year's organic sessions and GA4 was installed last month, the template cannot invent that column. Say so on the page and start the clock now.

Bing Webmaster Tools is a free source for Bing search data if your audience uses it. It does not replace the Google columns, but it fills a separate small section at no cost.

Why Do Search Console Clicks and GA4 Sessions Not Match?

Search Console clicks and GA4 sessions do not match because the two tools count different things in different ways. Google's own documentation puts the cause in six words: "Clicks and sessions are calculated differently" (Google Search Central, 2026). The same page lists the details, and they make a short "read this before you present" box for the bottom of your template:

• Different calculation methods: a click is a visit from a result; a session is a block of activity on the site.
• Canonical URLs: Search Console counts the Google Search canonical URL only.
• Time zone: Search Console reports in Pacific Time.
• Bot traffic: Analytics excludes known bot traffic, and Search Console does not necessarily filter it.
• Attribution: the two tools assign a visit to its source by different rules.

Here is a worked example with made-up numbers. Search Console shows 1,200 clicks and GA4 shows 1,050 organic sessions. The gap is 150, which is 12.5% of the clicks. Without a note, a boss will ask which number is wrong. With the box above, you can answer that neither is wrong.

Put both columns in the report and add the box once, under the traffic table. Do not try to force the numbers to match by adjusting one of them. Compare each tool with its own last month, because the direction of change is what you are reporting.

How Do You Create an SEO Report Step by Step?

You create an SEO report in six steps: choose the question, pull the data, fill the template, explain the gaps, write the next steps and send it in a fixed format.

1. Choose the question. Decide whether the reader needs the monthly performance report or the one-page on-page report. A boss who asks for an SEO report usually wants the first.
2. Pull the data. Export queries and pages from Search Console, and organic sessions and conversions from GA4, for the same dates. Matching the date range in both keeps the comparison fair.
3. Fill the template. Work down the nine sections in order. Mark any section with no data source as not tracked.
4. Explain the gaps. Add the Search Console and GA4 note from the section above, plus one line on anything unusual, such as a launch or an outage.
5. Write the next steps. Give three to five actions, each pointing to the number that justifies it.
6. Send and save. Send the report in the same format every month, and keep a copy of the raw export.

Keeping the export matters because Search Console keeps data for the last 16 months, so reports built on it also hold a maximum of 16 months (Google Analytics Help). The Performance report's default view shows only the past three months (Google Search Console Help), so the stored history is about five times longer than what you see unless you change the date range.

The 16-month limit sets a hard rule for year-over-year comparisons. Comparing this month with the same month last year needs 13 months of data, which fits. Comparing two years back needs 25, which does not. If your client wants a two-year view, start saving a monthly export now, because after 16 months the original data is gone.

How Much Do SEO Reporting Tools Cost Compared With Free Routes?

Google's own routes, which are Google Sheets, Looker Studio and Search Console exports, cost nothing, while the reporting tools priced on their own pages start at US$39 and $69 a month. The table puts them side by side.

Supermetrics lists Starter at US$39 a month billed yearly or US$49 billed monthly, as checked on its page on October 22, 2026 (Supermetrics, 2026). Its five free templates for Google Sheets and Looker Studio need a Supermetrics subscription once the 14-day trial ends, and the Semrush ones also need a paid Semrush subscription, so the word free describes the template file and not the data.

Swydo's FAQ states plans start at $69 a month with 10 data sources, and extra sources cost $2 to $4.50 each. That page carries no date, so recheck the price before you budget around it.

Supermetrics Starter costs $468 a year billed yearly ($39 x 12) and $588 billed monthly ($49 x 12), so annual billing saves $120. Swydo's base plan comes to $828 a year ($69 x 12). Five extra data sources would add $10 to $22.50 a month, which puts the monthly total between $79 and $91.50.

Whatagraph, DashThis, AgencyAnalytics and Databox are other reporting tools in the same category. Their prices are not covered here, so check each tool's own page. For a freelancer with one or two clients, the free Google route costs hours rather than dollars. Past a certain number of clients, that exchange rate changes, and a paid tool starts to pay for itself.

How Do You Export an SEO Report as a PDF?

You can export an SEO report as a PDF in five ways: download it from Looker Studio, export a Google Sheet, print a report page from your browser, schedule it from a reporting tool, or save a generated report through the browser print dialog. Each route has a different limit.

Looker Studio is the route most people need. Google's documentation says to "Save a snapshot of your report by downloading it as PDF." (Looker Studio documentation, Google). The word snapshot is the limit: a PDF cannot update after you export it. Send the PDF as the copy of record and keep the live dashboard or sheet as the working file.

Among the five top-ranking pages on this topic, only one names a path to a PDF, the Looker Studio download or scheduled delivery. The other four treat the PDF as an afterthought or skip it. Yet a PDF is often the file a client actually opens.

For one page, Realword's free SEO report generator audits one page at a time, and its Print or save as PDF button opens your browser's print dialog, where you choose Save as PDF. It does not need a report built in advance, which makes it the quickest route for the one-page report below.

Can You Make an SEO Report for a Single Page?

Yes, a single-page SEO report covers one URL and lists what a crawler reads on it: the title, headings, meta description, links and images. It is the second template from the start of this guide, and it needs no traffic data.

What Belongs in a One-URL Report

Use five blocks, one per element. Write the current text or count for each one, mark it fine or needs work, and add one line on what to change.

• Title: the exact title tag and whether it names the topic of the page.
• Headings: the H1 and the order of the H2s below it.
• Meta description: the current text and whether it answers the query.
• Links: how many internal and outside links the page has, and whether any look broken.
• Images: whether each image has alt text that describes it.

Run it before you edit the page and again after. You then hold two PDFs that show the change, which is the closest a one-URL report gets to a trend line.

When a One-URL Report Is the Wrong Choice

A one-URL report says nothing about rankings, backlinks or traffic, so it is the wrong choice when the reader needs to see results over time. A client who asks whether organic traffic grew needs the monthly performance report. A site owner who asks why a single article is not getting clicks needs the one-page report, and then the performance report to check whether clicks changed once the page was fixed.

Realword's generator covers the one-page job only. Treat it as the second template and not as a stand-in for the first.

How Do You Turn an SEO Report Into a Content Plan?

You turn an SEO report into a content plan by listing the topics and pages the next-steps section flags as weak, then deciding which to write new and which to refresh. Most pages end with a vague call for recommendations. A plan needs a topic, a keyword and a decision for each row.

Start from the report. Queries with many impressions and few clicks point to a page that needs a better answer. A top page that lost clicks is a refresh candidate. A topic your site never covers is a new article. A short list of those three types, each with a keyword, is a content plan. Our guide to building an AI content brief shows how to turn each row into instructions a writer can follow, and AI content strategy covers how to order the work.

We make Realword, so judge this section with that in mind. Here is the route from a report to a published article:

1. Run the report on one page. Open the free SEO report generator, enter one URL and note the on-page gaps.
2. Find missing topics. Add your site to Content Ideas. It is free and uses no credits. It reads your sitemap, groups your pages into topic clusters and lists 5 missing topics per cluster, each with a keyword, intent, format and priority.
3. Research one keyword. In Article Studio, enter the keyword, pick a language and a length from 1,000 to 4,000 words, or click an idea from Content Ideas to fill these in. The research step costs 200 credits. It reads the pages ranking now, notes what they miss, and collects People Also Ask questions and statistics with their sources.
4. Write the article. The writing step costs 300 credits. The article has a direct answer first, Key Takeaways, at least one table, linked sources for every statistic, section images with alt text and schema markup.
5. Publish. Copy the article out with its images, alt text, schema and links.

To refresh an old post, save it as a file (.docx, .pdf, .pptx, .xlsx, .txt or .md, up to 10 MB) and upload it through Your research, which skips the 200-credit research step. Realword does not edit the old post in place, so you publish the new version at the old URL.

A researched article costs 500 credits, 200 for research and 300 for writing, images included. On the Starter plan, $19 buys 2,000 credits, which is 4 articles, or $4.75 per article. If you run reports for several clients, the guide to a repeatable content production system covers how an agency can organize that work.

Realword does not track rankings, backlinks, traffic or how often AI assistants mention a brand, so the report itself still comes from Search Console, GA4 and the tools above. If you want to try the route, start on the free plan, which gives you 500 credits, enough for one full article, with no credit card.

How Do You Report AI Overviews and AI Mode in an SEO Report?

You report AI Overviews and AI Mode by adding a section that reads Google's generative AI report in Search Console, because that traffic is already counted in your overall search data. Google says sites appearing in AI features are included in overall search traffic in Search Console under the Web search type, and that "There are no additional requirements to appear in AI Overviews or AI Mode, nor other special optimizations necessary." (Google Search Central, 2025).

Google rolled out the generative AI performance report to all websites worldwide as of August 31, 2026. It shows impressions for AI Overviews and AI Mode, plus top pages, country and device (Google Search Console Help, 2026). That report is the new place to look, so make it the data source for section eight of the template.

Because Google asks for no special optimization, the AI section works best as a reading section. Report the impressions and the top pages, note any change from last period, and let the next-steps section handle content gaps. Do not invent an AI score that no source supports.

AI sections are becoming common. GeoToolbox builds a three-layer AI visibility section, Web Tonic includes AI search visibility among its ten sections, and Swydo lists AI Overviews and SERP features. That makes at least three of the five top-ranking pages. Supermetrics' five templates have none. If you want the content side of this, our guides on ranking in AI Overviews and getting cited by Perplexity cover how content structure affects citation.

What Mistakes Make an SEO Report Useless?

The biggest mistake in an SEO report is leaving out the bad numbers, which hides the problems the reader has to fix. Yoast advises including negative results to give a realistic picture (Yoast, 2025), and Web Tonic and SEOJuice both warn against reports that hide problems.

A template also does not make a report useful on its own. The top-ranking pages use between 7 and 10 sections, so the number matters less than whether each section answers a question the reader has. Four other mistakes show up often:

• Two data sources, no explanation. A report with Search Console and GA4 columns and no note invites the question of which one is wrong.
• Assuming history is available. Search Console's 16-month limit means a request for a longer trend needs saved exports.
• Using the wrong report. A one-URL audit cannot show results over time, and a monthly report cannot tell you what one page looks like to a crawler.
• No next steps. A report that ends on a chart leaves the reader with data and no work to do.

A quick test catches most of these. For each section, ask what decision the reader could make from it. If the answer is none, cut the section or move it to an appendix.

Frequently Asked Questions

How often should you send an SEO report?

Send a performance report monthly, because that is the cadence almost every top-ranking page uses. A month gives each section enough time to show a real change. A one-page on-page report has no fixed schedule. Run it when you publish a page or change one.

What is the difference between an SEO report and an SEO audit?

An SEO report shows how search results changed over a period, while an SEO audit checks a site or page for problems at one point in time. A report answers what happened. An audit answers what is wrong. A one-page on-page report is closer to an audit of a single URL.

Is there a free SEO report template for Google Sheets or Looker Studio?

Yes. You can build one free in Google Sheets or Looker Studio from the nine sections above, using Search Console and GA4 as the data. Ready-made free templates exist too, but those five need a Supermetrics subscription after a 14-day trial, and the Semrush ones a paid Semrush account too.

Do you need a paid tool to make an SEO report?

No, but two sections need one. Traffic, queries, top pages, technical health and AI visibility can come from Search Console, GA4 and the page itself. Backlinks and competitor comparisons need a paid index such as Ahrefs or Semrush, so mark them as not tracked if you have none.

Should an SEO report be a PDF, a dashboard or a spreadsheet?

Use a dashboard or sheet for the live numbers and a PDF for the copy you send. A PDF is a snapshot, so it cannot update after you export it. That makes it good for a record of one month and poor as a working file.

Conclusion

Pick the job first. For monthly performance, use Search Console and GA4 with Looker Studio, or a reporting tool such as Swydo if you want scheduled delivery. For finding missing topics and writing sourced articles, use Realword, then check the result in your own report next month. A free SEO report generator run on one page is the fastest way to start the one-page version. To try Realword, sign up free for 500 credits, enough for one full article, with no credit card.