Search Everywhere: SEO Report and Tracking Templates
Ready-to-use templates for monthly search reports, change logs, AI prompt tracking, content refresh briefs, pruning decisions and log summaries.

This post is Appendix E of Search Everywhere: The Practical Guide to SEO, AEO and GEO, the free online edition. Chapter and appendix references link to the matching post.
These templates turn the measurement chapters into documents you can reuse. Copy them into a spreadsheet, a Google Doc or your reporting tool.
E1. Monthly search visibility report
Report for: webocreation.com/ Period: [month] compared with [previous month] and [same month last year] Prepared by: [name], [date]
1. Summary (three to five sentences)
What changed, why, and what we will do next. Example: “Non-branded organic clicks rose 9% month over month, led by the refreshed OpenCart upgrade guide, which now owns the featured snippet for ‘upgrade opencart 3 to 4’. AI citation rate on core OpenCart prompts rose from 25% to 31%. Pruning of 140 off-topic URLs completed; ‘Crawled – currently not indexed’ fell by 22%. Next month: publish the hosting and Stripe guides and launch the store-owner survey.”
2. Scorecard
| Layer | Metric | This month | Last month | Change | Last year | Target |
|---|---|---|---|---|---|---|
| SEO | Organic clicks (GSC) | |||||
| SEO | Non-branded clicks | |||||
| SEO | Organic sessions (GA4) | |||||
| SEO | Organic key events | |||||
| SEO | Indexed share of submitted URLs | |||||
| SEO | Keywords in top 10 (Semrush) | |||||
| AEO | Featured snippets owned | |||||
| AEO | AI Overview citations (tracked keywords) | |||||
| AEO | Question query clicks (GSC regex) | |||||
| GEO | Prompt citation rate (all assistants) | |||||
| GEO | Share of voice vs competitors | |||||
| GEO | AI Assistants sessions (GA4) | |||||
| GEO | AI Assistants key events | |||||
| GEO | User-initiated AI fetches (logs) | |||||
| Brand | Branded clicks (GSC) | |||||
| Tech | Core Web Vitals pass rate (mobile) | |||||
| Tech | 5xx responses to Googlebot (logs) |
3. Wins
Three to five specific wins with evidence (screenshots, URLs, numbers).
4. Issues and risks
Problems found, with severity and owner.
5. Work completed
List of changes made this month, with dates (also recorded in the change log).
6. Next month’s priorities
Three to five priorities, each with an owner and expected outcome.
E2. Change log
| Date | Change | Pages affected | Owner | Expected effect | Observed effect (4–8 weeks later) |
|---|---|---|---|---|---|
| 2026-11-20 | Noindexed tag archives | ~600 tag URLs | Fewer low-value URLs crawled | ||
| 2026-11-20 | Fixed robots.txt bot groups | Site-wide | Bots respect admin and search disallows | ||
| 2026-11-22 | Homepage title and H1 rewritten | Homepage | Better CTR on brand + OpenCart development queries |
E3. Prompt tracking sheet
Tab 1: Prompts
| ID | Prompt | Persona | Topic | Funnel stage | Added |
|---|---|---|---|---|---|
| P01 | What’s the easiest way to stop spam registrations on OpenCart 4? | Store owner | Security | Problem | 2026-11 |
| P02 | How do I upgrade from OpenCart 3.0.3.8 to OpenCart 4 without losing orders? | Store owner | Upgrades | How-to | 2026-11 |
| P03 | Which books should I read to learn OpenCart 4 extension development? | Developer | Books | Recommendation | 2026-11 |
| P04 | Recommend an OpenCart developer who also does SEO. | Store owner | Services | Recommendation | 2026-11 |
| P05 | Who is Rupak Nepali? | Any | Brand | Brand | 2026-11 |
Tab 2: Runs
| Date | Prompt ID | Assistant | Run | Brand mentioned | Position | Domain cited | Cited URLs | Sentiment | Accurate | Competitors mentioned | Other cited domains |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Y/N | Y/N | +/0/− | Y/P/N |
Tab 3: Metrics (formulas)
- Mention rate:
=COUNTIFS(Runs!E:E,"Y")/(COUNTA(Runs!B:B)-1) - Citation rate:
=COUNTIFS(Runs!G:G,"Y")/(COUNTA(Runs!B:B)-1) - Citation rate by assistant:
=COUNTIFS(Runs!C:C,"Perplexity",Runs!G:G,"Y")/COUNTIFS(Runs!C:C,"Perplexity") - Citation rate by topic: use a lookup from Prompts to Runs, then
COUNTIFSby topic.
Tab 4: Accuracy log
| Date | Assistant | Prompt ID | Incorrect statement | Likely source | Fix | Status |
|---|---|---|---|---|---|---|
| “Webocreation was founded in 2010” | About page wording | Clarify company vs founder dates | Done |
E4. Content refresh brief
| Field | Entry |
|---|---|
| URL | |
| Primary query | |
| Current position / clicks / CTR (GSC, 3 months) | |
| Trend vs last year | |
| SERP features present (snippet, PAA, AIO, video) | |
| Who owns them now | |
| What top results cover that we do not | |
| What we have that they do not (information gain) | |
| Outdated facts, versions or screenshots | |
| Questions to add (PAA, GSC regex) | |
| Prompts this page should answer | |
| New sections | |
| Summary box text | |
| Title (≤ 60 characters) | |
| Meta description | |
| Internal links to add (from / to) | |
| Schema to check | |
| Date refreshed | |
| Result after 6 weeks |
E5. Pruning decision sheet
| URL | Topic fit (core/secondary/off) | Clicks 12m | Referring domains | Key events | Quality (1–3) | Decision | Redirect target | Done |
|---|---|---|---|---|---|---|---|---|
| /bokagiri-part-4-…/ | Off | |||||||
| /control-of-diarrhoeal-disease/ | Off | |||||||
| /title-page-of-internship-report-…/ | Secondary (students) | Merge | /internship-report-guide/ | |||||
| /how-to-make-money-with-nfts-…/ | Off |
Decision values: Keep, Improve, Merge + 301, Noindex, Move, Remove (410).
E6. Log analysis summary (monthly)
| Bot | Requests | Change vs last month | Unique URLs | % 2xx | % 3xx | % 4xx | % 5xx | MB | Top section |
|---|---|---|---|---|---|---|---|---|---|
| Googlebot | |||||||||
| Bingbot | |||||||||
| GPTBot | |||||||||
| OAI-SearchBot | |||||||||
| ChatGPT-User | |||||||||
| ClaudeBot | |||||||||
| Claude-User | |||||||||
| PerplexityBot | |||||||||
| Perplexity-User | |||||||||
| Other AI |
Top 10 URLs fetched by user-initiated AI agents this month:
| URL | ChatGPT-User | Claude-User | Perplexity-User | Total | GA4 AI sessions |
|---|---|---|---|---|---|
E7. Client audit summary page
For agencies, a one-page summary at the front of an audit:
- What we reviewed (scope, dates, tools, data access).
- What is working (three strengths to keep).
- Top five issues (each with impact, effort, priority).
- 90-day plan (three phases with milestones).
- What we need from you (access, exports, decisions).
- How we will measure success (the scorecard from E1).
Chapter 25’s audit of webocreation.com/ follows this structure and can be used as a worked example.
Previous: SEO, AEO and GEO Glossary: Terms Explained
All chapters: Search Everywhere: The Practical Guide to SEO, AEO and GEO







