Basic Competitor Link Assessment

	A	B	C	D	E	F	G
1	Nifty Marketing Basic Competitor Link Assessment
2	Step 1: Examine Competitors Identify high ranking competitors and look into what they are doing to rank so well. The metrics provided in this section serve as a baseline and more in-depth assessment is recommended. Use the notes section to comment on: rich media, basic optimization, keyword usage, content length, quality of content - readability, thoroughness, keyword density - structured data, page load time and anything else that stands out that the competitor is doing well.
3	Search Query
4	Competitor	Organic Ranking Position	URL	Domain Authority	# Linking Root Domains	# Backlinks	Notes
5
6
7
8
9
10
11	Search Query
12	Competitor	Organic Ranking Position	URL	Domain Authority	# Linking Root Domains	# Backlinks	Notes
13
14
15
16
17
18
19	Search Query
20	Competitor	Organic Ranking Position	URL	Domain Authority	# Linking Root Domains	# Backlinks	Notes
21
22
23
24
25
26	Step 2: Examine Links Using a link explorer of your choice like Ahrefs, CognitiveSEO or Open Site Explorer (SEOprofiler is free), export competitor linking domains for each competitor URL and copy/paste them into the slots provided below. If there are duplicates, you can remove them using the "Remove Duplicates" Spreadsheet Add-on. Do this for each column. Next, copy links from each slot and paste into the Total Links column. Finally, we want to find shared competitor links. To do this, select all links within the Total Links column and use the "Remove Duplicates" Add-on to move duplicate values to a custom location (top cell in Shared Links column). Now you're left with 1) A massive list of unique links across 5 high ranking competitors in "Total Links" and 2) A number of prospects that are shared between 2 or more high ranking competitors.
27	Competitor 1 Links	Competitor 2 Links	Competitor 3 Links	Competitor 4 Links	Competitor 5 Links	Total Links	Shared Links
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