Introducing Cohort Keyword Research

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.

What is Cohort Analysis?

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.

The Keyword-Level Data

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.

How To Use This Sheet

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“:

  1. Under the total average difficulty across all sites
  2. Under the total average CPC across all sites
  3. Above the total average MSV across all sites

A Video Walkthrough of the Process

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.

Get Access to The Google Sheet Template

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)

Comments

Your email address will not be published. Required fields are marked *

Other articles you may be interested in

Everything you need to grow your SEO skills.

One low price.

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!

Most Popular

The Full Accelerator

(Academy + Mastermind)
  • Make real connections
    Get specific questions answered and tap into a huge library of expert training.
  • TTT Academy:
    200+ hours of training Filter by topic and skill level to learn at your own pace.
  • Templates, Tools, and Process Docs
    Scale up and simplify every part of SEO.
  • Live Q&A Sessions
    Get direct, personal advice from a panel of industry veterans
  • 3+ Expert-Led Webinars Monthly
    Learn what works from experts at the top of their fields.
  • Members-Only Perks
    Save BIG on the tools and services you need to do your best work.
  • Exclusive Slack Community
    Build a network of smart friends and seasoned mentors you can turn to any time
Monthly Payment
$119
Join Now
New Option

Self-Guided Learning

(Academy only)
  • Make real connections
    Get specific questions answered and tap into a huge library of expert training.
  • TTT Academy:
    200+ hours of training Filter by topic and skill level to learn at your own pace.
  • Templates, Tools, and Process Docs
    Scale up and simplify every part of SEO.
  • Live Q&A Sessions
    Get direct, personal advice from a panel of industry veterans
  • 3+ Expert-Led Webinars Monthly
    Learn what works from experts at the top of their fields.
  • Members-Only Perks
    Save BIG on the tools and services you need to do your best work.
  • Exclusive Slack Community
    Build a network of smart friends and seasoned mentors you can turn to any time
Monthly Payment
$99
Join Now

Look…

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.

And seriously, come
ready to do the work.

Please Note: Due to the nature of our content,  we are unable to offer refunds. In more clear language: NO REFUNDS.