Leaving Keyword Strategy – Replacing Your Internal Linking

Update May 2012: Competition data is back, I am happy again and re-joined KST, you can read the full story here: Why I re-joined Keyword Strategy. I’ll leave this post up for those of you that want to know how to replace your internal linking, for whatever reason, with another tool.

If you haven’t read yesterday’s post >Leaving Keyword Strategy – How to Back Up Your Data< I suggest you do so first as some things are so similar that I haven’t explained them here 😉

First the list of things you will need:

Some sort of text and spreadsheet editor, if you don’t have Microft Office, here two free alternatives that work just as well:

Plus you will need a plugin to take on your internal linking, my recommendation so far is:

Ok, now you are all set and ready to roll!

  1. Go to your keywords tab in the dashboard and select it to show only keywords and urls.
  2. Put in ‘not null’ in the url-filter, this will give you only those keywords that have an associated url.
  3. Download this list as csv to your back up folder, better even to a new sub-folder called ‘internal links’ or similar and rename the file to something you will remember / recognize.
  4. Open file in spreadsheet editor and copy the two columns, keyword and url.
  5. Open new text document and copy in as ‘RTF’.
  6. This gives you now a table.
  7. Convert table to text by using ‘,’ as separator.
  8. Run find&replace all for ‘,’ and replace with ‘, ‘
  9. Copy and paste this list into ‘custom keywords’ field in SEO Smart Links.
  10. Deactivate and delete the Keyword Strategy plugin ;-(

Extra Tips

Take a moment and go through your list of Keyword-Url pairings and check if all like you want it or if something needs updating / cleaning up before you copy and paste the list into SEO Smart Links.

SEO Smart Links turn up immediately, so if no internal links appear, check your settings 😉

A good guide for using this plugin (and recommended settings) can be found here: Unofficial Guide to SEO Smart Links.

Ok, between yesterday’s and today’s blog post I should have covered all regarding moving your site away from Keyword Strategy, anything else you want to know? Any questions and / or suggestions? Just leave them in a comment …

If you like this blog post and found it helpful, why not share it with your preferred social network? Handy links and bookmarklets above ^^^ 😉

10 comments to Leaving Keyword Strategy – Replacing Your Internal Linking

  • Bizz

    The trouble with SEO Smartlinks (and most interlinking plugins I would imagine) is that the site slows down considerably as the site grows and more keywords are added.

    I even tried several caching plugins to offset the issue, but right around 300+ posts my site slowed down to over 11 second page loads in some cases!

    So much so in fact, that this is why I switched to KST in the first place, as it really is the best at doing this. Too bad it’s now overpriced as a stand-alone linking tool…

    • hospitalera

      Strange, I used it on a 600+ indexed pages site and didn’t run into that issue. Perhaps you asked it to do too many links per page? I will see how things go now that I switch back my sites to SEO Smart Links and will update this blog with what I find …

  • […] Leaving Keyword Strategy – Replacing Your Internal Linking […]

  • Bizz

    Yeah, I think I was taxing it too much on my first site, way back before I had any idea what internal linking strategies to use.

    I’m in the process of moving my keywords over now. On most of my blogs, I already had the plugin installed, but just sitting there in case I ever needed it again. Who knew…?

  • Vi

    Or you can just use google docs instead of any Office

    • hospitalera

      True, also I am weary how much of the Google docs Google actually ‘reads’, as OpenOffice / NeoOffice is free I prefer that method.

  • Very nice post. I am in the process of doing this on my blogs today. I did find it easier to move the keywords this way:

    Follow your instructions to get the “not null” keywords into an excel file.
    Insert a new column in between the Keyword and URL column,and put in a comma, then hit the space key. Also insert a new column after the URL column, so now you have this:

    A1 Keyword
    B1 ,
    C1 URL
    D1 (blank column)

    Paste the following into D1: =CONCATENATE(A1, B1, C1)

    The result will be: Keyword, Url showing up in cell D1.
    Now drag the formula in D1 down the list and you’ll have all of your keywords and URLs perfectly formatted in the D column to paste into SEO Smart Links