Kovmere vs Manual Spreadsheets for Tracking Repeated AI Recommendations and Cited Pages
A manual spreadsheet is one of the cheapest ways to track AI recommendations, and for a handful of questions checked now and then it works well. It also lets you test any assistant, in any market, including the consumer apps your customers use. It becomes hard to keep honest when you repeat each question several times across several engines and log the cited pages, because the work grows with every run. Kovmere, which is our product, automates that routine for up to 18 buyer questions and 2 brand checks on five engines. Start with a spreadsheet if you are testing the idea; switch when the logging takes longer than the thinking.
What does a manual tracker need to record?
A spreadsheet only produces evidence you can trust if every row captures the same things. For each run of each question on each engine, record:
| Column | Why it matters |
|---|---|
| Date and time | Answers change; you need to know when each was taken |
| Engine, mode and settings | Logged in or out, search on or off, location, model name if shown |
| Question, word for word | A small wording change can change the answer |
| Run number | So you can tell a pattern from a one-off |
| Brands named, in order | Who the answer put forward and who it only mentioned |
| Were you mentioned? Recommended? | Two different outcomes; keep them in separate columns |
| Cited URLs | Every link shown, not just the first |
| Your pages cited? | Whether any cited URL is on your own domain |
| Notes | Wrong facts, outdated prices, qualifiers attached to your name |
Keep the questions on a separate tab and never edit them in place; if you change a question, add a new one so the old history stays meaningful. Our guide to manually tracking AI visibility by testing prompts across engines walks through the method step by step, and whether to use temporary ChatGPT chats covers keeping tests clean.
How much work is a manual tracker?
The arithmetic is simple and unforgiving. Twenty questions on five engines with three runs each is 300 answers. If copying an answer, noting the brands and pasting every cited link takes about two minutes, one full reading is around ten hours. Repeat that monthly and it is a working week every quarter, before anyone analyses the results.
Most teams cut the scope to make it bearable: fewer engines, one run per question, or only the first cited link. Each cut makes the data weaker in a specific way. One run per question cannot tell a pattern from chance; recording only the first link misses the review site cited third that actually carries the answer.
How should you analyse the sheet once it has data?
Raw rows are not findings. A few simple summaries turn them into decisions:
- Per question: in how many of the runs were you mentioned, and in how many were you recommended? Questions where you are mentioned but rarely recommended are a different problem from questions where you never appear.
- Per engine: a gap on one engine only usually points to that engine's sources; a gap everywhere points to your own pages or your reputation.
- Top cited domains: count how often each domain appears across all runs. The few at the top are where outreach or corrections pay off first.
- Rivals named instead: for each lost question, which competitor took the place, and which page was cited for it.
- Change since last reading: only for questions whose wording, engine and settings stayed exactly the same.
Pivot tables can do all of this, but only if every row was logged the same way, which is the hardest part to keep up over months.
Where do spreadsheets break?
- Consistency. Different people log differently. One counts "also consider" as a recommendation, another does not.
- Settings drift. Testing one week logged in and the next logged out, or from a different location, changes the answers without anyone noticing.
- Source analysis. Logging URLs is one thing; opening the most-cited pages to see whether they mention you is another job entirely, and it is usually the first thing dropped.
- Repetition. The longer it runs, the more likely a question gets edited in place and its history quietly breaks.
- Turning findings into fixes. A spreadsheet tells you where you lost. Working out what to publish, and checking every claim in the draft against your own site, is still to do.
Where do spreadsheets win?
- Cost. Nothing to buy.
- Any surface. You can test the consumer apps, signed in or out, voice assistants, shopping features or AI Mode, none of which Kovmere samples.
- Any market and language. Kovmere measures one market per site, in the US, UK, Canada, Australia, Ireland or New Zealand; a spreadsheet can test anywhere you can reach.
- Learning. Doing a few readings by hand teaches you how answers behave, which makes any tool's output easier to judge later.
How does Kovmere compare with a spreadsheet?
| Manual spreadsheet | Kovmere (ours) | |
|---|---|---|
| Cost | Free, plus staff time | $19 one-time Check; Pro $49 a month |
| Engines and surfaces | Any you can open, including consumer apps | OpenAI, Perplexity, Gemini and Claude through search-enabled APIs, plus Google AI Overviews |
| Market | Any | One market per site: US, UK, Canada, Australia, Ireland or New Zealand |
| Runs | As many as you have time for | Three per question per engine in each baseline; single-run re-tests weekly on Pro |
| Mention vs recommendation | Your judgement, row by row | Recommendation judged only after a whole-word mention, reported separately |
| Cited pages | Whatever you paste | Every cited URL counted; the most-cited fetched and labelled by page type and whether they mention you |
| Fixes | You write them | Up to 3 on a Check, up to 12 per billing period on Pro, each fact traced to your site |
When is switching worth it?
- You keep cutting runs or engines to save time. At that point the spreadsheet is producing weaker evidence than you need.
- You report the results to someone. A boss or client will ask how the numbers were collected; a fixed method is easier to defend.
- You plan to change pages and measure the effect. Comparisons need the same questions, settings and runs every time.
- You want the fixes, not just the findings. Drafting from evidence is the slow part a spreadsheet does not help with.
Many teams keep both: a small spreadsheet for the surfaces Kovmere does not sample, such as AI Mode or a voice assistant, and Kovmere for the repeated readings on five engines.
What do people ask about tracking AI answers by hand?
How many runs per question should a manual tracker use?
At least three on each engine for the questions that matter most. A single run cannot show whether an answer is typical.
Should I record every cited link?
Yes. The page that carries an answer is often not the first link shown, and missing it leads you to fix the wrong thing.
Can I mix manual checks with a tool?
Yes, as long as you keep the methods apart in your reporting. Manual checks of the consumer apps answer a different question from API samples with fixed settings.
Is the free route ever better?
For a first look at a few questions, or for surfaces and markets a tool does not cover, yes. For repeated, comparable readings on many answers, the hours usually cost more than a subscription.
Published by The Kovmere Team · updated Oct 3, 2026 · More resources