AI Citation Tracker

AI Visibility & GEO Toolkit, template 2 of 6

AI Citation Tracker

Log answers from ChatGPT, Perplexity, Gemini and AI Overviews, and measure your citation rate by platform.

How often AI answers cite your site, on which platforms and prompts, measured over an explicit set of valid, observed answers.

  • Excel workbook (.xlsx), opens in Google Sheets
  • PDF field guide, 9 to 11 pages
  • Blank and worked CSV templates
  • DataForSEO import script

Free, no email required. Version 3.0, updated November 2026.

AI Citation Tracker.xlsx
M13fx=IF(K13="","",IF(K13<>"Ready","n.a.",IF(AND(E13=1,G13=1),1,0)))

Start HereDashboardWorkspaceDelivery QAField Guide

The formula above is the real one from cell M13. Scroll it sideways to read the whole rule.

Connected to the DataForSEO API

This template is designed around one DataForSEO endpoint. Pull the data, convert it with one command, and the workbook does the rest.

Setup steps

DataForSEO AI Optimization: LLM MentionsAI answers (ChatGPT or Google AI Overviews) that mention a domain or keyword, with their cited sourcesai_optimization/llm_mentions/search_mentions/live

Save the JSON responseThe full API response, kept as your source of truth.response.json

Run the import scriptOffline. No API calls, no credentials.dataforseo_import.py import --template 26

Paste at A13Dashboard, checks and action list update instantly.AI Citation Tracker.xlsx

Column map for this template:Filled by the APIAudit trail (automatic)You add

Observation IDPrompt or queryPlatform / modelObservation dateUsable answerAnswer includes citationsTarget domain citedTarget citation URLEvidenceSource reference
4 of 10 input columns come straight from DataForSEO

What the AI citation tracker decides

'Are we showing up in ChatGPT?' is now a board-level question, and most answers to it are anecdotes: someone tried a prompt and saw the brand mentioned. Anecdotes can't show change over time, can't be compared across platforms, and can't be audited.

This AI citation tracker logs each observed answer: prompt, platform, date, whether the answer was valid, whether it contained citations, whether your site was cited and which URL, plus evidence. It calculates eligible, cited and citation-bearing answers so your citation rate is always computed over a clear denominator, with a per-platform breakdown on the Dashboard.

Who it's for

  • SEOs and marketers tracking AI search visibility
  • Brands proving GEO work is moving the needle
  • Agencies reporting AI visibility without an expensive tool
  • Teams validating what paid AI visibility tools report

Where it fits in your workflow

The AI citation tracker answers one question. These three templates answer the questions around it:

  • AI Prompt Research Template: which prompts belong in your AI visibility panel, how much each matters, and how many observations each tracking cycle needs.
  • AI Share of Voice Calculator: how your domain's AI citation rate and share compare with competitors' within the same answer corpus.
  • AI Referral Traffic Tracker: which AI referral sources and landing pages send visits that convert, and how much contribution each AI session is worth.

What's inside the download

One ZIP with the workbook, a 10-column input template (blank and filled), the PDF field guide and an offline script that converts saved DataForSEO responses into the input CSV. The workbook has five tabs.

Workspace. The working table. 10 input columns, 4 calculated columns, room for 250 rows. Dropdowns, Yes/No fields and range checks catch bad inputs as you paste.
Start Here. What it decides, a four-step setup and the colour key.
Dashboard. KPI cards, charts, a ranked Top 10 and an automatic action list.
Delivery QA. Pass, fail or exclude each validation step with evidence, owner and date.
Field Guide. Every field explained, plus each formula in plain English.

How the AI citation tracker calculation works

Eligible answer = answer valid. Cited answer = valid and your site cited. Citation-bearing answer = valid and has any citations. Citation rate = cited ÷ eligible, overall and per platform.

The key formula, exactly as it appears in the workbook

=IF(K13="","",IF(K13<>"Ready","n.a.",IF(AND(E13=1,G13=1),1,0)))
Result column Plain-English formula What it tells you
Eligible answer Usable answer Denominator contribution for overall observed-answer citation rate.
Cited answer IF(AND(Usable answer=1,Target domain cited=1),1,0) Numerator contribution for target citation rate.
Citation-bearing answer IF(AND(Usable answer=1,Answer includes citations=1),1,0) Alternative denominator for share among citation-bearing answers.

How to use the AI citation tracker

  1. Run the prompt panelUse the prompts from your prompt research template. Run each on each platform, logged out where possible.
  2. Log every answerOne row per answer with platform and date. Mark answer valid = 0 for errors or refusals.
  3. Record citationsMark whether the answer had any citations and whether your domain was cited, and paste the cited URL.
  4. Save evidenceKeep a screenshot or the answer text. AI answers aren't reproducible later.

The worked example in the Workspace tab. Clear the lime input cells, paste your CSV at A13 (values only) and every result recalculates.

