SEO and Marketing · 4 min read · Updated

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.

Free SEO Report and Tracking Templates: featured image for the webocreation.com guide

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 COUNTIFS by 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:

  1. What we reviewed (scope, dates, tools, data access).
  2. What is working (three strengths to keep).
  3. Top five issues (each with impact, effort, priority).
  4. 90-day plan (three phases with milestones).
  5. What we need from you (access, exports, decisions).
  6. 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

Search Everywhere (full PDF)The complete guide in one printable PDF.PDF · 2.8 MB
Free download: unlock it in one step

Share this page

or

Mailchimp opens in a new tab to confirm. Unsubscribe any time.

Rupak Nepali
Written byRupak Nepali

Rupak Nepali is a web developer, manage Webocreation website and the author of six books:
Getting Started with OpenCart Module Development (Packt, 2013),
OpenCart Theme and Module Development (Packt, 2015),
OpenCart 4: Dev Guide for Themes & Extensions (2024),
OpenCart 4: User Manual (2025),
Cloudflare for the Enterprise Website (2026) and
The Technical Web Guide for Marketers (2026).
Rupak has built OpenCart stores and extensions since 2010, has published more than 600 tutorials on Webocreation, and shares free OpenCart extensions on GitHub.
Find Rupak on
GitHub | Amazon | LinkedIn | X | YouTube.

Leave a Reply

Your email address will not be published. Required fields are marked *