Competitor Analysis Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGH
1
2
Getting Started
3
1) Make a copy of this sheet. (Please don't request access. It won't be given.)

2) Clear out the data in all "Backlink Import" & "Keyword Import" tabs marked in red.

3) Next you complete the "Backlink Gap Analysis" and the "Keyword Gap Analysis"
4
5
6
7
8
9
10
Backlink Gap Analysis
11
For this report to populate, head over to https://moz.com/researchtools/ose/.

1) Input your first competitor's domain, then click "Linking Domains" in the left panel.

2) Export the report as a .csv and then paste the results into the "Backlink Import Competitor 1-4" tabs marked in red.

3) Repeat the process for competitors 2-4.

4) Repeat the process for your own site and paste the .csv into the "Backlink Import - Your Site" tab.

5) Now, the "Backlink Gap Analysis" Tab marked in green should be fully populated.

6) Right click on all of the "Backlink Import" tabs marked in red and "hide" them to clean up your sheet.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Keyword Gap Analysis
26
To get this report to populate you need to head over to SEMrush's Organic Research Report here: https://www.semrush.com/info/empty/domain_organic/

1) Input your competitors domain then scroll down to "Organic Research Positions" and click "Export" all the way on the right.

2) Export the report as a .csv and then paste the results into the "Keyword Import Competitor 1-4" tabs marked in red.

3) Repest the process for competitor 2-4.

4) Repeat the process for your own site as well and paste the .csv into the "Keyword Import - Your Site" tab.

5) Now the "Keyword Gap Analysis" Tab marked in green should be fully populated.

6) Right click on all of the "Keyword Import" tabs marked in red and "hide" them to clean up your sheet.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
Loading...
Main menu