Client report writer
Open-source skills that turn your agent into an SEO operator. Diagnose traffic decay, write refresh briefs, build proposals, and generate client-ready reports.
npx -y skills add marketingskills/seo --skill client-report-writerAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Turn GSC/GA4 performance data into a client-ready weekly or monthly narrative. Use when Codex needs to produce a professional SEO performance report with executive summary, metrics breakdown, trend analysis, and action recommendations.
SKILL.md
3.0 KB, as published. Nobody here has run it
Client Report Writer
Overview
Transforms raw GSC and GA4 data into a structured client-ready report. The report tells a clear story: what happened, why it happened, and what to do next. Works with live data or pasted exports.
Inputs
- Current period GSC data (clicks, impressions, CTR, avg position by page and query)
- Prior period GSC data for comparison
- Optional: GA4 data (sessions, users, conversions, landing pages)
- Optional: goals or KPIs the client tracks
- Optional: previous report for trend continuity
- Client name or brand voice preferences
Workflow
- Collect metrics for current and prior periods.
- Calculate period-over-period changes for all key metrics.
- Identify:
- Top-level trend (up, down, flat with magnitude).
- Pages that drove the change (top gainers, top decliners).
- Queries that drove the change.
- Technical issues detected (indexing drops, coverage changes).
- Categorize changes as:
- Expected (seasonal, planned launches, known ranking shifts).
- Actionable (fixable issues with clear ROI).
- Monitoring (needs observation before action).
- Write the report in professional narrative form.
- Add a recommendations section with prioritized actions.
Output Format
## SEO Performance Report
**Client:** [Name] | **Period:** [Range] | **Date:** [Date]
### Executive Summary
[3-5 sentence narrative of overall performance]
### Key Metrics
| Metric | Current | Prior | Change |
|---|---|---|---|
### What Changed
[Explanation of the main movements]
### Pages Driving Performance
#### Top Gainers
[Table with page, metric change, probable cause]
#### Top Decliners
[Table with page, metric change, probable cause]
### Query Trends
[Notable query movements, new opportunities, declining terms]
### Technical Health
[Index status, coverage issues, crawl stats if available]
### Recommendations
1. [Priority action with expected impact]
2. [Secondary action]
3. [Monitoring item]
### Appendix
Data sources, date ranges, methodology notes.
Style Guidance
- Use professional, direct language. Avoid jargon where possible.
- Frame negative movements as situations with clear next actions, not failures.
- Include both absolute numbers and percentages.
- Call out what the client should be excited about and what needs attention.
- Keep the executive summary to 3-5 sentences — senior stakeholders should get the full picture from it.
- Separate signal from noise: if a 5% drop is normal fluctuation, say so.
Related Skills
traffic-decay-detector— feeds declining page data into the report.proposal-builder— for converting prospect data into a proposal (consulting version of this).marketingskills/seo/skills/live-search-console-data— live GSC/GA4 data bridge.