AI-Visibility-Audit-Tracker.xlsx

	B	C	D
1
2	AI VISIBILITY AUDIT TRACKER
3	Pitching for AI Visibility · Jeneration Academy
4
5	Client		Type the client name here (yellow cells are yours to fill in).
6	Audit date
7
8	THIS AUDIT AT A GLANCE
9	Client citations (client site plus coverage about the client)	0	Count every citation that points to your client or to coverage about your client, across all 25 rows.
10	Total citations (client plus competitors in the same answers)	0	Count every citation for your client plus the competitors who showed up in those same answers.
11	SHARE OF SOURCE	0.0%	Client citations divided by total citations. Example: 6 of 30 citations = 20 percent. Track the same calculation every month.
12	Answers where the client was mentioned (of 25)	0	A mention is the brand name showing up in an answer.
13	Answers where the client's own site was cited (of 25)	0	Good, but this is the web team's win.
14	Answers where coverage about the client was cited (of 25)	0	This is the PR win.
15
16	HOW TO USE IT
17	1. Make a copy of this file for each client (File > Make a copy in Google Sheets).
18	2. Write your five customer-style questions on the Audit Tracker tab, then run each one on all five engines, logged out or in a temporary chat with memory off.
19	3. Run each question two or three times and log the pattern. Screenshot every answer and date it.
20	4. Fill the yellow cells: sources, competitors, Y or N, and the two citation counts for each row.
21	5. Share of source on this page calculates itself. Copy it into Monthly History once a month.
22	6. Rerun the same five questions on the same five engines on the same day every month.
23
24	EXAMPLE ROW (for format only, do not copy into your data)
25	Q1 / ChatGPT / sources: trade-pub.com, brand.com / competitors: Brand X, Brand Y / mentioned: Y / own site cited: Y / coverage cited: N / client citations: 1 / total citations: 5
26
27	Assumption: share of source uses the definition in the course: client citations divided by total citations for the client plus the competitors who appeared in those same answers.
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100