This is the third and final part of a series on fast SEO competitive analysis. In the first article we went over the basic, but essential keyword research process. Focusing on more than just individual keywords, and looking specifically for search behaviorand categorizing target keywords.
In part two we identified where content gaps existed by looking at what was most relevant in Google search, compared to what Google found most relevant specific to a particular site. Step one, content. Step two, ranking eligibility.
Part three brings it all together as we look at detailed competitive analysis. Using SERP presence data to understanding the competitive landscape. Not just for our targeted keywords, but for each search behavior.
Tools Used:
- Google Sheet
Competition Segmented by Search Behavior
Starting from hundreds of searched terms customers are using to find Google Sites, our example used in part one, we were able to boil down search behavior into a single sentence. When customers search on Google, they want to build/create/make/start a Web page or site, and they want it to befree/easy/online.
Using the Advanced Web Ranking data from part two and VLOOKUP to pull in search volume, we can create a pivot table that will allow us to identify the most present SERP competitors for particular keywords or keyword combinations.
