SEO Client Report — a Claude Code & Codex skill for automated SEO reporting

Status: new. Freshly published and not yet exercised end-to-end against a live account — feedback and issues welcome.

seo-client-report is a free Claude Code & Codex skill — an AI report generator that builds a monthly SEO report for clients from the Search Console, GA4, and rank-tracker exports the user provides, and publishes it as a branded live page rather than a PDF attachment. It applies the same client report template every month: the agent computes period-over-period deltas, writes the narrative, builds the charts, and publishes to a tracked URL. This is the sense in which the reporting is automated — the template, structure, and publishing recur without manual assembly.

It is intended for SEO consultants and agencies that produce recurring monthly client reports.

What it does

  • Take the performance data you provide (Search Console exports, GA4/analytics, rank-tracker data) for the reporting period and compare it to last period — every metric is paired with its prior-period figure and delta.
  • Never invent a metric. If a figure needed for a claimed win is missing, the skill asks for it instead of estimating.
  • Order sections by client-facing outcomes — rankings, traffic, leads, revenue — then work performed, then next steps. Methodology is placed in the appendix, not the opening.
  • Render ranking and traffic movement as charts that remain legible when screenshot and reshared (for example, into a Slack thread).
  • Publish as a branded live page on your handle or your own custom domain, so the deliverable carries the agency's branding.
  • Keep the format consistent month over month, so every report in the series shares one structure and clients know where to find each number.
  • Report back view analytics (aggregate views by day), indicating whether the client opened the report before the call.

SEO client report template

The skill applies one structure to every monthly client report, so month twelve matches month one and the client learns where to find their numbers.

What should an SEO client report include?

An SEO client report should include seven sections, in this order:

  1. Executive summary — the headline outcomes in the client's terms (leads, revenue, rankings that matter to them), three to five sentences, no jargon.
  2. KPI scorecard with month-over-month deltas — organic sessions, clicks, impressions, conversions; every metric paired with last period's figure and the change (absolute and %).
  3. Keyword rankings — movement on the client's target terms, rather than a dump of every tracked keyword.
  4. Organic traffic and top pages — which pages earned the traffic, which gained or lost, and why.
  5. Backlinks won — new referring domains and the notable links, tied to the work that earned them.
  6. Technical health — crawl errors, Core Web Vitals, indexation issues found and fixed.
  7. Next steps — planned work for the next period.

The ordering places outcomes first and methodology last, matching how clients rather than analysts read a report. This is the client report template the skill applies, and the structure holds for any monthly client report, whether or not the skill is used.

How do I automate SEO client reports?

Three steps, with user approval before anything is published:

  1. Install the skill (one command, below) in Claude Code or Codex.
  2. Provide the data — your Search Console and GA4 exports (or connected data sources) and rank-tracker numbers for the period. The skill works from real figures you supply; it does not pull from Google APIs itself, and it asks rather than estimates when a number is missing.
  3. The agent builds and publishes — it reuses last month's structure, computes the period-over-period deltas, writes the narrative, renders the charts, and shows you the headline numbers and section list for approval. Only then does it publish to a live, tracked URL.

The following month, pointing the skill at the new period's data produces the same report with new numbers. The template, the narrative structure, and the publishing step are handled by the skill.

Who it's for

  • SEO consultants and freelancers sending recurring monthly reports
  • Agencies standardizing client reporting across many accounts
  • Anyone producing the same report format repeatedly across reporting periods

Install

/plugin marketplace add dashaworks/seo-client-report-skill

How it works

Publishes through the ReportRoom MCP server — the agent fetches the design system, authors the report, lints it, and publishes to a live URL with analytics attached. ReportRoom is a hosted service; the skill provisions a free account in-conversation on first use, and published pages carry a small "Published with ReportRoom" footer credit. Custom domains are available on Team and Business plans.

FAQ

Does it connect to Google Search Console or GA4 directly?

No. You provide the exports (or already-connected data sources), and the skill builds the report from those figures. It does not fabricate, extrapolate, or pad a metric — missing numbers are requested from the user rather than filled in, so the published report contains only figures the user supplied.

Are the published reports private?

Published pages are public, indexable URLs — the skill scans for anything a client wouldn't want public before you approve. View analytics are aggregate view counts by day (reported to you, never shown on the report), and each page keeps one client — pages are never reused across clients.

Related skills

  • report-skills — the report-skills hub: the general bundle, including a non-SEO client reporter for status reports, audits and campaign recaps
  • data-room-skill — a virtual data room skill for fundraising and M&A document sharing
  • share-as-link-skill — publish any AI output as a live URL

All of them publish through ReportRoom, the AI report generator behind the live pages.

License

MIT — see LICENSE.