SMX London - Tools for Pulling Rank. Using Twitter and Backlinks to Build Links. In SEO, we look at many pools of data to find how we can get our client to rank better and increase revenue from search.
But we usually look at them individually — exploring competitor backlinks, Twitter users, ect. What if we mashed those pools of data together to find linking opportunities? That was a question Wil posed to me several months ago and asked that I develop a tool in Excel. The fundamental goal of the tool is to mash Twitter and backlink data together to find out who is following your client but does not link to them. This can be very powerful because it leverages existing relationships to get links that scale. Lets begin with how to find people that follow your client but do not link back to them.
Pull the Twitter Data Export your clients Twitter followers using Export.ly. Creating a New Excel Spreadsheet We are going to do this with Wil’s Twitter data as example. Pulling OSE Backlinks Export your clients external backlinks from Open Site Explorer or Majestic SEO. Drag. Discover Links Using Google Analytics New Backlink URL Report. Today the Google Analytics team announced that we will start seeing backlink URLs in their newly released Social Reports.
According to the announcement post, written by Ilya Grigorik, Software Engineering Manager, Google Analytics (and PostRank Founder): “These reports provide another layer of social insight showing which of your content attracts links, and enables you to keep track of conversations across other sites that link to your content. Most website and blog owners had no easy mechanism to do this in the past, but we see it as another important feature for holistic social media reports. When you know what your most linked content is, it is then also much easier to replicate the success and ensure that you are building relationships with those users who actively link to you the most.” Where To Find The Backlink URLs Report The Backlink information is not easy to find. As indicated in the screenshot above, click on the Activity Stream tab above the graphs.
ImportXML Cookbook. ImportXML Cookbook (May 9, 2012) Added more here: More ImportXML Cookbooks Here’s a collection of ImportXML functions that I’ve collected over the past few months.
Some of them I grabbed from other folks, others I’ve made myself. This post won’t introduce you to ImportXML. If you don’t know what ImportXML is go read this EPIC post by the guys at Distilled: “The ImportXML Guide for Google Docs”. Google Search Update 2/15/12: Google Scraper in Google Docs Update - Update to getting SERPs in Google Docs. Replace {KEYWORD} with the search term you’re looking for. =ImportXML(" seo company&num=100", "//h3[@class='r']/a/@href") Getting The Top 100 Search Result Links =ImportXML(" "//h3[@class='r']/a/@href") Getting the Top 100 Search Result Titles =ImportXML(" "//h3") Google Products Replace {KEYWORD} with the keyword your looking for.