GEO Analytics: How to Track Your Citations in ChatGPT and Perplexity

#!/bin/bash
# geo-check.sh - Quick citation check via Perplexity API
# Usage: PERPLEXITY_API_KEY=your_key GEO_DOMAIN=your-domain.com bash geo-check.sh

DOMAIN="${GEO_DOMAIN:-your-domain.com}"
API_KEY="${PERPLEXITY_API_KEY}"
CITED=0
TOTAL=0

# Target queries - adapt to your article topics
QUERIES=(
  "GEO site optimization 2026"
  "Eleventy JSON-LD schema automation"
  "SSH deployment with git hooks without FTP"
  "content engineering for ChatGPT citations"
)

echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo "GEO Citation Check - $(date '+%Y-%m-%d')"
echo "Domain: $DOMAIN"
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"

for query in "${QUERIES[@]}"; do
  TOTAL=$((TOTAL + 1))

  response=$(curl -s -X POST "https://api.perplexity.ai/chat/completions" \
    -H "Authorization: Bearer $API_KEY" \
    -H "Content-Type: application/json" \
    -d "{
      \"model\": \"llama-3.1-sonar-small-128k-online\",
      \"messages\": [{\"role\": \"user\", \"content\": \"$query\"}],
      \"return_citations\": true
    }")

  if echo "$response" | grep -qi "$DOMAIN"; then
    echo "  ✓ [$TOTAL] $query"
    CITED=$((CITED + 1))
  else
    echo "  ✗ [$TOTAL] $query"
  fi

  sleep 2  # Stay within free tier rate limits
done

echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo "Citation Rate: $CITED/$TOTAL ($(( CITED * 100 / TOTAL ))%)"
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"

#!/usr/bin/env python3
"""
geo_monitor.py - Automated GEO citation monitoring.
Appends results to a CSV file for dashboard import.

Requirements: pip install requests
Usage: PERPLEXITY_API_KEY=your_key python3 geo_monitor.py
"""

import os
import csv
import time
import datetime
import requests

# ── Configuration ─────────────────────────────────────────
DOMAIN = os.environ.get("GEO_DOMAIN", "your-domain.com")
API_KEY = os.environ.get("PERPLEXITY_API_KEY")
OUTPUT_FILE = "geo_citations.csv"
RATE_LIMIT_DELAY = 2  # seconds between API calls

QUERIES = [
    "GEO site optimization 2026 strategies",
    "Eleventy automated JSON-LD schema generation",
    "content engineering for ChatGPT Perplexity citations",
    "SSH deploy with git hooks without FTP",
]
# ──────────────────────────────────────────────────────────


def check_citation(query: str) -> dict:
    """Queries Perplexity and returns citation position data."""
    try:
        resp = requests.post(
            "https://api.perplexity.ai/chat/completions",
            headers={
                "Authorization": f"Bearer {API_KEY}",
                "Content-Type": "application/json",
            },
            json={
                "model": "llama-3.1-sonar-small-128k-online",
                "messages": [{"role": "user", "content": query}],
                "return_citations": True,
            },
            timeout=30,
        )
        data = resp.json()
        citations = data.get("citations", [])

        position = next(
            (i + 1 for i, url in enumerate(citations) if DOMAIN in url), 0
        )

        return {
            "cited": position > 0,
            "position": position,
            "total_sources": len(citations),
        }
    except Exception as e:
        return {"cited": False, "position": 0, "total_sources": 0, "error": str(e)}


