A daily SEO report written by an AI employee on Claude Code

What the report covers

• Search: impressions, clicks and average position for the last seven days, with the queries and pages behind them.
• What's working: queries in the top 10, pages whose impressions are rising, and pages with impressions but no clicks, which usually means the title or the content doesn't match the search.
• Visitors: unique visitors, visitors from search engines and visitors from AI assistants such as ChatGPT and Perplexity, with the landing pages they came to.
• The gap to the goal: this week's numbers against the weekly target.
• What it did today, and the decisions it needs from you.

An example: our own report, November 10, 2026

This is the top of the report Crewmark's SEO employee posted for crewmark.ai, a site a few weeks old.

How to set up a daily SEO report on Claude Code or Codex

1. Give it read-only access to the numbers

   For Search Console: the Search Console API with a read-only service account, an MCP server, or a browser the agent can drive while you're signed in. For analytics: your tool's CLI, API or MCP server; our employee uses PostHog's CLI. Read access is all it needs.

2. Copy the role brief

   Put it in CLAUDE.md for Claude Code or AGENTS.md for Codex, and change the goal to yours. The open-source Marketing Team Skills include an seo-daily-report skill with the same steps.

   # Role: SEO reporter
   Runs from the recurring issue "Daily SEO report", every day at 18:30.
   
   1. Search Console, last 7 days: impressions, clicks, average position.
      Read the queries and pages tables. Note queries in the top 10,
      pages whose impressions are rising, and pages with impressions
      but no clicks.
   2. Analytics, last 7 days: unique visitors, visitors from search,
      visitors from AI assistants, top landing pages from search.
   3. Compare with the weekly goal: 10,000 impressions, 500 clicks,
      2,000 unique visitors.
   4. Pick one thing that works and double down on it today
      (a related page, an FAQ, internal links or a translation).
   5. Post the report as a comment on the issue, list any decision
      you need from me, then mark the issue done.
   
   Rules
   - Read-only access to Search Console and analytics.
   - Ignore queries in quotes or with long -site: lists: those are
     rank trackers, not people.

3. Put it on a schedule

   Make the report a recurring issue, so it comes back to the employee every day at the same time and you can see whether today's is done.

   # A recurring issue, assigned to your SEO employee (Crewmark CLI)
   crewmark issues create --title "Daily SEO report" --assignee "<employee>" \
     --repeat "daily at 18:30" --timezone America/New_York

4. Read it where you already work

   The report lands as a comment on the issue. When it needs something from you, it marks the issue Needs action and asks.

Turn the report into action

A report that only describes the numbers doesn't move them. The useful part is the rule for what to do next, and it's in the brief:

• A query in the top 10 or rising: write the related long tail (the same tool's other uses, “vs”, alternatives, errors, platforms), add an FAQ, link to it from pages that already get visitors, or translate it into a language that already searches for it.
• Impressions but no clicks: the page doesn't match the search. Retitle it to the query people use, or write a page for that query.
• Head terms stuck past position 50: stop spending time on them; a new site wins long tails first.
• Write the decision and the result in a log, so tomorrow's report can check whether it worked.

Step by step for Claude Code and Codex

The built-in commands, the tools to connect and the schedule for each agent: Claude Code for SEO and Codex for SEO.

Hire the SEO employee that writes it

The report is one part of an SEO specialist's day. Crewmark turns your Claude Code or Codex into that employee, with a role, a goal in numbers, working hours and a heartbeat.

1. Start from the role

   The AI SEO specialist comes with its goals, daily routine and brief.

2. Add the report as a recurring issue

   It wakes on its heartbeat, sees the report is due and posts it.

3. See the rest of marketing

   More jobs for marketing teams are on Claude Code for marketing; the next use case is a weekly competitor digest.

FAQ