ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
StepAction ItemTarget Tab / ToolKey Focus & Goals
2
1. Import RankingsExport current rankings from SEO tools (Ahrefs, Semrush, GSC) and paste them into the sheet.Rankings TabProvides the data foundation for the cannibalization check. Do not edit formulas here.
3
2. Select PagesList the existing or planned URLs you intend to optimize (Home, Category, Blog, etc.).Keyword Mapping TabEstablishes a clear view of your site structure before assigning keywords.
4
3. Keyword ResearchBuild a list of non-branded keywords, focusing on search intent, difficulty, and relevance.Keyword Analysis TabGathers data on search volume and difficulty to inform your strategy.
5
4. Map KeywordsAssign one primary keyword per page, then group secondary and supporting keywords.Keyword Mapping TabEnsures each page has one clear focus and prevents intent overlap.
6
5. Cannibalization CheckUse the built-in VLOOKUP tool to see if multiple pages are already ranking for the same term.Template LogicIdentifies and fixes overlapping targets so pages don't compete against themselves.
7
6. Optimize & ExecuteUpdate title tags, meta descriptions, headings, and internal links based on the map.On-Page SEOTurns the research into live changes; this map becomes your "Source of Truth."
8
7. Revisit & RefineRegularly update the sheet as you add new content or as search behavior shifts.Ongoing MaintenanceKeeps your SEO strategy dynamic and responsive to ranking changes.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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