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

Measure sessions, conversion rate and contribution per session from ChatGPT, Perplexity, Gemini, Copilot and Claude.

What it decides
  Which AI referral sources and landing pages send visits that convert, and how much contribution each AI session is worth.

Files
  AI Referral Traffic Tracker.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  AI Referral Traffic 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: Landing page
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Isolate AI referrals in GA4: Create a custom channel group or exploration filter for AI sources by session source.
  2. Export by landing page and source: Pull sessions, key events (conversions) and revenue or contribution for a fixed window.
  3. Add citations and attribution model: Note how many citations you observed for that page and which attribution model the numbers use.
  4. Compare sources: Read contribution per session on the Dashboard. Invest content effort where AI visits convert.

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-referral-traffic-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
