serp-scraping-for-fun-and-profit

So a little while ago I pointed out that Facebook is running a massive Grayhat Strategy to Rank for Longtail in the SERPs, essentially carrying out SERP Sniffing to an insanely large scale, with the view of potentially building a community driven Content Farm. Some really interesting questions popped to mind:

  • How many keywords are they ranking for?
  • How well are they ranking?
  • What sort of traffic volumes would they get?
  • What would the commercial value of that traffic be?

Not all of these are easy to answer, and may or may not be of interest. So I expanded my questions with:

  • How can I check their Rankings?

So I had a rough answer. Scrape and Rank. In reality, this would not be possible without the Dark Art of Scraping Google Search Results.

Which kind of lead me to think, this is a pretty simple, yet good method of referencing rankings. However scraping need not be bad. Like any SEO technique, it can be used for both,good and evil.

  • How can I use that technique for blackhat purposes?
  • How can I use that technique for whitehat purposes?

So I have figured a way to answer SOME of my questions. I then asked myself:

Can I create a simple and rough version of my technique so that ANYONE can use and verify?

The answer was, yes, to an extent. The recipe would include:

  1. A Scraping Script,
  2. A Rank Checker,
  3. A Spreadsheet
  4. A little time.

Summary: In the post below I demonstrate

  • The potential extent to which Facebook is gaming the SERPs with crappy content
  • The ability to use Scraping for both white and black SEO techniques

Scraping Assbook

  • Grab the keywords and Rank Check for google .com
  • Compile and sort by everything in positions:
    • Pos 1
    • Pos 2-5
    • Pos 6-10
    • Page 2
    • Pos 21-50
    • Pos 51-100
    • Pos 101-200
    • Not ranked
  • Sort into pie chart, and analyse.

I scraped the first 600 results of the query, with the help of the awesome Richard Shove.  Well I had to strip 8 keywords for non eligibility / repeat.  Also, when ranking, I only considered ranks up to the first 200 results. And I define a good rank to average rank as anything in the top 50.

What did I find? The ranking data makes good reading, even for such a small dataset:

Google SERP Rankings for Facebook

Google SERP Rankings for Facebook

The data shows that of my keywords selected, only 25% weren’t ranked in the top 200 positions. Of the same data set, 17% ranked on page 1 of the SERPs.

Now lets look at that in theoretical terms. The query I used to generate this list indicates 119,000,000 results found.(That is One hundred and Nineteen MILLION results!!!)

 

Site Query Equals 119 000 000 Results

Site Query Equals 119 000 000 Results

This is nowhere near the real number indexed.  Why do I say that? Well you will get different indexed results depending on how quick google serves up the data to you… So refreshing the search gives me a different number indexed.

 

Site Query Equals 219 000 000 Results

Site Query Equals 219 000 000 Results

Lets just say for simplicities sake we have 100,000,000 pages indexed. If the data set above forms a working sample, then you expect 75% of these results ranking for the keywords necessary. 17% of the same  dataset ranks in page one.

BIG picture? If (and note I say IF) my hypothesis holds, then these community pages that rank on page one equal in the region of 17,000,000. That is Seventeen MILLION folks. What traffic wold you hope to generate with 17 Million results on page 1 in google?

Not finished yet. The three most common variations on these pages title tags include:

  • Community
  • Interest
  • Topic

Now cross reference any keywords that have these extentions added, in order to make a mid range keyphrase. I can only guess at the volume of page one rankings for those keyphrase variations.

At this juncture, I must point out that my friend Branko who is an awesome SEO Scientist, highlighted the fact that my methodology  needs verification:

If I was you, I would take 2 more random sets of 600 queries and see if the distribution is similar. That way you can get an idea of how much fluctuations you have and how solid your data is. If you want to take it to the next level, there are statistical tests that can tell you whether your sample is representative of the population.

Now I was too lazy to do that to be honest. However I am sure those of you who are better at analysing and manipulating sata may be tempted. If so, let me know!

Now this is a massive massive invasion of the SERPs. And if I had the full X Million KW list to hand, I would love to have dug through it. But even my unscientific approach indicated something we British would call “corkers” . Danny Sullivan taught me a neat trick years ago, of comparing a high volume KW against another to get an indication of popularity. My list indicates that Facebook ranks well for “Singing”. Now lets use Danny’s technique:

Singing vs Viagra

Singing vs Viagra

