UPGeoSEO

SEO Client Report Format: How to Build One in an Afternoon

By UPGeoSEO Team · Editorial team

Nov 19, 2026 · Updated Nov 20, 2026

SEO Client Report Format: How to Build One in an Afternoon

The SEO client report format is simple: you prepare it in one afternoon and send it every month, with a more strategic review each quarter and one-off alerts if something serious happens. The report explains what has happened in organic search, why, and what you will do next.

It has seven sections: executive summary, visibility on Google (clicks, impressions, CTR and position from Search Console), organic traffic and key events from GA4, priority keywords, technical health, work done and next steps.

Key takeaways

  • If you change a filter between one month and the next, the comparison is worthless. Note down brand, property, country, device, search type, dates and extraction time, and repeat them every month.
  • Export the Search Console data every month. It only keeps 16 months, and GA4 sessions are never added to clicks: they are different measures.
  • Put the absolute figure next to every change. Clicks are compared in percentages, CTR in percentage points, and with no baseline the change is marked as not available.
  • Finish with three to five actions that carry a URL, evidence, change, owner and date. Review them when you open the next report.

Step 1: set brand, country, device and dates before opening any data

Write down seven details before touching any tool: brand, property, country, device, search type, inclusive dates and extraction time. With them, anyone can repeat your query and get the same result. Without them, you won't know whether a change is real or the result of a different filter.

DetailExampleWhy it matters
PropertyFull domainAvoids mixing subdomains by accident
CountrySpainA month with "all countries" and another with only Spain can't be compared
DeviceAllMobile and desktop behave differently
Search typeWebImages or video don't add to this total
Dates1 to 30 November, both inclusiveCloses the month without ambiguity
Extraction3 DecemberIf someone repeats the query days later, you'll be able to explain the difference

The mistake that breaks it: rebuilding the filters from memory every month. Save this table in the template and copy it as it is.

Step 2: pull clicks, impressions, CTR and position from Search Console

The Search Console performance report gives four visibility figures: clicks, impressions, CTR and position, plus the queries users typed. That is how the official Search Console help describes it. Export the month with the filters from step 1.

CTR is not a separate data point: according to Google's definition, it is clicks divided by impressions. If you recalculate it yourself, it works as a quality check. If your figures don't match the exported ones, check the filters.

There is a limit worth knowing: Search Console keeps data for the last 16 months. That is enough to compare with the same month of the previous year. To go further back, you need to have saved your exports beforehand.

The mistake that breaks it: waiting until you need the data. Save the monthly export in a client folder on the same day you send the report.

Step 3: how do I add Google Analytics without mixing clicks and sessions?

Search Console counts clicks on search results; Google Analytics counts sessions on your website. They are different measures and they don't match. Link both tools, pull the organic traffic from Analytics and put it in a separate block, with its own definition.

To set up the integration, link an Analytics web data stream to a Search Console property. You can see organic traffic under Acquisition > Traffic acquisition.

Define two terms in the report itself, in Google's words, so the client doesn't confuse them with clicks:

Google warns that the two tools use different metrics and systems, so the data won't match exactly. Don't add clicks and sessions together as if they were independent visits.

If the client doesn't have GA4: write in the report that you have no sessions or key events. Don't turn search clicks into assumed conversions.

Step 4: how do I calculate the month's changes?

The percentage change is (this month − previous month) ÷ previous month. For CTR you don't use a percentage: you subtract and express the result in percentage points.

Metric (made-up example)Previous monthThis monthChange
Impressions20,00025,000+25%
Clicks400450+12.5%
CTR (clicks ÷ impressions)2%1.8%−0.2 percentage points

Check the calculation: 450 ÷ 25,000 = 1.8%, and 50 more clicks on a base of 400 is 12.5%. Writing "CTR drops 10%" would be technically true, but misleading. Say "0.2 points" and show both CTRs.

If the baseline is missing or zero, the percentage change is not available. Don't write "+∞%" or an invented 100%: write "n/a" and explain why (new page, property just verified).

