Formulas for ai-prompt-tracker.csv. Import the CSV into Google Sheets or Excel on a sheet named "runs"; column letters match the CSV header (A to Z).
Checked October 7, 2026: a Python recomputation on the two EXAMPLE rows gave mention rate 0.5, citation rate 0.5 and citation share 1/14.
Delete the two EXAMPLE rows and replace every placeholder (the engine name) before you trust a number. The CSV has no comment lines so it stays importable.

Mention rate               =COUNTIF(runs!N2:N1000,"yes")/COUNTA(runs!C2:C1000)
Citation rate              =COUNTIF(runs!P2:P1000,"yes")/COUNTA(runs!C2:C1000)
Citation share             =SUM(runs!R2:R1000)/SUM(runs!S2:S1000)
Mention rate, one engine   =COUNTIFS(runs!G2:G1000,"ChatGPT",runs!N2:N1000,"yes")/COUNTIF(runs!G2:G1000,"ChatGPT")
Citation rate, one engine  =COUNTIFS(runs!G2:G1000,"ChatGPT",runs!P2:P1000,"yes")/COUNTIF(runs!G2:G1000,"ChatGPT")
