Free SEO and AI search templates

Free SEO and GEO templates: an SEO report with AI visibility ranges, an evidence-graded GEO checklist and an AI Overview CTR loss finder. Excel, CC BY 4.0, no signup.

Last updated

On this page
  1. Which template do you need?
  2. What makes these different
  3. Coming next
  4. How to use them
  5. Questions
  6. License and credit
  7. Update log

Short answer: three free spreadsheet templates for SEO now that buyers also ask AI tools. An SEO report template that adds AI visibility with a range on every rate, a GEO checklist where every item is graded by the evidence behind it, and an AI Overview CTR loss finder for Search Console data. All three are Excel files, free, with no signup, licensed CC BY 4.0.

Every file here is ours. The report template uses the same interval method as our free answer log analyzer, and the checklist uses the same evidence grades as our free skills. The report and CTR templates ship with fictional example rows, so you can see what they produce before you add your own data.

  • REPORT · EXCEL

    SEO report template with AI visibility

    Search Console numbers next to AI answer numbers. Every AI rate gets a 95% range, and a verdict says whether a change is real or run-to-run noise.

    Get the report template →
  • CHECKLIST · EXCEL

    GEO checklist, graded by evidence

    19 checks, each tagged with what supports it: platform documentation, a published study, or nothing yet. Tells you what to do first and what to skip.

    See the checklist →
  • SEARCH CONSOLE · EXCEL

    AI Overview CTR loss finder

    Finds the queries where your click-through rate fell while your ranking held, and separates AI Overview losses from title and snippet problems.

    Get the CTR sheet →
  • SKILL · FREE

    Question set builder

    The step before any AI visibility report: a fixed set of buyer questions with stable IDs, so months compare.

    View on GitHub →

Which template do you need?

If you want toUseYou need
Report SEO and AI visibility to a client or your boss each monthSEO report templateSearch Console, and a log or tracker of AI answers
Decide which GEO tactics are worth your timeGEO checklistNothing
Find out whether AI Overviews are taking your clicksAI Overview CTR loss finderSearch Console
Build the questions you track in AI answersQuestion set builderNothing
Turn logged AI answers into counts for the reportAnswer log analyzerA CSV of answers

What makes these different

  • Ranges, not single numbers. AI answers change from one run to the next, so a rate from a handful of answers can swing a long way by chance. The report template puts a 95% range on every rate and only calls a change real when the data supports it.
  • Every tactic is graded. The checklist says whether an item rests on platform documentation, a published study, a vendor claim or nothing at all. Grades come from one public evidence file and change only when the evidence does.
  • Built for Search Console as it is. Google says AI Overviews and AI Mode traffic is included in the Web search type of the Performance report (Google, AI features and your website). That page does not describe a way to filter it out. So the CTR sheet has you record by hand whether an AI Overview showed, rather than pretending to measure it.

Coming next

Verified directory link sheet, due 6 December 2026. Our BL-001 experiment starts submitting this site on 6 November 2026 to the free directories that public “get backlinks” lists recommend. On day 30 we publish every site that gave a live followed link on an indexed page, and the share of submissions that gave nothing. We will not publish an unchecked list.

How to use them

  1. Download the file and open it in Excel or LibreOffice Calc.
  2. Read the Start here tab. Shaded cells are the ones you fill in; other cells hold formulas or fixed text.
  3. In the report and CTR templates, delete the fictional example rows and paste in your own data.

Questions

Are these templates free?

Yes. No signup, no email gate, and no paid tool needed to fill them in.

Can I use them for client work?

Yes. They are licensed CC BY 4.0: use and adapt them, including commercially, with credit and a link to this page.

Do I need an AI visibility tracker for the report template?

No. The AI tab takes three counts per engine and period: answers logged, answers that name you, and answers that cite your site. You can get those from any tracker, from a hand log, or from our free answer log analyzer.

License and credit

All templates are free to use and adapt under CC BY 4.0, with credit and a link: AI Visibility Census, aivisibilitycensus.com/templates/. Found a mistake? Email hello@aivisibilitycensus.com or open an issue on GitHub. If a template saves you time, star the repository: stars are how other people find it.

New templates and every Census test result, sent when they publish: get the Census by email. Free, and one click to leave.

Update log

DateChange
4 November 2026Page published with three templates.