AI Citation Tracker
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.
=IF(K13="","",IF(K13<>"Ready","n.a.",IF(AND(E13=1,G13=1),1,0)))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.
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
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.
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
- Run the prompt panelUse the prompts from your prompt research template. Run each on each platform, logged out where possible.
- Log every answerOne row per answer with platform and date. Mark answer valid = 0 for errors or refusals.
- Record citationsMark whether the answer had any citations and whether your domain was cited, and paste the cited URL.
- 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.
- 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 } ]
- Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
- 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
- Add what the API can't knowObservation date, Usable answer, Answer includes citations, Target domain cited, Target citation URL, Evidence
- 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.
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
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.
Use it with these templates
Each template answers one decision. These are the ones that feed into, or follow from, the AI citation tracker.
25AI Prompt Research TemplateLabs: Keyword Overview
Turn real customer tasks and keywords into a weighted prompt panel for ChatGPT, Perplexity, Gemini and AI Overviews.
27AI Share of Voice CalculatorAI Optimization: LLM Mentions
Compare citation rate and share across competitor domains inside one fixed set of AI answers.
30AI Referral Traffic TrackerAI Optimization: LLM Mentions
Measure sessions, conversion rate and contribution per session from ChatGPT, Perplexity, Gemini, Copilot and Claude.
28Answer Evidence Audit TemplateOn-Page API
Check every claim for a supporting source, original value, clarity and freshness, so AI answers can quote and cite it.
29Brand Entity Consistency AuditAI Optimization: LLM Mentions
Compare your official brand facts with Wikidata, LinkedIn, GBP, Yelp and more, and log every correction request.
19SEO Content Brief TemplateLabs: Keyword Overview
A content brief built for Google and AI answers: real questions, original evidence, sources and a three-step approval workflow.
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.
Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.






