How to create a list of links for Interlinking

1. 53

   janderson99posted 12 years ago

   This describes how to develop a list of links for all your hubs in excel that you can filter to create a list to be added to a text capsule (Related Articles). See image below
   
   Open my account ( statistics)
   Start swiping in the top left corner - go right across the page and right down to the bottom
   Press copy
   Paste it into a new excel worksheet
   Delete all the columns apart from the one with the links
   Save.
   Now apply auto filter to the worksheet - depends on the version you are using (google it or use help)
   This adds a down arrow to the column
   To filter click on the button for the column containing the links
   Select 'custom'
   Select 'contains'
   Enter your key word - say 'shark'
   This will display all the links with 'shark' in the title.
   To copy the list put the cursor somewhere away from the links and swipe - the links are hot and if you click on them it will open up the page (good for editing)
   
   You now have a spreadsheet with all your links in order (don't sort the list) they were published. To display all of them again filter with the word '  ' ie a space.
   
   You only have to do this once. As you publish new ones simply copy just the link on the stats page and paste it at the bottom of the excel list.
   
   After filtering using excel and copying - Paste the selection of links copied from excel into a new word document
   It will appear as a table.
   You now need to convert the table to text with paragraph marks. This depends on the version of word you are using ( search under help or google it).
   You now have a list of links in a word document - edit out the ones you don't want or reduce their number.
   
   Create a new text capsule in HP with the heading "Related Articles about Snakes"  or similar.
   Paste the links into the capsule. Swipe to highlight all of them - click 'Bold' and Save
   
   That's it.
   
   What I normally do is to click the right arrow button (float right) and then edit again to add a grey or color background. The list then appears down the right side of the page.
   
   Done.
   
   When I create a new hub and produce a list I also add a series of links on the old pages to the new one. Copy the link from the statistics page (my account) paste it into excel. and leave it copied. To add links from old pages to the new page - click on one of the related links - open up the page to edit, then open up the capsule with the list of links in it and paste in the new one. Make it bold and save - you my have to fiddle with the layout - saving it twice seems to fix it. Repeat for 5-10 old pages that are relevant.
   
   Done you have interlinking completed.
   
   PS - The best links are within the text as shown below. This option is for hubbers with large numbers of hubs
   EXAMPLE
   
   

   replyreport
2. 74

   IzzyMposted 12 years ago

   This is great J, thanks!
   
   I would also be interested to know how you made that screen shot snippet appear so big. Whenever I try to do that it turns out tiny when I post it

   replyreport
   1. 53

      janderson99posted 12 years agoin reply to this

      What you need to do is to generate the image, edit it, save it. Then you need to upload it to a website. Then you use the image html described under formating
      [img]http://URLyoursite.com/yourimage.jpg[/img xxxxx]

      replyreport
3. 77

   DzyMsLizzyposted 12 years ago

   Very interesting, and useful, but wouldn't it be easier to find things by simply alpha-sorting the list by title within Excel, instead of having to go through all the "filter/find" steps?    It would be for me....

   replyreport
   1. 53

      janderson99posted 12 years agoin reply to this

      If you mean alphabetical sorting then this will not produce what you want.
      
      recipe for cheese salad
      how to make pasta - simple recipes
      A good way to find gold
      A recipe for homemade soap
      Best vacation ideas
      Making Hay while the sunshines
      
      What you want for related links for recipes is to filter for all titles that contain the keyword 'recipe'
      i.e.
      recipe for cheese salad
      how to make pasta - simple recipes
      A recipe for homemade soap
      
      PS I deliberately don't sort the list because I want to retain them in order published.  I actually hate excel - I'm sure there are many whiz-bang other ways of doing it.

      replyreport
      1. 77

         DzyMsLizzyposted 12 years agoin reply to this

         Hmmm... well, in spite of the number of Hubs I've published, I pretty much retain a good idea of what I wrote and what the title is....so I think, for me, alphabetical sort would work...my eye is quick enough to scan and find what I'm looking for.
         Alternately, perhaps you could sort from the Groups list...then, you'd already have your categories, and easily find things.  From there, it's easy enough to re-sort your list by title on your Hubs listing page, and pick up the links you want, then put it back to the default sort.
         For me, I would not particularly care when I published the article for this particular purpose, so that value would not be useful to me.
         At any rate, you explained all the steps very well, and I appreciate your sharing your tips--it got me thinking--and that's always a good thing.
         Cheers!

         replyreport
4. 73

   Johnny Parkerposted 12 years ago

   This looks a great idea but would it adversly affect Google rankings (not that I've got any to worry about!). I'm no SEO expert but I thought I read somewhere that the more recent Google changes took a dim view of pages with a lot of links.
   
   Also, I may be completely wrong (again) but isn't there some kind of HP restriction of two links per page?

   replyreport