<aside> 🚨 Want more notes like this? Subscribe to weekly strategy emails: seonotebook.com

</aside>

Today’s note is going to take resources to execute, but I want it to inspire you and I want you to push yourself, because that’s what SEO is all about!

The end result is this exercise is a content roadmap that will likely produce thousands of article topics.

What you’re looking at below is the net result of a spreadsheet that I created for one of my clients using the method I’m about to teach you.

That translates into 390,172 keywords! but where did they come from and how did I extract them?

Before we get into all that, here’s what you’ll need to get started:

• A Python developer (Upwork is your friend)
• a website with blog that earns at 10,000 clicks per month (you can do it with less, you just won’t get as much data).
• a Google Search Console API key
• a Keywords Everywhere API key
• a Keyword Cupid account
• About a week to complete the extraction (this burns through your GSC API credits, but it’s so worth it).