1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Free tip for backlinking

Discussion in 'Black Hat SEO' started by christianbed, Oct 2, 2013.

  1. christianbed

    christianbed Jr. VIP Jr. VIP Premium Member

    Joined:
    Aug 17, 2011
    Messages:
    1,346
    Likes Received:
    882
    Location:
    alert("Make Money")
    Home Page:
    Ok, so after a lot of thought and a few dead-ends, I finally figured out a way to build targeted links to sites that have a huge number of products/pages. I'll just lay out the basics for anyone who is interested (perhaps someone has a better method, so I may have just reinvented the wheel here!)

    1. Download Screaming Frog (google it, it is free, and you should already be using it anyway!)
    2. Run your site through it
    3. It will pull all the permalinks and put them in one column, and will do the same for title, meta descriptions h1's, etc
      • [​IMG]
    4. Copy/paste this whole thing into Excel (you can export it instead of copy/paste if you like)
    5. Delete whatever columns you don't want to use. I just kept url and title (meta descriptions could work instead of title for some sites).
    6. You may have to add a new column to do this next step, because you want to put the title in column A (these are going to act as your anchor text), and put the corresponding urls in column B
    7. Now, in cell C1, type this formula and hit enter =A1&" "&B1&""
    8. It should now combine both cell A1 and cell B1 in cell C1
      • [​IMG]
    9. Now you can do the next step a couple ways...basically, we want to copy that formula down for all url/anchor combinations so that it formats all your urls. The easiest way is to hold SHIFT down and click C1, then (still holding SHIFT) scroll down to the last entry in column C and click in that cell. Now the whole column should be highlighted. Next, while still highlighted, go up to your toolbar and find the 'fill' dropdown button and click 'DOWN'...Bingo! Now all of your anchors and urls are together in column C.
      • [​IMG]
      • Alternative method for copying down: If you like doing things the hard way, you can copy down by clicking on the little dot at the lower right hand side of the cell and drag it all the way down column C then release at the last cell.
    10. Still with me? Good. Now, the only problem is that, as you can see in the second image above, there is no space between the anchor and the url in column C...we need to fix this...so...
    11. copy/paste column C into notepad (to get rid of the table formatting without losing data), then copy/paste from notepad into Word.
    12. From here, you are a little bit on your own...and a little formatting knowledge goes a long way. What worked for me is to use the 'no spacing' button, which tightened up the page, then I bulletpointed the whole page to ensure that it was structured like this:
    Anchor1
    Url1

    Anchor2
    Url2

    Ex:

    Get monkey in your PayPal
    http://yoursite.com/get-monkey-in-paypal
    13. Finally, I just copy/paste back into notepad and save for future use in link software or just for reference.

    I realize this is a bit convoluted, and if you know of an easier way to do this, please share, but this is what worked for me, and now instead of building links with the usual keywords and LSI's, I can now do hyper-specific links that reflect the true character of the item/page itself. Hope that helps!
     

    Attached Files:

    • Thanks Thanks x 6
  2. srinu0812

    srinu0812 Supreme Member

    Joined:
    Nov 1, 2012
    Messages:
    1,311
    Likes Received:
    755
    An effective way to build backlinks! Worthy share. +repped.
     
  3. souleclipse

    souleclipse Jr. VIP Jr. VIP Premium Member

    Joined:
    Apr 28, 2011
    Messages:
    1,054
    Likes Received:
    210
    Gender:
    Male
    Home Page:
  4. christianbed

    christianbed Jr. VIP Jr. VIP Premium Member

    Joined:
    Aug 17, 2011
    Messages:
    1,346
    Likes Received:
    882
    Location:
    alert("Make Money")
    Home Page:
    Scrapebox (sparingly, and with a decent list that you scrape for your own niche) & GSA are going to be my first ports of call.

    However, with this info, you can now write articles that easily allow you to do deep links!

    Wake up in the morning, pick a anchor/link combo, write something about it...share it on Twitter, Facebook, Pinterest, G+, make a YouTube video, whatever. Then rinse and repeat with a different combo every day.

    You should be able to come up with dozens of ways this info can be used. ;-)
     
    • Thanks Thanks x 1
  5. RosuC

    RosuC Regular Member

    Joined:
    Oct 9, 2012
    Messages:
    263
    Likes Received:
    112
    Location:
    Spain
    Home Page:
    Interesting share Christian. Thank you for it, but is still for the beginners and is working to produce a small amount of money as starting.
     
  6. Good OP, nice share for beginners to help lot...
     
  7. dafoss

    dafoss Registered Member

    Joined:
    Aug 20, 2013
    Messages:
    76
    Likes Received:
    5
    Occupation:
    SEO Worker
    Location:
    New York, USA
    I must say, screaming frog is one of the best softs I've ever used, it's just great
     
  8. foleymon

    foleymon Registered Member

    Joined:
    Jan 3, 2013
    Messages:
    61
    Likes Received:
    91
    Location:
    Vero Beach, FL, USA
    Home Page:
    Try using the following formula in your C Column

    =CONCATENATE(A1&"insert a couple of spaces here"&B1)

    This should combine the A Column and B Column in the C Column and you can insert spaces where the red text is.
    That should save you some copy paste work.

    Would need to increment the A1 and B1 down the column same way as you explained above.
     
    • Thanks Thanks x 1
    Last edited: Oct 2, 2013
  9. Portal88

    Portal88 Newbie

    Joined:
    Aug 2, 2013
    Messages:
    34
    Likes Received:
    1
    Location:
    http://www.asphostportal.com
    Home Page:
    Wow.... Great tips... Thank you for sharing this information.
     
  10. djp3k05

    djp3k05 Jr. VIP Jr. VIP

    Joined:
    Oct 30, 2010
    Messages:
    726
    Likes Received:
    218
    interesting idea...