Ive noticed a lot of “SEO keyword” tools are pulling data from google adwords, such as longtailpro. and that really is looking in the wrong place if you ask me. You want to look the data from real SERP results, and find the real low hanging fruit. It just takes some manual digging, but a few hours of research will pay off when you get organic traffic with 0 back links built.

Its a great way to look for ideas on articles to write, and ones that stand a good chance of getting to page one. If you are writing junk content just to have a article about this topic, then you are surely going to have a hard time with seo/content marketing. In the example of this website (pdxwebdesign), i am trying to find some WordPress/webdesign topics to write about.

Step 1: Scraping A Keyword List

If you head over to keyword s$%#er ( i know, i didn’t pick the name ), you can enter a few keywords to start searching for. You can also scrape lists from multiple search engines with scrapebox’s keyword scraper. 

Note: Open up this site in a few different tabs to have multiple keyword reports running at the same time. 

If you dont have a copy of scrapebox yet, then you can find the discounted purchase link to scrapebox here. Not my referral link (BHW), but $67 dollars is the best deal i can currently find on it. Its such a great tool to have, hard to not buy it at that price.

Step 2: Scraping Proxies

If you plan on looking at a large amount of data, then you will need to scrape some proxies.
To do this, find the Manage Button in the lower left.

Under the Manage Popup, click on Harvest Proxies and start.
Once it finishes finding proxies, export them so you can test them.

Because we are looking at google search results, we have to use Google enabled proxies. 

Filter: Keep Proxies that pass the google/custom test
and save proxies to scrapebox.

Step 3: Filtering & Cleaning the List of Data

Copy the list of keywords from keyword shitter and Paste/Add from clipboard ( append to existing list ). So you dont erase the data if you are running multiple tabs of keyword shitter. 

Remove Duplicate “URLS”, Even though these are keywords, it will still remove any duplicates.

Step 4: Processing the Data

Under the Add On menu – Install and open up Google Competition Finder.

You will need to move the keywords from the Harvested URLs to Keywords in order to import within scrapebox. 

You might have to play around with the settings a bit, or just run 1 thread with a delay. Google really hates data scrapping, so we need to have multiple proxies to process large amounts of data. 

I would run on Board Match Search.

What we are looking for are long tail phrases that have a low amount of search results. Low search results means there is not alot of pages optimize for that search phrase, and generally will be easier to rank in the serps.

Fighting against 40,000 results, with 30,000 of them being fairly unrelated to the users intent…. Or Fighting against 3,000,000 results with large authority websites blanketing the first page with top notch content.

Step 5: Manually Reviewing The Keywords

It we look at the phase “How to create a website offline wordpress” We see a handful of large DA sites and mostly youtube videos in the top few spots. The user intent on this keyword would be how to create a website locally on their computer without having to build it live on the web.  

If you have not already, go ahead and Install Mozbar to view the DA/PA in the Serp Results. Its 100% free, you just have to create a account with them. 

It would be fairly hard to rank for this keyword without a good amount of Domain authority, but i noticed in this example under the first couple search results. A few social & forums sites come up in these results. You can try placing a link on those with a helpful response to the thread starter. 

I would start with 50,000 Results Max when first learning how to find long tail keywords to write articles on. Go for some easy wins to see it really does work. 

If we looked at this keyword/phrase in Adwords keyword planner – you will see the results show as “Low Competition.” It likely is but, its because not a lot of people are bidding on this keyword in Adwords.  Adwords data really has nothing to do with how hard it is to rank in google.