Key takeaways
- The first rule of how to create SEO report pages: start with the reader and the goal, not the data. A report for an owner, a marketing manager and a developer should not look the same.
- Search Console gives clicks, impressions, CTR and average position; GA4 gives what visitors did on the site. Google says the two “won’t match completely”, so report them side by side, not as one number.
- Compare like with like: the same date range a year earlier, or weekly or monthly views, which Google says remove the day-of-the-week effect.
- Add Search Console annotations for site changes, so the chart explains itself. Each note can be up to 120 characters.
- Write the summary last, put it first, and check every number before the report goes out.
People who search “how to create SEO report” usually have the data already and a deadline close behind it. What they lack is an order of work. This guide shows how to create an SEO report step by step from free Google data, adding a paid ranking check only where it shows something Search Console cannot.
I have worked in SEO and digital marketing for more than 16 years, and I have built reports for owners who wanted one page and for teams who wanted every detail. The method below works for both, because the first step decides how much of everything else you need.
If you want to know what a basic monthly report should contain, read the numbers a small business should see every month. If you write for clients, how to write a report your client actually reads covers tone and structure. This article is the build itself.
How to create SEO report pages: the build in seven steps
Here is the whole process before the detail. Each step has a section below.
| Step | What you do | Where the data comes from |
|---|---|---|
| 1. Reader and goals | Decide who reads it and what they need to decide | A short conversation |
| 2. Search data | Clicks, impressions, CTR, average position, top queries and pages | Search Console Performance report |
| 3. Site data | Sessions from organic search and key events | GA4 |
| 4. Fair comparison | Same period last year, or weekly or monthly views | Search Console compare filter, GA4 date ranges |
| 5. Rankings | Positions for the keywords that matter, by device and location | A ranking check |
| 6. Annotations | What changed on the site, and when | Search Console annotations, your change log |
| 7. Summary and QA | What happened, why, and what comes next; then check every figure | You |
Step 1: define the reader and the goals
Before opening any tool, write down two things: who will read the report, and what they should be able to decide after reading it. An owner may want to know whether SEO is bringing enquiries. A marketing manager may want to know which pages to improve next. A developer needs to know what broke and where.
Then write the goals in plain words, such as “more quote requests from the service pages” or “recover traffic to the blog after the redesign”. Every chart in the report should relate to one of them. If a chart does not, leave it out. Most weak reports I see are not wrong; they are simply full of numbers nobody asked for.
Step 2: pull Search Console data
Search Console’s Performance report is the core of any SEO report, because it shows what happened in Google before anyone reached the site. Google defines the four main metrics:
- Clicks: “The number of times a user clicked your site from Google Search results.”
- Impressions: “How many times your site appeared in Search results.”
- CTR: “The click count divided by the impression count.”
- Average position: “The average position of the topmost result from your site.”
Use the Queries and Pages tabs to find the searches and pages behind any change. For most reports, the top queries and top pages, filtered to the topics in your goals, are enough. Google notes that “Many reports provide an export button to download both the chart and table data”, which is how you get the figures into a spreadsheet or document.
One caution: “The newest data can be preliminary, meaning it’s still being collected and might change in the next few hours.” Leave a few days after the period ends before you pull the final numbers.
If you want this data to update itself, our guide to building an SEO keyword dashboard from Search Console shows how to connect it to Data Studio (formerly Looker Studio).
Step 3: add GA4 data for what happened on the site
Search Console stops at the click. GA4 shows what visitors did next. For an SEO report you usually need only two things from it: sessions from organic search, and key events from those sessions. Google defines a key event as “an event that measures an action that’s particularly important to the success of your business.” Quote requests, calls and bookings are the usual examples, and you mark them in Admin.
Do not try to make the two tools agree. Google’s page on using Search Console and Google Analytics data says “these tools use different metrics and systems, which means the data won’t match completely”, and that “Clicks and sessions are calculated differently.” It also notes that Search Console’s default time zone is Pacific Time. Put the two side by side, label which tool each figure comes from, and explain any gap in one sentence.
Step 4: compare like-for-like periods
A month compared with the month before is often misleading. Seasons, holidays and the number of weekends all change search demand. Year-on-year is usually fairer: this October against last October.
In Search Console, the comparison sits in the date filter. Google’s advanced filtering and comparison page explains that you choose Compare in the filter and that “the results table will display a Difference column” for each row. When comparing two date ranges, it suggests you “consider using the Weekly or Monthly granularity option”, because grouping by week or month removes the day-of-the-week effect.
Use the same date ranges in GA4, and state them at the top of the report. A reader should never have to guess which period a number belongs to.
Keep a short definitions box
Under the summary, add three lines: the date range, the comparison period and where each figure comes from. It prevents most of the questions a report usually triggers.
Step 5: add rankings where they help
Search Console’s average position covers every search where your site appeared, across devices and locations. That is useful for trends, but it cannot tell you where a specific page ranks for a specific keyword in a specific city on mobile. Our article on Search Console average position versus a rank tracker explains the difference in detail.
If the goals in step 1 depend on particular keywords, such as a service in a few towns, add a ranking check for that list. Keep it short: the keywords tied to the goals, not every phrase you have ever targeted. Report the change since the previous check and leave the long table for an appendix.
A report earns trust when every number on the first page answers a question the reader actually has.
Step 6: annotate what changed
Charts without context invite the wrong conclusions. If traffic dropped the week a new template went live, the report should say so on the chart.
Search Console now supports this. Google’s help page on Search Console annotations says annotations “help you understand changes in your data by providing context on your charts.” You add them by right-clicking the Performance chart on a date. Each note can be up to 120 characters, a property can have up to 200, and annotations are shared across the property. The page also says “Annotations older than 500 days are automatically deleted”, so keep your own change log as well.
What to annotate: site launches and redesigns, migrations, template changes, large content updates, tracking changes, and outages. Not every blog post.
Step 7: write the summary, then check everything
Write the summary last, and put it first. Three short parts are enough: what happened, why it happened (as far as the data shows), and what you recommend next. Plain sentences beat a page of charts. For format choices, when a PDF is the right format covers layout, and the monthly SEO report template gives a structure you can copy.
Then check the report before it goes out.
QA checklist before sending
- Every figure matches the tool it came from, for the stated date range.
- The comparison period is the same length and type as the current period.
- Search Console and GA4 figures are labelled with their source.
- Preliminary data is not included.
- Each chart relates to one of the goals from step 1.
- Annotations explain any sharp change on the charts.
- The summary says what to do next, and who does it.
FAQ
How do I make an SEO report for free?
Use Search Console for clicks, impressions, CTR, average position, queries and pages, and GA4 for organic sessions and key events. Export the data to a spreadsheet or connect it to Data Studio, compare like-for-like periods and write a short summary on top.
How often should I create an SEO report?
Monthly suits most businesses, with a quarterly review of the bigger picture. Weekly reports tend to show noise rather than change, unless you are tracking a launch or a migration.
Why don’t Search Console and Google Analytics numbers match?
Google explains that the tools use different metrics and systems: clicks and sessions are counted differently, bots are handled differently, and the default time zones differ. Small gaps are normal; watch whether the trends agree.
What should an SEO report include?
A summary first, then the search data, site data, a fair comparison, rankings for the keywords tied to your goals, notes on what changed, and next steps. Anything that does not serve a goal can go in an appendix or be left out.
If you want a second pair of eyes on how your SEO report is built, send me the last one and tell me who reads it, and I'll suggest what to change.
Eugen Platon · SEO consultant with 16+ years in SEO and digital marketing · free 10-minute first call