Fill the AI citation tracker with DataForSEO

Every template in this library is built to run on DataForSEO data. This one uses DataForSEO AI Optimization: LLM Mentions: AI answers (ChatGPT or Google AI Overviews) that mention a domain or keyword, with their cited sources.

DataForSEO supplies the URL or query list and the audit trail; you add the measurements listed below.

  1. Request the dataSend this request with your DataForSEO API login (HTTP Basic auth).
    POST https://api.dataforseo.com/v3/ai_optimization/llm_mentions/search_mentions/live [ { "target": [ { "domain": "yourdomain.com" } ], "platform": "chat_gpt", "location_code": 2840, "language_code": "en", "limit": 100 } ]
  2. Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
  3. Convert it with the included scriptIt runs offline, makes no API calls and never sees your credentials.
    python3 Automation/dataforseo_import.py import --template 26 --input response.json --output my-inputs.csv
  4. Add what the API can't knowObservation date, Usable answer, Answer includes citations, Target domain cited, Target citation URL, Evidence
  5. Paste at A13Clear the demo rows, paste the CSV values at Workspace cell A13 and the dashboard updates.
Fills automatically from DataForSEO You add
Observation ID, Prompt or query, Platform / model Observation date, Usable answer, Answer includes citations, Target domain cited, Target citation URL, Evidence

Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable. Before a big pull, estimate the cost with the DataForSEO pricing calculator. The same steps, plus an example request file, are in the download's Automation folder.

Worked example: Northbeam Outdoor

Every template ships filled with data from Northbeam Outdoor, a fictional outdoor-gear retailer that appears across all 40 workbooks, so you can see what useful output looks like before you add your own. This workbook has 20 example rows.

20Records
0Rows with input issues
26.3%Overall target citation rate
17Answers with any citations

Across 20 example observations Northbeam is cited in about a quarter of valid answers. ChatGPT and Perplexity cite it most; Google AI Overviews didn't cite it once. That gap tells you where to focus.

Input fields

Keep the columns in this order when you prepare a CSV. A missing observation stays blank; use 0 only for a measured zero or a verified No. Fields marked DataForSEO can be filled automatically by the included script.

CSV field Column Meaning and rule Source
observation_id Observation ID Unique prompt-platform-locale-run identifier. DataForSEO: observation_id
prompt Prompt or query Exact observed question. DataForSEO: question
platform Platform / model Observed platform and model label. DataForSEO: platform_model
observed_date Observation date Date the response was collected, using one timezone. Your records
answer_valid Usable answer 1 only if a complete answer for the planned run was collected. 1 = Yes, 0 = No. Your records
answer_has_citations Answer includes citations 1 if the complete answer contains inspectable source links. 1 = Yes, 0 = No. Your records
target_cited Target domain cited 1 only when an exact target domain or approved subdomain appears in the source links. 1 = Yes, 0 = No. Your records
citation_url Target citation URL The actual source URL, or NONE after checking a valid answer. Optional. Your records
evidence Evidence Link to a dated crawl, screenshot, ticket or source that another reviewer can inspect. Your records
source_ref Source reference Task ID, export filename and observation scope. Retain the untouched source response separately. Optional. DataForSEO: source_ref

Reading the result honestly

Report overall and conditional rates with their denominators. Separate platform, locale, prompt intent and collection date.

Limits. LLM Mentions results are a discovered corpus, not your complete test panel. Missing or failed runs are not negative citations.

AI citation tracker mistakes to avoid

Counting mentions as citationsA brand mention without a link is useful but different. Track it separately if you need it.
Dropping failed answers silentlyMark them invalid so the denominator stays honest.
Comparing cycles with different panelsChange the panel and you change the baseline. Keep it stable.

Tips from practice

  • Track the URL that gets cited; it tells you which content AI trusts.
  • Pair with the AI referral tracker to see whether citations send visits.
  • Use the share of voice calculator to compare with competitors in the same corpus.

Frequently asked questions

How do I track if ChatGPT cites my website?

Run a fixed set of prompts on a schedule, log each answer, and record whether your site is cited and which URL. This template calculates the citation rate.

What's the difference between a mention and a citation?

A citation links to or names your page as a source. A mention names your brand without sourcing it.

Which AI platforms should I track?

Usually ChatGPT, Perplexity, Google AI Overviews and Gemini, plus AI Mode, Copilot or Claude if your audience uses them.

Can I track AI citations for free?

Yes, manually with a spreadsheet like this one. Tools automate it at scale, but the measurement logic is the same.

Part of the AI Visibility & GEO Toolkit

Get all 6 AI Visibility & GEO templates in one ZIP, or the complete set of 40 SEO and GEO templates with the 401-page field handbook.

Download the AI Visibility & GEO Toolkit

See the complete SEO & GEO toolkit

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.

More on digital marketing in our blog

See all posts