Link Gap Analysis

What Is Needed To Complete This Procedure

• Access to Ahrefs
• The Link Gap Analysis template spreadsheet: http://bit.ly/link-gap-analysis-template
• The Report template doc: http://bit.ly/link-gap-report  

Example Of Completed Report

You can see an example of a completed report here: http://bit.ly/2YSUT93 

You can see an example of the completed workbook here: http://bit.ly/38Pxiuz 

Standard Operating Procedure – Video

Please find the video below:

https://www.loom.com/share/5bd854ab8cd54c02861b3a881a644923

Standard Operating Procedure – Screenshots

1. Make a copy of the Link Gap Analysis template: FOUND HERE
   1. Change the title of the workbook and save in the appropriate location
2. Complete the information in the ‘Cover’. Remembering to only complete the blue cells.
   1. Make a list of the top 3 competitors URLs.
      1. Do not include any directors in this list as they are ranking by means other than through backlinks. Examples of directories are: airtasker, serviceseeking, hipages, oneflare, yellow pages, threetoprated.
3. Going to the ‘DR Comparison’ and ‘Data-Overview’ tab complete the following for the target URL and each competitor
   1. Run a report in Site Explorer:

4. Type the Domain Rating (DR) from the report in the respective cell of the ‘DR Comparison’ tab in the sheet

1. Scroll down to the URL rating distribution section:
2. Copy and paste this data into the respective location that is indicated in Data-Overview tab.

5. Now for each target and competitor URL go to ‘Data-Detail’ section and complete the following:
   1. Got to the Backlinks section in Ahrefs
   2. Select ‘One Link Per Domain’ as the filter

3. Export to excel

3. In the spreadsheet that is downloaded: Copy and paste from A2 to the end of the data
4. Drop the formula in columns X through to AC down to the end of the data

6. Make a copy of the ‘The Report template doc’ linked to at the beginning of this document
7. Save in an appropriate location, Label the document and change the title in the document
8. Copy and paste in screenshots of the 6 reports from the Google Sheet. See the example at the start of the document for the reports which should be screenshot.
9. Check the sharing settings on the workbook and google document. Create bit.ly links in order to send to other people.

END OF PROCEDURE