Blog

Free AEO Audit Template: 5 Steps to See Why AI Overviews Skip Your Site

← All posts
TL;DR
  • An AEO audit template is a spreadsheet that records, query by query, whether Google's AI Overview appears, who it cites, and why that is not you.
  • Five steps: keyword research, AI Overview analysis, finding the reasons, citation analysis, opportunities. Each has one table below that you can copy into Google Sheets.
  • A first pass on 10 queries fits in about 30 minutes with no paid tool.

An AEO audit template is a simple spreadsheet that shows which of your target queries trigger a Google AI Overview, which sources get cited, and where your pages are missing. This post gives you the five-step version, with one table per step that you can copy into Google Sheets and finish in about 30 minutes.

There is no file to download. Every table is printed here, so you can copy it straight into a blank sheet.

What does an AEO audit template actually track?

Classic rank tracking asks one question: what position is my page in? An AEO audit asks a different one: when Google writes an answer, whose pages does it point to, and am I one of them?

That changes what you record. Instead of a position number, you log the answer itself, the list of cited sources, and your own gaps.

Here is the whole template at a glance.

StepThe question it answersWhat you record
1. Keyword researchWhich queries are worth checking?Query, intent, whether an AI Overview shows
2. AI Overview analysisWhat does Google's answer look like?Date, format, cited sources, are you in it
3. Find the reasonsWhy did those pages get picked?A hypothesis and the evidence for it
4. Citation analysisWho gets cited again and again?Domains, types of source, how often they appear
5. OpportunitiesWhat do I change first?Action, effort, owner, recheck date

One fact shapes the whole sheet. Google's documentation says a page needs to be indexed and eligible to show with a snippet to appear as a supporting link in AI Overviews or AI Mode, and that no extra technical requirements exist (Google Search Central, checked 26 Oct 2026). So your audit is mostly about content and coverage, not about hidden switches.

Step 1: How do I pick the queries to audit?

Start with 10 queries, not 100. Pick questions a buyer would type before they know your brand, plus a few where you already rank on page one.

Add a column for intent (learn, compare, buy) because AI Overviews do not appear for every search. Google says they show only when its systems judge them useful on top of classic results, and they often do not trigger (Google Search Central, checked 26 Oct 2026). A query with no AI Overview still goes in the sheet, marked "No", so you do not re-check it next month.

Tab 1: Keywords

KeywordIntentSearch volume (your SEO tool)AI Overview shown? (Y/N)Priority (1-3)

Filled example row (made-up, for illustration only)

KeywordIntentSearch volumeAI Overview shown?Priority
how to track ai overview citationsLearnfrom your toolY1

Step 2: How do I analyze what the AI Overview says?

Search each query in a logged-out or private window and record what you see. Answers can change between checks, so write down the date, the device and your location every time.

Capture the shape of the answer, not just the yes or no. A numbered list, a short paragraph and a comparison table each reward different page layouts.

Tab 2: AI Overview checks

KeywordDate checkedDevice / locationAnswer formatNumber of cited sourcesAre you cited? (Y/N)Screenshot link

Filled example row

KeywordDateDevice / locationFormatSourcesYou cited?Screenshot
how to track ai overview citations26 Oct 2026Desktop, India4-step list5N(paste link)

If you have Search Console, add its Generative AI report as a cross-check. Google added Generative AI performance reports to Search Console in June 2026 (Google's announcement).

Step 3: Why did Google cite those pages and not mine?

This is the step most audits skip, and it is where the sheet earns its keep. For every query where you are not cited, open the cited pages and compare them to yours.

Write a hypothesis and the evidence behind it. "Their page is better" is not a finding. "Their page answers the question in the first two sentences, mine starts with a history of the topic" is.

Common reasons to test, one per row:

  • The cited page answers the exact question in its opening lines.
  • Your page covers the main query but not the related sub-questions. Google says AI Overviews may run several related searches ("query fan-out") before answering, which can widen the set of pages it links to.
  • Your page is not indexed, or a snippet control such as nosnippet blocks it.
  • The cited source is a type you do not publish, such as a video or a forum thread.
  • Your claim has no named source or date, while theirs does.

Tab 3: Reasons

KeywordCited page (URL)Why it was picked (hypothesis)EvidenceGap on your page

Filled example row

KeywordCited pageHypothesisEvidenceGap on your page
how to track ai overview citations(competitor URL)Opens with a 4-step list that matches the questionSteps sit in the first 100 wordsYour post has the steps in section 4

Step 4: How do I find which sources get cited again and again?

Once you have 10 checks, look across rows. Tally every cited domain and label its type: brand site, publisher, forum, video, documentation.

You are looking for repeat names. A domain that shows up in six of ten checks is a stronger signal than any single answer. A source type you never publish shows you a format gap.

Do not assume a top-10 ranking will protect you. Ahrefs reported in early 2026 that about 38% of cited pages also ranked in the top 10, down from about 76% in an earlier study. BrightEdge put the overlap near 17% (reported by Search Engine Journal, checked 26 Oct 2026). The two figures come from different methods, so treat them as separate measurements, not one number. Both say ranking alone does not predict citation.

Tab 4: Citations

Cited domainSource typeTimes cited across your checksQueries where it appearsCan you compete?

Step 5: What should I fix first?

Turn every gap from Step 3 into one action with a size and an owner. Sort by effort so the first fixes are cheap ones, like moving the direct answer to the top of an existing page.

Add a recheck date. An action without a recheck date is a wish. Rerun only the affected query after you publish the change, and log the result in Tab 2.

Tab 5: Opportunities

KeywordGapActionEffort (S/M/L)OwnerRecheck date

Filled example row

KeywordGapActionEffortOwnerRecheck
how to track ai overview citationsSteps buried in section 4Move a 4-step answer to the first 100 words, add a question headingSYou4 weeks after publishing

How do I run the whole audit in 30 minutes?

Use this budget for a first pass on 10 queries. A real first run may take longer, and later runs are faster because your sheet already has the queries.

MinutesDo this
0-5Copy the 5 tabs into a new Google Sheet. List 10 queries in Tab 1.
5-15Check each query once and fill Tab 2. About one minute per query.
15-21For every "N" in Tab 2, open one cited page and fill Tab 3.
21-26Tally the cited domains in Tab 4.
26-30Write 3 actions in Tab 5, each with a recheck date.

What can a spreadsheet audit not do?

A sheet gives you a snapshot, and snapshots drift. AI answers can change from one check to the next, so a single "N" is a clue, not a verdict. Repeat important queries on a schedule, such as monthly, before you rewrite a page.

It also does not scale. Past a few dozen queries, checking by hand costs more time than it saves, and a tracking tool becomes worth looking at. Until then, a sheet is enough to learn how your category behaves.

FAQ

What is an AEO audit?

An AEO (answer engine optimization) audit checks whether answer engines, such as Google's AI Overviews, show and cite your content for the queries you care about. It records the answer, the sources and your gaps, then turns the gaps into actions.

How often should I run it?

Monthly is a sensible start for your top queries, and again after a major content update. Because answers change between checks, compare trends over several runs, not single results.

Do I need paid tools?

No. A browser, a spreadsheet and Search Console cover this template. Paid tools help once you track many queries or several AI engines.

If I rank in the top 10, will AI Overviews cite me?

Not reliably. Studies from Ahrefs and BrightEdge found that many cited pages sit outside the top 10, though they disagree on how many. Treat ranking as the entry ticket and citation as a separate result to check.

Sources (checked 26 Oct 2026)