| name | weekly-report-writer |
| description | Generate a client-ready weekly SEO report from week-over-week GSC data. Use when the user says "write my weekly SEO report", "weekly GSC report", "client SEO update", "WoW performance summary", "what changed this week", or pastes current + prior week Search Console exports. Works standalone from two GSC CSVs.
|
Weekly Report Writer
Turn two weeks of GSC data into a concise, client-ready markdown report: what changed, what moved, and what you'll do about it next week. The audience is a busy stakeholder — lead with the numbers and the plan, not raw data dumps.
Input
Two GSC exports, same window length (7 days each), ideally Page or Query+Page level:
Expected columns: Query and/or Page, Clicks, Impressions, CTR, Position. Confirm the two date ranges and that windows match. If only one week is given, ask for the second. Ask who the report is for (client name / brand) so you can address it.
Steps
- Compute site-level WoW totals: total Clicks, Impressions, average CTR, average Position — with absolute and % change for each. Average position improves when the number goes down — phrase changes in plain language ("moved up 1.4 spots").
- Top movers — up. The pages/queries with the largest positive Δclicks (and note Δposition). Cap at ~5.
- Top movers — down. The largest negative Δclicks. Cap at ~5. For each decliner, give a one-line plausible reason from the data (position drop, CTR drop, impressions drop = demand/seasonality vs ranking).
- New & lost. Queries/pages that appeared this week (new rankings) or dropped out entirely. Highlight notable ones.
- Quick wins surfaced. Note any new striking-distance (pos 11–20) queries worth chasing — feeds next week's priorities.
- Set 3 priorities for the coming week — concrete, tied to the data above (e.g. "Refresh
/declining-post — lost 40 clicks as it slipped from 6→11; update stats and re-target the primary query"). Not generic ("keep creating content").
Output
A clean markdown report, ready to paste/send:
# Weekly SEO Report — [Client] — [date range] vs [prior range]
## Summary
[2–3 sentence plain-language overview: overall direction + the single most important thing.]
## Performance at a glance
| Metric | This week | Last week | Change |
|--------|-----------|-----------|--------|
| Clicks | … | … | +X (+Y%) |
| Impressions | … | … | … |
| Avg CTR | … | … | … |
| Avg position | … | … | … |
## What went up
[Top movers up — table or bullets, page/query + Δ]
## What went down
[Top movers down + likely reason each]
## Priorities for next week
1. …
2. …
3. …
Keep it tight and skimmable. Translate jargon for a non-technical reader. Be honest about declines — frame them with the action you'll take, not excuses. End with the one headline metric the client should remember.
