by Nick Eubanks
Cohort keyword research is a process I’ve created and refined over the past ~2 years as an off-shoot of FTF’s larger keyword research offering; identifying a market’s total addressable market online.
If you’re unfamiliar with cohort analysis, wikipedia defines it as:
Cohort analysis is a subset of behavioral analytics that takes the data from a given dataset (e.g. an eCommerce platform, web application, or online game) and rather than looking at all users as one unit, it breaks them into related groups for analysis.
These related groups, or cohorts, usually share common characteristics or experiences within a defined time-span. Cohort analysis allows a company to “see patterns clearly across the life-cycle of a customer (or user), rather than slicing across all customers blindly without accounting for the natural cycle that a customer undergoes.”
An easier example to understand would be thinking back to your high school class, while it’s likely there have been thousands of people who have graduated from your high school, one specific cohort would be the group of people you graduated with — for me this is the class of 2002 from Valley Forge Military Academy.
You can go deeper down this rabbit hole as well, for example additional cohorts (that I would be a part of) are the 2002 VFMA Calculus 2 class, or the 2000 VFMA Varsity Rifle Team, and so on.
The nuance here within SEO is applying the approach to sets of keyword data to identify patterns between cohorts that exist based on keyword-level metrics like search volume, cost per click, and organic difficulty.
For this process I am currently exclusively using data from Ahrefs.
As of the time of publication, their keyword difficulty rating is my favorite across all the SEO tools out there.
The cohorts my process looks at are:
For each metric, I’m going to use data from 5 websites in the same niche, and create cohorts for the average maximums and minimums of each metric, using the mean for each as the middle of the road to sort all other term-level metrics into an “above” or “below” bucket.
This is useful because it allows you to combine these metrics to identify your best opportunities, i.e. keywords with higher than average volume and cost, but lower than average difficulty.
It allows us to identify opportunities based on combining data from each threshold group and then applying it across the entire keyword population.
So pulling the top 1,000 keyword rankings for each site (for these top 1,000 I’m using the highest ranking terms (i.e. sorted by lowest ranking position; so from position 1+) in ascending order, but you could sort terms by MSV, Difficulty, or whatever your heart desires), I’m able to set a heuristic baseline for each site saying “show me all terms that are“:
To help run through this entire process, I created a Google Sheet that’s setup with a dashboard view, “keyword environment” sheet that dynamically shows the individual term lists and all correlating data based on your selected cohort query, and is built to support up to 100,000 rows (keywords) for 5 websites.
This template is just one of dozens we’ve built for Traffic Think Tank members.
Sign up for traffic think tank now and get instant access to this sheet, over 300 hours of exclusive content, and some of the most useful discussion threads in the SEO industry.
Get instant access to the cohort keyword template
(and over 300 hours of exclusive SEO process content and templates)
How much would it cost to hire 10 top-notch mentors on-call?
Or buy dozens of courses covering every SEO topic?
Stop burning hours on half-baked blog posts and YouTube videos.
Learn from top SEOs for a full year for less than it'd cost to hire one of them for a day!
We’re not here to promise you the moon and give you swiss cheese.
If you want the best results, you should think of the Traffic Think Tank as a community support group, like AA for SEOs who want to get better. If you want to get your money’s worth and see improvements in your SEO, take group participation seriously and studiously.
No results are promised or guaranteed. You apply the advice you take from this group at your own risk.
We’ve made every effort to represent accurately the products and services we offer, and their potential to help you grow rankings, revenue, traffic, and your skills as an SEO.
We also constantly work to ensure what’s shared in the group remains private, including the immediate cancellation of membership for anyone found to be sharing our resources outside of the community.
Where any of the success stories or testimonials on this page share results of any kind, you should not expect the same results unless your business, efforts and resources are exactly the same as the person who shared that testimonial or story.
Please Note: Due to the nature of our content, we are unable to offer refunds. In more clear language: NO REFUNDS.