When doing keyword research for programmatic sites, you shouldn’t be analysing each page individually. You especially can’t be optimising an entire programmatic build page by page. You should really be looking at the overall group, that each page falls into, and looking it as a whole. How do we do this though? How can we …
Extracting Keyword Templates/Patterns from a Keyword Set Read More »
Breaking down your GSC into brand vs generic keyword performance can give you a better insight into how an SEO campaign is going. Most SEO activity won’t be affecting the brand too much, as it will be more to drive performance increased within the generic keywords. Whilst you’ll get a flow-on effect, in that as …
Categorising a large keyword list in bulk takes hours to do, unless you do it a special way. Learn how to categorise thousands of keywords in seconds through the use of a magical Excel formula. You can categorise data in Excel with this formula, it doesn’t only work on keywords. Another popular use of mine …
Estimating your organic traffic will allow you better assess your current performance for a set of keywords, but also allows you to directly compare that performance with your competitors. In this video, I run through how to properly set up your data and run the formula across a set of categorised keywords. This will be …
Discover the easiest ways to generate keywords in bulk using Excel. These formulas are the basis of so much work, and keyword generation really will just give you a top-level understanding of the formula’s use. Concatenate – Join as many cells together as needed =CONCATENATE(*First CELL to join*,*Second CELL to Join*) Concatenation is a …
Comparison keywords are an awesome foot-in-the-door SEO targeting strategy if you’re kicking off any sort of product-based strategy. Many decent volume, low-comp keywords just sitting there for the picking and can be targetted individually, or in bulk. Many people won’t even consider many of them! My latest little project has even just cracked 270 clicks …
Product Comparison Keywords: A foot-in-the-door SEO strategy Read More »
An extremely large table of all their keywords, isn’t going to give the insight some clients would want. Some would like more a bit more insight into the data they’ve paid thousands for. Building a keyword research dashboard in Excel is a great way to allow a client to interact with their keyword data. In …
I’ve been doing SEO a little while now on and off over the years (but mostly on) and finally getting back into it full time now. Over time, I have learned quite a few little handy tricks doing keyword research that has helped me save countless hours… and many weeks! I figured it was about …
10 Years of Keyword Research and What You Can Learn From It Read More »