How cool is that? Singing gets more searches than Viagra. and here is a scraper page auto built by Facebook ranking for it. I include this because it indicates the potential volume of traffic that can be had by a large scale site that gets involved in Gray SEO techniques.

Whitehat Scraping

Whitehat Scraping

When working on large scale SEO projects, for example Ecommerce SEO, competitive analysis is key in successful Long to Mid range strategy. Often we as SEOs tend to hone in on the “money” words and forget that the long tail not only exists, but is highly profitable.

I am not saying that we DONT target long tail keywords, but I dont think we competitively analyse this data.

So how do you use SERP Scraping for comptitive analysis? Do I have to really tell you? :P

  • First off, scrape all the pages indexed for the competitor in question.
  • Second, most common ecommerce SEO set ups use keyword splitters in the title tag. (They could be pipes, commas, arrows etc etc.) So use that knowledge to pull off keywords from your scraped data.
  • Third, run a rank check on the full list.
  • Four, compare against your own data. Where are the gaps?
  • Profit.

Blackhat Scraping

Blackhat Scraping

Again, this is quite a simple use of that SERP rank data.

  • Find a number of large sized sites with average or poor SEO
  • Scrape all the pages indexed.
  • You can use title tags, headings, etc to compile keywords from your scraped data.
  • Third, run a rank check on the full list.
  • Four, sort the data. Start with one word, two word, and continue sequencing till you get to 4-5 word combinations.
  • Now you have an insanely large keyword list with rankings – sorted into  keyword tails.
  • I would then further sort these into “common” themes, e.g all car and auto related words / phrases together…
  • Use an autoblog tool such as WPRobot to create thematic microsites which automatically pump out content based around your keyword sets. Add links where necessary.
  • Profit?!

A serious Blackhat would probably know how to use Scraped SERPs for much much more than what I suggest above. However, I have chosen to demonstrate the lowest common denominator :)   After all, this is a similar technique to the one I would say Mahalo used

Free Scraper

So there are a bunch of tools you can use to scrape, but to show you how easy it can be, see the link to the Google Scraping Script. (A big thank you to Dan Harrison of WordPress Doctors and William Vicary of Semto).

In case you think this is the only way to do this,  here is another variant of the scraping script (thanks to Yousaf Sekander of  Elevate Local).

This is just a limited version of the scraper and will take ages to pull out industrial strength data. If you are looking for something much more robust, try:

Free Data

I have no doubt that I have probably made a few mistakes. So here is the data – use it as you will.

http://bit.ly/FacebookScrapingData

Jaamit

I met Jaamit through our various conversations on SEOmoz, and then eventually through twitter. My first impression of him was what I felt I would have been like when I was that age. And I immediately took a liking to him. He was easy to get on with and a pleasure to speak to. As most people know, when it came to my friends in the industry, Jaamit was amongst those that I counted less friend, and more family.  I wish I knew him better. I knew him through SEO and whenever we met up our conversations were all about the industry. I knew a little about where he wanted to go, and what he was doing to try and get there, but outside SEO industry I knew only a little about him.

I did know that he was dedicated, ambitious and a perfectionist. And that despite how well he knew his stuff, he was a nervous wreck when it came to public speaking. He would redo his presentations a million times before he was happy with them, and even then was never quite relaxed. I always teased him about it, and always tried to get him drunk on the night before he was due to speak…

We would play pranks together, and act the fool often when we met up with others for various drinks and events, though he would tell me off for pranking others…(as you can see, my favourite photo of him is in one of those silly moods)

He would come to me for advice and for a listening ear when he was stressed about work, or any major work related decisions, including when he uprooted himself from Brighton to move to London. And I would do what any friend would, listen and offer my opinion. He was smart enough though to take my good advice, and ignore my bad advice. He was brave enough to make decisions that scared him, and ambitious enough to go for his dreams. And he loved SEO and the industry.

I think Jaamit would have been both, proud and touched by the love that the industry showed him. I want to thank every one of you who raised a glass to him, sent your love and wishes to both, me and his family.

I have never been prouder to be part of this industry as I have been in last few days. I haven’t seen such support before in my life, from hundreds of offers of support, messages, tweets, emails, texts and phonecalls to the love that 100’s of strangers have shown. For that, thank you.

When my time comes, and if I even manage a fraction of the love that was shown to this boy, then I will feel that I have achieved something in life. It was touching and inspiring to watch the streams of messages and conversations.