Step 5: explain why the numbers move

A report without interpretation is a data dump. For every relevant change, answer three questions: what happened, why, and what you will do.

Impressions up, clicks flat. Check the queries that gained visibility, their position, their intent and whether the search results satisfy the need without a click. One likely cause is new queries entering at low positions. Check it in the query list before stating it.

Percentages on a small base. "+50%" on a base of 4 clicks means nothing. Show both figures: "from 4 to 6 clicks". That way the client sees the real scale and you don't promise growth that doesn't exist.

Don't include everything you can measure. What to include and what to leave out of the report depends on the client's goal, and the practical rule is that every figure in the report carries a sentence of explanation or comes out.

Step 6: close with a summary and three to five actions

Start the document with an executive summary of three to five sentences, because it is what gets read most, and end it with three to five actions for the following month, in priority order.

Write the summary last, when you already know what happened, but put it first.

What does the closing section look like for a dental clinic?

Example summary (made-up data): "In November, organic clicks and impressions went up. Next month we'll improve the title of the treatments page and strengthen the whitening page."

URLEvidenceChangeOwnerDate
Whitening pageMany impressions and low CTRRewrite title and descriptionSEO consultant10 Dec
HomeStable brand queriesAdd links to key treatmentsSEO consultant15 Dec
Implants pageNo traffic in the monthProvide photos and indicative pricesClient20 Dec

If you run several clients: the SEO client report under your name

With UPGeoSEO you manage your clients' sites in a single account. The client report page and the PDF show your name (and your logo on the report page), not ours. Your clients don't need an account with us and the invoice goes only to you.

One thing remains ours: the report link is served from our domain. If you prefer to build the report by hand, you can also do it with Looker Studio, which has a Search Console connector, DashThis or SE Ranking.

What do the report page and the PDF contain?

If you create a client report link or send the PDF, that page or file shows the site's own Search Console totals (such as clicks and impressions) to whoever you give it to, according to the UPGeoSEO privacy policy. Anyone with the link can open it, so share it with care. You can revoke it whenever you want.

The weekly PDF carries the same figures as that site's performance page: clicks and impressions, results by article, indexing status, keywords, AI search results and that week's work.

Which agency plan do I need and what does it not promise?

The agency plan is monthly, plus tax. Up to 5 sites cost 549 USD (about 110 USD per site, with 15 full audits a month). Up to 10 sites cost 999 USD (about 100 USD per site, with 20 audits a month). Above 10 the price is custom. Each site includes up to 5 languages at no extra cost, with more on request, and there is no lock-in.

UPGeoSEO doesn't promise rankings or citations: visibility is built over weeks or months. The free audit only reads the home page (plus robots.txt and sitemap), gives two scores out of 100 in about ten seconds, asks for no card and fixes nothing; your email unlocks the full list. To see how each piece fits, from the first audit to the AI citation walks through the whole process.

Frequently asked questions

What do I do if the client doesn't have Search Console verified yet?

Verify the property today, before doing anything else. If you have no data from earlier periods, the first report will have nothing to compare against. Say so in the document and set that month as the baseline for comparing the following ones.

When do I send an alert outside the monthly report?

When something changes fast enough that it can't wait for the month-end close. For example, a sustained drop in clicks over several days, a key page that stops being indexed or an accidental block in robots.txt. Send a short message with what happened, what you know and when you will check again.

Should I include AI answer visibility in the report?

If the client cares about appearing in ChatGPT, Gemini or Perplexity, put it in a separate block and don't mix it with Search Console clicks. Report a mention rate with its sample size, not a "position", and explain that AI visibility and organic traffic aren't measured the same way.

Where do I start today with this month's report?

Start today with this month's report. If you run several clients, in UPGeoSEO you can run each one's home page through the free audit.

Related posts

Ready to see where you stand?

You just read the theory. Now run a free SEO + GEO audit of your own site: 13 SEO checks and 5 GEO checks, no card, no signup to look.