Keeping track of all of your keywords and inbound links can be a time consuming business – but having a well set up Excel spreadsheet can make the process much easier.
So we’ve created this FREE SEO EXCEL SPREADSHEET TO DOWNLOAD
This SEO Excel spreadsheet has a number of worksheets with templates for a variety of SEO lists, so all you need to do is enter the data as you go along.
This will not only help you be more organised with your link building activity – but will make it easier to chunk your work in to themed areas of activity and come back to it over time – SEO work can be rather repetitive and boring if you don’t break it all up!
The SEO Spreadsheet contains the following worksheets (which you can access via the tabs at the bottom)
For logging the keywords you identify for anchor text links in keyword research activity
For logging suitable Link partners (in relevant industries) to exchange links with
Log which online directories you have registered your site with here
Blog and Forums –
You need to be commenting on blogs and forums and linking back to relevant content on your site to make the most of Social Media as an opportunity for Link Building. Log all of this activity on this worksheet
PR Sites –
List good places to submit press releases with links here.
Link Request –
Keep track of who you have requested links from, and whether they have accepted or not.
Paid Listings –
Track all of your paid links and how much you’ve spent on them – Excel is great for this as it can keep a running total of expenditure.
Link Tracker –
Track how heavily you are link building to certain areas of your site, to make sure you don’t over on under do it.
Link Request Template –
Remember that requesting links means contacting real people! Use this request template as a starting point.