I especially want to thank the guys at OMD who have been fantastic.

Like I said, I wish I knew him better, but always thought I would have the time. I felt that he was a brother to me, and I watched with pride as he made decisions that furthered his dreams. I was shocked when I heard the news, and genuinely didn’t know how to react, and on some level still don’t. And I want to thank all those people who offered to help. People have been great at a time when the need existed, and for that I love you.

His passing away made me think, as I am sure it made you too, of the fact that life is so short. There are some changes that I am going to make to my life, while I will improve on other aspects of my existence. Jaamit once told me that he most respected me for offering to hear him out and the advice I was always willing to give him. To thank you all, and to keep that part of my personality that he liked the most, I promise to all in the SEO industry, if there is ANYTHING, I can do, advise on, or help with, my doors will always be open. I lost one brother, but I know that there are hundreds more out there, who have the same dreams, same wishes, and if I can help even one person, in Jaamits name I will.

I spoke to Jaamits wife earlier today, and she wanted to pass on her thanks, as well as those of his parents. They read all the tweets, messages and blog posts that were written about him from the moment that the news broke, and it means much to them to see the love that Jaamit was given. So on behalf of them, thank you.

The funeral and wake has been planned for Saturday the 4th of December in Ealing. For those of you who would like to attend the wake to raise a glass to him, please let me know so we can work out the numbers.

Re: Jaamit Wake: Location: Ealing Town Hall in the Nelson Room Friday 2pm, New Broadway, Ealing, London W5 2BY

For those of you who cannot attend, but would like to send flowers or cards, please send them to his house:

  • Ground Floor Flat
  • 48 Leyborne Avenue
  • London
  • W139RA

I cant bear to go through all the tweets again and pul out the lovely things that you guys have said, but if you would like to leave your thoughts and wishes, please do so in the comments below, and I will make sure his family gets them.

Once again, thank you, I love you, and Rest In Peace my friend. You made an impact that has touched thousands, and I wish you could have seen the effect that you have had on people.

Jaamit

I met Jaamit through our various conversations on SEOmoz, and then eventually through twitter. My first impression of him was what I felt I would have been like when I was that age. And I immediately took a liking to him. He was easy to get on with and a pleasure to speak to. As most people know, when it came to my friends in the industry, Jaamit was amongst those that I counted less friend, and more family. I wish I knew him better. I knew him through SEO and whenever we met up our conversations were all about the industry. I knew a little about where he wanted to go, and what he was doing to try and get there, but outside SEO industry I knew only a little about him.

I did know that he was dedicated, ambitious and a perfectionist. And that despite how well he knew his stuff, he was a nervous wreck when it came to public speaking. He would redo his presentations a million times before he was happy with them, and even then was never quite relaxed. I always teased him about it, and always tried to get him drunk on the night before he was due to speak…

He would come to me for advice and for a listening ear when he was stressed about work, or any major work related decisions, including when he uprooted himself from Brighton to move to London. And I would do what any friend would, listen and offer my opinion. He was smart enough though to take my good advice, and ignore my bad advice. He was brave enough to make decisions that scared him, and ambitious enough to go for his dreams. And he loved SEO and the industry.

The SEO Industry

I think Jaamit would have been both, proud and touched by the love that the industry showed him. I want to thank every one of you who raised a glass to him, sent your love and wishes to both, me and his family.

I have never been prouder to be part of this industry as I have been in last few days. I haven’t seen such support before in my life, from hundreds of offers of support, messages, tweets, emails, texts and phonecalls to the love that 100’s of strangers have shown. For that, thank you.

When my time comes, and if I even manage a fraction of the love that was shown to this boy, then I will feel that I have achieved something in life. It was touching and inspiring to watch the streams of messages and conversations.

Me

Like I said, I wish I knew him better, but always thought I would have the time. I felt that he was a brother to me, and I watched with pride as he made decisions that furthered his dreams. I was shocked when I heard the news, and genuinely didn’t know how to react, and on some level still don’t. And I want to thank all those people who offered to help. People have been great at a time when the need existed, and for that I love you.

His passing away made me think, as I am sure id made you too, of the fact that life is so short. There are some changes that I am going to make to my life, while I will improve on other aspects of my existence. Jaamit once told me that he most respected me for offering to hear him out and the advice I was always willing to give him. To thank you all, and to keep that part of my personality that he liked the most, I promise to all in the SEO industry, if there is ANYTHING, I can do, advise on, or help with, my doors will always be open. I lost one brother, but I know that there are hundreds more out there, who have the same dream

