![]()
If you’re reponsible for creating backlinks to a website, such as submitting the site to directories, requesting a link or reciprocal link from a similar website etc it is good practice to make sure you keep records of all your activity. This is especially important if you’re not the only person responsible for doing this! A good method is to use a spreadsheet within Google Docs, which allows the same spreadsheet to be used simultaneously by multiple users in real time. Editing a document using Google Docs is much more efficient than most document management systems as it allows everyone to work from the same document at the same time, and even see what your colleague is typing!
The spreadsheet above has 4 columns:
- The URL of the website or directory that you are trying to get to link to your site
- The date you submitted your URL or contacted the site webmaster
- The status of the request, which we have as either ‘Pending’, ‘Approved’ or ‘Failed’
- Any useful information or notes associated with the request, that may serve as a reminder or can provide instructions to other users
There are many other columns which you can add that you may think are useful and can help you assess the quality of the links. For example, useful columns might include:
- Page Rank (PR) of the page the link to your site is on
- The number of other links on the page
- The date the link was added to the site
- Type of link (i.e. directory, direct, reciprocal etc)
The more information you include, the stronger your records will be. However, the flipside is that the more information you need to fill in, the longer the process will take! It is also possible to ’sort’ the information, so once you have compiled a large list you can sort the data by i.e. status, date submitted, page rank etc.
Similar to Microsoft Excel, you can also change the format of cells with ‘rules’, using ‘conditional formatting’. This allows you to review the status of your requests with just a quick glance using different colour schemes for each status type. For example, entering the string ‘Pending’ into the status column automatically makes the text bold and changes the background colour to a light orange.
Although this process may seem like a lot of work, ultimately it will save you time and effort and also any potential embarrassment by contacting the same webmasters repeatedly!