ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
2
3
General organic performanceAppearances in AI/LLMs this month
4
DADRMonthly organic trafficKWs #1-3Referring domainsAI share of voiceAIOsChatGPTPerplexityGeminiCoPilot
5
Client/brand
6
Competitor 1
7
Competitor 2
8
Competitor 3
9
Competitor 4
10
Competitor 5
11
12
13
StepInstructions
14
1List your client/brand's name and the names of five chosen competitors in the table above (this populates other tables in the workbook).

If you're unsure on competitors, use an SEO performance tool to find competing domains with a high percentage of common keywords, and check the website to ensure the offering is similar
15
2Pull the Domain Authority or other relevant domain strength metric you're analysing and add to the table above.

This helps give a rough overview of the link and referring domain profile strength
16
3Complete the sheet titled 'Organic Traffic' - this will populate the above with the latest estimimated monthly figure.

This table above will show a snapshot and won't account for any seasonality that might come into play in your sector/niche. You must also look at the graph in the organic traffic tab
17
4Complete the sheet titled 'KWs #1-3' - this will populate the above with the latest estimimated monthly figure
18
5Complete the sheet titled 'RDs over time' - this will populate the above with the latest estimimated monthly figure
19
6Use your preferred AI monitoring tool to look into the number of appearances across each of the popular AI/LLM tools for each brand, and/or AI share of voice. List the figures above.
20
7Using all of the data, and the charts in the completed sheets as part of steps 3-5, you should be able to identify your strongest competitors, and those making moves/challenger brands.

These are the ones you want to dig into further to identify how they're influencing that performance.
21
8Complete the sheet title "link intersect" - this will help you see the domains already linking to competitors and therefore key targets for activity
22
9To further dig into the link intersect targets, and other brand mentions acquired by competitors - complete sheet titled "coverage & links"
23
10Complete the sheet titled "AI visibility gaps" to analyse why your brand is missing out on relevant opps
24
25
26
27
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