ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Guidelines on how to use the sheet
2
Step 1Upload your keyword list on Ahrefs/ Semrush
3
Step 2Get Search volume and export the list
4
Step 3Fill the 'search volume' column in this sheet
5
Step 4Write down the ranking difficulty of each keyword. Manually check the SERP and see the top pages and ask the following questions:
- How authoritative (quality and quantity of referring domains) are these pages?
- Does these pages satisfy the search intent?
- Are these websites have topical authority on the topic?
- Is there any content quality/depth gap in the top results?
- Can I provide unique value and make the content 10x better than what's already there?

Then number each keywords based on the following pattern:

3 = High Ranking Diff, 2 = Medium Ranking Diff, 1 = Low Ranking Diff
6
Step 5Add Business value for each keyword. Keywords that are highly related to the business offerings should be labelled as 3 (High business value).

Number each keywords based on the following pattern:

3 = High Business value, 2 = Medium Business value, 1 = Low Business value
7
Step 6Add traffic potential for each keyword. High traffic potential (3) doesn't always mean very high traffic (say 1,0000 searches/ month). It means thattraffic potential is high considering your niche and target audience.
For a B2B business High traffic potential may also stand for 300 searches/month (for instance). Add business context and label each cell.

Number each keywords based on the following pattern:

3 = High Traffic potential, 2 = Medium Traffic potential, 1 = Low Traffic potential
8
Step 7Now, You'll get the priority score on the last column. This way, you'll have a clear understanding of what keywords to target first and where do I have most opportunity.
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