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 to | Use | You need |
|---|---|---|
| Report SEO and AI visibility to a client or your boss each month | SEO report template | Search Console, and a log or tracker of AI answers |
| Decide which GEO tactics are worth your time | GEO checklist | Nothing |
| Find out whether AI Overviews are taking your clicks | AI Overview CTR loss finder | Search Console |
| Build the questions you track in AI answers | Question set builder | Nothing |
| Turn logged AI answers into counts for the report | Answer log analyzer | A 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
- Download the file and open it in Excel or LibreOffice Calc.
- Read the Start here tab. Shaded cells are the ones you fill in; other cells hold formulas or fixed text.
- 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
| Date | Change |
|---|---|
| 4 November 2026 | Page published with three templates. |