AI Citation Tracker (Optimization Theory, v3.0, November 2026)
=========================================================

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

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

Files
  AI Citation Tracker.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  AI Citation Tracker - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO AI Optimization: LLM Mentions
  Fills automatically: Observation ID, Prompt or query, Platform / model
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

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

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/ai-citation-tracker/
Part of the AI Visibility & GEO Toolkit: https://optimizationtheory.com/download-view/ai-visibility-toolkit-6-geo-research-and-measurement-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