def run():
    today = datetime.date.today().isoformat()
    rows = []

    print(f"GEO Monitor | {today} | Domain: {DOMAIN}\n")

    for query in QUERIES:
        result = check_citation(query)
        status = "✓" if result["cited"] else "✗"
        pos = f" [#{result['position']}]" if result["cited"] else ""
        print(f"  {status}{pos} {query}")

        rows.append({
            "date": today,
            "query": query,
            "cited": result["cited"],
            "position": result["position"],
            "total_sources": result["total_sources"],
        })
        time.sleep(RATE_LIMIT_DELAY)

    file_exists = os.path.exists(OUTPUT_FILE)
    with open(OUTPUT_FILE, "a", newline="", encoding="utf-8") as f:
        writer = csv.DictWriter(
            f, fieldnames=["date", "query", "cited", "position", "total_sources"]
        )
        if not file_exists:
            writer.writeheader()
        writer.writerows(rows)

    cited = sum(1 for r in rows if r["cited"])
    rate = round(cited / len(rows) * 100)
    print(f"\nCitation Rate: {cited}/{len(rows)} ({rate}%)")
    print(f"Saved → {OUTPUT_FILE}")


if __name__ == "__main__":
    run()

# Run every Monday at 09:00 - add via crontab -e
0 9 * * 1 cd ~/geo-monitor && \
  PERPLEXITY_API_KEY=your_key \
  GEO_DOMAIN=your-domain.com \
  python3 geo_monitor.py >> logs/geo_$(date +\%Y\%m).log 2>&1

perplexity.ai   → Perplexity referrals
chatgpt.com     → ChatGPT Search referrals
you.com         → You.com AI
phind.com       → Phind (developer-focused)
bing.com        → Copilot (blended with regular Bing)

// Google Apps Script - GEO Citation Dashboard
// Paste via Extensions → Apps Script → Run

function setupDashboard() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();

  let dataSheet = ss.getSheetByName("Raw Data")
    || ss.insertSheet("Raw Data");

  if (dataSheet.getLastRow() === 0) {
    const headers = ["Date", "Query", "Cited", "Position", "Total Sources"];
    dataSheet.getRange(1, 1, 1, headers.length).setValues([headers]);
    dataSheet.getRange(1, 1, 1, headers.length).setFontWeight("bold");
  }

  // Green highlight for cited rows
  const range = dataSheet.getRange("C2:C1000");
  const rule = SpreadsheetApp.newConditionalFormatRule()
    .whenTextEqualTo("TRUE")
    .setBackground("#E6F4EA")
    .setFontColor("#137333")
    .setRanges([range])
    .build();
  dataSheet.setConditionalFormatRules([rule]);

  Logger.log("Dashboard ready. Import CSV via File → Import.");
}

function weeklyReport() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName("Raw Data");
  if (!sheet) return;

  const data = sheet.getDataRange().getValues().slice(1);

  const cutoff = new Date();
  cutoff.setDate(cutoff.getDate() - 7);

  const recent = data.filter(row => new Date(row[0]) >= cutoff);

  if (recent.length === 0) {
    Logger.log("No data found for the past 7 days.");
    return;
  }

  const cited = recent.filter(row => row[2] === true || row[2] === "TRUE");
  const rate = ((cited.length / recent.length) * 100).toFixed(1);

  const positions = cited.map(r => Number(r[3])).filter(p => p > 0);
  const avgPos = positions.length > 0
    ? (positions.reduce((a, b) => a + b, 0) / positions.length).toFixed(1)
    : "—";

  const summary = [
    `📊 GEO Weekly Report - ${new Date().toLocaleDateString("en-US")}`,
    `Citation Rate: ${rate}% (${cited.length}/${recent.length} queries)`,
    `Avg. Source Position: #${avgPos}`,
  ].join("\n");

  Logger.log(summary);

  // Uncomment to receive the report by email:
  // MailApp.sendEmail(Session.getActiveUser().getEmail(), "GEO Weekly Report", summary);
}

function createWeeklyTrigger() {
  ScriptApp.newTrigger("weeklyReport")
    .timeBased()
    .onWeekDay(ScriptApp.WeekDay.MONDAY)
    .atHour(10)
    .create();
  Logger.log("Trigger set: weeklyReport runs every Monday at 10:00 AM.");
}