Template · Beginner
AI Visibility Audit Template (Sheet + Report)
This AI visibility audit template is a spreadsheet and one-page report structure for checking how often AI engines mention, cite and recommend your brand compared with competitors. You log prompts, run them in each engine, record what appears and which sources are cited, then summarise the findings. It works manually or with a MentionX scan export, and fits a first audit of 20–50 prompts.
What does the template do?
It gives you a consistent way to answer four questions:
- Do AI engines know about us? (mention rate)
- Do they use our content as a source? (citation rate)
- Do they recommend us? (recommendation rate)
- Who wins instead, and why? (competitor share and cited sources)
Consistency matters more than tooling. If you record results the same way every time, you can compare audits month to month.
Who is this template for?
It suits marketers running their first GEO check, agencies preparing a pitch or onboarding a client and in-house teams that want a repeatable monthly baseline before buying tools. Because every field is defined, two people can fill it in and get comparable results, which matters when an audit is shared across a team or handed over to a client.
How long does an audit take?
As a rough estimate, a 20-prompt audit across three engines with one run each produces 60 answers and takes three to four hours by hand, including recording sources. Doubling to two runs roughly doubles the recording time. A scan export removes most of the manual logging, leaving your time for analysis and the report, which is where the value is. Block the time in one sitting if you can, so every answer comes from the same day.
What's in each tab?
| Tab | Purpose |
|---|---|
| Setup | Brand, competitors, engines, audit date, run count |
| Prompts | Prompt list with stage and topic |
| Results | One row per prompt × engine × run |
| Sources | Every cited URL with domain and type |
| Summary | Auto-calculated rates and share of voice |
| Report | One-page findings outline |
What do the fields mean?
Prompts tab
| Field | Definition |
|---|---|
| Prompt ID | Short unique code, e.g. P01 |
| Prompt | Exact text, written the way a buyer would ask |
| Stage | Category, comparison, problem or brand |
| Topic | The product line or theme |
| Priority | High, medium or low |
Results tab
| Field | Definition |
|---|---|
| Date | When the prompt was run |
| Engine | e.g. ChatGPT, Perplexity, Google AI Overviews, Gemini, Copilot |
| Run | 1, 2, 3… for repeat runs |
| Brand mentioned | Yes/No: your brand name appears anywhere |
| Brand cited | Yes/No: one of your URLs is a source |
| Brand recommended | Yes/No: the answer suggests choosing you |
| Position | Order of first mention among brands, if listed |
| Competitor 1–3 mentioned | Yes/No per competitor |
| Notes | Accuracy problems, sentiment, odd answers |
Sources tab
| Field | Definition |
|---|---|
| URL | The cited page |
| Domain | Root domain |
| Type | Own site, competitor, review site, media, community, reference, other |
| Mentions us | Yes/No |
| Influenceable | Could we realistically earn a mention here? |
How do you fill it in?
- [ ] Enter your brand, three real competitors and the engines you'll check in Setup.
- [ ] Write 20–50 prompts across all four stages in Prompts.
- [ ] Run each prompt in each engine. Use a clean session, without signing in where possible, and note your location.
- [ ] Record every answer in Results; repeat runs if you can.
- [ ] Copy every cited URL into Sources.
- [ ] Check the Summary tab and write the Report.
If you use MentionX, paste the scan export into the Results tab. The columns are designed to match.
What does a filled example look like?
Illustrative example only; the brand and results are invented.
| Prompt | Engine | Mentioned | Cited | Recommended | Competitors mentioned |
|---|---|---|---|---|---|
| best CRM for small nonprofits | ChatGPT | Yes | No | No | 3 |
| best CRM for small nonprofits | Perplexity | No | No | No | 2 |
| [brand] vs [competitor] pricing | ChatGPT | Yes | Yes | No | 1 |
| how to track donors without spreadsheets | Google AI Overviews | No | No | No | 2 |
Summary for this fictional audit: mentioned in 2 of 4 answers, cited in 1, recommended in 0. With only four rows, that's a format example, not a finding.
How are the summary rates calculated?
| Metric | Formula |
|---|---|
| Mention rate | Answers mentioning you ÷ total answers |
| Citation rate | Answers citing your URLs ÷ total answers |
| Recommendation rate | Answers recommending you ÷ total answers |
| Share of voice | Your mentions ÷ all brand mentions (you + competitors) |
Report rates by engine as well as overall. One engine often behaves very differently from another. With small samples, add a range: the NIST guidance on the Wilson interval explains a sound method for proportions.
How do you turn it into a report?
Use the one-page outline in the Report tab:
- Headline: one sentence on where you stand.
- By engine: a small table of the three rates.
- Competitors: who wins and on which prompt types.
- Sources: the five most-cited domains and whether they mention you.
- Accuracy issues: wrong prices, outdated features, confusion with other brands.
- Three actions, each tied to a finding.
- Limits: sample size, date and location.
What mistakes should you avoid?
- Leading prompts. Don't ask "Is [brand] good?" in category research.
- Mixing methods. Keep the engines, settings and location consistent between audits.
- Single runs only. Answers vary; even two runs show you how much.
- Skipping sources. The Sources tab is where most actions come from.
- Overclaiming. A first audit is a baseline, not proof of a trend.
How often should you re-run the audit?
Monthly works for most teams; quarterly is fine for slower-moving categories. Keep the same prompt set as your core and add new prompts in a separate section, so your trend line stays comparable.
Where next?
Learn to design better prompts in GEO 101, go deeper with the GEO audit template and the citation gap analysis template, or use this template for the Break into GEO capstone.
Questions
What does the template include?
A prompt log sheet, a results sheet, a source sheet, a summary tab and a one-page report outline.
Do I need MentionX to use it?
No. You can fill it in manually. A MentionX scan export can be pasted in to save time.
How many prompts should I start with?
Twenty to fifty prompts on one priority topic is a practical first audit.