Jaamit

I met Jaamit through our various conversations on SEOmoz, and then eventually through twitter. My first impression of him was what I felt I would have been like when I was that age. And I immediately took a liking to him. He was easy to get on with and a pleasure to speak to. As most people know, when it came to my friends in the industry, Jaamit was amongst those that I counted less friend, and more family.  I wish I knew him better. I knew him through SEO and whenever we met up our conversations were all about the industry. I knew a little about where he wanted to go, and what he was doing to try and get there, but outside SEO industry I knew only a little about him.

I did know that he was dedicated, ambitious and a perfectionist. And that despite how well he knew his stuff, he was a nervous wreck when it came to public speaking. He would redo his presentations a million times before he was happy with them, and even then was never quite relaxed. I always teased him about it, and always tried to get him drunk on the night before he was due to speak…

He would come to me for advice and for a listening ear when he was stressed about work, or any major work related decisions, including when he uprooted himself from Brighton to move to London. And I would do what any friend would, listen and offer my opinion. He was smart enough though to take my good advice, and ignore my bad advice. He was brave enough to make decisions that scared him, and ambitious enough to go for his dreams. And he loved SEO and the industry.

The SEO Industry

I think Jaamit would have been both, proud and touched by the love that the industry showed him. I want to thank every one of you who raised a glass to him, sent your love and wishes to both, me and his family.

I have never been prouder to be part of this industry as I have been in last few days. I haven’t seen such support before in my life, from hundreds of offers of support, messages, tweets, emails, texts and phonecalls to the love that 100’s of strangers have shown. For that, thank you.

When my time comes, and if I even manage a fraction of the love that was shown to this boy, then I will feel that I have achieved something in life. It was touching and inspiring to watch the streams of messages and conversations.

Me

Like I said, I wish I knew him better, but always thought I would have the time. I felt that he was a brother to me, and I watched with pride as he made decisions that furthered his dreams. I was shocked when I heard the news, and genuinely didn’t know how to react, and on some level still don’t. And I want to thank all those people who offered to help. People have been great at a time when the need existed, and for that I love you.

His passing away made me think, as I am sure id made you too, of the fact that life is so short. There are some changes that I am going to make to my life, while I will improve on other aspects of my existence. Jaamit once told me that he most respected me for offering to hear him out and the advice I was always willing to give him. To thank you all, and to keep that part of my personality that he liked the most, I promise to all in the SEO industry, if there is ANYTHING, I can do, advise on, or help with, my doors will always be open. I lost one brother, but I know that there are hundreds more out there, who have the same dreams, same wishes, and if I can help even one person, in Jaamits name I will.

Thank You

I spoke to Jaamits wife earlier today, and she wanted to pass on her thanks, as well as those of his parents. They read all the tweets, messages and blog posts that were written about him from the moment that the news broke, and it means much to them to see the love that Jaamit was given. So on behalf of them, thank you.

The funeral and wake has been planned for Saturday the 4th of December in Ealing. For those of you who would like to attend the wake to raise a glass to him, please let me know so we can work out the numbers.

For those of you who cannot attend, but would like to send flowers or cards, please send them to his house:

Ground Floor Flat

48 Leybourne Avenue

London

W139RA

s, same wishes, and if I can help even one person, in Jaamits name I will.

Thank You

I spoke to Jaamits wife earlier today, and she wanted to pass on her thanks, as well as those of his parents. They read all the tweets, messages and blog posts that were written about him from the moment that the news broke, and it means much to them to see the love that Jaamit was given. So on behalf of them, thank you.

The funeral and wake has been planned for Saturday the 4th of December in Ealing. For those of you who would like to attend the wake to raise a glass to him, please let me know so we can work out the numbers.

For those of you who cannot attend, but would like to send flowers or cards, please send them to his house:

Ground Floor Flat

48 Leybourne Avenue

London

W139RA

Negative SEO – 4 Killer Strategies To Look For

Gutted I couldn’t make it to both the sessions at 10:30, I had to miss Tom Critchlows talk, Advanced Analytics for Affiliates. For those of you who know Tom, you know he really gets analytics, and in fact he recently posted for the google analytics team, no mean feat! I hope to catchup with him later if he is willing to share any tips.

Continue reading “Negative SEO – 4 Killer Strategies To Look For”